Warning: Low Stock emails

[mcarbone]

I have my site configured to send a low stock warning email (which is very important) when the product dips below 5,000. The problem is that it sends that warning every time an order is placed.

What can I do to configure it so that the email is just sent once when the product is below 5,000?

Zen V: 1.3.8

Thanks so much!

MC

[DrByte]

You'd have to write custom code to set some sort of flag in the database saying that notification has already been sent, and then check for that flag before emailing ... and then when you restock the items you'll have to be sure that you reset that flag or else you'll not be notified again.

[mcarbone]

Challenging! I will try to do this.

I will start by looking at script in this file:
/includes/classes/order.php

I got here because I looked up in the developer's tool kit: EMAIL_TEXT_SUBJECT_LOWSTOCK.

Thanks for guidance Dr. Byte - am I on the right path?

MC

[mcarbone]

I think it is somewhere around here in order.php

if ($this->email_low_stock != '' and SEND_LOWSTOCK_EMAIL=='1') {
// send an email
$email_low_stock = SEND_EXTRA_LOW_STOCK_EMAIL_TITLE . "\n\n" . $this->email_low_stock;
zen_mail('', SEND_EXTRA_LOW_STOCK_EMAILS_TO, EMAIL_TEXT_SUBJECT_LOWSTOCK, $email_low_stock, STORE_OWNER, EMAIL_FROM, array('EMAIL_MESSAGE_HTML' => nl2br($email_low_stock)),'low_stock');
}

(line 939)
I need help on how to create a DB flag. I don't know how. But, I think I need to add another conditional stmt after :SEND_LOWSTOCK_EMAIL=='1'.

something like: "and db_flag== 1".

Would this work?

Thanks for all your help.

MC