Summary

You may see that Triple Whale’s “Amazon Product Sales” tile doesn’t match the “Ordered Product Sales” in Amazon Seller Central or the exact figures in Amazon’s official analytics. Often this arises from how canceled, pending, or partial orders are handled and the rounding differences in Triple Whale’s data feed.

Why This Happens

• Canceled/Pending Orders: Amazon’s API does not send price data for canceled/pending orders. Triple Whale provides this data separately as “Product Sales” and “Canceled Product Sales.”
• Rounding Discrepancies: Triple Whale rounds each order line item, while Amazon uses a higher level of granularity without rounding.
• API Limitations: Amazon doesn’t always provide full detail on pending or partial refunds, so Triple Whale can only approximate some of those amounts.

Example Scenario

1. Customer places a $50 Amazon order, then cancels $10 worth of items the same day.
   • Amazon: Either shows a $40 net order in the dashboard, or shows $50 ordered and $10 canceled (depending on the timing of the cancelation).
   • Triple Whale: Shows $50 product sales and $10 canceled sales, but might round them individually (e.g., $9.67 becomes $10).

How This Affects Reporting

• Minor Gaps or Overlaps: Over many orders, rounding or canceled-item issues can add up to bigger reported differences.
• Unexpected “Canceled Product Sales”: You may see an entire line for canceled items, which Amazon lumps differently or net out in its own metrics.

How to Interpret the Data Correctly

1. Compare “Ordered Product Sales” in Amazon to “Product Sales” in Triple Whale. A direct 1:1 match may never happen due to rounding, but they should be close over a larger date range.
2. Check the “Canceled” Amount: If you see more canceled/pending sales in Amazon than in Triple Whale, it might be that Triple Whale hasn’t received the updates.
3. Focus on Trends vs. Exact Dollars: If you only see a small numeric gap, it’s likely just rounding or timing differences.