Help with Product Quantity

[Basta]

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.

[Basta]

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

[Ajeh]

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

[Basta]

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

[Ajeh]

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

[zidain]

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

Zidain

[Ajeh]

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