My Orders Aren't Showing Up In Shopify's Sales By Location Report

Shopify's analytics and reporting don't always display your orders as expected.  Sometimes orders created from apps like EZ Importer may act differently when summarized in the reporting tools.  We've seen imported orders missing from reports grouping by Point Of Sale location.  

Sales Reporting, POS Location, and Sales Channel

Even though orders are being imported and set to a specific location, Shopify sees the app as a different sales channel than your provided POS location.  When you're looking at the report, it's looking at the sales channel and not the location, which can be confusing when you first look at it.  

This means Shopify doesn't have a report that considers the location; it uses the sales location instead.  So when looking at sales reports and group by location, you're looking to group by sales channel location, not the actual location_id that you set on import.

We've posted about this in the Shopify forums, and you can read Shopify's response here.

POS Location and Fulfillment Location

Another thing to be aware of is the difference between the POS and fulfillment locations.  This causes confusion, so it's important to point it out.  The location that's displayed on your order is the fulfillment location.  This is where the order is being fulfilled from.  When working natively with Shopify, their internal systems will ensure they are all in sync.  EZ Importer can't make assumptions like this because merchants have different setups.  So you'll have to map the location_id field, which is the POS location, and the fulfillment assigned_location, which is the fulfillment location.

Note that setting the locations will not allow your orders to appear in sales reports grouped by location.  Because Shopify uses the sales channel as the POS location, the orders will not appear in the reports. 


App: EZ Importer

Tags: reporting, sales channels