Help with Product Quantity

Hi, I recently asked a similar question on this subject and I still need help.
I only want 1 of each item added to the cart & I would like the Max 1 to be shown in the cart and category area. How can I get the Max 1 on all my items that have already been listed and on all future items?
I was shown how to do this to each individual item using the product's detail page in the Admin, but I hope I would not have to do it to all 800 items one at a time.
Thanks for any help on this subject.

I guess this not worth a reply .... thanks anyway!!!

If you want Maximum to be 1 for all products in the database table products you can run this command in the Tools ... Insert SQL Patches ...

UPDATE products SET products_quantity_order_max = 1;

To make this a default setting when adding products you would need to customize the file:
/admin/includes/modules/product/collect_info.php

and change approximately line 36 from:

                       'products_quantity_order_max' => '0',

to read:

                       'products_quantity_order_max' => '1',

NOTE: there are no overrides for this file ...

Thank you, Thank you, Thank you...... it worked...
easy when you know how to do it...

Thanks for the update and glad that this worked for you ... :smile:

how do I re-set the SQL entry...I mis-understood this post and now I want to reverse it.

Zidain

To not have a Maximum value set on the Products use the same command but with the 0 value:

UPDATE products SET products_quantity_order_max = 0; 

0 means Unlimited ...