Forecast column reference

Every column the Forecast view table can show, listed alphabetically under the name you see in the Columns picker and the table header. Use this when you know the column name and want the quick definition. For the grouped narrative version, see Forecast → Forecast view table.

Default visible marks the columns a new view starts with. Rows marked Sales Performance display mode are the columns the table shows when the view uses that display mode, next to Product/Variant Title and In Stock.

A

Column	What it shows
ABC AnalysisABC tierThe A / B / C grouping from ABC analysis: A is your highest-revenue tier, C is the long tail. Logistified computes it from sales over the configured lookback period. Read more →	A / B / C tier, driven by revenue concentration over the ABC lookback period.

B

Column	What it shows
Barcode	The variant’s barcode, with a copy button.
Buildable incl. Supplier Stock	Same as Buildable Now, plus your own stock held at suppliers. Needs Assemblified connected.
Buildable Now	Units buildable right now from on-hand component stock, pooled across selected locations. BOM items only. Needs Assemblified connected.

C

Column	What it shows
Capital Tied Up	Sales Performance display mode. The value of your stock at cost: In Stock × Shopify Unit Cost, in your currency. Empty without a unit cost.
Category Name	The product’s category.
CommittedCommitted quantityUnits reserved for customer orders that haven't shipped yet. Read more →	Units reserved for orders not yet shipped.

D

Column	What it shows
Daily Average Sales	Average units sold per day over the last 30 days. Hover for the 60- and 90-day averages.
Daily Avg Sales (30d)	Average units sold per day over the last 30 days.
Daily Avg Sales (60d)	Average units sold per day over the last 60 days.
Daily Avg Sales (90d)	Average units sold per day over the last 90 days.
Days of StockDays of stockHow many full days your stock lasts at the forecast pace before you would first miss a sale. Incoming stock counts if it arrives before then; when you'd run out first, the cell warns **Stock-out before incoming**. Read more →	Full days of stock left before you’d first miss sales at the forecast pace. Incoming stock counts if it arrives before then; the cell warns Stock-out before incoming when you’d run out first. Default visible.
Days of Stock with All IncomingDays of stock with all incomingHow many days until your stock is finally used up, counting every open purchase order and transfer order, including deliveries that land after a stock-out. Never lower than Days of stock. Read more →	Days until your stock is finally used up, counting every open PO and TO, including deliveries that land after a stockout. Never lower than Days of Stock.
Days Until Reorder PointDays until reorderHow many days until your on-hand inventory hits the reorder point. Less than zero means you're already overdue. Read more →	Days from today until your stock falls to the reorder point.
Demand Pattern	How regularly the item has sold, classified from the last 12 months of daily sales: Smooth, Intermittent, Lumpy, Erratic, or Insufficient data. Based on days with at least one sale, not order counts.
Discount Margin	Sales Performance display mode. Your gross margin at 15% and 25% off the current price, with the drop in percentage points against the full-price margin. Hover for 5% to 50% off. Needs a price and a Shopify Unit Cost.
Disputed Quantity	Units on POs in “Disputed” status.

E

Column	What it shows
EOQEconomic order quantityThe order size that minimises the combined cost of holding inventory and placing orders. Sometimes Logistified suggests it instead of the raw reorder quantity; when it does, you see a green "EOQ" pill in the cell. Read more →	Economic order quantity: the order size that minimises holding + ordering cost.

F

Column	What it shows
Forecast HorizonForecast horizonHow far into the future the forecast looks. Logistified picks it from your lead time plus a safety buffer. Read more →	How far forward the forecast looks, in days.

G

Column	What it shows
Gross Margin	Sales Performance display mode. (Price − Shopify Unit Cost) ÷ price, in %. Needs both a price and a unit cost.
Gross Profit at Risk	Gross profit you would lose to a stockout that an order placed today can no longer prevent: daily gross profit × the days you’d run out before the supplier’s lead time, plus the commitment and launch-plan units you couldn’t ship in that time. 0 when stock covers the lead time.

H

Column	What it shows
Holding Cost/YearHolding costThe cost of keeping a unit in stock for a year: storage, capital tied up, insurance, obsolescence risk. Used in economic order quantity calculations. Read more →	Annual cost to hold one unit, in your currency. Used in EOQ math.

I

Column	What it shows
Image	The variant image. Default visible.
In Draft PO	Whether the variant already appears on at least one Draft PO. Hidden by default; filter Yes to review drafted items or No to avoid duplicates.
In Pre-Assembled Stock	For a raw material, how many units of it sit inside pre-assembled parent items already on the shelf. Raw-material rows only. Needs Assemblified connected.
In StockIn stock cellThe Forecast page cell that visualises current inventory as a colored fill bar with markers at min, reorder point, target, and max. Hover for the breakdown. Read more →	The variant’s inventory. Default visible, and always shown in the Supply and Sales Performance display modes. Also shows incoming units, overdue incoming, planned outflow, and Draft PO membership when present. See In Stock for how a location filter changes the number.
Incoming QuantityIncoming quantityUnits expected to arrive from open purchase orders and in-transit transfer orders. Shopify maintains its own incoming counter; Logistified updates it from PO/TO workflow, and Incoming Reconciliation may require a manual apply if the two drift. Read more →	Confirmed-and-not-yet-received units across open POs and TOs. A ⚠ line counts the units whose delivery date has passed.
Is Gift Card	Variant is a gift card.

