Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Import CSV?


tmcca

Recommended Posts

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

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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). 

Always back up before making changes.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...