No.31
Shopify Inventory Sync Starts with Locations: Getting Your Sync Target Right
Most sync trouble is about where the numbers land, not the settings. How Shopify per-location inventory decides where each sheet row goes.
Multi-location Operations
From what a location is, through mapping warehouses, column-per-location stock design, split fulfilment and order routing, to merging and retiring sites. For stores running more than one place.
21 articles
- No.32
How Many Locations Make Inventory Sync Easier — and When You Have Too Many
The number of locations you model sets how much data your sync carries. When a split is justified, when it is not, and how to settle on a count.
- No.33
Mapping Warehouses to Shopify Locations Without Breaking Your Inventory Sync
Your warehouse-to-location mapping is a contract the whole sync leans on. Bind by stable identifiers, start one-to-one, and catch drift early.
- No.34
One Sheet, Many Locations: Column Design for Shopify Inventory Sync
Stop splitting stock across one file per warehouse. The column layout that makes multi-location Shopify sync run, and the rules that keep it.
- No.35
Keeping Shopify Inventory Sync Correct When Orders Ship in Parts
When one order ships in two or three parts, when does Shopify deduct stock? Where sheet sync collides with split fulfillment, and how to cope.
- No.36
Order Routing Basics: Which Location Ships the Order
With several locations, Shopify picks the ship-from warehouse for you. How that choice is made, and how to nudge it the way you intend.
- No.37
Running Warehouse Transfers and Restocks Without Fighting Your Sync
Move stock between warehouses and the next sync rolls it back. A workflow for transfers that keeps sheet and Shopify in agreement.
- No.38
Setting Safety Stock (Buffers) Per Location
One store-wide buffer forces fast and slow locations to share a cushion. Give each location its own safety stock, computed in your sheet.
- No.39
Structurally preventing overselling across locations
Selling one SKU from several locations causes cross-location overselling. Aggregate versus per-location stock, and how to prevent it by design.
- No.40
How to Run Pop-up and Retail Locations Separately from Your Warehouse
Shops and pop-ups behave nothing like warehouses. Whether to sync or exclude them, how POS interacts, and how to model temporary locations.
- No.41
Treating a 3PL or Dropship Supplier Warehouse as a Shopify Location
How to model a 3PL or dropship supplier warehouse as a Shopify location, feed quantities in by sheet, and decide who owns the numbers.
- No.42
Deactivating or Merging Locations Safely Without Losing Inventory
Closing or merging warehouses without deleting stock or breaking sync mappings is a matter of order. The safe sequence, before and after.
- No.43
Reconciling physical counts warehouse by warehouse against your sheet
With multiple warehouses, count per location and reconcile per location. Count sheets, isolating discrepancies, and updating the master.
- No.44
Designing Fulfillment by Assigning Locations to Regions and Markets
Map each domestic and cross-border market to its nearest location so orders ship from the closest stock, and catch imbalance before it bites.
- No.45
Handling Per-Location Backorders Without It Falling Apart
Backorders get messy across locations, because the real question is which warehouse absorbs demand. Deciding oversell, and keeping the sheet true.
- No.46
Visualizing and Reporting On-Hand Inventory by Location
Build a report from your inventory master sheet that shows on-hand stock per location at a glance, surfacing low stock and imbalance.
- No.47
Common Multi-Location Sync Mistakes and How to Avoid Them
The classic multi-location sync mistakes — writing to the wrong location, ignoring committed stock, syncing totals — each with its fix.
- No.48
A Setup Checklist Before You Start Multi-Location Sync
An ordered setup checklist before your first multi-location sync: naming locations, stocking products, columns, connection test, priorities.
- No.49
How Often Should You Sync Inventory Across Multiple Warehouses?
Choosing a sync cadence when locations behave differently: the trade-offs of frequent versus rare syncs, and how to avoid overlapping runs.
- No.50
How to Migrate from a Single Location to Multiple Locations
A step-by-step path from one location to several without stockouts: splitting on-hand, reshaping the sheet, re-mapping, and testing.
- No.04
How to Handle Multi-Location Inventory Comfortably in Google Sheets
Warehouses and shops in one sheet. Comparing horizontal and vertical layouts, and how to design multi-location inventory that holds up in practice.