Warning Please update your order ...

First, I appologise for crossposting this question:blush:

When adding items to the shopping cart, I get this error

Warning Please update your order ...
Product Name: San Antonio Spurs 3 Time Champion 24KT Gold Coin ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0 *Mixed Option Values is ON

but, all of my settings are:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: No

What else could be the problem?

Check again to be sure ...

That error looks like someone has 0 for minimum and 0 for units ...

Ajeh:

Check again to be sure ...

That error looks like someone has 0 for minimum and 0 for units ...

This error occured after I made a test order. No matter how many of a product I put into the basket, or, how many different products I add, I get the same error.

I've checked my settings, specifically for the products that I placed into the cart, and the settings are as I stated earlier:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: No

wtashby:

This error occured after I made a test order. No matter how many of a product I put into the basket, or, how many different products I add, I get the same error.

I've checked my settings, specifically for the products that I placed into the cart, and the settings are as I stated earlier:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1
Product Qty Min/Unit Mix: No

The problem is occuring at The Ashby Mint, and I can't seem to find anyway of correcting it. Everything is set properly (or so I believe) in admin, but, In the catalog, it shows

Min: 0 Units: 0
*Mixed ON

for ALL the products.

Please, someone take a look and see if you can help me.

Ajeh:

Check again to be sure ...

That error looks like someone has 0 for minimum and 0 for units ...
Linda,

I discovered something. ALL of my products, for some reason have the Products Quantity Box Shows: set to No, Do not show Quantity Box.

This is the cause of my problems. Is there a way to globaly set this to Yes? I have several hundred products and it would take hours to do it manually.

Thanks

Is there a way to globaly change the Products Quantity Box Status from No to Yes? Maybe even an SQL query? With my limited time, it would take a month of sundays to manually change them all.

Thanks,

Tom

You mean a simple command that you could run in the Tools ... Install SQL Patches ... such as:

UPDATE products SET products_qty_box_status=1;

that might get you back on track and save you hours and hours of valuable time that could be better spent doing something else ... :smartass:

Ajeh:

You mean a simple command that you could run in the Tools ... Install SQL Patches ... such as:

UPDATE products SET products_qty_box_status=1;

Nope,  That didn't work.:cry:

I'm still getting:

> Warning Please update your order ...
> Product Name: 2006 Los Angeles Angels Team Force Photomint ... Quantity Units errors -
> You ordered a total of: 1 Min: 0 Units: 0  *Mixed Option Values is ON

Go to phpMyAdmin ...

Find your database ...

Browse the products table ...

Sort on the fields:
products_quantity_order_min
products_quantity_order_units

Do you find a bunch set to 0 ...

These cannot be 0 they should be at least 1

If all are set to 1 ... make sure your Admin and Catalog configure.php files are both using the same database information ...

Otherwise, fix these with:

UPDATE products SET products_quantity_order_min=1;

UPDATE products SET products_quantity_order_units=1;

Yep:thumbsup: :thumbsup:

That did the trick!

Thanks Linda,

You are a True Zen Gem:wink2:

You are most welcome and glad to have been able to save you hours and hours and days and days of edit ... :smile:

:laugh:

Did you take a :smartass: pill today?

Thanks again, and I hope this helps anyone else that may have this problem, now, or in the future.

Lots of pills ... it has been a stressful week ... :cool: