Hello!
I’m building a script to export the “Total Sales” report to CSV.
I’m running into an issue on the Sales Channel field.
Here is the script export return:
Here is the manual export return from Shopify online:
As you can see I am not seeing any other values besides “Online Store”, “Shop”, or “FERMÀT.” Well, that’s not entirely true. The other values have slight similarities or are completely absent.
Here is my query:
query GetTotalSalesReport {{
orders(first: 50{after_clause}, query: “financial_status:paid AND processed_at:>={start_date} AND processed_at:<={end_date}”) {{
edges {{
cursor
node {{
id
name
processedAt
sourceName
transactions {{
id
kind
status
}}
billingAddress {{
country
province
city
}}
shippingAddress {{
country
province
city
}}
lineItems(first: 50) {{
edges {{
node {{
product {{
productType
vendor
}}
title
variantTitle
sku
quantity
originalUnitPriceSet {{
shopMoney {{
amount
}}
}}
discountedTotalSet {{
shopMoney {{
amount
}}
}}
discountAllocations {{
allocatedAmountSet {{
shopMoney {{
amount
}}
}}
}}
refundableQuantity
}}
}}
}}
netSales: currentTotalPriceSet {{
shopMoney {{
amount
}}
}}
shipping: currentShippingPriceSet {{
shopMoney {{
amount
}}
}}
taxes: currentTotalTaxSet {{
shopMoney {{
amount
}}
}}
totalSales: currentTotalPriceSet {{
shopMoney {{
amount
}}
}}
channelInformation {{
channelId
channelDefinition {{
subChannelName
}}
app {{
id
title
}}
}}
}}
}}
pageInfo {{
hasNextPage
}}
}}
}}
Any thoughts or suggestions here would be lovely!