Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

How does shopify calculate the Total Sales figure shown on dash board compared to the analytic

How does shopify calculate the Total Sales figure shown on dash board compared to the analytic

philhutchinson
Visitor
1 0 1

Hi,

We pull all our clients orders down via the dashboard and do monthly reporting.

We pull these reports at the start of the next month, e.g. we pull April's at the start of May.

 

We process our reports based on total_price for an order and only process the clients required channels.

 

To Keep it simple in this example (Web)

 

So for this client... The dashboard on the right shows

 

Total sales breakdown

1 Apr–30
Orders£51,871.51
Returns-£5,697.03
Total sales£46,174.48

 

431 Orders

 

The Analytics shows

 

sort ascending bySales channel name sort descending byOrders sort descending byGross sales sort descending byDiscounts sort descending byReturns sort descending byNet sales sort descending byShipping sort descending byDuties sort descending byAdditional fees sort descending byTax sort descending byTotal salesSummary
Amai Quantity Breaks and Gifts
Online Store
Draft Orders
438
£63,092.75
-£12,446.84
-£6,105.18
£44,540.73
£1,812.17
£0.00
£0.00
£0.00
£46,352.90
0
£0.00
£0.00
-£215.05
-£215.05
£0.00
£0.00
£0.00
£0.00
-£215.05
431
£62,413.25
-£12,343.36
-£5,670.28
£44,399.61
£1,774.87
£0.00
£0.00
£0.00
£46,174.48
7
£679.50
-£103.48
-£219.85
£356.17
£37.30
£0.00
£0.00
£0.00
£393.47

 

Which I can't see how Online Store equals the front page figure

 

And when I download and process all the orders from the system .. I see...

 

sourceDateTotal PriceOrderersOrders
shopify_draft_order2023-04613.3267
web2023-0451934.91404434

 

So I have discrepancies everywhere?

 

I have 3 extra orders?    

 

I look at the created_at field for processing orders?

 

If someone could point me the right direction on why none of this matches it would be very helpful.

 

Thanks

Phil

 

Replies 0 (0)