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…
| source | Date | Total Price | Orderers | Orders |
|---|---|---|---|---|
| shopify_draft_order | 2023-04 | 613.32 | 6 | 7 |
| web | 2023-04 | 51934.91 | 404 | 434 |
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