Why Shopify tells you what sold, not what you have

Your Shopify dashboard says 24 units. Your 3PL portal says 31. Your supplier is on a six-week lead time and hasn't replied to the last two emails. A flash sale inquiry just landed and you have four hours to respond. This is the e-commerce inventory gap, not a Shopify problem, not a 3PL problem, but what happens when three accurate systems each hold a different part of the answer and nobody has the full picture at once.

Your Shopify dashboard says 24 units in stock. Your 3PL portal says 31. You placed a supplier order five weeks ago on a six-week lead time, which means it might have shipped last week, or it might ship next week, the supplier has not replied to the last two emails. A flash sale inquiry just landed: a corporate buyer wants 40 units, white-labelled, delivered in three weeks. You have four hours to respond.

You know one of those numbers is wrong. You do not know which one. And the answer to the buyer's question, can we do this or not, is sitting somewhere in the gap between three systems that have never spoken to each other.

This is the e-commerce inventory problem that nobody talks about, because it does not look like a data problem. It looks like a supplier problem, or a 3PL problem, or a Shopify problem. It is none of those. It is what happens when three accurate systems each hold a different part of the answer and the person who needs to act has to reconcile them manually under time pressure, every single time.

Why Shopify is not an inventory system

Shopify is an order system. It is very good at what it does: recording what was sold, processing payment, generating fulfilment requests, and decrementing inventory counts when an order ships. The inventory number in Shopify is the number of units Shopify believes are available to sell.

That number is not wrong. But it is incomplete in several ways that matter.

When your 3PL receives a return, the unit goes back into their warehouse. It may be in quarantine for inspection. It may be reintegrated into saleable stock immediately. It may be marked as damaged and set aside. What Shopify knows depends entirely on whether someone has manually adjusted the inventory count to match. Many teams have a weekly restock sync; some do it less often. In the meantime, Shopify's number does not reflect the return.

When your supplier ships an order, the units are in transit, physically moving towards the 3PL but not yet received or counted. Shopify does not know those units exist until the 3PL receives them and the count is updated. If your supplier lead time is four to six weeks and you are ordering monthly, there are always units in transit that Shopify cannot see.

When your 3PL holds units back for a pre-committed bulk order, those units are physically present in the warehouse but not available to sell. Shopify may or may not reflect that reservation, depending on whether the hold was entered as a Shopify order or handled directly between you and the 3PL.

None of this is Shopify's fault. It is doing what it was designed to do. The problem is that DTC operations teams use it as the source of truth for inventory decisions it was never designed to support.

The 3PL gap

Your 3PL knows things Shopify does not: the physical count at any given moment, how many units are in quarantine, how many are picked and awaiting despatch, how many arrived in the last goods receipt and whether any were damaged. Most 3PLs have a portal that shows you this. Some send daily reports by email.

The problem is that this information lives in the 3PL's system, formatted the way they track it, updated on their schedule. Matching it against your Shopify stock level is a manual task, open the portal, open Shopify, reconcile the difference, figure out which number is current enough to act on. If you have more than two or three SKUs, this takes time and attention that most DTC ops leads do not have spare when an inquiry lands.

The number that actually matters for a sales decision, units available now, plus units due to arrive, minus units already committed, is not in either system. It is the result of combining both, which requires a third thing: someone doing the calculation, at the moment they need it, with information that may be hours or days old.

The supplier picture

Supplier lead time is the variable that decides whether you can take an order or not, and it is almost entirely invisible in both Shopify and your 3PL's system. What you know: when you placed the last order, roughly how long it usually takes, and the status of any open purchase orders, if you have tracked them somewhere. What you do not know, in real time: whether the supplier has started production, whether the shipment has left port, whether it cleared customs, and whether it is on a truck heading to your 3PL right now.

Most DTC brands at the 10 to 100 employee scale track this in a spreadsheet, a tab called something like 'PO tracker' or 'supplier log', maintained by whoever handles buying, updated after each email from the supplier. The sheet has the right shape: PO number, SKU, units, order date, expected delivery, status. The problem is that the status is always as of the last time someone updated it, which is rarely today.

When someone needs to know whether a shipment is inbound, a buyer asking about availability, an ops lead deciding whether to reorder, they look at the spreadsheet and they call or email the supplier to check. Every time. Because the spreadsheet is not live. It is a record of conversations.

What this actually costs

The four scenarios we see repeatedly in DTC operations:

Missed reorder. The real stock number, on hand plus inbound minus committed, drops below the reorder threshold, but nobody notices because each system only shows a partial picture. The reorder happens three weeks later than it should. Production slots fill up at the supplier. The shipment arrives six weeks after it was needed instead of four. A launch is delayed or a channel runs out of stock during a peak window.

Oversell on a flash sale or bulk inquiry. The buyer says yes based on the Shopify number and the vague sense that there is inbound stock coming. The 3PL ships what they can. The rest is backordered. The buyer receives a partial delivery and a delayed follow-up. The relationship takes a hit.

Overstock from buying blind. The ops lead places a reorder because Shopify shows low stock, without checking that the 3PL received a large returns batch last week or that the supplier's previous shipment has already cleared customs and is sitting in the container terminal. Two weeks later, the warehouse has six months of stock for a SKU that sells in three. Capital is tied up. Storage costs accumulate.

Customer service overhead. 'Where is my order?' tickets that require someone to manually check the 3PL portal, cross-reference the Shopify order, and email the supplier if the tracking number is not working. Five minutes per ticket. Twenty tickets a week. Manageable until it is not.

What a connected view requires

The dashboard we build for DTC inventory connects three sources: Shopify (what has been ordered and what the system believes is available), the 3PL (what is physically present, in what state, and what has shipped), and the purchase order tracker (what is on order, with which supplier, and when it is due).

The reconciliation layer calculates the number that matters: units on hand at the 3PL, minus units committed to unfulfilled orders, plus units inbound on confirmed purchase orders, with the inbound figure broken down by expected arrival window. That is the number that answers the question about the flash sale. Not three separate numbers from three separate systems. One number, with a breakdown if you need to interrogate it.

It also flags the signals that tend to get missed: a SKU where on-hand plus inbound falls below a reorder threshold, a purchase order that is past its expected delivery date without a 3PL goods receipt, a returns backlog that has grown past a normal level. These exist in the data today. They just require someone to look at the right part of the right system at the right time to catch them, which is not a repeatable process.

What actually changes

The buyer inquiry that lands on a Tuesday morning no longer requires a twenty-minute reconciliation exercise before you can respond. You open the dashboard, you see available plus inbound by SKU, you know whether you can take the order and on what timeline. You respond in the same session you received the inquiry.

The reorder decision that used to happen when someone remembered to check the spreadsheet now happens when the number crosses the threshold. Not because someone set a calendar reminder. Because the dashboard flags it.

The supplier call to ask where the shipment is still happens sometimes, suppliers are not always predictable. But it is no longer the standard way to find out whether inbound stock exists. The PO is in the dashboard. The expected arrival window is visible. The gap between expected and actual arrival is flagged. The call becomes an exception rather than a routine.

The Shopify number, the 3PL number, and the supplier picture do not stop being separate systems. They just stop requiring a person to reconcile them manually every time a decision needs to be made on a timeline shorter than the spreadsheet's last update.

If this is the gap you are sitting in, the DTC founding client page explains how we work with e-commerce and DTC brands specifically, what the seven-day build covers, what you hand us on day one, and what you have at the end.