@irish.chen the point about par levels and reorder points living only
inside Stocky’s app logic is right on the facts, but I’d push back on
whether it’s worth a week of screenshotting.
A reorder point in Stocky is a number somebody typed in at some point,
usually a while ago. It doesn’t move when the product’s sales move. So
when you migrate it, you’re carrying over a decision made against last
year’s demand and treating it as data.
The settings actually worth capturing are the ones that aren’t derived
from sales at all:
- supplier MOQs and case/pack sizes
- shelf or storage capacity ceilings
- anything contractual
Those can’t be recomputed from anything, and they’re gone on the 31st.
Reorder points, par levels and safety stock are a different matter — you
can rebuild those in an afternoon from sales history plus lead time, and
you’ll end up with better numbers than the ones you rescued.
Two additions to @HJBCodeforge’s list, which I think is the most useful
summary in this thread:
On reconstructing lead time from received_at — use the median, not the
mean. One container stuck in customs drags a mean out by weeks and
quietly inflates every reorder point you compute from it. Since partial
deliveries give you several received dates per PO, you usually have
enough points for a median to be meaningful.
On velocity — a single window hides the thing that actually causes the
stockouts. A product selling at its 30-day average is predictable. A
product whose last 7 days are running 40% above its 30-day average has
moved its own stockout date forward by about a week, without a single
unit leaving your stock plan, and a static reorder point won’t notice
until it’s already been crossed. Comparing the two windows costs nothing
— both are inside the same 30 days of order data you’re already pulling
— and that comparison is where the surprises live.
Disclosure: I’m building in this space (StockPulse). For the question in
the title, I’m not the answer — no purchase orders, no receiving, no
suggested quantities. @HJBCodeforge’s Replenora and brata’s BR
Inventory Planner both cover the PO half properly and mine doesn’t.
Mine only does the days-of-cover and order-by-date part. I put that
calculation up as a free page — no signup, runs in your browser — if you
want to sanity-check one product against whatever you end up picking: