Guide16 min read
Shopify Inventory Management: Fix Mismatches and Forecast
Shopify inventory counts drift when more than one thing can write to the same number: staff, apps, transfers, returns and a warehouse system. To fix a mismatch, find who changed the count in the adjustment history, correct it after a physical count, then give each SKU one owner and a count routine. Forecasting comes second, because a forecast built on counts you do not trust repeats the error at scale. This guide covers the five inventory states, the causes of a mismatch, a seven step fix, accuracy checks, reorder point formulas, forecasting tools and when outside help pays off.
Key takeaways
- Check the adjustment history first: it shows which staff member, app or sales channel changed the count, but only for the last 180 days.
- On hand is Committed plus Unavailable plus Available, so a gap between two numbers is often a state, not an error.
- One consultancy, shopexperts, lists two systems both writing stock counts among the usual causes of a stock sync failing, so name one owner for every SKU.
- A forecast needs lead time, average daily sales and a safety buffer: reorder point is lead time demand plus safety stock.
- Shopify's forecasting guidance starts at 8 weeks of orders and wants a year of orders to see seasonality, and Stocky ended on 31 August 2026.
What the Shopify inventory numbers mean
Shopify tracks five inventory states, and a mismatch is sometimes only a state you did not expect. Shopify's inventory states page puts it this way: "On hand inventory is the sum of your Committed, Unavailable, and Available inventory." It adds that when you edit the On hand quantity, "your Available quantity changes by the same amount."
If the shelf matches On hand but Available looks low, the stock may be set aside for an order, and nothing is wrong.
| State | What it means | A common source of confusion |
|---|---|---|
| On hand | All units at a location: committed, unavailable and available together. | The shelf count matches On hand, but Available is lower. |
| Available | Units you can sell now. | Staff read Available as what is physically on the shelf. |
| Committed | Units set aside and not for sale. Shopify's examples are units in an unfulfilled order, reserved in a draft order, or in a transfer marked ready to ship. | Available drops, although nothing has left the building. |
| Unavailable | Units set aside by apps or held for reasons such as damage, quality control or safety stock. | An app or a rule holds stock and nobody remembers why. |
| Incoming | Stock on its way from a transfer or purchase order. Not on hand and not sellable until it is received. | A report adds Incoming to On hand and calls the total stock. |
Source: Shopify Help Center, inventory states. Third column: Morsegrid's wording.
Incoming stock and locations
Shopify says incoming inventory "isn't available to sell until it has been received and its state has been changed to Available." Its developer documentation adds that Shopify does not count units in the incoming state as on hand. That is the root of phantom stock from open purchase orders: a report or spreadsheet that adds the two back together.
Locations are separate counts. Shopify's multi-location page says each location's inventory is independent and cannot be shared or pooled. Plain definitions are in the ecommerce operations glossary.
Why Shopify inventory does not match
Shopify inventory does not match for a short list of reasons, and you find the right one by looking at who changed the count. Shopify's guide to inventory discrepancies defines a discrepancy as recorded inventory that does not match what you have in stock. It lists human error, inventory shrinkage, incorrect location or misplaced stock, order picking and packing errors, and supply chain and vendor mistakes as causes.
The table turns those causes, and the sync problems apps add, into symptoms you can see in the admin. It is Morsegrid's own working list.
| Symptom | Likely cause | Where to look |
|---|---|---|
| The count jumps after an app syncs | Two systems write the same stock count, or the SKUs do not match exactly. | Adjustment history, Created by column. |
| Available is lower than the shelf | Committed stock: unfulfilled orders, draft orders or transfers marked ready to ship. | The Committed column and open orders. |
| Available is higher than the shelf | Shrinkage, returns restocked without inspection, or damage nobody recorded. | Adjustment reasons for that SKU. |
| Stock sits as incoming and never sells | A transfer or purchase order that was never received. | Transfers and purchase orders. |
| A bundle sells and its parts do not drop | Bundle settings or SKU mapping between the store and the other system. | The bundle's component list and the sync rule. |
| Reports show stock the shelf does not hold | Open purchase orders counted as stock. | The report's definition. See the phantom stock guide. |
Sources: Shopify Help Center on inventory states and adjustment history; shopexperts, a consulting marketplace, for sync causes.
When more than one system writes the count
Two systems writing one count is the sync problem to rule out first. In its guide to Shopify inventory that stops syncing, shopexperts, a marketplace that sells Shopify consulting, says inventory usually stops syncing because SKUs do not match exactly, two systems are both writing stock counts, a 3PL or sales channel connection has stopped, or bundle and multi-location settings are wrong. Its advice: "Decide which system owns inventory before fixing anything, or the problem comes back."
An app that pushes a total quantity will overwrite a fix you made by hand. Shopify's Admin API has a guard against this. Its developer documentation describes a field for the last known quantity at the location, used for compare and swap checks, so an update can be refused when the count has changed underneath it. An app can opt out of the check by passing null. If an app keeps overwriting good counts, ask its vendor whether it uses that check.
How to fix a Shopify inventory mismatch, step by step
Fix a mismatch in seven steps, in this order, and do not change the number until step 5. Work on one SKU at one location first. Once you know the cause, the rest of the catalog follows.
- Pick one SKU and one location where the count is wrong. Write down what Shopify shows and what you expect.
- Open the product's adjustment history. The Created by column shows the staff member, app or sales channel that made each adjustment. Note the last five adjustments, as shopexperts suggests, and who made them. Shopify shows only the last 180 days here.
- Compare the same SKU in the other system, such as the 3PL, POS or ERP, and check that the SKU matches exactly.
- Check the sync rule before you edit. Pause it or find out which side wins, so an app does not overwrite your fix.
- Count the physical units at that location, including anything in a staging area.
- Correct the number with the reason Count. Shopify's adjusting inventory page lists Count for use after counting physical stock, when there is a discrepancy between the actual and the previously recorded quantity. The default reason is Correction, so choose Count on purpose.
- Test it. Place one test order and cancel it, then confirm Available moves and settles back to the number you set. If not, another system is still writing.
Set to or Adjust by
Use Set to for an exact quantity and Adjust by for a movement. Shopify says to use Set to "when you know the exact inventory quantity, such as after a physical count." Adjust by is for receiving new stock, moving items to unavailable states, or removing items, where you know the movement but not the new total. Both are described on Shopify's adjusting inventory page.
A fulfilment app that did not sync an order
If a fulfilment service did not sync an order, Shopify's multi-location page describes a manual fix: change the order's location and fulfil it by hand, which it says prevents duplicate shipments.
Write the procedure down once. The ecommerce SOP template has a stock count reconciliation procedure you can copy.
How to keep Shopify inventory accurate
Keep inventory accurate by measuring accuracy, counting a slice of stock every week, and making every change leave a reason. Accuracy you never measure shows up only when a customer order fails.
Measure accuracy as counted over recorded
Shopify's inventory accuracy guide calculates the rate as units counted divided by units recorded, times 100. Its example is 500 counted against 550 recorded: (500 / 550) * 100 is 90.9%. The same guide says acceptable accuracy typically ranges from 95 to 99.5%, depending on the industry and application. The page dates from 2022, so treat the range as Shopify's guidance, not a current benchmark for your category.
Count a slice every week
Cycle counting means counting predetermined portions of your inventory regularly, whether daily, weekly or monthly, as Shopify's discrepancy guide describes it. It spreads the work out.
Shopify's inventory management page gives two ways to do it. In Shopify POS, Quick count supports up to 1,000 items in a single session. For an offline count, you export on-hand inventory to CSV, count the items using a spreadsheet or a scanning tool, and import the counted quantities by CSV to update your inventory.
Count the products that matter first
Start with the products that earn the most. Shopify's inventory reports page describes an ABC analysis report that gives each product variant a grade based on the percentage of your revenue that variant contributed to over the last 28 days. Count the A grades most often and the C grades least often.
Add controls so the count stays right
Four habits keep a corrected count from drifting again:
- Use an adjustment reason on every edit, so the history explains itself.
- Give every SKU one owner: one system or one person who is allowed to write its count.
- Train staff on Set to versus Adjust by, and scan barcodes where you can.
- Reconcile returns and transfers on a schedule, as ecommerce fulfillment automation explains.
Shopify inventory forecasting: the formulas
A basic forecast is four numbers you can calculate in a spreadsheet today: average daily sales, lead time demand, safety stock and reorder point. The last three come from Shopify's inventory forecasting guide. Average daily sales is units sold in a period divided by the days in that period.
| Number | Formula | Shopify's worked example |
|---|---|---|
| Average daily sales | Units sold in a period divided by days in the period | 5 bottles a day |
| Lead time demand | Average lead time in days times average daily sales | 10 days times 5 bottles is 50 |
| Safety stock | Maximum daily sales times maximum lead time in days, minus lead time demand | 10 times 15, minus 50, is 100 |
| Reorder point | Lead time demand plus safety stock | 50 plus 100 is 150 |
Source: Shopify, inventory forecasting guide, published May 2023. The first row is Morsegrid's plain definition.
How to read the worked example
In Shopify's example, a water bottle seller has a 10 day average lead time and sells 5 a day, so lead time demand is 50. At the busiest it sells 10 a day and waits up to 15 days, so safety stock is 100. The guide concludes the seller would want to reorder when inventory reaches 150 water bottles.
Put your own numbers in a sheet: average daily sales, average lead time and maximum lead time for every SKU. If a product was out of stock for part of the period, count only the days it was on sale (our advice).
How much sales history you need
Shopify's forecasting page says you can start to plan with demand forecasting using only 8 weeks of consistent weekly orders, and that after a year of orders you can begin to forecast for seasonality, such as the high and low months for sales. Vendors can ask for more. Prediko, an inventory planning app, says in its forecasting guide that quantitative forecasting in general works best with at least two years of solid sales data. That is advice about the method, not a stated requirement of its product. Both are vendor and platform guidance, so test any forecast against your own sales.
Which forecasting method to use
Choose the method by what you know about the product. Shopify's guide names five types of forecasting: trend, graphical, qualitative, quantitative and causal. The table picks four approaches that cover most stores. Moving averages and exponential smoothing are techniques Shopify lists under quantitative forecasting.
| Approach | How it works | Use it when |
|---|---|---|
| Moving average (a quantitative technique) | Filters out random blips to reveal broader, long-term trends. | Demand is steady and you want to ignore one-off spikes. |
| Exponential smoothing (a quantitative technique) | Prioritizes your most recent sales data. | Demand is shifting and recent weeks matter more than old ones. |
| Causal forecasting (a type) | Predicts demand from the specific events that drive it, rather than just repeating past sales. | Promotions, holidays or ad campaigns move your sales. |
| Qualitative forecasting (a type) | Shopify says to use it when your business lacks sufficient historical data for trend forecasting. | A new product has no sales history yet. |
Source: Shopify, inventory forecasting guide. Third column: Morsegrid's reading.
Forecasting tools for Shopify
Shopify gives you inventory reports and, since Stocky ended, Sidekick-drafted reorders. An app adds demand forecasts and purchase orders. Every tool inherits the accuracy of the counts it reads. If you want an AI assistant to read inventory, first see how the Claude connector for Shopify works for store operations.
What Shopify includes
Shopify's inventory reports page describes three reports worth knowing. Check which your plan shows in your own admin.
- Inventory remaining: estimates how long your tracked inventory will last, based on average sales rates for each variant.
- ABC analysis: grades each variant by its share of revenue over the last 28 days.
- Products by sell-through rate: the percentage of your total inventory sold in the period you select.
- Restock alerts: Shopify says you can use Shopify Flow to set up automatic inventory workflows, like restocking alerts or hiding out-of-stock products. For the choice of automation tool, see Shopify Flow vs n8n vs Make.
Stocky is gone
If you used Stocky for reorders, the change matters. Shopify's Stocky transition page says Stocky is no longer available as of 31 August 2026 and that you now manage inventory in the Shopify admin and Shopify POS. It says Sidekick recommends items based on sales data and drafts the purchase order or transfer for you. It also says historical purchase orders cannot be imported. If you recreated open orders by hand, run the check in the phantom stock guide.
Forecasting apps
The two vendors below are described in their own words, and we have not tested either. Other apps exist, but we have not read their vendor pages, so we do not describe them.
| Tool | What it does, per its own description | Fits when |
|---|---|---|
| A spreadsheet | Holds the four formulas above for each SKU. This is Morsegrid's suggestion, not a vendor claim. | You have a short product list, one location, and counts you trust. |
| Inventory Planner | Turns sales data into forecasts, purchase orders and reporting, using your sales patterns, seasonality and lead times. | You want forecasts and purchase orders in one app. |
| Prediko | Shopify app for demand forecasting, inventory transfers, raw materials, purchase orders and reports. | You have a long sales history, since Prediko's guide says quantitative forecasting in general works best with at least two years of data. |
Sources: the vendors' own pages, linked in the table, and Prediko's forecasting guide. Both vendors sell software. No prices are shown because none were read at a source.
Syncing Shopify with an ERP, a 3PL or other channels
When Shopify shares stock with an ERP, a 3PL or other channels, pick the system that owns the count, let the others read it, and test every write. How a Shopify and ERP connection works, and how to choose between a connector, middleware and a custom build, is in the Shopify ERP integration guide.
Each system added is another writer. List them before you change a rule:
- Staff in the Shopify admin.
- Apps that adjust or hold stock.
- Transfers and purchase orders.
- A 3PL or fulfilment app.
- A POS at a shop or pop-up.
- An ERP, which may post stock as a total or as a change.
When to bring in help
Bring in outside help when the same count breaks twice after you have fixed it, or when two systems disagree and nobody owns the answer.
Stock errors can also reach your support queue as "where is my order" tickets. See where is my order automation and the customer support workflows guide. Reporting that shows the wrong stock or margin is a related problem, covered in the ecommerce reporting guide.
What a good diagnosis delivers
Ask any consultant, including us, to hand over these five things:
- A list of every system that writes stock, with when and how often each one writes.
- The cause found for each SKU in a sample, with the record that proves it.
- A recommended owner for each SKU or product group.
- The fixes in order, largest first.
- A note of what could not be seen, so nobody mistakes silence for a clean result.
Questions to ask any consultant
Use these to compare any independent, agency or Shopify Partner:
- Which ERP, 3PL and helpdesk have you connected to Shopify before?
- How do you handle returns, bundles and split shipments?
- Do you need write access, or can you start from exports?
A consultant for inventory accuracy, and what a quote should cover
Choose a consultant who can name the cause of your mismatches, not one who lists tools. A quote is comparable only when every consultant prices the same written scope: SKUs, locations, systems that write stock, returns and bundles, what you receive and who maintains it. We print no price, because we found no neutral source for consultant rates.
How we work on stock problems
Morsegrid reads your Shopify, helpdesk and ERP data before it proposes anything. Access is read-only, and we can often start from exports. We write the fix down and train your team to run it. See ecommerce operations at Morsegrid, take the free 3-minute assessment, or read how to choose an ecommerce operations partner.
Frequently asked questions
- How do I fix Shopify inventory mismatches?
- Open the product's adjustment history and see which staff member, app or sales channel changed the count. Compare the SKU in any other system, pause the sync rule, count the shelf, then correct the number with the reason Count. Shopify shows only the last 180 days of history.
- What is a good inventory accuracy rate?
- Accuracy is units counted divided by units recorded, times 100. Shopify's inventory accuracy guide says acceptable accuracy typically ranges from 95 to 99.5%, depending on the industry and application. The page dates from 2022, so use the range as a starting point.
- How much sales history do I need to forecast inventory?
- Shopify says you can start demand forecasting with 8 weeks of consistent weekly orders, and that a year of orders lets you forecast for seasonality. Prediko, a vendor, says in its forecasting guide that quantitative forecasting in general works best with at least two years of solid sales data.
- Does Shopify have built-in inventory forecasting now that Stocky is gone?
- Shopify has inventory reports for stock remaining, ABC analysis and sell-through. Since Stocky ended on 31 August 2026, Shopify says Sidekick drafts the purchase order or transfer from sales data. For full demand forecasts, stores use a spreadsheet or an app such as Inventory Planner.
- Why does my Shopify inventory not match my ERP or 3PL?
- shopexperts, a consulting marketplace, lists the usual causes: SKUs that do not match exactly, two systems both writing the same count, a connection that has stopped, and bundle or location settings that differ. Decide which system owns the count, then check the adjustment history to see who wrote the last change.
Start with one SKU and its adjustment history. If the same count breaks again, bring us the export and we will find where the number comes from before we suggest a fix.
Keep reading
Guide
Shopify ERP Integration: How It Works and How to Choose
How Shopify ERP integration works, what data syncs, why orders stop syncing, and how to choose between a connector, middleware or a custom build.
16 min read
Guide
Ecommerce Reporting: One Set of Numbers for Your Store
Ecommerce reporting that matches across Shopify, ad platforms and accounting: which reports to run, how to get profit per order, and how to pick tools.
16 min read