Page 1 of 1

Reorder stock alert

Posted: Mon Feb 09, 2009 3:45 pm
by Carolharry
Hello Everyone,

We sell third party products on our site. So we buy them say in 200 count. We want an alert system which tells marketing that the stock has to be reordered once the stock out cout left out comes to 50. Is this possible in AbleCommerce in the box solution or can it be customized in any way?
The inventory control feature in Product page doesn't seem to do alerts.

Can anyone please give pointers.

Thanks alot,
Carol

Re: Reorder stock alert

Posted: Mon Feb 09, 2009 5:09 pm
by nickc
Possible to do directly from the database (assuming you're using SQL2005+).
Use a trigger to compare ac_Products.InStock with ac_Products.InStockWarningLevel:
see http://www.4guysfromrolla.com/webtech/t ... 06-1.shtml

Re: Reorder stock alert

Posted: Tue Feb 10, 2009 8:49 am
by Carolharry
Thank you so much for your response.

I thought we get that feature in Ablecommerce solution. Anyways, thank you again.

Carol.