Versions Compared

Old Version 28

changes.mady.by.user Hunter Schaeffer

Saved on

compared with

New Version 29

changes.mady.by.user Hunter Schaeffer

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleI'm trying to build some deeper reporting for our orders coming through ultracart. I've exported the orders using all columns into a CSV format and the numbers I see from those orders don't match the "Total Sales" number in the Statistics (Basic) section. I was wondering if you could enlighten me as to how that number and the "Total orders" is calculated. I have all the orders in one table with line items in the order broken out into another table and I can't seem to match the numbers up.

The analytics bus that drives that dashboard is not guaranteed to be accounting perfect - it's meant to be a snapshot representation on sales activity.  One should not try to match those up literally penny for penny.  Instead, if widgets uses an event stream, it may differ slightly from the official order database.  If you're doing accounting type reporting and reconciliation, it's recommended that you use either the Reports menu or order exports for conducting a deeper analysis of your sales activity.