When you connected Billy Grace to your e-commerce platform, you will see an e-commerce settings page under Management in the left menu. This article explains how and when to use this section.
On this page, there are three tabs
Order Statuses
Orders
Settings
Order statuses
In order statuses, you see all order statuses of the orders we imported into Billy Grace. By default, these are the statuses of the last 3 years.
Orders
In orders, you see all imported orders of the last 30 days.
The orders and order value you see in this table are used to calculate the total revenue and other metrics in the Overview and Channel Performance.
If the revenue on the Overview is different from what you see in your connected e-commerce platform, then you could run an export of the E-commerce order table and compare this with an export of orders from your e-commerce platform.
I see a difference in revenue on the overview compared to what I see in Shopify / Magento / WooCommerce / Salesforce commerce cloud / e-commerce platform, Why is there a difference?
Most of the time this is caused because of refunds or because in Billy Grace orders with statuses are taking into account in the total revenue that in your e-commerce platform are filtered from the calculation. You can check this by:
Navigate to the E-commerce page
Navigate to Orders
Run an export of the orders of the last 30 days
4. Run an export from the orders in your e-commerce platform
5. Compare the two list with each other in Excel or another spreadsheet platform.
6. You want to look for orders that are present in one order dump, but missing in the other.
Often we see that the difference is caused by order statuses that are used in Billy Grace but filtered from the e-commerce platform. By default, all order statuses are used in Billy Grace to calculate the total revenue. To change this, you navigate to the last tab.
Settings
In settings, you can choose which order statuses should be included to calculate total revenue.
In the above example, the statuses Paid, Pending and partially_paid are included in the revenue calculation. All other statuses are excluded.
Keep in mind that Billy Grace updates every night. Changing the order statuses here will have effect on the revenue and order calculation tomorrow.
Experiencing other issues or discrepancies between orders and revenue in Billy Grace in comparison to your e-commerce platform? Please contact us via the in-app support chat.