VizupCommerce
shopify

Shopify Inventory Cash Flow: A Reorder and Overstock Audit

Karmanya Agarwal•
#shopify#inventory#cash flow#merchandising

Shopify merchants can protect cash flow by reviewing inventory value, days remaining, sell-through, margin, and supplier lead time before reordering, discounting, or stopping a SKU.

A reorder decision is also a capital-allocation decision. Every new purchase order puts cash into a product before that product becomes a sale, while an overstock decision can leave cash sitting in stock that needs storage, merchandising, and eventually a commercial exit.

Shopify gives merchants several useful views for this review: the product analytics bar surfaces sell-through rate, days of inventory remaining, and inventory value, while inventory reports provide variant-level quantities and movement details.[4][5] Those views do not choose the right action for your brand. They give you evidence to combine with lead times, upcoming launches, product lifecycle, gross margin, returns, and customer demand.

This workflow is for Shopify physical-product brands that need one repeatable question answered:

Should this variant receive more cash, less cash, or a deliberate path out of the catalog?

The four decisions behind an inventory review

Do not begin with “Which products are low?” Begin with the decision each product needs.

DecisionMerchant questionTypical next step
ReorderWill the next shipment arrive before likely demand exceeds usable stock?Confirm demand, lead time, safety stock, cost, and purchase quantity.
HoldIs current stock sufficient, or is an open order already covering the need?Pause a new purchase order and set a review date.
MerchandiseCan a clearer offer, bundle, placement, or product explanation help the existing stock move?Test a bounded merchandising action without hiding margin assumptions.
ExitIs the stock unlikely to earn its space, attention, or next purchase?Stop reordering and choose a controlled markdown, bundle, wholesale, donation, or other exit path.

These are operating categories, not universal thresholds. A fashion brand may protect a core black size medium differently from a seasonal color. A beauty brand may need a separate review for shade demand, product age, or claims and compliance constraints. Record the reason for the decision so the next review can distinguish a demand problem from a data, supplier, pricing, or product-fit problem.

Start with the numbers Shopify already exposes

1. Review demand velocity and stock coverage

Open the product analytics view and inventory reports for the same period. Shopify defines sell-through as the quantity sold divided by the quantity sold plus the quantity still in inventory; its days-of-inventory-remaining view divides stock on hand by average units sold per day.[4][5]

Use these metrics as signals, not promises:

The reports have important boundaries. Shopify says inventory reporting can have processing latency, and a variant with no sales in the selected period can show days remaining as N/A because there is not enough data for a prediction.[5] Treat missing velocity as a reason to investigate, not as evidence that demand is zero.

2. Separate available, committed, and incoming stock

A total quantity is not the same as stock you can promise to a new customer. Shopify’s month-end inventory reports distinguish available inventory from committed inventory for unfulfilled orders and incoming units in transfers.[5]

For each SKU or variant, write down:

This separation prevents a common mistake: placing another purchase order because the admin view looks low while a reliable shipment is already on the way, or promising units that are physically present but already committed.

3. Make cost data usable before comparing products

Shopify’s profit reports only include products and variants that had a cost recorded when they were sold.[9] Add or verify cost per item for every variant you plan to compare, and document which costs are included in your own operating decision.

Shopify’s reported gross margin is based on net sales and product cost; discounts and refunds can change the reported margin.[9] That makes gross margin a useful screening input, not a complete cash-flow model. A merchant may still need to account for freight, payment costs, fulfillment, duties, returns, storage, marketing, and any other variable cost before approving a new buy or a markdown.

Build a reorder decision instead of copying a report

Shopify’s inventory analytics help you see what is happening. The buying decision needs a small merchant-owned worksheet.

A practical reorder worksheet

For each SKU or variant, capture:

  1. Expected daily demand: use a defined historical window and adjust for known seasonality, launch plans, promotions, and channel changes.
  2. Supplier lead time: record the usual and worst credible time from order confirmation to sellable stock.
  3. Safety stock: document the buffer you are willing to fund for demand or supply uncertainty; do not copy a generic percentage into every category.
  4. Usable available units: start with available stock, then remove units that cannot be sold because of damage, quality review, or a known operational hold.
  5. Reliable incoming units: count a purchase order only when the quantity and arrival assumption are current enough for your business.
  6. Cost per unit and contribution view: compare the next purchase with the margin and variable-cost assumptions that matter to the decision.

A simple internal planning formula is:

reorder units = max(
0,
(expected daily demand × lead-time days)
+ safety stock
- usable available units
- reliable incoming units
)

This is a planning framework, not a Shopify calculation or a forecast guarantee. Keep the assumptions beside the result. If demand is highly seasonal, the last 28 days may be a poor proxy; if supplier reliability is weak, a “confirmed” arrival may still deserve a risk note.

Shopify purchase orders can record products, prices, quantities, payment terms, and supplier information, and a purchase order can later be linked to an inventory transfer.[8] Use that record to make the commercial assumption reviewable instead of leaving it in a message thread or a buyer’s memory.

Use ABC analysis to allocate attention, not to outsource judgment

