The Shopify extractor pulls raw data from the Shopify API and extracts the following resources from a Shopify shop:
For more information you can check the documentation for tap-shopify.
In order to access your Shopify data, you will need:
The store subdomain can be derived from your Shopify admin URL.
If your admin URL starts with
https://my-first-store.myshopify.com/, your store subdomain is
First, you will need to create a Private App:
Now that your app has been created, we can acquire the password Meltano will use to authenticate with the Shopify API.
shppa_) is your API password. You can copy and paste it into the Meltano data source configuration.
This property determines how much historical data will be extracted.
Please be aware that the larger the time period and amount of data, the longer the initial extraction can be expected to take.
meltano add extractor tap-shopify
If you are successful, you should see
Added and installed extractors 'tap-shopify' in your terminal.
.envfile in a text editor
# See above for steps on how to acquire "Store Subdomain" export TAP_SHOPIFY_SHOP="my-first-store" # See above for steps on how to acquire "Private App API Password" export TAP_SHOPIFY_API_KEY="shppa_1a2b3c4d5e6f" # The date uses ISO-8601 and supports time if desired export TAP_STRIPE_START_DATE="YYYY-MM-DD"