Reconciling Shopify and Ordergroove Sales Data

Shopify and Ordergroove have different methods for calculating revenue, so your sales numbers in Shopify might look different than the revenue reported in Ordergroove. It's important to understand the differences so you have a clear picture of your total subscription revenue.


How Shopify Determines Sales Revenue

Ordergroove and Shopify metrics are not one-to-one in their definitions. Shopify has two separate measurements for sales.

Shopify Net Sales = Gross sales - discounts - returns
Shopify Total Sales = Gross sales - discounts - returns + taxes + duties + shipping charges

There are two main reasons why Shopify and Ordergroove may not match-up. There are discrepancies due to shipping, tax, and returns, and there are discrepancies over how initial order is counted.


Discrepancies due to shipping, tax, returns

Ordergroove does not track shipping costs or tax costs. We consider revenue, sometimes referred to as Gross Merchandise Value (GMV), as total revenue processed from recurring orders without tax or shipping. Shopify does track shipping and tax; they account for both in your reports. 

Refunds are another accounting difference. When an order is refunded, Shopify removes the revenue from your data reporting. No update is sent to Ordergroove to tell us to remove the value from our system, so your reports will show a higher revenue.

Discrepancies due to initial order revenue and revenue from recurring orders

Ordergroove reports on two distinct revenue metrics.

  • Activation Revenue: new subscription revenue, only the first order.
  • Recurring Order Revenue: revenue from all recurring purchases.

Shopify's Sale Channel Name = Ordergroove Subscriptions filter only displays recurring revenue, not the initial purchase, so it will be significantly less than what's displayed in your Ordergroove dashboard.

To match what you see in Ordergroove, set a filter in Shopify with the following condition: Sale Channel Name = Ordergroove Subscriptions