Once you start handling multi-warehouse inventory in Shopify, the first question you hit is: how many locations should I create? It looks like you should just make one per warehouse or store, but it isn’t that simple. Too many or too few, and day-to-day operations slowly become a grind.
This article focuses purely on the step before the hands-on work of mapping and sheet column layout — the design decision of how many locations to split into in the first place. Settle this early, and your later sheet design and sync workflow become remarkably smoother.
The cost of too many, and the cost of too few
A location is the unit for a place that stocks, fulfills, and sells inventory. Shopify tracks inventory per location as states such as available, committed, and on hand, and it assigns and fulfills orders across locations. So the more you split locations, the more finely you can follow both how inventory looks and how orders move.
But that granularity has a price. Split into too many locations and you multiply the things to count at stock-take, the columns and rows to manage in your sheet, and the spots to check on every sync. Since a product has to be stocked at a location before you can assign a quantity there, every new location also adds a little quiet busywork. Split into too few and inventory you really wanted to manage separately gets blended into a single number, and you lose track of how much is where. The right count sits between these two extremes.
Criteria for splitting a location
So when should you split? Rather than deciding on physical distance alone, anchor on these three lenses and your judgment stays steady.
- 01Fulfillment origin: do you actually ship orders from that stock? If you dispatch from genuinely separate places, splitting makes order assignment more accurate
- 02Inventory ownership: is a different person or team accountable for the numbers? If the boundary of responsibility differs, separate locations follow naturally
- 03Stock-count unit: do you count it at a different time, by different people? If the same person counts it all on the same day, there’s no need to force a split
If two or more of these come up “different,” that’s a sign to split. If all three are “the same,” you can almost always merge them into one. The trick is to think in terms of operational boundaries, not distance. Bear in mind that Shopify keeps available quantities separately per location, so splitting lets you accurately express a state like “in stock in Tokyo, sold out in Osaka” for the very same product. Whether you actually need that distinction is itself a useful hint.
When one physical place still warrants two locations
Even within a single warehouse, splitting can make operations easier. For instance, if you keep retail stock and wholesale stock in the same building but their assignment and ownership are entirely separate, two locations keep the numbers from blending. Another use is putting a quarantine area for inspection-pending or defective items in a location distinct from sellable stock. The idea is to split by the “character” of the inventory, not by place.
How to spot locations worth merging
As the flip side of splitting, let’s make the conditions for merging explicit too. In cases like the following, there’s usually little benefit to bothering with a separate location.
- The same person counts it at the same time
- You don’t distinguish which side you ship from, so it’s effectively one pool of stock
- The inventory always moves together and there’s almost no moment you’d update just one side
- Even if you split it, nobody actually looks at the distinction to make a decision
That last point is easy to overlook. If nobody uses the split number, the split is generating management cost and nothing else. Asking “is this distinction used in any decision?” helps you trim away unnecessary locations.
Design the initial setup assuming you’ll add more
Your location count isn’t fixed once decided. Businesses change and warehouses come and go. That’s exactly why designing from the start on the assumption that you’ll add more later makes you resilient to change. Start with the minimum, then split only the spots where operations start to hurt — that’s the realistic way forward.
You don’t need to nail the perfect location structure on day one. You just add the missing boundaries as you operate.
If you sync with a sheet as your inventory master, adding locations doesn’t change the backbone of your workflow. Sync Master supports multiple locations, so it can write per-location on-hand quantities straight from your sheet. And with scheduled sync, your manual workload barely changes even as locations grow. When you add a new location, running the connection test to confirm your column mapping before any real sync lets you switch over with confidence, heading off any accidental mix-ups.
A checklist for deciding your own location count
Finally, here’s a checklist to settle it hands-on. List your candidate places or inventory groupings, and for each one, check the following.
- Do you actually ship orders from it (is it independent as a fulfillment origin)?
- Is a different person or team accountable for its quantities?
- Are its stock-count timing or owner separate from the others?
- Will you use the split number for decisions like pricing, replenishment, or pausing sales?
- Is this grouping likely to grow or split in the near future?
Two or more “yes” answers point to a standalone location; mostly “no” means merge. That’s a good enough rule of thumb. Don’t chase perfection — start few and grow it as you operate. That’s the surest path to a location design with neither too much nor too little.