Create reports with the Data Studio connector for Shopify

[Michael_Whitak1]

Hi there,

I updated the app to use a newer API. Please let me know if you still get
that message in a few days.

Kind regards,
Michael

[fergmacdonald]

Thanks for building this. I had some discrepancies which took a little time to figure out so I'll lay out what I found to see if that helps anyone.

We have more than 1 store and are based in the UK so charge VAT.

Store A has product prices excluding tax and then tax is added on at checkout.

Store B has product prices including tax.

In Data Studio "Item Revenue" will be product prices excluding tax and shipping for store A and including tax for store B. Store B will match the 'sales' report in Shopify because the Shopify Gross Sales figure is excluding tax, but Store A will not.

You can create a 'Total Revenue' figure by creating a calculated field "Item Revenue+Shipping Cost-Total Discounts". You can create a Net Revenue figure by removing Refunds from that. However, as previous posts mention, refunds are based on the order date, not the date the refund is made. Shopify reports on the date the refund is made so the net revenue figure will not match Shopify reports.

Lastly, I'm getting an issue where time series (bar charts, line graphs) are not showing correctly. They're missing loads of data, while scorecard boxes are showing it OK.

[Michael_Whitak1]

Hi there,

Many thanks for taking the time to dig in. I don't know if there is
anything I can add, but just to let you know that I am actively updating
this free connector so if there are ideas, mistakes to fix and/or data
points that should be added, please let me know.

>From my perspective I have faced a couple of challenges:

1) Shopify is not consistent in their naming convention, so the fields in
the API do not correspond to how they name the fields in their reporting in
the admin. So we have "Total Sales" in the reporting, but "total_price" in
the API. That can be a source of inconsistencies.

2) Unfortunately Shopify does not have a "Refund API" that could be queried
by date. I can only display refunds that are attached to orders within the
report timeframe. Refunds are the biggest source of discrepancies between
the admin reports and Data Studio.

Cheers,
Michael

[fergmacdonald]

Hey, interesting, I don't have 'total sales' in my connection but I connected it a while ago. Perhaps it's been updated since then. Is there anything I'd need to do to refresh/update it?

[Michael_Whitak1]

No, it's not in there as it could indeed be calculated. According to
https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/sales-report
Total sales = Gross sales - discounts - returns + taxes + shipping charges

I can add it, but I left it out because of the potential for discrepancies
due to the returns issue.

[powerbackpack]

Hey Michael,

Fantastic application. We've been playing around with it and love it. Recently we had this error pop up:

Shopify API Connector requires your Shopify API Connector key or token in order to access your data. Do not enter your Google account information.

I think on your site the key is visible, but it's partially cut off: 

[emreisik]

Hey there, what is the key? Where can I find it?

[FergusMacdonald]

I think the key might be your example URL in the private app details that you set up in Shopify.

[emreisik]

Yup! That's it thank you! 👍🏻

[EugeniuS]

Hello,

it seems something is going wrong

How can i solve this issue?

Thanks!