tmcca Posted February 4, 2020 Share Posted February 4, 2020 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 More sharing options...
Dan Cole Posted February 4, 2020 Share Posted February 4, 2020 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 Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
tmcca Posted February 7, 2020 Author Share Posted February 7, 2020 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? Link to comment Share on other sites More sharing options...
kgtee Posted February 7, 2020 Share Posted February 7, 2020 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 More sharing options...
♥ecartz Posted February 7, 2020 Share Posted February 7, 2020 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.