I would like to be able to do run a low stock inventory report so I know in advance when an item is going to become unavailable. For this there would have to be a field for a Re-Order Point. The Reorder Point determines when an item should be re-ordered.
TOCDCO
2 Dec 2008 2:25 AM
Correct... as of right now, only reporting is available for "out of stock" products report...
This should be a given..
Last modified: 2 Dec 2008 2:25 AM
Studiotech
2 Dec 2008 7:55 AM
Most of ERP and other webshop systems this task is called minimum and maximum stock quantity.
The most advanced ERPs can suggest / shedule a reorder (from the manufacturer) when the min. qty is achieved and the Reorder qty is the Max-the actual (min.) to fill up the stock to max...
We do it this in another system (ERP), and in my family webshop I do it simply in excel.
The bast way could be:
Min stock / Product
Max stock / Product
And a notification email with suggested reorder amount, when stock is at min qty.
wazoodle
2 Dec 2008 11:47 AM
If there is an review and upgrade to low stock functionality, I'd recommend the following:
1) Add the following fields to category and product tables:
Reorder Point (number)
Reorder Quantity (number)
Notification Email (email address)
2) Notification feature. Trigger a notification email when stock reaches Reader Point.
3) Stock Report. The stock report should list all products and their current inventory. Further to that, the report should be able to filter to only products below a number and all products that are at or below their Reorder Point.
Finally, and maybe another topic, there should be a way to use CRON to run reports. Most merchants need the same reports over and over again, rather than running them manually each day/week/month/quarter, it would be nice to have CRON run them.
