Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Would like the ability to specify at what quantity (per product) an e-mail will be sent to notify us when the inventory is getting low.
Right now it e-mails when it reaches and the out of stock level. But, if i set that to say 5 pieces so that i'm notified before i'm actually out of stock, the stock status is changed to "out of Stock" for the customers (have it set to "Show as out of Stock (do not allow orders)", but there is clearly still 5 pieces available to order. |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
Yes I have noticed that too. And I'm still getting out of stock notices on products that are no longer active.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Out of Stock and Low Stock Notification should be different. One for the email so I can order more stock, one for the customer to let him know we have no more stock.
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I'm not sure Dan is up to 3.2 -- that is where you get the "Low Stock Notification" feature -- that HELPS A LOT.
The problem with the email is it includes items that are NOT tracked by inventory -- these should be able to be filtered out. |
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
I'm getting a daily email stating "The following are low in stock or out of stock". I have my inventory items set to "Show as Out of Stock (Do Not allow Orders)". I have it set to go off when inventory falls to Zero. My email displays all products with zero inventory only on items where inventory is enabled. The only problem I have is it displays all zero inventory items including those that are inactive. It has been operating this way since BV5 came out. BV5 SP3.2.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Bob,
Modify the [dbo].[bvc_ProductInventory_AllLowStock_s] in your database and add
AND b.Status = 1 at the end of the where clause:
[...]
a.LastUpdated
FROM bvc_ProductInventory AS a JOIN bvc_Product AS b ON a.ProductBvin = b.bvin
WHERE a.ReorderLevel <= 0 AND b.TrackInventory = 1 AND b.Status = 1
To only get the products that are active.
Regards,
Corneliu |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.