My company uses Shopify for our ecommerce business and i have to get data from Shopify and do analytics. I did a lot of search these days and i finally get some process by bringing some data from Shopify to Alteryx and I want to share the resources i use and summarize them below:
1. Shopify API documents.
It helps to understand what and how to use the API. Using API, we could get Shopify data we want.
https://shopify.dev/api
Shopify provides different types of API and what I use is Admin API and use REST.
https://shopify.dev/api/admin/rest/reference
2. Shopify Admin
After logging in to Shopify, merchants set up their store, configure settings, and manage their business using the Shopify admin. The Shopify admin includes core aspects of the merchant's Shopify business, including orders, products, and customers. Merchants also install apps in the Shopify admin. I don't need to do any set up for our Shopify store but it helps me understand i need to use Shopify admin API. What I view and manage after logging into my store are Shopify admin pages.
3. Shopify private app and authentication:
A Shopify app extends the existing functionality of Shopify. Most Shopify apps are built by third-party developers, not by Shopify.
You can build an app to add features to Shopify stores and extend the merchant experience, or to create unique buying experiences for customers. You can also pull Shopify store data into your app, platform, or integration. To tailor experiences to their specific needs, merchants use Shopify apps to help build their business, integrate with external services, and add features to their Shopify admin.
I created a private app and use basic HTTP authentication to get my Shopify data.
You could find the instruction how to create a private app and how to use basic HTTP authentication from
Basic HTTP authentication
The authentication way works for me in Alteryx is the base64 representation, the resource i learnt how to use it and connect is from accepted solution of:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/oAuth-library-or-solution-for-use-in-A...
The post attached a workflow to introduce how to get products information from Shopify in Alteryx.
4. How to get all orders from Shopify example(Python):
It is a good example for me to understand the process and it is connected in Python not Alteryx.
https://towardsdatascience.com/how-to-get-all-orders-from-shopify-69db163c7a2d
5. Download tool detailed introduction:
It helps me understand how to use Download tool when we need to connect Shopify store successfully in Alteryx
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connecto...
6. Download and Parse Json
When we connect Shopify with Alteryx successfully, data we got from Shopify is Json. We need to parse json in Alteryx.
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-7-Download-Data-and-Parse-JSON/td-p/3673...
Convert Shopify complex json into table:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-shopify-complex-json-into-tabl...
Parse Nested JSON (Product ) from shopify:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parse-Nested-JSON-Product-from-shopify...
Please feel free to add your resources help you and any feedbacks are welcomed!
