Import CSV?

[tmcca]

Is there a plugin that will take a CSV file read it and than you can convert it to Oscommerce? Example would be lets say CSV file has Sku than you take that and put it in model, etc. Or the best way to convert the CSV file? Thanks

[Dan Cole]

Take a look at EasyPopulate...it'll allow you to import and export product information using a csv file.  It might do what you want or at least get you on your way.

Dan

 

[tmcca]

Is there anything that will read a csv file and convert the fields to oscommerce automatically? Php script? Or you have to do this manually?

[kgtee]

The model id/sku is related to a specific product id and a specific table.  Assuming that you have the CSV file prepared in the correct format readable by MySQL, then you may use phpmyadmin to import the CSV file. For your case the process is UPDATE rather than INSERT.

Stackoverflow

[♥ecartz]

1 hour ago, tmcca said:

Is there anything that will read a csv file and convert the fields to oscommerce automatically?

Not more automatically than Easy Populate does.  Note that you have to change the columns to match what Easy Populate expects.  Otherwise it has no way of knowing that the SKU column should go in products_model. 

While it is possible to import using phpMyAdmin, realize that it won't automatically associate products name (language specific, in the products_description table) with model (not language specific, in the products table).  Easy Populate does know about that and will make those associations automatically.  Same thing with category name (language specific, in the categories description table, associated through categories and products_to_categories to products).