search

woocommerce / woocommerce-admin

(Deprecated) This plugin has been merged to woocommerce/woocommerce
https://woocommerce.github.io/woocommerce-admin/#/
Other
360 stars 145 forks source link

With WooCommerce Payments multicurrency functionality, numbers in the Revenue tab can be incorrect #8526

Closed csmcneill closed 2 years ago

csmcneill commented 2 years ago

Describe the bug

When using the built-in multicurrency option of WooCommerce Payments, comparing the totals of each order to the numbers that are listed in Analytics > Revenue do not always match up.

To Reproduce

@elazzabi was able to reproduce this:

  1. Set up the store to accept multiple currencies via WCPay.
  2. Add a widget to switch currencies on the front-end.
  3. Place an order and switch to a different currency.
  4. Place several other orders in the store's default currency.
  5. Convert the individual amounts of the order placed in step 4 (e.g. gross sales, shipping, taxes) to the store's base currency; use the exchange rate found via Stripe.
  6. Add up the following for each individual order: gross sales, discounts, shipping, taxes, and net sales
  7. Navigate to Analytics > Revenue.
  8. Compare the totals in step 5 to the numbers in step 6.

Actual behavior:

The price in Analytics > Revenue can be off by between +0.01 to +0.17 (so far—it could potentially be off by more).

Screenshots

0.01 discrepancy:

Markup 2022-05-15 at 18 46 08

0.17 discrepancy:

Markup 2022-05-16 at 10 38 04

Expected behavior

The totals in Analytics > Revenue will match the orders when they are added together individually.

Additional context

5217062-zen p1652658889462989-slack-C7U3Y3VMY

csmcneill commented 2 years ago

Moved to the WCPay repo here: https://github.com/Automattic/woocommerce-payments/issues/4282

Closing this issue.