mkiler Posted November 30, 2008 Share Posted November 30, 2008 Hi I try to describe how to update information like price and quantity using phpmyadmin and excel.It's my way and I use that, maybe you must change something in your data to use that.First step, using phpmyadmin create backup of your database. Next export table ps_pruduct to csv file and save on hard drive. Next step - look to file which is attached to this post. Inside file is macro - you must change something to work with your data. My file haves two worksheet - csv (data exported and pasted from phpmyadmin) and tech (actual information about price and quantity). To compare this worksheets I use Supplier Reference (unique for any items in my shop). Macro reed colum R from csv and try to find the same value in column B from tech. If found respondent, then change value column J and K from csv to value in column F and I from worksheet tech. You must change some value in this macro but I think is simple. When macro change data, copy worksheet csv and paste to orginal file which is exported from phpmyadmin. Next using phpmyadmin load data to your shop.Maybe this help someone. data.xls 1 Link to comment Share on other sites More sharing options...
qasrani Posted December 1, 2008 Share Posted December 1, 2008 Thanks for nice tip Link to comment Share on other sites More sharing options...
ShowYou Posted January 1, 2010 Share Posted January 1, 2010 Hello mkiler,Thanks for data.I have a problem because i have more 5000 products. Data.xls don't work with a lot of products. Can you help me ? Thanks Link to comment Share on other sites More sharing options...
Recommended Posts