L

Column	What it shows
Last Received Date	Hidden by default. The date of the variant’s most recent purchase order receipt.
Last Received Quantity	Hidden by default. The total quantity received on that most-recent purchase order.
Limiting Component	The component currently capping Buildable Now: restock this one first to build more. Needs Assemblified connected.
Location Counts	Number of locations that stock this variant.

M

Column	What it shows
Max InventoryMax inventoryA per-variant maximum stock level you set as an override. Displayed on the Forecast page's In Stock cell and used by min/max replenishment workflows. Read more →	Per-variant maximum stock level override. The cell shows In Stock against it.
Measurement Weight	The unit weight.
Min InventoryMin inventoryA per-variant minimum stock level you set as an override. Displayed on the Forecast page's In Stock cell and used by min/max replenishment workflows. Does not change the forecast model's reorder math. Read more →	Per-variant minimum stock level override.
Momentum (7d/28d)	Recent daily sales divided by the longer-term daily average (7 days vs 28 days). 1 = usual rate; above 1 accelerating, below 1 slowing.
Momentum (14d/90d)	Recent daily sales divided by the longer-term daily average (14 days vs 90 days). 1 = usual rate; above 1 accelerating, below 1 slowing.
Momentum Trend (7d/28d)	Up when the short-term rate is at least 20% above the long-term rate, Down when at least 20% below, Stable in between, Insufficient data when there isn’t enough history.
Momentum Trend (14d/90d)	Up when the short-term rate is at least 20% above the long-term rate, Down when at least 20% below, Stable in between, Insufficient data when there isn’t enough history.
Monthly Average Sales	Average units sold per month over up to the last 12 months; the cell notes how many months are included. Hover for the month-by-month chart.
Monthly Avg Sales (3m)	Average units sold per month over the last 3 months, the current month included.
Monthly Avg Sales (6m)	Average units sold per month over the last 6 months, the current month included.
Monthly Avg Sales (12m)	Average units sold per month over the last 12 months, the current month included.
Monthly Total Sales	Units sold so far this calendar month. Hover for the two months before.
Monthly Total Sales (3m)	Units sold over the last 3 months, the current month included.
Monthly Total Sales (6m)	Units sold over the last 6 months, the current month included.
Monthly Total Sales (12m)	Units sold over the last 12 months, the current month included.
MOQMinimum Order QuantityThe smallest quantity a supplier is willing to ship in a single PO line. Logistified rounds reorder suggestions up to the MOQ (or the next multiple of the pack size) so suggestions are immediately actionable. Read more →	Minimum order quantity from the primary supplier.

O

Column	What it shows
On HandOn hand quantityPhysically present units at a location, available to sell. Mirrors Shopify's on-hand value. Read more →	Physically present units.
On Hold Quantity	Units on POs in “On Hold” status.
On PO with Status	Which purchase order statuses the variant currently sits on (Draft, Sent, Confirmed, and so on). Hidden by default; filter to a status, or exclude “Any open PO” to find items you haven’t already reordered.
OOS With Reorder	When you’d run out if you placed the suggested reorder now.
Out of Stock Date	The first day your stock would hit zero at the forecast pace. Incoming stock counts if it arrives before then.
Out of Stock Date (incl. all incoming)	The day your stock is finally used up, counting every incoming delivery, including ones that land after a stockout.

P

Column	What it shows
Pack SizePack sizeThe packaging increment your supplier ships in, for example, 12 to a case. Logistified rounds order quantities up to the nearest multiple of pack size. Read more →	The packaging increment the supplier ships in.
Pre-Assembled	Finished units already built and on the shelf at the selected locations. BOM items only. Needs Assemblified connected.
Predicted Sales (horizon)Predicted salesThe total units the forecast model expects you'll sell during the next forecast horizon. The raw output of the model before any reorder math. Read more →	Total units expected during the forecast horizon.
Price	The selling price.
Primary SupplierPrimary supplierThe supplier whose lead time, MOQ, pack size, and cost feed the reorder math for a variant. One per variant. You can change it any time. Read more →	Whether the supplier shown on this row is the variant’s primary supplier. Useful when you filter by supplier.
Product ID	The product’s Shopify ID, with a copy button.
Product Title	The product’s title.
Product Type	The Shopify product type.
Product/Variant Title	The product title with the variant title and SKU beneath it. Default visible, and always shown in the Supply and Sales Performance display modes.

R

