Warning notice when adding products to shopping cart

[John Vieth]

Visitors now get a warning notice when adding products to shopping cart. The notice appears in a yellow box at the top of the shopping cart page. The message is something like the following...

Please update your order ...
Product Name: Widget X ... Quantity Units errors -
You ordered a total of: 2 Min: 0 Units: 0

What's up? This never happened before. Please help.

- John

[Ajeh]

There is no such thing as 0 Units ... have you ever tried to buy 0 grapefruits at the store? They really look at you funny in the checkout line ...

There is no such thing as 0 Minimum either ... for the same reason ... why would I have to buy 0 widgets to get out of said store?

The defaults on these are:
Minimum: 1
Maximum: 0 (unlimited)
Units: 1

and should be left as such unless you specifically need to say, you must order 6 widgets in units of 2 ... meaning, at least 6 but then can get 6, 8, 10, 12, 14, etc.

[John Vieth]

How did these get changed? Do I need to set them to the default using Easy Populate or something? I have thousands of products, so I really don't want to update each product manually.

[Ajeh]

Somewhere along the way either you or Easy Populate is goobering up your data ...

Check to see what happens if you click on NEW PRODUCT button and see if they are set to the DEFAULTS of:

Product Qty Minimum: 1
Product Qty Maximum: 0 0 = Unlimited, 1 = No Qty Boxes
Product Qty Units: 1

If so, either Easy Populate is setup wrong or your database defaults in the products table are incorrect for the fields:

products_quantity_order_min 1
products_quantity_order_units 1
products_quantity_order_max 0

These can all be fixed easily back to the defaults with:

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

in the Tools ... Insert SQL Patches ...

But it is a good idea to find out the cause for this problem as well as fix the issues ...

NOTE: Always make a backup before making changes to your database tables ...

[John Vieth]

Wow! Thanks for that! You really spoon fed me exactly what I needed. I had a feeling an update query would fix it, but you spelled it all out. Thanks!

[Ajeh]

We do aim to please ...

Glad that this could help you ...