ZENCART ZENSDAY – Predictive inventory. Ok, folks this is likely one of the most useful parts of our Adafruit business we’re thrilled to share with the world… One of the ‘brick walls’ that any business eventually hits is how to manage inventory. If you’re a one person shop and you have 10 items to keep track of, you can probably do it all in your head. But once you get to 25 or so items it can get really messy. That’s why a few years ago we wrote up our own ‘predictive’ inventory system. Now to make it absolutely clear, this php code cannot actually see into the future. However, it can look into the past and make a good educated guess about how long your inventory will last assuming you have pretty steady purchasing history.

Basically, this code will look at all your product categories and items and sum up how many orders were placed for these items. Then it puts them in a table with the current inventory/stock. The table entries have a background of light red if your current inventory will run out before then. For example lets look at this screenshot:

If the future purchasing is like the past, then we’ll run out of 9V regulated adapters in about 4-6 weeks. If you know the approximate lead time for stuff you buy then you can just keep ordering just when the ‘red bars’ start showing up too much!

Read more!