When your store grows and you open a second warehouse or shop, the time finally comes to consider moving to multi-location operation. Still, taking inventory you have run from a single location and suddenly splitting it can feel a little nerve-racking. You worry that stock might double up — or look short — somewhere in the middle, leading to stockouts or overselling.
This article walks you through a safe path from a single location to multiple locations, step by step. We will cover what changes, how to split your existing on-hand inventory, how to reshape your Google Sheet, and how to re-map the sync — plus how to avoid opening an overselling gap mid-migration.
What Changes When You Go Multi-Location
First, the groundwork: a Shopify location is a place that stocks, fulfills, and sells inventory. With a single location, your stock sits in that one place and the available count is a single number. Go multi-location and inventory is recorded per location as separate states (available, committed, on hand). Even for the same SKU, the numbers at warehouse A move separately from store B, and the available count varies by location.
The key point is that a product must be set up to stock inventory at a location before you can assign a quantity there. Adding a new location alone leaves its stock at zero, so it helps to think of migration as the work of deciding ‟which product, at which location, in what quantity” and then applying it. When an order comes in, Shopify fulfills and commits from a location that has stock.
Splitting Your Existing On-Hand Inventory
The heart of the migration is how to distribute the on-hand inventory now sitting in one place across the new locations. First, add the new location and set the relevant products to be stocked there too. Without this setup you cannot enter a quantity at that location. Then split each SKU’s total stock to match reality.
- 01Export your current on-hand inventory as a pre-migration snapshot
- 02Add the new location and set the relevant products to be stocked there
- 03Per SKU, allocate the total stock to each location with real figures (check that the sum matches the original)
- 04Where you have a count or physical figure, enter the real number rather than guessing
- 05After allocating, reconcile each location’s on-hand total against the pre-migration snapshot
The one thing to avoid most is copying the original quantity into both locations as-is. If you put 100 units at warehouse A and 100 at store B, you appear to have 200 units, which invites overselling. Keep in mind that this is about ‟how to split the total of 100,” not about increasing it.
Reshaping the Google Sheet from One Column to Several
If you use a Google Sheet as your inventory master, a single ‟quantity” column was probably enough until now. For multiple locations, you reshape that one column into a column per location. For example, split into ‟Warehouse A qty” and ‟Store B qty,” and fill each SKU’s row with the on-hand count for each.
How to Lay Out the Columns
The layout we recommend keeps one row per SKU and adds a quantity column to the right for each location. Leave the SKU column in place and line up quantity columns headed ‟Warehouse A” and ‟Store B.” Do not delete the original ‟quantity” column right away; keep it a while as a check on the totals. Confirm that ‟Warehouse A plus Store B” equals the original total on each row before you clean up the old column.
- Leave the SKU column as is; do not change the identifier
- Add one quantity column per location with clear headings
- Keep the original total column and reconcile it against the sum of the location columns
- Treat blanks as 0, or enter an explicit 0 to remove ambiguity
Re-Mapping the Sync and Checking with a Connection Test
Once the sheet has multiple columns, reshape the sync settings to match. Sync Master supports multiple locations and treats Google Sheets as the single source of truth, writing each column’s quantity into the corresponding Shopify location’s on hand. At migration time, the key is to re-map ‟which column corresponds to which location” afresh.
Before you fire off a real sync here, use the connection test. The connection test lets you confirm that the column-to-location mapping is correct before any stock is actually rewritten. You can check up front that the warehouse A column really points to the warehouse A location, and the store B column to store B. Catching a mix-up here prevents the accident of wrong quantities landing in Shopify.
If the test is clean, it is finally time for the first real sync. Afterward, pull a few SKUs and verify in the Shopify admin that each location’s on hand matches the sheet values. If all is well, set up scheduled sync, and from then on you move to an operation where updating the sheet alone keeps each location’s stock aligned automatically.
Not Opening an Overselling Gap Mid-Migration
An easy thing to miss in a migration is the ‟gap” that opens up partway through the work. If you have reshaped the sheet into multiple columns but the sync is still on the old settings, the stock on the Shopify side will be temporarily off. To avoid this, keep the order — reshape the sheet, update the mapping, run the connection test, then the real sync — intact and finish it as one block in a single push.
If you are concerned, it is also effective to pause automatic sync just for the duration of the migration work and run the first sync manually only after the sheet and mapping are fully in order. That way, half-finished numbers cannot flow into Shopify. Once the migration is done and you have confirmed the figures match, resume scheduled sync. Migrating from single to multiple is a one-time task, but doing it carefully here makes your subsequent multi-location operation far more stable.