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 ...

[John Vieth]

Is there a similar UPDATE query that would force the quantity field to appear on all product pages? ...because that seems to be part of the problem, too--the quantity field disappeared. I can go back into individual products and turn it on, but I don't want to do that for thousands of products.

Also, regarding Easy Populate... Is there a more reliable way to do bulk updates that is not too time consuming?

Thanks,
John

[Ajeh]

Again backup first ...

If this is the result of bad data, it can be fixed with:

UPDATE products set products_qty_box_status = 1; 

I'd really try to find out what is breaking things first ...

[John Vieth]

That did the trick. I had to run all four of the queries below, of course after first replacing "products" with the name of my products table, like xxxxx_products...

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

I'm pretty sure the data was corrupted in the first place as a result of some clumsy Easy Populate handy work on my part. I'll be more careful in the future. I'm kind of afraid to do a lot of work with attributes because it will probably just make the whole Easy Populate process even trickier, but nothing ventured nothing gained "they" say.

I do have one more question... While cleaning up my products table, I found the following columns, but I can't find a place in the admin where I can edit them...

metatags_title_status
metatags_products_name_status
metatags_model_status
metatags_price_status
metatags_title_tagline_status

How are these altered in the admin? Please advise.

Thanks for all your help everyone!!!

[Ajeh]

When on the Product listing in the Catalog of the Admin there is either a Black or Orange biohazard icon ...

When Black there are no custom meta tag settings when Orange then there are custom meta tag settings ...

Update the Products meta tags in this manner and there are also similar settings for Categories ...