Help Center

Understanding the Core Item Replenishment Report

Sarah Barr
Sarah Barr
  • Updated

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.
Tip: Watch the OTB After column. If an order pushes a class negative, you can lower the weeks-of-supply target, or prioritize the Order now items and leave Next order for later.
Tip: Before a big selling period, change the date range to the same period last year so the recommendations reflect that season's selling pace.

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.

© ManagementONE® · Retail ORBIT® Powered by Management One

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.