You can use the data connector for Shopify and directly import data from your Shopify to Treasure Data.
For sample workflows on how to import data from Shopify, view Treasure Boxes.
Basic knowledge of Treasure Data
Basic knowledge of Shopify
Obtain Shopify Credentials
To get Shopify Credentials, complete the following steps:
Sign up at https://www.shopify.com/ to create an online store for the user.
Enter the details about the user.
Enter additional details about business.
Create a private app.
The user can see and use the API credentials to store and to connect with different external applications.
Shopify translates your free-form Store Name into URL-friendly value. For example, it truncates special characters and replaces spaces with hyphens.
For example: Example Shop-123-!#$ becomes example-shop-123:
You need to use the translated value (in Admin URL, after signing in):
Use the TD Console to Create Your Connection
Create a New Connection
Go to Integrations Hub > Catalog and search and select Shopify.
Select Create. You are creating an authenticated connection.
The following dialog opens.
3. Complete the required fields and then select Continue.
4. Name your new Shopify connection. Select Done.
Transfer Your Data to Treasure Data
After creating the authenticated connection, you are automatically taken to the Authentications tab.
Look for the connection you created and select New Source. Edit the following fields.
The type of object that you want to transfer from Shopify such as products, customers, transactions, orders, inventory, and metafields. The following list identifies supported elements:
|Incremental||Load data into Treasure Data incrementally. This selection enables the Incremental field.|
The data field used to sort the objects. There are two options: created_at and updated_at.
The data field used to sort the metadata objects. There are two options: created_at and updated_at.
Defining the 'start_date' allows you to select only objects that have been created or updated since the 'start_date'. This field is dependent on the Incremental field.
|Use precise 'End date'|
Specify the End date or leave blank.
|Number of days to fetch||Specify how many days, starting from the 'start_date,' that you want to fetch data.|
Specify a date by which objects have been updated:
|Inventory Item IDs||A list of inventory_ids.|
|Location IDs||A list of location_ids.|
The time in which `inventory_level` objects have been updated_at, from a specified time until present.
|Fetch all customer's metafields|
Download all customer's metafields
2. Preview your data. To make changes, select Advanced Settings, otherwise select Next.
3. Select a database and a table where you want to transfer your data.
4. Specify the schedule of the data transfer using the following dialog and select Next.
5. Name your source and select Done.