Consolidating locations is a moment that arrives sooner or later for anyone running multiple warehouses. You merge a few small ones into one, or close a location you no longer use. Physically it looks like just moving boxes, but once Shopify and sheet sync are involved, one wrong step can make an entire location’s stock vanish into thin air.
This article is for operators who use Google Sheets as the master for multi-location inventory. We will lay out the order for deactivating or merging locations safely. Two principles do the heavy lifting: move the stock out first, and remove the mapping last.
What to Do Before You Deactivate
When you deactivate a location, it can no longer track quantities and drops out of fulfillment and selling. The trap to watch is that deactivating only means stop using — it does not move stock somewhere else for you. Deactivate without preparing, and the quantities sitting at that site have nowhere to go.
Start with a count of where things stand. How many of each product are still at the location you plan to close? Match that against the master sheet and confirm the numbers agree. Move forward with a discrepancy in place and you will lose track of what is correct partway through the transfer.
The Order: Move Stock Out, Then Deactivate
The safe procedure is simple. In a sheet-as-master setup, the sheet is where numbers really move. Follow this order and you will almost never lose stock.
- 01Physically move the closing location’s stock to the destination location
- 02In the master sheet, add the quantities to the destination column and zero out the closing side
- 03Run the sync and confirm each Shopify location now matches the sheet
- 04Visually verify that the closing location’s stock is all at zero
- 05Only after confirming zero, deactivate that location in Shopify
The key is putting deactivation dead last. Once the stock is at zero and the sync has settled, there is no orphaned quantity to worry about. An app like Sync Master, which writes from a master sheet into multiple locations, lets you decrease the closing side and increase the destination in a single sheet edit.
When Open Orders or Transfers Remain
Sometimes the location you want to close still has unshipped orders or in-progress transfers hanging off it. Try to deactivate with those left dangling and Shopify may warn you, or you may need to reassign fulfillment to another location.
Ship out the open orders first, or move their fulfillment to another location. Finish any in-progress inter-location transfers through to shelving before moving on. Decide that you will deactivate only after the loose ends hit zero, and you will dodge the avoidable stumbles.
Handling Duplicate SKUs and Combined Quantities When Merging
When you merge two locations into one, the same SKU often holds stock at both sites. If you simply deactivate one side, that site’s quantity goes unaccounted for and your total appears to shrink. With a merge, never forget the addition.
It is safest to combine in the sheet before syncing. For the same SKU, pull the closing side and the keeping side into one column and write the total into the location you are keeping. Adding by hand invites arithmetic slips, so let a sheet formula combine them automatically for peace of mind.
- When the same SKU lives at several sites, always sum the quantities before writing to the keeper
- Let a sheet formula do the combining rather than mental math, to cut mistakes
- After merging, always reconcile that the keeper’s total equals the pre-migration grand total
Cleaning Up Mappings and Columns on the Sheet Side
Once the stock is moved and synced, it is time to tidy the sheet. Leaving the columns you built for the closed location lying around invites confusion later and creates a chance to drop a number into an old, stale column by mistake.
Deleting the column outright, though, is premature. First remove that column-to-location pairing from your sync mapping. Delete the column while the mapping still points at it, and the now-dangling setting becomes a source of sync errors. The order is: remove the mapping, confirm it works, then tidy the column.
Confirming No Sync Errors After Deactivation
The final touch is a check run after the deactivation and cleanup are done. Make sure no setting still tries to write toward the closed location. Sync Master’s connection test lets you verify, before touching live inventory, that your column-to-location mapping no longer contradicts the current setup.
Pass the test once, then push a small manual sync and confirm no errors or warnings appear. If all is clean, resume scheduled sync from there. Check this far and you will not be startled by an unfamiliar error in the next morning’s automatic run.
Deactivating or merging locations is nothing to fear as long as you keep the order. Move stock out first, sum quantities on a merge, remove the mapping before clearing the column, and confirm the sync last. Walk this flow once and you can reorganize your sites without losing a single unit. Try it on a small location first.