Quantity Box

[ekat]

The quantity box does not show in the shopping cart. I'm thinking I accidently turned it off but for the life of me I can't figure out where to turn it back on. Any help would be greatly appreciated

[Ajeh]

Edit a product ... do you have:

Products Quantity Box Shows:
Yes, Show Quantity Box
No, Do not show Quantity Box

Needs to be on YES

[ekat]

Ohhhhhhh! Heh, yup I turned them off. Thanks so much!

[finius_lyn]

Anyone know how to set multiple products to 'on' at a time? for some reason it is defaulting to 'no' when I add products using easy populate.
This is frustrating as I have about 9,000 products to upload and don't want to change this by hand for each one.
Any help would be appreciated...

[Ajeh]

The default in the database table for products should be 1 ...

I am not sure what you are using in your import, but setting that to 1 is what you want ...

If you cannot do this on the import then you can run it via the Tools ... Insert SQL Patch ...

UPDATE products SET products_qty_box_status = 1; 

[finius_lyn]

The box is now showing, but I still get a nasty error.
Specifically, when someone adds a product to the shopping cart, you get this error:
Product Name: whatever product ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

The default in the database table for products should be 1 ...

I am not sure what you are using in your import, but setting that to 1 is what you want ...

If you cannot do this on the import then you can run it via the Tools ... Insert SQL Patch ...

UPDATE products SET products_qty_box_status = 1;