... Quantity Units errors - please update your order

[w2e]

When I add something to cart, I get this error message:

Please update your order
... Quantity Units errors - You ordered a total of: 1 Min: 0 Units: 0

I noticed that there is no quantity showing next to the add-to-cart button.

What's wrong? How do I fix this?

Thanks.

[kbalona]

Did you upload items with Easy Populate? I got that error when I uploaded items using EP Advanced. I fixed it by running:

UPDATE products SET products_quantity_order_min = 1;
UPDATE products SET products_quantity_order_units = 1;
UPDATE products SET products_quantity_order_max = 0;

on the "Tools>Install SQL Patches" page. Backup your database before you run it.

[countrycharm]

What does this code actually do. It does not fix the actual problem in Product in Category: where it reads
Warning: Does not show Quantity Box, Default to Qty 1. I know that box is suppose to be checked, but I also uploaded 2100 different items with EP Advanced. I have each product set at 200 each. Will this code still work after someone makes a purchase or will that product show out of stock.

UPDATE products SET products_quantity_order_units = 1

Thank you