Column	What it shows
Reorder DateReorder dateThe day Logistified expects your on-hand inventory to hit the reorder point. Acting earlier is fine; acting later risks a stockout. Read more →	The calendar date you should fire the order. Color-coded. Default visible.
Reorder ForecastReorder quantityThe number of units to order. Starts as a raw target (cover demand until the next reorder), then adjusts for MOQ, pack size, incoming stock, back orders, and EOQ. Read more →	The recommended order quantity after MOQ, pack size, and EOQ adjustments. Default visible.
Reorder PointReorder pointThe inventory level at which you should reorder. Calculated as the demand you expect during your lead time plus a safety stock cushion. When on-hand drops to this level, it's time to send a PO. Read more →	The inventory level you should reorder at.
Reorder Point Overdue	How many days past the reorder date you already are; 0 when you aren’t.
Requires Shipping	Whether this variant is shipped.
ReservedReserved quantityA separate Shopify reserve bucket, like committed, but for specific allocations. Read more →	A separate Shopify reserve bucket.

S

Column	What it shows
Safety StockSafety stockExtra inventory held above forecasted demand to absorb variability: demand spikes, longer-than-expected lead times, supplier hiccups. Higher safety stock reduces stock-outs but raises holding costs; Logistified surfaces both sides of that trade-off. Read more →	The calculated safety buffer (rounded up) built into the reorder point.
Sales Days/Month (3m)	Average number of days per month with at least one sale, over the last 3 months. A day counts once no matter how many orders it had; this isn’t an order count.
Sales Days/Month (6m)	Average number of days per month with at least one sale, over the last 6 months.
Sales Days/Month (12m)	Average number of days per month with at least one sale, over the last 12 months.
Sales Velocity	Sales Performance display mode. Units sold per week (average of the last 4 complete weeks) and in the last complete calendar month, each with its trend against the period before, plus a chart of the last 6 months.
Sales Velocity (weekly)	Average units sold per week over the last 4 complete weeks (Monday to Sunday).
Sell-Through	Sales Performance display mode. Units sold ÷ (units sold + In Stock) over the last 7 days (/wk) and the last 30 days (/mo), each with its change in percentage points. Hover for the 90-day rate.
Sell-Through (30d)	Share of the units you had that sold in the last 30 days: sold ÷ (sold + In Stock), in %. Empty when there is nothing sold and nothing in stock.
Sell-Through Change (30d)	Percentage-point change of the 30-day sell-through compared with the 30 days before. Needs 60 days of history.
Sellable Online Quantity	Units available to the online storefront.
Shopify Unit Cost	The variant’s unit cost (cost per item) from Shopify.
SKUSKUA Stock Keeping Unit, the unique code that identifies a single sellable variant of a product. Every variant in Logistified is keyed by its SKU; variants without a SKU are flagged on the data-quality tile. Read more →	Your stock-keeping unit.
Sold Today	Units sold so far today (UTC), with a line comparing them with the 30-day daily average. The forecast itself only uses complete days. Also part of the Sales Performance display mode.
Sold Today vs 30d Avg	Today’s units compared with the average daily sales of the last 30 days, in %. Green from +10%, amber from −10%.
Static Reorder PointStatic reorder pointA fixed reorder point you set yourself, instead of letting the model compute one. Display + threshold-filter only: the forecast model uses its own computed reorder point in reorder math. Read more →	A fixed reorder point you set yourself.
Status	The product’s Shopify status: Active, Draft, or Archived.
Stock at Supplier	Your own stock physically held at suppliers. Hidden by default. Not affected by a location filter. See Supplier-held stock.
Stock at Supplier (Available)	The part of your supplier-held stock not reserved by an open release. Hidden by default.
Stock at Supplier (Reserved)	The part of your supplier-held stock reserved by an open release. Hidden by default.
Supplier	The supplier name. Default visible.
Supplier SKU	The SKU your supplier uses.
Supplier Unit Cost	The cost price you have on file for this row’s supplier, in that supplier’s currency.

T

Column	What it shows
Tags	Shopify tags.
Target InventoryTarget inventoryA per-variant target stock level you set as an override. Used by min/max replenishment workflows as the "refill to" target. Read more →	Per-variant target stock level override. The cell shows In Stock as a share of it.
Tax Code	Shopify tax code.
Taxable	Whether tax applies.
Total Sales	Units sold in the last 30 days. Hover for the 60- and 90-day totals.
Total Sales (30d)	Units sold in the last 30 days.
Total Sales (60d)	Units sold in the last 60 days.
Total Sales (90d)	Units sold in the last 90 days.

U

Column	What it shows
Unit Price Measurement Type	For unit-priced products: type of measurement.

V

Column	What it shows
Variant ID	The variant’s Shopify ID, with a copy button.
Variant Title	The variant title.
Variant Tracked	Whether Shopify tracks inventory for this variant.
Vendor	The Shopify vendor name.

W

Column	What it shows
Weeks to Sell	Sales Performance display mode. How many weeks your In Stock quantity lasts at the current weekly sales rate. Shows “No sales” when there are no recent sales or no stock.

Y

Column	What it shows
YoY Change (28d)	Units sold in the last 28 days compared with the same 28 days one year earlier, in %. Empty until the item has 13 months of history.

See also

• Forecast → Forecast view table: the grouped narrative version.
• Forecast → Reorder suggestions: the math behind reorder-related columns.
• Reference → Glossary: every forecast term defined.

Last updated: 27 October 2026