Retail ORBIT® Knowledge Base · Custom Reports
Understanding the Core Item Replenishment Report
Keep the items you always carry in stock: see what's about to run out, how much to order, and what that order does to your open-to-buy.
What this report does
Core items are the products you keep in stock all the time: your basics, best-selling tees, everyday restocks. For each core item, the Core Item Replenishment report shows:
- When it will run out, based on how fast it sells and what's already on order
- Whether you need to order now, given how long your vendor takes to deliver and how often you place orders
- How many units to order
- What that order does to your open-to-buy (OTB)
The report is sorted most urgent first, so the items you need to order now are at the top.
Where to find it
In Retail ORBIT, go to Reports → Custom Reports tab → click the Core Item Replenishment card.
How Retail ORBIT decides what's "core"
There are two ways an item becomes a core item:
Detected: Retail ORBIT looks at your sales history. By default, an item that sold in at least 9 of the last 12 weeks counts as core. You can change these numbers in Settings.
Pinned: You choose. Click the pin icon next to a product name to mark it as core, or to remove an item that was detected but isn't really a core item for you. Pins are saved for your whole company, so everyone on your account sees the same list.
The Core items filter controls which items appear: Detected + pinned (the default), Detected only, Pinned only, or All items.
Reading the report
Status
Status compares when an item will run out with how soon you could get more. Restock time is your vendor's lead time (how long an order takes to arrive) plus your order cadence (how often you place orders).
| Status | What it means |
|---|---|
| Order now | The item will run out before a new order could arrive. Order it on this order. |
| Next order | It's getting close. Plan it into your next order. |
| Covered | You have enough on hand and on order for now. |
| Insufficient data | Not enough history to make a recommendation, usually fewer than 14 days in stock or no receiving data. No order is suggested. |
Key columns
| Column | What it tells you |
|---|---|
| Product | The style name, how many SKUs it has and how many need ordering, plus whether it's core because it was detected or pinned. |
| Status | Order now, Next order, Covered or Insufficient data (see above). |
| OTB · Suggested Orders $ · OTB After | Your open-to-buy, the dollar value of the suggested orders, and the open-to-buy left after placing them. Shown on Total, Category and Class rows. |
| Stockout Date | The day the item is expected to run out, counting stock on hand and purchase orders that arrive before then. |
| Units OH | Units on hand today. |
| On Order | Units on open purchase orders, with the next arrival date. |
| Velocity / Day | Average units sold per day, counting only the days the item was actually in stock. |
| Trend | Whether sales are speeding up or slowing down: the last 4 weeks compared with the 4 weeks before. |
| Weeks of Supply | How many weeks your current stock will last at the current selling pace. |
| Suggested Reorder | Units to order so you stay in stock until your next order arrives and still have your target weeks of cover. |
More columns are available from the Columns menu, including Net Sales, margin, Sell-Through %, Lost Sales and Last Order Date.
How the suggested reorder is calculated
In plain terms: Retail ORBIT works out how many units you'll sell between now and when your next order is in place, adds the weeks of cover you want to keep on hand, then subtracts what you already have and what's arriving in time. The target cover comes from your plan for that class, plus a little extra for core items (1.25× by default). You can type your own weeks-of-supply target to override it.
Filters and controls
| Control | Use it to… |
|---|---|
| Date range | Choose the sales period for the sales columns: 1, 3 (default) or 6 months, or a custom range. |
| Location · Category · Class · Vendor | Narrow the report. Each filter also has Exclude selected to show everything except your choice. |
| Status · Core items | Show only certain statuses (for example, just Order now) or choose which core items to include. |
| On-order and OTB span | How far ahead to count purchase orders and open-to-buy. Default is 3 months out. |
| Values: Retail | Cost | Show dollar columns at retail or at cost. |
| Product | SKU | Switch to SKU to see every size and color under each product. |
| Weeks of supply target | Type a number of weeks (1–52) to override the plan-based target. Clear it to go back to the plan. |
| Hide covered · Hide zero-sales SKUs | Clean up the view so you only see what needs action. |
| Hierarchy | Group the report: Total by Product, Category by Product, Class by Product, Vendor by Product, or Product by Location. OTB columns appear only in the first three. |
Report settings
Click Settings to fine-tune how recommendations are made. Changes recalculate the table right away. Each setting shows where its value comes from: Default, Client, From plan or You.
| Setting | Default |
|---|---|
| Lead time (how long orders take to arrive) | 2 weeks |
| Order cadence (how often you order) | 2 weeks |
| Core uplift (extra cover for core items) | 1.25× |
| Velocity lookback | 12 weeks |
| Minimum in-stock days | 14 days |
| Core detection: sold in N of last M weeks | 9 of 12 |
Use Save to this view to keep your settings with a saved view, or Reset to client defaults to undo your changes.
Step by step: build a reorder
| 01 | Open the report from Reports → Custom Reports → Core Item Replenishment. |
| 02 | Check your settings. Make sure lead time and order cadence match how you really buy. If your vendor takes 6 weeks, a 2-week lead time will under-order. |
| 03 | Review the core list. Pin any basics that are missing, and unpin anything that isn't really core. |
| 04 | Filter Status to Order now (or turn on Hide covered). |
| 05 | Switch to Vendor by Product to see what each vendor needs, or Class by Product to check the order against your open-to-buy. |
| 06 | Switch to SKU view to see exactly which sizes and colors to order. |
| 07 | Click Export orders to download a CSV grouped by vendor, with one line per SKU, units to order and expected arrival. Use the export icon on a vendor row to export just that vendor. |
Related reports
- Top Sellers & Item Performance: SKU-level sales with recommended reorder quantities for any date range
- Aged Inventory: finds the goods that need to move
- Vendor Performance Analysis: shows vendor balance and open-to-buy
Questions? Contact your M1 Advisor or Retail ORBIT Support.
Comments
0 comments
Please sign in to leave a comment.