Need Sales Reports by Channel filtered by location

Need Sales Reports by Channel filtered by location

threadfare
Tourist
11 0 13

We have two physical locations using POS and one online channel from which we fulfill online orders from both physical locations based on inventory at those locations. I need to be able to see Online Sales by Location which currently isn't an option inherent in Shopify (mind blowing as this should be!)

Replies 4 (4)

CloudlabSam
Shopify Partner
611 49 106

Hi There,

 

I think you're mixing terms a bit. The sale is always from your online channel and is then fulfilled by a physical location. It sounds like you are looking for sales based on the location from which the product was fulfilled. There are some edge cases to consider, like what happens when you fulfill an order from two different locations.

 

Shopify has reports for sales by locations, but not sales based on the fulfillment location. For that you can use one of the reporting apps like Report Toaster, Better Reports, etc.

 

threadfare
Tourist
11 0 13
Yes that is what I am needing. Sales by fulfillment location. And yes there are times when an order’s fulfillment is split between the two store locations. I need those orders sales broken down and attributed to whatever location they were allocated to ship from.

Most landlords require sales reporting including online orders fulfilled from that physical storefront…it is also a requirement when reporting sales for sales tax purposes.

Report-Pundit
Shopify Partner
364 13 26

Hey @threadfare ,

 

If you are still looking for a solution to your requirement, we can create a custom sales report by fulfillment locations by fetching the "assigned fulfillment location" for each product you sell.

 

Please let us know if you need any help. We will be glad to assist.

 

Cheers!

 



Report Pundit - Instant reports and custom dashboards

BetterReports-C
Shopify Partner
97 0 7

Hi @threadfare 

 

Claudia here from Better Reports.

 

Have you been able to find a solution? If not, I would recommend our app Better Reports for this.

 

We can create a report from the Fulfillment line table showing the location(s) where the online sales were fulfilled. In the event an order is fulfilled at both locations, this will show which item was fulfilled at location A and which at location B.

In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.

 

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?