frame

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register
Hello m'Managerians !
What do you think m'Manager 2.0 should be ? What features SHOULD or MUST be implemented right now ! Request or Vote here

Low Stock Alert on Service Items

edited June 10 in Bugs Report

Hi,
If you want to fix this issue before next release, open application/helpers/mm_standalone_helper.php and search for function alert_low_stock() Update the query this way:


$query = "SELECT item_id, sku, name, available, reorder_point FROM oc_items WHERE available <= reorder_point AND date(next_stock_warning) = DATE(NOW()) OR date(next_stock_warning) IS NULL AND is_service = 0";

Thanks
Eric

Tagged:
Sign In or Register to comment.

m'Manager

| Let's Build Together a Great App !
If you are a happy user, send me a coffee.
2015 - 2107 © m'Manager.
Powered by VanillaForums, Designed by ThemeSteam

Recent Donations

  • Joni Mueller from https://pixelita.com/ - 63€
  • HeyrmanD from https://locco-palace.be - 25€
  • Patricia from Sjopz.com - 10€
  • AskinSavascisi from wolftech.com - 3€
  • Get In Touch