Mesmerin Posted December 10, 2003 Share Posted December 10, 2003 Hi, I've set up an osCommerce shop, all works fine, now I have to add the products. I've got about 500 products to add, is there an easier way than to add them all seperately with the "new product"-button in the admin-page? Greetings, Mick Link to comment Share on other sites More sharing options...
crash3903 Posted December 10, 2003 Share Posted December 10, 2003 I use the following method use phpmyadmin to export the following tables products categories (after setting up the categories in osc admin) categorie_descriptions product_descriptions products_to_categories I then use excel to copy and paste the text in the fields within the relevant tables for the products using the category numbers i add the relevant ones to the products_to_categories tables then i use aan application called twang that writes the sql for me (Found this is better than importing text files for me) and then i execute the sql scripts voila! The products are now there - My shop has over 1300 items and it took me about 30 minutes to do it this way hth regards mark Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
Mesmerin Posted December 10, 2003 Author Share Posted December 10, 2003 Hi, that sounds great. :) I've installed phpmyadmin and see all those tables. How can I export a table now? 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.