Warning Please update your order ...

[wtashby]

First, I appologise for crossposting this question

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?

[Ajeh]

Check again to be sure ...

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

[wtashby]

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.

[wtashby]

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

[wtashby]

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

[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; 

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

[wtashby]

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.

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

[Ajeh]

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; 

[wtashby]

Yep

That did the trick!

Thanks Linda,

You are a True Zen Gem