How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard.
Does anyone have any insights on this?
We selected the report "All Orders". We have played with all columns, total_price, subtotal_price, total_discounts, total_tax and others.
Thanks
Best Answer
-
According to their documentation Net Sales is Gross - Discounts - Returns + Taxes + Shipping so you should be able to back into Gross sales with:
Gross = total_price + total_discounts + returns - total_tax - total_shipping_price_set_presentment_money_amount
Refunds/Returns isn't included in the All Orders report in the API, you'll also need to pull the Refunds report.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
According to their documentation Net Sales is Gross - Discounts - Returns + Taxes + Shipping so you should be able to back into Gross sales with:
Gross = total_price + total_discounts + returns - total_tax - total_shipping_price_set_presentment_money_amount
Refunds/Returns isn't included in the All Orders report in the API, you'll also need to pull the Refunds report.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive