jayeshshiyani Posted January 17, 2007 Share Posted January 17, 2007 i am trying to import all my products as they are on excel, i exported a dummy so that i get a template of headings and then used that to merge my sheet into which was a success. but then realised i cant import excel/csv etc... what the best way to do this because admin panel is far too time consuming. i am using my sql admin 4.0 if that helps! Link to comment Share on other sites More sharing options...
Guest Posted January 17, 2007 Share Posted January 17, 2007 You should be able to 'import' a CSV file directly into MySql using phpMyAdmin - make sure your CSV file is in the correct order , navigate to the correct table in phpMyAdmin and import. I have never done this on a products table before though - backup before trying anything like this . Link to comment Share on other sites More sharing options...
shooter-boy Posted January 18, 2007 Share Posted January 18, 2007 Why not install Easy Populate? Then you can still go through admin, and stops the risk of buggering up your database completely. Rob Rob Bell - Inspired Graphix Customising osCommerce in Australia, and the world! View my profile for web and email links. I'm sorry, but i cannot offer Free support via PM etc, and osCommerce forums prohibit me from putting any reference to paid support in my signauture. However viewing my profile may provide links to my website or something like that which you may find useful. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.