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
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
no reply ?
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:
Code:UPDATE products SET products_qty_box_status = 1;
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
thank you Oba san !
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
You cannot use:
Minimum 0
Units 0
as there is no such thing ...
Code:UPDATE products SET products_quantity_order_min = 1;Code:UPDATE products SET products_quantity_order_units = 1;
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Ajeh,
Has anybody told you lately that you are
AWESOME!
Thank you so much!
You are most welcome ... thanks for the update that this is working for you ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Bookmarks