Different amounts from Shopify API & Shopify UI (Net Sale and Gross Sale)

Shopify Plus

Topic summary

A user reports discrepancies between sales figures (Net Sale and Gross Sale) retrieved via Shopify API versus those displayed in Shopify’s UI for identical date ranges. The store operates exclusively in the US market with USD currency, ruling out currency conversion as a factor.

Key clarifications needed:

  • Whether “Shopify UI” refers specifically to the dashboard
  • The exact API implementation and code being used
  • Applied filters (order status: approved vs. fulfilled, date ranges, etc.)

A respondent notes that API requests can be configured in various ways, and different filtering criteria—such as order approval status versus fulfillment status—can significantly impact the returned values. Without seeing the specific API code and parameters, it’s difficult to pinpoint the root cause.

Status: The issue remains unresolved pending additional technical details about the API implementation.

Summarized with AI on November 1. AI used: claude-sonnet-4-5-20250929.
1

Hello,

I noticed differences in sales amounts between Shopify API and UI reports for the same date. We operate only in the US market using dollars ($), so currency settings shouldn’t be an issue.

Could you explain the cause of this discrepancy and how to resolve it?

Thank you!

2

Saying Shopify UI - you mean the dashboard?

Saying Shopify API - you mean you guys request the data through Shopify API? Need to see the code. What filters are applied for the Net and Gross sale, all approved orders or fulfilled? All those factors can impact, but it is hard to say as Shopify API requests can be done different way.