How to Filter and Group Shopify Reports by Physical Storefront

If you run a Shopify store with one or more brick-and-mortar locations, you already know that online and in-person sales tell very di!erent stories. A shopper browsing your website behaves di!erently than someone walking into your retail shop, and lumping both into the same numbers can hide problems — or opportunities — that only show up when you look at physical storefront performance on its own.

What "Filter by Physical Storefront" Actually Does

Inside Shopify's Reports and Explore tools, there's now an Is physical storefront filter and dimension. This lets you segment your analytics based on whether a location is tagged as a physical storefront, so you can compare how your retail locations perform against your online store and other sales channels side by side.

Instead of manually cross-referencing location names across multiple reports, you can isolate everything happening at your physical shops — sales, order counts, average order value, product performance — and hold it up against the rest of your business in a single view. It works alongside Shopify's existing point-of-sale reporting dimensions, and once you build a report with this filter, you can save it as a custom report to reuse whenever you need it.

Importantly, the filter reflects each location's current status. If a location is marked as a physical storefront today, all of its historical sales data is included under that label, regardless of when the sale actually happened. So if you update a location's setting, yourreports adjust immediately rather than requiring a re-sync or backfill.

Setting Up Physical Storefront Filtering, Step by Step

Getting this running only takes a few minutes:

1. Mark your locations correctly. From your Shopify admin, go to Settings > Locations, open the location's detail page, and confirm it's flagged as a physical storefront. This flag is what powers the entire filter, so it's worth double-checking each location if you have several.
2. Open Analytics > Reports (or the Explore tool) from your Shopify admin.
3. Choose or build the report you want to segment — sales by location, product performance, order volume, or any custom report you've created.
4. Add the filter. In the configuration panel, click the plus icon next to Filters, then select Is physical storefront from the list. Filters in Shopify are grouped by category, so you'll find it alongside other point-of-sale-related fields.
5. Set the value to true (to see only storefront activity) or false (to see everything else —online store, marketplaces, and other channels).
6. Save the report if you plan to check this view regularly. Saved reports keep your filter settings so you don't have to rebuild them every time.

You can also combine this filter with others — for example, pairing it with a date range, a specific sales channel, or a shipping region — to get an even more targeted slice of your data.

Why This Matters for Managing Your Shopify Store

1. You get a clear read on in-store performance

Retail and ecommerce have di!erent rhythms. Foot traffic, staffing, local events, and weather all influence in-person sales in ways that don't apply to your online store. Filtering reports by physical storefront means you're no longer forced to average these two very different businesses together, which can mask underperformance in one channel or overstate success in another.

2. It supports smarter multi-location decisions

If you operate more than one retail location, grouping by physical storefront lets you compare stores against each other without your online channel muddying the comparison. That makes it easier to spot which location is genuinely thriving, which one might need a merchandising refresh, and where staffing or inventory adjustments could have the biggest impact.

3. It simplifies reporting workflows

Before this kind of native filtering, many merchants relied on exporting order and inventory data to spreadsheets just to separate in-store numbers from online numbers — a manual, error-prone process. Being able to filter and save these views directly inside Shopify's Reports and Explore tools removes that extra step and reduces the risk of stale or miscalculated exports.

4. It strengthens your retail analytics overall

This filter works in tandem with Shopify's broader retail analytics reporting, which already includes metrics like sales by retail location and sales by staff for merchants using Shopify POS. Combining these with the physical storefront filter gives you a fuller picture: not just how a location is performing, but how that performance compares to your digital channels and to your business as a whole.

5. It helps with forecasting and planning

When you can reliably isolate physical storefront data, forecasting becomes more accurate. You're basing projections on consistent, like-for-like data rather than blended numbers that shift depending on your channel mix from month to month. That matters when you're planning inventory purchases, seasonal staffng, or deciding whether it's time to open (or close) a location.

Bringing It All Together

For any merchant running a hybrid retail and ecommerce operation, separating physical storefront performance from your other sales channels isn't just a nice-to-have — it's foundational to understanding your business accurately. Shopify's filter and grouping option for physical storefronts removes the friction that used to require manual exports and spreadsheet work, letting you build clean, comparable, and reusable reports directly inside your Shopify admin.

If you haven't checked your location settings recently, it's worth a quick audit. Confirm each physical storefront is flagged correctly, then head into Analytics to start filtering. Once it's set up, you'll have a much sharper view of how your retail locations are truly performing — and the data to back up your next big decision.