Reorder lists from sales pace
On a set schedule, SI turns recent usage or sales and stock on hand into a suggested reorder list grouped by supplier, for you to approve.
The problem
Reordering happens from memory or a quick look at the shelf. Fast movers run out, slow movers get reordered anyway, and nobody has time to do the math across hundreds of items.
What SI does
SI reads recent sales or usage per item, stock on hand and on order, and each supplier's lead time and minimum order. It works out how many days of stock remain, flags anything that will run out before the next delivery could arrive, and drafts a reorder list per supplier with a short reason next to each line (for example, 'using faster than last month, about nine days left, three-week lead time').
Examples
The same job looks different in different businesses. These are illustrations, not client results.
- Restaurant
Weekly usage from the point-of-sale system and the last inventory count produce a list for the produce, dry goods and paper suppliers, with a note that the brunch menu is using eggs faster.
- Dental office
Gloves, impression material and sterilization pouches are tracked from monthly counts, and the order is drafted before the distributor's cutoff.
- Online store
Units sold per variant over the last 30 and 90 days and current stock produce a reorder list per supplier, flagging three variants that will run out before restock.
What it takes to set up
Read access to sales or usage data (point of sale, order system, job records or a stock sheet) plus one sheet of suppliers, lead times, pack sizes and minimums. Agree on how much stock to keep per item group. Setup is often about a week including tuning.
What a human still checks
- The buyer or owner reviews every line and edits quantities before anything goes to a supplier.
- SI only drafts; it does not place orders.
- Seasonal and discontinued items are marked so they are not suggested blindly.
Try it yourself
Paste this into your SI tool of choice and swap the [bracketed] parts for your own details. It asks SI to stop and show you before it does anything.
Using this sales or usage data [file] for the last [90] days and my stock on hand [file], estimate days of stock left for each item. Use these lead times and minimums [supplier sheet]. Draft a reorder list grouped by supplier with a one-line reason for each item, and flag anything with less than [14] days left. Pause and show me before sending, submitting, posting or changing anything.
Next step
Want this built? Book a free 30-minute consult
Bring one real example, such as an export, an inbox, or a spreadsheet. We will map the steps and decide what SI drafts and what you approve.