• Registered: 2009-06-12
  • Posts: 3

Topic: Low Inventory

It would be nice to have the option of setting a low quantity for inventory items and then have the system highlight or flag the item if the quantity falls below the specified amount.

  • Registered: 2009-08-11
  • Posts: 3

Re: Low Inventory

This would be an extremely useful function to have. I have been trying to create my own PHP/SQL page to do this.

  • Registered: 2010-02-08
  • Posts: 3

Re: Low Inventory

Might even be nicer to have the system email administrators upon low inventory status. I am assuming this might require a cron job in the background or some script in the header that would check periodically upon page refreshes seeing as inventory levels would not adjust unless someone was logged into the system anyway (assuming the portable page would not affect quantities).

  • Registered: 2011-01-05
  • Posts: 19

Re: Low Inventory

I just had a request for this feature.  I pushed back and asked How do you intend to use this?.  There was no good answer so I suggested:

  • Add a new inventory column called WarningLevel.

  • Add another inventory column called CriticalLevel.

  • Set appropriate values for each inventory item.

  • Create a new report that lists 1) Inventory items with quantity <= WarningLevel and > CriticalLevel, and 2) Inventory items with quantity <= CriticalLevel.

  • When its time to reorder to replenish inventory, run the report.

  • Place orders based off of the report.  I assume reports don't have pagination issues (20 results per page, etc) and can be printed.

This would work fine for users who place orders on a periodic basis.  I doubt that the users place inventory reorders constantly.  And I'm guessing that this functionality is much easier to implement.