Why don't the totals in Shopify reports match Metorik reports?

Store admin? Check out the report settings here. As you change them, Metorik will show you what last month's sales would be so you can compare that to Shopify.

You'll likely find that the totals in Shopify reports don't match the totals in Metorik reports. This is due to a number of reasons, which we'll outline below:

Discounts

This is the most common cause of a discrepancy. Shopify includes the pre-discount amount in it's "Total Sales" (gross revenue) figure. For example:

This isn't a good way of recording sales as your store never received this revenue, and by the nature of discounts, possibly was never going to – it's hypothetical revenue.

Metorik only includes the revenue your store actually received.

Multiple currencies

The currency conversion rates Metorik uses may not match the rates your store is using. Both amounts will be inaccurate, so it's recommended you filter your data by currency to get the raw, more accurate amounts. Read more.

Excluded order statuses

Metorik allows you to customise the order statuses excluded from reports (unlike Shopify) so it's possible that the report totals won't match up as Shopify is including statuses that you've excluded. Read more.

Gross/Net sales

Metorik allows you to customise what should be deducted from gross sales to determine net sales. Additionally, Metorik offers 2 reports related to net sales - the revenue report and the orders report. Both have differences so it's worth reading this help doc to understand them.

Troubleshooting

There can be a variety of reasons for discrepancies, usually, it is to do with the difference in reporting on discounted orders, Order Statuses being included/excluded from reports, or how the Refunds are being handled, but there could be other reasons.

In general, we recommend sticking to one platform to base your stats on as there is likely always going to be some level of difference.  You can see that the Gross Sales for example are calculated differently across the platforms.

Of course, we want you to have full confidence in Metorik's reporting so we'll definitely help to find the reason for the difference.

Narrow down the discrepancy

It's always best to break it down into as smaller time frame as possible (i.e 1 or 2 days) so that we can look at the exact orders that make up a total and explain any discrepancies.

The first thing to do would be to find a particular day within a period that you can see a difference, we can then look at each order that makes up the number from the Revenue report page and see why there is a difference

You can click through to see all the Orders that are used to make up the numbers, and you can also Export these Orders.

It's also worth noting here how Metorik handles refunds.... we do it in two ways which you can read about here Revenue and Order reports and there is full explanation of the Refunds and the Refunds report here.

Further help

This often is enough to see why there maybe a difference however if it still isn't clear we can compare them directly with the Shopify Orders that are being used.

To do this you can export the Orders from the particular date you are looking at from within your Shopify store directly, and then open a support ticket with us attaching the Orders export file so we can take a further look.

There is always a valid reason we just need to narrow it down first and then we can get it cleared up for you asap!