How to get Gross Sales from Shopify?

caiopimenta · 2023-01-31T18:49:55+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Connectors

Magic ETL

Accepted answers

GrantSmith

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.

All comments

GrantSmith

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.

German_Rodriguez

Looking for the same, can anyone point me in the right direction regarding how to set Shopify Connector DataSet

i can not find best practices or suggestions

German_Rodriguez

my reports are running and

net sales = subtotal_price

gross sales = total_price

I was able to join an old DB with Shopify orders and now DOMO have a card that looks the same as Shopify dashboard