Reorder stock alert

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Carolharry
Commander (CMDR)
Commander (CMDR)
Posts: 121
Joined: Wed Dec 17, 2008 9:13 am

Reorder stock alert

Post by Carolharry » Mon Feb 09, 2009 3:45 pm

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

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: Reorder stock alert

Post by nickc » Mon Feb 09, 2009 5:09 pm

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

Carolharry
Commander (CMDR)
Commander (CMDR)
Posts: 121
Joined: Wed Dec 17, 2008 9:13 am

Re: Reorder stock alert

Post by Carolharry » Tue Feb 10, 2009 8:49 am

Thank you so much for your response.

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

Carol.

Post Reply