(SOLVED) Products Module

[belgirl]

Hi--I am using the Products Module and I have a quick question:  Is there a way to import multiple items via a spreadsheet or sql rather than having to type in each product one by one?  Sure would save me alot of time.  Any help would be greatly appreciated.

Thanks!

[belgirl]

So I take it by the lack of response that this is not possible? 

[apcco]

I've played with it too but you'll have to do it yourself. Either build a udt/php routine that reads your csv and inserts each line or look into mysql LOAD DATA LOCAL you can import a whole csv file into the table.

[belgirl]

Yep, that's what I am going to do--load the csv into the individual tables.  There are several that have to be modified.  I have almost 30,000 products, so there is no way I am typing those in one by one.  LOL...I will let everyone know how to it goes once completed!

[belgirl]

Well--I did it!  25,000 products are now in my database and displaying as a price list using the Products Module.  Whoo hoo!  If anyone wants to know in detail how I did this, let me know but essentially what I did is I exported 4 main tables that dealt with PRODUCTS, HIERARCHY, PRODUCTS TO HIER and PRODUCTS_FIELDVALS.  I looked at the format in excel and then took my price list and converted it into these 4 main tables.  One for products, one for the hierarchy categories, one to tell which product goes under which hierarchy category and one for the extra field details.  Then I exported the excel file into csv files and imported them back into my MYSQL database via the PHP Admin.  After a few tweeks..VIOLA!