SOLVED Low stock notification email - stock quantity wrong

[lostmail]

Sample:
I have 10 in stock
Low stock is set at 3

Order is 8 pcs.

Admin gets an email notification that there are 10 in stock...

Something`s wrong here...should be 2 pcs. remaining - not 10.
10-8 = 2

[Jörgen]

Check without overrides, could be an template issue. Not calculating with reserved. I guess the stock of 8 is still reserved, yes ?

Jörgen @ Kreativ Fotografi

[jenkinhill]

Surely stock total is not reduced until the products are shipped.

[lostmail]

Hm would it not make sense to have the left over products calculated after the order is placed ? So it`s irritating if there is the stock amoung without the open orders...

[pinochico]

So it`s irritating if there is the stock amoung without the open orders...

is not, it is exactly what we require from the e-shop.

[lostmail]

HM I think it is....normally the availibility for disposition is calculated with open orders to decide if it is urgent or not to re-order....only for inventory you need the current stock status but for on going disposition you need to know what the availibilty.
thats the different between stock status and availibility.....every ERP availibilty is working with open/pending oders included (Disposition).
And at last it`s the first information you get from the system where you can see what the availibility is - not the stock status before the (last) orders..

Or do you see open orders not relevant for stock status and cancel them ?

[pinochico]

We are tailoring the bridge between VM and ERP.

If there are 10 items in stock and 8 items in reservations, you actually have
- 10 boxes in stock
- in stock 8 pcs out of 10 pcs are packed and reserved for customers = no one can order them until the ordering process is completed
- in stock you have 2 pcs of 10 pcs free to order

This is the correct functionality of the eshop and the VM surprisingly adheres to it.

Even for ERP (warehouse) it is right, because if the control comes from the tax office, you still have the right number of pieces in stock - 10 pieces == you have 10 pieces in stock and therefore in the cost of the company.

I don't really understand what you're trying to achieve - it seems to me that you want only 2 pieces in stock?

But that contradicts the laws of nature - I still have 10 pieces of goods on the shelf in the warehouse - they are not lost anywhere, no one took them.

Sorry - Google Translate

[lostmail]

It`s all OK but not the "low stock email notification" when the low stock minimum is reached.

I have 10 in stock.
Low stock is set to 3

Now comes an order with 8 pcs.

In that moment I receive the los stock email notification that 10 pcs. are in stock.....this is true; temporarily but the AVAILABILITY is relevant here....it`s now 10-8 = 2

So the Email is irritating because it tells the stock status (10 pcs.) before the order (8 pcs.) comes in which activates the low stock email notification.

[lostmail]

We are tailoring the bridge between VM and ERP.

If there are 10 items in stock and 8 items in reservations, you actually have
- 10 boxes in stock
- in stock 8 pcs out of 10 pcs are packed and reserved for customers = no one can order them until the ordering process is completed
- in stock you have 2 pcs of 10 pcs free to order

That is correct.
But what should it be good for taht the low stock email notification tell that there are 10 pcs. in STOCK....?
It would make sense that there ae currently 2 pcs. AVAILABLE....

[Jörgen]

Is this one order of 8 that is shipped or is another order involved ? The email informes that the order quantity in stock is under 3 but You have an extra order that reserves another 8  that have not been removed from stock yet ?

If You had only one order you would have gotten the message that there are 2 in stock after shipment.


Jörgen

[lostmail]

Yes - I placed one order about 8 pcs. in test system to check what happens with the low stock email notification.

As you mentioned the message should be:

"there are 2 in stock after shipment." 

But in the sent email message you see, that not the available pcs. AFTER shipment but the stock pcs. BEFORE the order  is shipped.

[Jörgen]

This is not happening in my store I get the stock e-mail after shipment and with two in stock not ten as You mention. Are all Your order statuses correct ? I guess you have "is removed" chosen to early in You work flow. It should only be chosen for "shipped", "delivered" or similar statuses.

Jörgen @ Kreativ Fotografi

[lostmail]

Hm - is there a point in configuration to set the status when low stock mail should be sent ?

[Jörgen]

As i said in My earlier post "is removed' should only be assigned to order status, shipped, delivered or similar. Depends om your workflow. I.e when products have been taken out from stock.
Jörgen @ Kreativ Fotografi

[lostmail]

Where is the order status set to initiate sending "the low stock notification" ?
I think it has to be "order completed"....but it seems my system is sending out it one step before...