Beyond an online warehouse, you might open a physical shop or set up a weekend pop-up — and suddenly the places where you hold inventory multiply. This is where many merchants stumble on one question: can I treat store stock the same way I treat warehouse stock?
The short answer is no. Retail shops and pop-ups are locations with a different character from warehouses, so it pays to model and run them a little differently. In this article we walk gently through how to separate stores and pop-ups from warehouses, and how to get along with sheet syncing and POS.
Why retail and pop-ups deserve their own location
In Shopify, a location is simply a place that stocks, sells, or ships inventory. A warehouse, a shop, and a pop-up can each be registered as its own location. Because inventory is tracked per location, the same product can sit as ten in the warehouse and three in the shop, separately.
So why not just lump the store in with the warehouse? The reason is simple: the way stock moves, and how fast, is completely different between the two. Warehouse stock mostly drops as online orders ship out. Store stock drops the instant a customer picks something up and takes it to the till. Merge two kinds of movement into one number and you instantly lose sight of how much is where.
- Warehouse: stock falls as online orders are fulfilled, and tends to move in batches
- Retail shop: stock falls one unit at a time at the counter, and POS updates it on the spot
- Pop-up: you carry in stock for a limited run, then pack up when it ends
POS movements and how they relate to sheet sync
The thing to watch with a physical shop is Shopify POS, the register app. When one item sells at the counter, POS automatically subtracts one from that store location. That is wonderfully convenient — but it calls for care when you use a sheet as your source of truth and sync from it.
If your sheet says the store has five units and you overwrite the store location with that figure, you risk wiping out the sales POS has been racking up in real time. Your sheet might update only a few times a day, while POS moves by the second. That gap in update speed is the single most important thing to grasp when managing store stock from a sheet.
Should store stock be managed in the sheet or excluded?
Here is where many people hesitate: should store stock live in the sheet too, or be left out of the sync entirely? A rough guide:
- 01Shops with frequent POS sales are safest left out of sheet sync, with the count left to POS
- 02Shops that POS rarely touches — a display space or a restocking waypoint, say — can be managed by number in the sheet with little risk of drift
- 03When in doubt, start by syncing only your warehouse locations from the sheet, and run stores manually or via POS
In other words, leave places that people move in real time to that system (POS), and keep only the places where you decide the numbers in your sheet. Drawing the line that way avoids collisions. Our app, Sync Master, supports multiple locations (multi-warehouse) and lets you choose which locations to write to, so it is easy to design a setup that syncs only warehouses and leaves stores out.
Modeling a temporary location for a limited-run pop-up
For weekend markets or one-off event stalls, the idea of a temporary location really helps. Create a dedicated location, and move into it only the stock you plan to carry along. Do this and pop-up sales stay cleanly separate from your online stock, which prevents double-selling.
When the pop-up ends, return any leftovers to the warehouse location and deactivate the temporary one. Deactivating rather than deleting keeps the past inventory history, which makes it easy to reuse the next time you set up at the same spot. If you manage things in a sheet, you can simply add a pop-up column for the run and remove it afterward.
Removing stores from your online sales locations
Another important point is whether a location’s stock should be sellable online at all. If you accidentally include retail or pop-up stock in your online store’s available count, an item that only exists at the counter can sell online — and then you cannot ship it.
To prevent this, remove stores and pop-ups from the locations your Online Store sales channel draws stock from. Shopify lets you manage which locations’ inventory each sales channel can see, so you can keep shop-floor stock off the web. Make warehouses your only online-facing locations and you avoid the accident of those three store units being snatched up by a web order.
Dividing stocktakes when stores and warehouses mix
Last comes the stocktake. With warehouses and stores mixed together, both the counting method and who does it will change. Warehouses are easy to count in one go, while store stock shifts little by little during opening hours — so the trick is to count when sales have stopped, such as after closing.
We recommend splitting stocktake duty by location, with each person responsible only for the real count at their own location. The warehouse lead tidies the warehouse columns in the sheet; shop staff reconcile the store’s POS stock after closing. Make the roles clear and no one wonders which number to fix, and drift surfaces sooner. The more mixed your setup, the more deciding up front which mechanism governs each location pays off over the long run.
Retail shops and pop-ups are locations that simply move differently from warehouses. Separate the places you leave to POS from the ones you hold in your sheet, and make the online-publishing scope and stocktake ownership clear — get that separation right and your inventory stays easy to read no matter how many stores and warehouses you add.