Updating all products to show quantity box

21 Feb 2011, 1:13 PM

#1

akasashasha

Zen Follower

Join Date:: Mar 2009
Location:: France
Posts:: 158
Plugin Contributions:: 0

Updating all products to show quantity box

Dear all,

I would like to know if there is a sql command that enable to update all products so they show the quantity box.

Thanks

And, by the way, is there a guide on this sql codes for zencart ?

Aka

22 Feb 2011, 11:10 AM

#2

akasashasha

Zen Follower

Join Date:: Mar 2009
Location:: France
Posts:: 158
Plugin Contributions:: 0

Re: Updating all products to show quantity box

no reply ?

22 Feb 2011, 1:39 PM

#3

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Updating all products to show quantity box

Providing the issue is with the field setting of products_qty_box_status in the products table, you can backup your database and run the SQL command:

UPDATE products SET products_qty_box_status = 1;

24 Feb 2011, 3:31 PM

#4

akasashasha

Zen Follower

Join Date:: Mar 2009
Location:: France
Posts:: 158
Plugin Contributions:: 0

Re: Updating all products to show quantity box

thank you Oba san !

24 Feb 2012, 7:39 PM

#5

feznizzle

Totally Zenned

Join Date:: Apr 2010
Posts:: 900
Plugin Contributions:: 0

Re: Updating all products to show quantity box

Good stuff, thanks Ajeh! I too benefited from your answer.

But I have a follow on question. After running your script, all of the qty boxes say...
Min: 0 Units: 0

This is because Product Qty Minimum and Product Qty Units are defaulting to zero instead of 1.

Can you give us a script that will input 1's into those two slots?

Thanks,
Mike

24 Feb 2012, 9:49 PM

#6

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Updating all products to show quantity box

You cannot use:
Minimum 0
Units 0

as there is no such thing ...

UPDATE products SET products_quantity_order_min = 1;

UPDATE products SET products_quantity_order_units = 1;

24 Feb 2012, 9:57 PM

#7

feznizzle

Totally Zenned

Join Date:: Apr 2010
Posts:: 900
Plugin Contributions:: 0

Re: Updating all products to show quantity box

Ajeh,

Has anybody told you lately that you are
AWESOME!

Thank you so much!
:clap::clap::clap:

24 Feb 2012, 10:01 PM

#8

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Updating all products to show quantity box

You are most welcome ... thanks for the update that this is working for you ... :cool: