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
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 custom 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):
- Go to Integrations Hub > Catalog and search and select Shopify.
- Select Create. You are creating an authenticated connection.
The following dialog opens. Check Admin API access token in Shopify console for Password value.
Complete the required fields and then select Continue.
Name your new Shopify connection. Select Done.
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.
| Field | Description |
|---|---|
| Source | 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: - Objects - inventory level - inventory_items - location - Order status - open - closed - canceled - any - Metafields resource - product - customer - order - online_store - shop - Product resource objects - product - product_variant - product_image - collection - Order resource objects - order - draft_order - Online_store resource objects - blog - article - page |
| Incremental | Load data into Treasure Data incrementally. This selection enables the Incremental field**.** |
| Incremental field | The data field used to sort the objects. There are two options: created_at and updated_at. |
| Data type | The data field used to sort the metadata objects. There are two options: created_at and updated_at. |
| Start date | 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. When incremental is set to false, created_at is considered the Start date target when you import from products, customers, transactions, orders object |
| Use precise 'End date' | Specify the End dateor leave blank. |
| Number of days to fetch | Specify how many days, starting from the 'start_date,'that you want to fetch data. |
| End date | Specify a date by which objects have been updated: - If End date is not specified, all the objects up to now are retrieved. - If Start time and End time can be combined to specify a specific period, from'start_date' until 'end_date'. |
| Inventory Item IDs | A list of inventory_ids. |
| Location IDs | Alist of location_ids. |
| Updated at | 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 |
- Preview your data. To make changes, select Advanced Settings, otherwise select Next.
- Select a database and a table where you want to transfer your data.
- Specify the schedule of the data transfer using the following dialog and select Next.
- Name your source and select Done.
