Is there a wat to set a Minimum Qty By Manufacturer Only

[milobloom]

Is there a wat to set a Minimum Qty By Manufacturer Only?

I want to set a minimum qty of just 1 manufacturer so that they have to buy a minimum qty of 12.

Is there a way, even a sql statement to set them all at once instead of having to go into each one and set them.


Thanks in advance.

[Ajeh]

This is Zen Cart ... you can customize the code to do anything you like ... it just depends on how crafty you are with the code ...

[Ajeh]

Or .. do you mean a SQL to update the products table to force the 12 minimum on 1 manufactuers_id ...

[milobloom]

>>Or .. do you mean a SQL to update the products table to force the 12 minimum on 1 manufactuers_id ..

That is exactly what I am looking for...

[Ajeh]

Backup your database ...

After you have backed up your database ...

You did backup your database first, right?

You can use in the Tools ... Install SQL Patches ...

UPDATE products SET products_quantity_order_min = 12 where manufacturers_id = 49;

where 49 is the manufacturers_id for the Products that you want to have the minimum quantity of 12 on the add to cart ...

[milobloom]

Thank you very Much!

Its Always imperative that I back up first...

[Ajeh]

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