Help with order system

[Danimalistic]

How can I set up an automatic inventory re-order thresh-hold to automatically email a vendor to request additional inventory when a products stock is lower than the threshhold I set for it?

[Ajeh]

This could be done by adding a verification of products_quantity based on low level ... and then do a routine to sort the order by manufactuer ...

Add an email field to manufacturer ...

Then those with email addresses will get an email for only their products when that product(s) drops to the low order point ...

This may take a bit of work ... and you might want to consider a validation field to say that the email was sent so it doesn't keep sending the email while you wait for stock to be filled ... depending on what the low order is ...

Example: if set to 5 you do not want to send an email for products_quantity = 5, 4, 3, 2, 1 etc.

[Danimalistic]

Thanks for the quick response Ajeh. I'll start working on that today, as a new zenner I may be reposting to this with additional questions along the way.