Warning: Low Stock

Hi,

After upgrading from to v1.3.9c, we keep receiving the low stock email warning every time a new order comes in. This didn't happen in v1.3.7. Did something change? How do I fix this?

Check the Stock settings and see what you have the low stock set to and if you have the email settings turned on in the Emails ...

Hi Ajeh

All the current v1.3.9 settings are the same as v1.3.7.
Stock Re-order level is 5.
Send Low Stock Emails is 1.

Why didn't I have this problem in v1.3.7 but now I do in v1.3.9 ? Did I do something wrong somewhere?

How many do you have in stock?

Send Low Stock is an on/off switch in the Email settings ...

The email goes out at or below the Stock Re-order level ...

I have 100 in stock for all products. The email is sent every time a new order comes in... it doesn't make sense.

So all stock levels on the products_quantity is > 5 on an order and you have reorder level at 5 and you are still getting this low stock email?

Browse the configuration database table for the configuration_key:
STOCK_REORDER_LEVEL

Make sure you only have 1 record in there for that configuration_key ...

Yes, that's correct. Other people are having the same problem.
I did a search and yes only have 1 record in there for the configuration_key of STOCK_REORDER_LEVEL.

So far I cannot reproduce this issue ...

I get the Low Stock Email when I hit the Low Stock Level and will continue to get the Low Stock Email every time the Product is sold until it has its products_quantity raised about the Low Stock level ...

Hi Ajeh

Which file(s) control this? Perhaps I can upload the original file(s) and see if it makes a difference.

This is done in the Orders class in the
/includes/classes/order.php

You might do a compare of this file against the original ...

We just upgraded a 1.3.8a to .9h - and it's happening with us as well. Checked every setting, have 13 in stock, stock check level is 1, and yet every order we get an email.

The interesting thing is that it's saying stock is ' -1 ' ...

Was there a fix or a place to look for this one besides orders.php?!? (which I'll check in a moment...)

Fez-o Joe:

The interesting thing is that it's saying stock is ' -1 ' ...

If you have 13 in stock ... where are you seeing the 13 and where are you seeing the -1 ...

13 is listed while viewing the product in its quantity available under Catalog, Products, etc.

-1 is in the email being sent each time. It would happen with any product. (the 13 is currently the Sons fez)

---- cutsnippaste -----
Low Stock Report:

ID# 143, 2X (24 inches), The Honu Fez - 2XL (24 inches), Tassel :: Green,
Venting :: Antique Copper, Stock: -1

It's looking like it may be the 'Stock by Attributes' add-on, which doesn't do what we need it to do... so, let me uninstall that and turn the email notification back on and see if it happens. (it was the only code change in orders.php)

This has always happened with me during the almost three years I've been using Zen Cart. I finally just turned off the notification, which sucks when things actually do go out of stock and I don't notice; but it's six of one, half dozen of the other since every order generated the low stock email, I wasn't paying attention to them...

Anyone come up to a solution to this that searching around didn't find?