Sync Master
Blog

Designing Fulfillment by Assigning Locations to Regions and Markets

Multi-locationOperations

Summary

How to map each domestic and cross-border market to the nearest location so customers ship from the closest stock. We cover planning regional allocation in a sheet and catching shortages caused by imbalance early.

If a Tokyo customer could ship from your Kanto warehouse and a European customer from a local one, both shipping cost and lead time drop sharply. For stores with several warehouses, designing fulfillment by region and market is a topic that affects not just revenue but customer satisfaction.

Today we focus specifically on tying a market concept like Shopify Markets to your locations, so orders ship from the nearest stock for the customer’s region. Rather than the automatic routing of orders itself, the heart of this is the groundwork: deciding which stock to hold in which region.

The idea of shipping from the nearest regional warehouse

In Shopify, a location is a place that stocks, fulfills, and sells inventory. When you register several locations, Shopify decides which site an incoming order should ship from. The key point is this: if there is stock at a site close to the customer’s delivery address, there is a better chance it can ship from there.

When nearest-shipping works well, the distance shrinks, and both cost and delivery days fall. Conversely, if stock piles up in only one warehouse, more orders ship from distant sites and costs climb. So regional fulfillment design starts not with adding more locations, but with holding the right inventory in each region.

Mapping markets to locations

Shopify Markets is a mechanism for tailoring pricing, currency, and presentation by country or region. The market itself does not automatically decide that a given order ships from a given warehouse, but it does give you a sense of where most orders come from. Mapping your markets to your warehouse locations in advance makes it far easier to set an allocation policy.

  • Domestic market → make your main domestic warehouse the center of fulfillment
  • EU market → weight inventory more heavily toward a warehouse inside the region
  • North American market → prefer a local site if you have one, otherwise design around cross-border shipping

When you split stock between domestic and cross-border

It is common to want separate stock for domestic and cross-border. For example, the domestic warehouse fulfills domestic orders first, while a separate pool is reserved for cross-border. Here the strength of Shopify locations is that you can hold the domestic location’s quantity and the overseas location’s quantity separately for the same product. Because available is managed per region, you can show numbers that stay close to real stock.

Planning regional allocation in a sheet

Deciding how much stock to place in each region falls apart fast if you keep it only in your head. We recommend treating a Google Sheet as the inventory master — the single source of truth — and writing the allocation out with one column per location. Lay a Kanto column, a Kansai column, and an EU column against each product row, and the regional split becomes visible at a glance.

  1. 01First list every SKU as a row and set up each location as a column
  2. 02From past sales by region, enter a target quantity you want at each warehouse
  3. 03Before peak season or a sale, weight the columns for regions where demand will rise

An app like Sync Master treats such a Google Sheet as the inventory master and writes per-location quantities into Shopify automatically. It supports multiple locations (multi-warehouse), so you can decide the regional split in a single sheet and push it straight to each site. It also offers a connection test to confirm your column mapping before any real sync, which prevents mix-ups like writing the EU column into the domestic warehouse.

Catching shortages from regional imbalance early

Splitting stock by region is convenient, but it also makes imbalance more likely — one region running dry while overall stock remains. You still have inventory in total, yet the warehouse for a popular region is empty. Left alone, this forces shipping from a distant warehouse at a higher cost, or in the worst case leads to lost sales.

Spot imbalance early and your options are surprisingly broad — transfer stock between warehouses, or rework the allocation in the sheet. What matters is building a habit of reviewing each region’s remaining quantity on a regular cadence.

Balancing shipping cost and lead time

Finally, do not lose sight of the balance between shipping cost and lead time. Nearest-shipping is ideal, but holding a lot of stock so the nearby warehouse never runs out inflates carrying costs. Trim stock too far, and more orders ship from distant warehouses, stretching cost and days. Which way to lean depends on how each region sells and how much delivery delay your customers accept.

Regional and market fulfillment design is never set-and-forget; you keep revisiting allocation as sales shift. With a setup that makes a Google Sheet the master and reflects it to each location, regional adjustments come down to changing a few numbers. Start with your two biggest regions and give nearest-shipping design a try.

Related reading

Other articles you might like

Stop pasting stock numbers by hand.

Install Sync Master on Shopify and run your first sync in under five minutes.