More and more stores keep stock not only in their own warehouse but also with a 3PL provider or a dropship supplier. The tricky part is making inventory you do not physically hold visible inside Shopify. This is exactly where many merchants get stuck.
The answer is surprisingly simple: register the external warehouse as a Shopify location too. Today we will focus not on the supplier feed itself, but on how to design and run an external warehouse as a single location.
Why model an external warehouse as a location, and what to watch
In Shopify, a location is a place that stocks, fulfills, and sells inventory. Your own warehouse, a 3PL site, or a supplier’s warehouse can all live as the same kind of location. There is no reason not to use this.
- Even when stock is split across sites, the total available quantity is calculated for you
- You can trace which order shipped from which warehouse, per location
- Each site can hold its own available quantity, so the numbers stay closer to reality
There is a catch, though. You cannot eyeball external stock in real time. The freshness of the numbers depends on how often the supplier updates its data, and Shopify will not magically pull real quantities from an external warehouse. That is precisely why you must decide who enters the numbers and when.
Feeding 3PL quantities into your master
Once the external warehouse exists as a location, the next question is how to load its quantities. Most 3PLs and suppliers send inventory data on a schedule as CSV or a Google Sheet. Typing all of that into Shopify by hand is simply not realistic.
The approach we like is to treat a Google Sheet as the master — the single source of truth — and lay out each location’s quantity as its own column. One column for your warehouse, one for the 3PL, one for the dropship supplier. Splitting columns by location makes management far easier.
Mismatches in supplier data granularity and timing
Here you have to watch for differences in the granularity and timing of supplier data. A supplier might send data by style number rather than per SKU, and might update once a day or only every few days. If your master cadence and the supplier cadence do not line up, you risk overselling or double-counting stock.
- Keep a separate lookup table that maps the supplier SKU to your own SKU
- Know the update timing and check a date column so you do not overwrite with stale data
- Reconcile case packs and unit differences before they enter the master
Setting dropship stock as the shipping origin
With dropshipping, goods ship directly from the supplier to your customer. That means the location is both a place that stocks inventory and the actual point of origin for fulfillment. Because Shopify assigns and fulfills orders per location, a dedicated dropship location makes it clear which orders should be routed to the supplier.
Decide whether the external location is overwritten or referenced
The most important design choice is whether you overwrite the external location’s numbers from the master, or keep them purely as a reference display. If you trust the supplier’s figures enough to push them straight into Shopify, that is an overwrite workflow; if a human makes the final call, that is a reference workflow.
- 01If supplier data is accurate and near real time, an overwrite workflow fits well
- 02If data is coarse, or you want to hold a safety buffer, adjust on the master side before pushing
- 03When in doubt, start with a few SKUs and watch how the gaps behave before scaling up
An app like Sync Master treats a Google Sheet as the inventory master and writes per-location quantities into Shopify automatically. It supports multiple locations (multi-warehouse), so you can manage your own and external warehouses in a single sheet. It also offers a connection test to validate your column mapping before any real sync, which helps prevent accidents like overwriting only the external warehouse column by mistake.
Make ownership of the inventory clear
Finally, the thing that pays off most in day-to-day operations is making ownership of the numbers explicit. When an external warehouse figure drifts, who fixes it — the supplier, or someone on your team? If that split of responsibility is fuzzy, the very convenience of modeling locations can become a source of confusion.
Treating an external warehouse as a location is a powerful way to bring your inventory view closer to reality. Do not stop at building the mechanism; decide on data freshness and ownership too, and you can confidently trust both 3PL and dropship setups. Start with one external warehouse and give location modeling a try.