grumpydasmurf Posted September 13, 2011 Posted September 13, 2011 Anyone got a quick script to reset all product quantity to 0 (zero)? I use a spreadsheet from my suppliers to update my inventory and I use EZ populate to import it. For some reason, either my suppliers fault or EZ populate but my site is showing discontinued items as being in stock. What I want to do is reset all qty to 0 before I run ez populate. I'm wondering if anyone has a script which will do what I am asking already so I can save a few hours writing one. Thanks in advance. Grumpy
GemRock Posted September 13, 2011 Posted September 13, 2011 in phpMyAdmin, sql, type: update products set products_quantity = 0 Ken commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience.
grumpydasmurf Posted September 19, 2011 Author Posted September 19, 2011 Worked like a charm, even easier than I was thinking. Grumpy
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.