Need Help IMPORTING Products

[fsiano]

Hello everyone,

I am in need of importing a predefined list of products into my cart. My supplier supplied me with 3 different formats of his stock.

This is the Top row of a .csv document. Then below in the second row in the info that pertains to each category.

--------

Item No Item Title Description Page Number Retail Price Retail Code UPC Code Each Weight Case Weight Parent Category Sub Category Each Price Case Price Case Count Qty Price Qty Count Qty On Hand

--------------------

Can I use this and edit it in any way to import into my database???there is also a .txt and a .xls format of all of the info.

I know I have seen easy populate contributions. Can someone please lead me in the right direction of how to import these products????

Any help greatly appreciated

Thanks

Frank S

[fsiano]

anyone please help??????? :oops:

thanks

frank s

[Silencer]

I think there is only way - write data importer yourself. Thats will be not very hard task if you have some PHP experience.

 

It must be something like:

$dlink = mysql_connect('server','user','pass');

$fp = fopen ("test.csv","r");

while ($data = fgetcsv ($fp, 99999, ",")) {

$query = 'INSERT INTO products VALUES (NULL,'.$data[0].','.$data[1].')';

mysql_query($query) or die("error: ".mysql_error());

 

-- here comes code for products_descriptions and so on

}

[Apex]

you can use the easy populate contribution: http://www.oscommerce.com/community/contri...ions,500/page,6. After you install it run the download and get a csv file of you existing products to get familiar with the output file. Use excel to copy and paste the new products where they need to go and upload the file. That should do it. Remember to back up your db and files and you DEFINNATLEY want to read the README file with easy populate for guidence and troubleshooting if any. I've installed EP on 3 sites without a problem.

 

Hope this helps.

- ApEx