I added Net Sales, Tax, Shipping, Discounts, Open/Closed, Active/Cancelled Orders. Just refresh the fields in the connection.
I also added refunds to the connector. Note that refunds are attached to orders. For example, if you process a refund today for an order that was placed a few days ago, and you run a Data Studio report for today, the refund will not be listed in the report.
Let me know what you think!
You can just leave the defaults and see if that works for you. The data goes straight and live from the Shopify API to Data Studio, so if you have 1000s of orders that have to be paginated through, it's possible that something will fail if the data gets too large or it takes too long.
I can add fields if they are in the Order API response.
Good luck trying it out!
|2 hours ago|
|3 hours ago|