Forums / General Questions / How to set a whole store with quantity 1000 ?

How to set a whole store with quantity 1000 ?

Results 1 to 3 of 3

6 May 2012, 11:13 AM

lilly06

New Zenner

Join Date:: Dec 2010
Location:: monaco
Posts:: 40
Plugin Contributions:: 0

How to set a whole store with quantity 1000 ?

I need help please, as my whole store is set as sold out! my whole quantity for all products are at 0 and i need the exact code for SQL to switch all quantity to 1000

i tried this code:
UPDATE products SET products_quantity = 1000;

bu nothing works.. my store is 1.3.9h i haven't updated it yet

Someone worked on my store for me and this morning the whole quantity changed, and i don't know when this person will be able to help, i need assistance as soon as possible

Thank you for the help!!!

6 May 2012, 11:38 AM

stevesh

Black Belt

Join Date:: Feb 2005
Location:: Lansing, Michigan USA
Posts:: 19,793
Plugin Contributions:: 2

Re: How to set a whole store with quantity 1000 ?

I got this from RodG in another thread, and it worked on my 1.5.0 test site:

UPDATE products SET products_quantity= 1000 WHERE 1 ;

6 May 2012, 12:09 PM

lilly06

New Zenner

Join Date:: Dec 2010
Location:: monaco
Posts:: 40
Plugin Contributions:: 0

Re: How to set a whole store with quantity 1000 ?

OMG!!! thank you so much!!!!!!!!! it worked like a charm!!! so it also work for 1.3.9h!