How can I create a sales report by hour and location?

How can I create a sales report by hour and location?

Hiatus
Visitor
1 0 0

Hi, I need to get a report on how busy my bricks and mortar store is by the hour in order to alter our opening times/days. I can get a report on Sessions over time but it takes into account online sales. Does anyone know how to get a report based solely on actual physical transactions in store? Thanks! 

Replies 3 (3)

CloudlabSam
Shopify Partner
568 46 95

You can use the Sales over time report and use the POS Location name filter to limit to sales at your brick and mortar.

BetterReports-K
Shopify Partner
177 6 16

Hi @Hiatus,

 

Keanna here from the Better Reports support team. I would recommend our app Better Reports for this! 

 

We have a built-in report called 'total orders by day and hour' that shows total orders by day of week and hour in a matrix-style heat map report. This covers all sales channels. We can create a custom version filtered to capture POS orders only. You can also include other metrics like 'total sales' if needed.

 

In addition to custom reporting capabilities, Better Reports offers more than 80 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. Reports can be exported to CSV, Excel, HTML, PDF or scheduled to send to email in the same format or to Google Sheets.

 

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.

CloudlabSam
Shopify Partner
568 46 95

Why not encourage solutions that would be Shopify specific first, instead of just promoting your app?