Introduction
For EC sites carrying overseas brands, one situation comes up constantly: the item is in stock, but the delivery time depends entirely on where that stock sits. If it's in the domestic warehouse it ships right away; if it has to come from the overseas warehouse, delivery takes weeks. When the site fails to communicate this difference, the result is post-order complaints of "this is taking longer than I expected" — and cancellations.
This article explains a system that manages domestic and overseas warehouse inventory separately and shows users an accurate lead time. The short version: getting inventory data and its presentation right measurably reduces inquiries and cancellations.
Why Use Multiple Warehouses
Stocking Everything Domestically Isn't Realistic
Overseas brands carry deep catalogs, and holding every item in a domestic warehouse inflates storage costs quickly. The practical balance is to keep strong sellers in the domestic warehouse and source the rest from the overseas warehouse (on the brand's home side) on demand.
Sell as "Available to Order," Not "Sold Out"
Items that exist only in the overseas warehouse can still be sold — as long as the lead time is communicated. Displaying "sold out" the moment domestic stock runs dry wastes the opportunity; show "available to order, approx. X weeks" instead, and users who can wait will still buy. Multi-warehouse management is as much a sales-opportunity mechanism as a logistics one.
Inventory States and How Lead Times Are Shown
In one sentence: the lead-time display splits into three patterns based on where the stock is.
Display on the Product Page
The product page switches its message according to stock status: "ships immediately" for domestic stock, "delivery in approx. X weeks" for overseas-only stock, and "out of stock — get restock alerts" when neither has it. Because the lead time is clear before purchase, the gap between user expectations and reality never opens up.
Per-Size, Per-Color Granularity
Products come in variants — sizes and colors — and stock status differs per variant. To support displays as specific as "black in size M ships immediately, black in size L is a several-week order," inventory data is held per variant, per warehouse.
Fetching and Evaluating Inventory Data
Warehouses Distinguished by Location ID
In Shopify, each place where stock is kept — a warehouse, a physical store — is registered as a "location" with its own location ID (a number identifying the storage place). Using the Admin API (the window for operating on management-side data), the system fetches stock counts per location and converts them into the site-friendly categories of "domestic stock" and "overseas stock."
The Evaluation Order
The logic is simple. Check the domestic warehouse first: if stock exists, show "ships immediately." If not, check the overseas warehouse: stock there means "available to order," and none in either place means "out of stock." That single ordered check is the whole rule.
In one sentence: check domestic first, then overseas, and display the lead time matching wherever stock is first found.
Handling Made-to-Order Purchases
State the Lead Time Where It Can't Be Missed
For overseas-only items, the fact that the item is ordered in and its estimated lead time are stated right next to the "Add to Cart" button — a position users are certain to see just before ordering. If this gets overlooked, the "I thought it would arrive soon" misunderstanding follows. It's only a matter of placement and wording, but the effect is substantial.
After the Order
When an order-in purchase comes through, shipment from the overseas warehouse to the domestic one is arranged, and the item ships to the user after arriving domestically. Because the extra leg adds time, this is communicated both on the product page and in the order confirmation, which has reduced delivery-related inquiries.
What Operations Taught Us
Lower Inventory Costs
Since not every product needs domestic stock, warehouse costs stay contained. Strong sellers are held domestically; everything else is fulfilled on order.
A Broader Catalog
With overseas stock sellable too, the number of products offered to users grows. "Expanding the lineup without holding the stock" becomes a working mechanism rather than a wish.
Fewer Inquiries and Cancellations
Showing stock status and lead time before purchase reduced both "when will it arrive?" inquiries and lead-time-related cancellations. A large share of expectation management can be solved at the display-design level.
Summary
Multi-warehouse inventory management balances lower stock costs with a wider catalog. The key design decision is not showing raw per-location numbers, but converting them into terms that carry meaning for users — ships immediately, available to order, out of stock. That conversion layer is the heart of running multiple warehouses well.