What Is the Shopify Sales by Fulfillment Location Report?
The Shopify Sales by Fulfillment Location report groups your Shopify sales by the physical location each order was fulfilled from, whether that is a warehouse, a retail store, or a third-party (3PL) site. For the date range you choose, it lists each fulfillment location alongside the products shipped from it, the net quantity of those products, and the total sales value tied to them.
This is not the same as where a customer is billed or where they live. Shopify's native sales reports center on billing location and channel, so the location that actually picks, packs, and ships an order stays hidden. This report fills that gap. If an order is split across two sites, both sites appear against the products they handled.
Merchants reach for this report when fulfillment happens from more than one place and the operational load needs a number. It answers a question the billing view cannot: where is our shipping work concentrated, and which products drive it?
Which Fields Are Included in the Shopify Sales by Fulfillment Location Report?
These four columns show where each product was shipped from and how much volume and revenue that location moved.
You can customize the pre-made report by adding a Date column to track fulfillment over time, filtering to a single site, or adding calculated columns such as each location's share of fulfilled sales or average units per order. Shipping fields like tracking number, delivery date, or shipping address can also be added when you want to follow where fulfilled orders are going. If you want the cost of shipping those orders alongside the location, the Shipping Label Cost report breaks label spend down per order.
Important Insights You Can Find in This Report
Which location is carrying most of the shipping load right now?
Sort by Total Sales and Net Quantity to see how the fulfillment work splits across sites. A location handling a large share of both units and revenue is your operational center of gravity. If that concentration keeps shifting toward one site, it usually signals where inventory and pick-pack staff need to follow, rather than being spread evenly out of habit.
Is a location moving lots of units but little revenue?
Read Net Quantity against Total Sales for each location, not just the totals. A site shipping high unit counts against low sales value is likely fulfilling cheaper, faster-moving SKUs, while a site with fewer units but strong sales is handling higher-value products. That mix tells you which location needs volume-focused staffing and which needs careful handling of expensive stock.
Which products depend on a single fulfillment site?
Filter to one product and check how many locations ship it. A product fulfilled from only one location is a supply risk: if that site runs low or goes down, those sales stop. Spotting single-source products early lets you decide whether to stock them at a second location before demand outpaces one warehouse.
THE ANALYST'S READ: The Signal Most Merchants Miss
The pattern worth hunting is the gap between where sales are fulfilled and where your customers actually are. This report tells you where orders ship from; pairing it with the Sales by Billing Location report tells you where they ship to. When a large block of fulfilled sales leaves one location but the buyers cluster on the opposite side of the country, every one of those orders is traveling farther than it needs to.
That could indicate a stock-placement problem rather than a demand problem. It may suggest that a fulfillment point closer to the demand cluster would cut both shipping cost and delivery time, or that inventory should be rebalanced so nearby stock covers nearby orders. Once you spot a location driving longer shipments, fulfillment and delivery date reporting is where you check whether the extra distance is also slowing processing or raising label cost.
How Can You Automate the Shopify Sales by Fulfillment Location Report?
Open Report Pundit and select the pre-made Sales by Fulfillment Location template. The columns are already set, so you can run it and press Save. To rebuild it yourself, open Custom Reports, add Fulfillment Location, Product Name, Net Quantity, and Total Sales, set your date range, and add a filter if you want to focus on one site.
Once saved, schedule it to send automatically on a daily, weekly, or monthly basis so you never rebuild it by hand. Reports can go to you, your ops team, or a 3PL contact, and can be delivered as Excel, CSV, or PDF, or pushed to Google Sheets and Google Drive.
Frequently Asked Questions
How is fulfillment location different from billing location?
Billing location is where the customer pays; fulfillment location is where the order physically ships from. This report is the operational view, so inventory placement, warehouse staffing, and shipping cost all follow the fulfilling site rather than the customer's address.
Why can't I see this in Shopify's native reports?
Shopify's built-in sales reports group by billing location, channel, or store, but not by the location an order was actually fulfilled from. That specific cut is not available natively, which is why merchants running multiple warehouses or a 3PL use a reporting app to see it.
How are orders that ship from more than one location handled?
An order can be split so different items ship from different sites. Each fulfilling location appears against the products it handled. Decide whether you want to count such an order once or once per location, and keep that rule consistent so your comparisons stay accurate.
What does Net Quantity mean in this report?
Net Quantity is the number of units shipped from a location minus any units that were later returned. It reflects the fulfillment volume that stayed sold, so a location with heavy returns will show a lower net figure than its raw shipped count.
Can this report help me decide where to open a new warehouse?
Yes. Compare where fulfilled sales concentrate in this report against where your customers are located in the Sales by Billing Location report. A large gap between the two points to a spot where a new fulfillment site could shorten delivery distances and lower shipping cost.
Can I track fulfillment location over time?
Yes. Add a Date column and group by week or month to see how the load shifts between locations across a period, instead of viewing a single static snapshot.