Zen Cart Logo
Forums / General Questions / Install SQL Patch for: Products Quantity Box Shows: Yes, show quantity box?

Install SQL Patch for: Products Quantity Box Shows: Yes, show quantity box?

Views: 897

Results 1 to 2 of 2
11 Mar 2015, 8:12 PM
#1
sports_guy avatar

sports_guy

Totally Zenned

Join Date:
Apr 2007
Location:
Dayton, Ohio
Posts:
682
Plugin Contributions:
0

Install SQL Patch for: Products Quantity Box Shows: Yes, show quantity box?

I am running an older version of Zen Cart (v1.3.9h). Yes, I know it needs updated but I cannot do it just yet. Hopefuly that is coming soon.

My problem is I have lots of products (700+) and each and every product was marked as: Products Quantity Box Shows: No, Do not show Quantity Box. Being set this way, people cannot add multiple products or update the quantity directly from the shopping cart page. So in experimenting I changed this radio to yes, and the multiple box location was then available on my shopping cart page.

Now I know I need to change this setting from: Yes, show quantity box
To: No, Do not show Quantity Box for every single product.

Is there a way I an execut a SQL patch directly fro Install SQL that will change this one option on each and every product? This would save me boatloads of time from having to open each and every product, change this radio, and then click save over and over.

5 Aug 2015, 12:11 PM
#2
icarp avatar

icarp

New Zenner

Join Date:
Feb 2009
Location:
sunny southern Ontario
Posts:
22
Plugin Contributions:
0

Re: Install SQL Patch for: Products Quantity Box Shows: Yes, show quantity box?

I used phpMyAdmin to run this:

UPDATE products SET products_qty_box_status=0

This came courtesy of Ajeh.