Thread: Monitoring Inventory and Establishing Reorder Points

We currently have “ShowInventoryTable” AppConfig set to on and can view product inventory levels on a product by product basis and by variant.

We are looking for a solution to GLOBALLY manage/view ALL products on a single page view. Also seeking to establish "Reorder Points" that alert us when stock levels reach predetermined minimums. (Either by "flagging" items or by e-mail.)

Thanks.

Thanks for all the help folks. I had read this forum was abysmal and now I know why.

Since forum solutions are offered FREE sometimes it is difficult to offer advice because to some of us what a member asks of the forum would take a lot of work. You are asking for something which is not available out-of-the-box and so custom-design is involved.

Also, I would suggest that you wouldn't really want to call a page which loads all of your products. Certainly a lot of us have product lists into the thousands and waiting for that page to build would be a pain.

I would suggest that you prepare a spreadsheet with the data and use its forumla capabilities to prepare SQL statements which you could then fire at the database. Also, for emailing you when you reach your re-order points you could use triggers on the tables, such that when your levels drop below your level it sends you an email.

There are various examples within the forum of both of these ideas. I know, because I've posted about them before.

Alternatively you could offer to pay for a solution. I'm sure you'll get some other replies.

Thank you esedirect. Straight talk and straight answers. I'm learning that with immense power comes responsibility and expertise I'm not fluent in. I'll need to hire someone more savvy than I to create my solutions, so be it.

You have made a new best friend. Thank you.

Cheers!