Background
Shopify is a Canadian e-commerce company headquartered in Ottawa, Ontario, that develops computer software for online stores and retail point-of-sale systems.
Source Wikipedia
In this article, we will demonstrate how easy it is to extract and manipulate Shopify data.
Preparation
1) Create Shopify account at www.shopify.com
2 ) Log in
3 ) Click apps
4) Click Private Apps
5) Create new Private App
6) Note API key and passport we will need them later
Python
1) Download and install python 2.7 version 32 bit for 32-bit version or 64 bit for 64-bit version of ETL software.
https://www.python.org/downloads/release/python-2712/
2) Once installed run the following command from the command line
python.exe pip install requests
That will install requests python package
Extracting Data
We now ready to extract the data.
Run Advanced ETL Processor Enterprise
Create a new package, add Script Action and make sure that language used is set Python
Enter this code, do not forget to replace SHOPNAME, KEY and PASSWORD
import requests
response = requests.get( "https://SHOPNAME.myshopify.com/admin/orders.xml",
auth=("KEY","PASSWORD"))
file = open("orders.xml", "w")
file.write(response.text)
file.close()
Data can be extracted as XML or as JSON, just replace file extension XML with JSON. Once data is saved on the local drive it can be loaded into the database
More information about Shopify API can be found here
https://help.shopify.com/api/reference/order
