← Back to articles

Shopify Inventory Management: Track Stock and Reorder by Location

Published October 29, 2026 · Written by Aanart

Shopify inventory management starts with a question: how many units of this variant can you sell from the location that needs to fulfil the order? Available stock can be much lower than on-hand stock once existing orders and unavailable units are accounted for. Incoming stock becomes useful for planning before it becomes sellable.

Use SourcetoMCP’s Shopify connector to find low-stock variants and read named inventory quantities by location. This workflow builds a replenishment queue from those quantities, recent sales and expected receipt dates. You can review the resulting recommendations before changing stock counts or ordering more.

Turn on tracking and check each fulfilment location

In Shopify admin, open the product or variant and confirm inventory tracking is active. Review the locations that stock and fulfil it, then check the inventory quantities for each location. Shopify’s inventory-state guide explains how those quantities appear in admin. Check the variant’s continue-selling policy too. A zero-available variant may still accept orders if you have allowed it.

For a store with several warehouses or shops, define which locations serve the channel you are planning for. Units in a retail location, a third-party warehouse or an inactive fulfilment location may not be available to the customer in front of you. Record the store, variant ID and location ID alongside the SKU and quantity.

Understand Shopify inventory states before counting stock

StateWhat it representsUse in a stock review
On handUnits physically held at the locationUse for physical counts and investigating differences.
AvailableUnits currently available to sellUse as the starting quantity for near-term fulfilment.
CommittedUnits set aside for commitments such as unfulfilled ordersKeep separate from units available to new orders.
UnavailableUnits held back, for example for damage or quality checksCheck whether an investigation or release is needed.
IncomingUnits expected from a transfer or supplierCount separately until received and available.

On hand includes available, committed and unavailable stock. Start with the available field when estimating sellable cover. Subtracting committed stock from available would count that commitment a second time. For unavailable quantities split into several named states, retain the source fields and avoid adding a subtotal alongside its components.

In SourcetoMCP, the low-stock report is a candidate list. It reads Shopify’s inventoryQuantity variant field, which Shopify documents as total sellable quantity. Use the returned inventory item ID to look up available, on_hand, committed and the other named quantities at individual locations. Use the location fields when the report needs to tell you where a shortage is happening.

Calculate stock cover and a reorder point

For steady demand, estimate daily sales from a complete period and check for stockouts, promotions and unusual orders. A low sales rate during a stockout may understate demand. An initial reorder point is daily demand multiplied by lead time, plus safety stock. Stock cover is available units divided by daily units sold. Both are planning estimates, so recheck them when demand or supplier timing changes.

This hypothetical example uses the same variant at two locations. The safety allowance at each is ten units and supplier lead time is seven days.

LocationOn handAvailableIncomingUnits sold per dayStock coverReorder point
Melbourne58244046 days38 units
Sydney65480316 days31 units

Melbourne is 14 sellable units below its reorder point even though it has 58 units on hand. If its incoming shipment arrives in eight days, it has roughly a two-day gap at current demand. Confirm the receipt date. If Sydney can send stock before the gap, check the transfer time and how many units it can spare above its own reorder point. Where a location has no recent sales or no reliable demand estimate, leave days of cover uncalculated and investigate.

Build a low-stock review with connected Shopify data

Pull low-stock variants, then check the named location quantities for relevant inventory item IDs. Include only tracked variants in your shortage count. Separate active products from archived or draft products and flag variants that can still sell at zero. A SKU can be duplicated, so use inventory item and location IDs for your stock table.

The connected shortlist returns up to 100 variants per request, and the per-item location lookup returns up to 50 locations. Check coverage before using either as a full-store count. For a large catalogue or a location with shortages hidden by stock elsewhere, start with a verified shortlist from Shopify admin or a location export. A variant can have plenty of stock in total while one warehouse is out.

Compare snapshots using the same inventory state. Shopify’s inventory reports say that from 1 October 2026 those reports use on-hand quantities, with earlier data still using available quantities. Check which measure an export uses before interpreting a change across that boundary.

Ask AI for a replenishment proposal

Review [Shopify store] and [fulfilment locations]. Find low-stock tracked variants or use my supplied inventory item IDs. Return available, on-hand, committed and incoming stock by location. Use the daily demand, lead times, receipt dates and safety stock I supply to calculate days of cover and a reorder point. Flag stockouts, uncertain arrivals, overselling settings, untracked variants and coverage limits. Rank likely gaps and propose a transfer or supplier check for each. Make no inventory changes.

Review stock counts and open transfers in Shopify before acting. A correction is a separate decision from a replenishment proposal. If you’re setting up connected access for the first time, follow the Shopify guide for Claude or Shopify guide for ChatGPT.

Platform guidance and SourcetoMCP capabilities checked on 14 November 2026. Worked figures are hypothetical examples.