Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

My SQL Admin


Recommended Posts

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

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

Why not install Easy Populate? Then you can still go through admin, and stops the risk of buggering up your database completely.



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


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

  • Create New...