Shopify’s ABC analysis groups variants by their share of revenue over the recent reporting period. The report describes A-grade products as the top sellers contributing around 80% of revenue, B-grade products as the next 15%, and C-grade products as the final 5%; the grade is based on revenue contribution, not product cost.[5][6]

That distinction matters. A high-revenue item can still have an unattractive contribution after returns, discounts, shipping, or paid acquisition. Use the grade to decide where to look first, then combine it with the economics and operational context.

SignalAsk before acting
A-grade and low days remainingIs the replenishment lead time real, and is the variant still commercially healthy after variable costs?
A-grade but high days remainingDid velocity change, or are we holding too much of a previously strong product?
B-grade with stable demandCan a smaller reorder or bundle protect availability without overfunding stock?
C-grade with high inventory valueIs the item slow because of weak demand, poor presentation, variant mismatch, or an avoidable product-page objection?
C-grade with no credible next useShould we stop buying and plan an exit rather than wait for the problem to grow?

Shopify’s guidance suggests giving A-grade products stronger inventory protection and considering discounts, bundles, donations, or stopping orders for C-grade products when that fits the business.[6] Those are options, not automatic instructions. Protect a product that supports a repeatable customer need; do not keep buying a low-margin bestseller simply because its revenue rank is high.

Fashion and beauty examples

Fashion: review the variant, not only the product

A dress can look healthy at product level while one size or color is accumulating. Review the SKU or variant rows, then ask:

If the product page is failing to answer a buying objection, fix that evidence gap before using a deeper discount as the default response. The Shopify product-description workflow is a useful adjacent review for that case.

Beauty: protect availability without hiding product risk

A beauty catalog may have meaningful differences between shades, sizes, routines, and use cases. Review the variant that is actually moving, not only the parent product’s combined sales. Record any product-age, packaging, batch, claims, or market constraint that changes how quickly the unit can be sold.

A low-stock alert is not automatically a reorder instruction. Confirm that the demand is for the same variant, the supplier can deliver within the relevant window, and the unit economics still make sense after discounts, refunds, fulfillment, and other variable costs.

Run the inventory cash-flow audit

Use one recent reporting window and one product family if the catalog is large. The goal is a defensible next action, not a perfect forecast.

set the decision boundary

Choose the product group, market, and date window. Write down the decision you are trying to make: approve a purchase order, delay it, reduce the quantity, fund a merchandising test, or exit a slow mover.

Record the last refresh date for inventory, sales, open purchase orders, and cost data. Do not compare a live inventory number with an old sales window without labeling the mismatch.

pull the evidence

Export or copy the smallest useful set of fields:

Shopify’s inventory reports include a month-end snapshot, inventory value, units sold per day, sell-through, ABC analysis, and inventory-remaining views, but the exact report availability and data boundaries should be checked in the current store.[5]

classify the exposure

For each variant, calculate or record:

inventory cost exposure = usable available units × cost per item

Then mark the product as reorder, hold, merchandise, or exit. Add one reason and one confidence label: high, medium, or low. Low confidence is useful when the decision relies on an unreliable arrival date, a short sales window, incomplete cost data, or a recent launch.

challenge the first answer

Ask three questions before approving the action:

  1. What would make this decision wrong?
  2. Which unit, variant, or location is hidden by the product-level total?
  3. Is the proposed action solving demand, availability, data accuracy, margin, or product communication?

If the answer is “we need a discount,” identify the commercial job first. A discount can move units, but it can also spend margin on shoppers who would have purchased without one. Keep the discount rules, margin floor, and stop condition in the same worksheet; this audit’s job is deciding whether more capital belongs in the SKU at all.

assign the next review

Record the action owner, approval owner, date, metric, and stop rule. Examples:

Do not let “monitor” become a hiding place. Every monitor decision needs a date and a condition that moves it to action.

Measure cash release without creating a new blind spot

Use a primary metric and guardrails before changing inventory policy.

Success measure

Choose the measure that matches the action. Examples include:

Write down the baseline date, data window, included variants, and any open purchase orders. Shopify’s inventory value report uses cost per item multiplied by ending quantity for available inventory, so incomplete or stale cost data can make the reported value incomplete.[5]

Risks to monitor

A cash release is not a win if it creates a worse customer or operating outcome. Monitor:

Compare a defined period with an appropriate baseline, and describe the result without causal language unless the test design isolates the change. A lower inventory value can reflect a sale, a stockout, a product deletion, a transfer, or an accounting-data change; it does not explain itself.

Before approving the change

Before the next reorder, confirm:

Good inventory management is not the pursuit of the highest stock level or the lowest stock level. It is the discipline of putting the next dollar into the product, variant, and location with the clearest evidence—and refusing to put more cash into a problem that has not been diagnosed.

Sources

[4] https://help.shopify.com/en/manual/products/analytics — Shopify Product analytics overview [5] https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/inventory-reports — Shopify Inventory reports [6] https://help.shopify.com/en/manual/products/inventory/adjusting-inventory/abc-analysis — Shopify ABC inventory analysis [8] https://help.shopify.com/en/manual/products/purchase-orders/creating-purchase-orders — Shopify Creating and managing purchase orders [9] https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/profit-reports — Shopify Profit reports

← Back to Blog