How does editing post-order date affect reporting?

How does editing post-order date affect reporting?

  • Source Medium Executive Summary reports on the discrete order-date, with any subsequent modifications to the order reflecting back on the original order-date.
  • Shopify reports on the event-date, with any subsequent modifications to the order reflecting on the date of the event/modification-date.

Due to the difference in reporting, gross revenue in the Source Medium Executive Summary may not align perfectly with the respective Shopify sales report.

As an example of a order-journey:

A customer places an order of $100 on November 10th from Store XYZ. The same customer adds $50 worth to the original order on November 11th. The following tables will summarize how the data will be presented to the store.

Shopify Report:

date
Gross Revenue
Nov 10, 2022
$100.00
Nov 11, 2022
$50.00

Source Medium Report:

date
Gross Revenue
Nov 10, 2022
$150.00
Nov 11, 2022
-