Jump to content
tmcca

Import CSV?

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

Share this post


Link to post
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

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
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

Edited by kgtee

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×