herot Posted August 9, 2006 Share Posted August 9, 2006 currently i am using 5 different .cvs files to upload all my product information... buy i think i am going to run into problems when i need to do things like delete or change prices on large list of items all at once... i do not know SQL very well but have learned some basics... is there a way (for some reason i never could get easy populate to work) to make this process faster and more efficient? currently installed contribs: SPPC (seperate pricing per customer) CoolMenu Featured Products HPFCG (hide products from customer group) Sort product by model (in admin) Did you get rid of the voices in your head? Do you now miss them and the things that they said? -David Gilmour Link to comment Share on other sites More sharing options...
kgt Posted August 9, 2006 Share Posted August 9, 2006 By far, the most efficient way to make large changes is to use SQL. It's what it's made for. You can download your entire products table to csv files, then empty the table, make your changes to the csv, and upload the csv. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
herot Posted August 9, 2006 Author Share Posted August 9, 2006 By far, the most efficient way to make large changes is to use SQL. It's what it's made for. You can download your entire products table to csv files, then empty the table, make your changes to the csv, and upload the csv. yeah, thats what ive been doing... i was just trying to figure out a way to do it without using 5 different csv files... (products, product descriptions, group price, products to categories, and i forget what the other is...) Did you get rid of the voices in your head? Do you now miss them and the things that they said? -David Gilmour Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2006 Share Posted August 9, 2006 PHPMyAdmin: http://www.phpmyadmin.net/home_page/index.php This is a great MySQL interface, it is good for minor changes and deleting multiple products at once, but be aware of how many tables get updated when you add a product. Getting EZpopulate to work would be your best bet. Link to comment Share on other sites More sharing options...
herot Posted August 9, 2006 Author Share Posted August 9, 2006 PHPMyAdmin: http://www.phpmyadmin.net/home_page/index.php This is a great MySQL interface, it is good for minor changes and deleting multiple products at once, but be aware of how many tables get updated when you add a product. Getting EZpopulate to work would be your best bet. yeah, ive been using phpmyadmin... it rocks. i just dont know SQL commands that well yet... im trying to get help on which version of EZpopulate to use in the contrib support forum... installed contribs: SPPC (seperate pricing per customer) CoolMenu Featured Products HPFCG (hide products from customer group) Sort product by model (in admin) and "On The Fly" thumbnailer as of today Did you get rid of the voices in your head? Do you now miss them and the things that they said? -David Gilmour 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.