Connecting to Shopify

Overview 

Shopify is an eCommerce platform for online stores and retail point-of-sale systems. You can use SkyPoint's built-in connector for importing data from Shopify. SkyPoint Modern Data Stack Platform collects, analyzes, and provides a solution to transform data into meaningful information for generating valuable insights. 

Prerequisite 

You have Shopify Account and credentials such as URI, API Password, and API key. Each API user has credentials to start the configuration.

Import Data using Shopify connector 

  1. In the left pane, go to Dataflow > Imports. 

The Dataflow window appears. 

Alt text 

  1. Click New Dataflow to create dataflow. 

Alt text 

  1. Enter a Name to identify your Dataflow.

❕ Note: Name starts with a letter.  Use letters and numbers only. No spaces between letters. 

  1. Click Next. 

Add Shopify Connector 

  1. In the All categories or Ecommerce tab, select the Shopify connector to start the configuration.  

  2. Also, you can use the Search function to find the Shopify connector. 

 

Alt text

  1. Select the Shopify connector to start the configuration.

Alt text

  1. Enter the Display Name to identify your Dataflow. 
  2. In the Description box, you can enter an explanation of the connector.  
  3. Click Next.

 

Alt text

To configure Shopify

Follow the below steps to configure the connection to Shopify:

  1. Enter your credentials such as Uniform Resource Identifier (URI), API Password, and API Key to connect with Shopify.
  2. Click Connect. 

Alt text 

  1. After configuration, you can enter the Table Details to process the data. 

❕ Note: In the Table Details column, you can mark only those fields that you want to import and process the data. 

Item  Description 
Purpose  Option to assign a purpose (Data, Metadata) for each table. 
Data
 Loads customer data. 
Metadata
 Loads Metadata. 
File Name Displays the name of the file that you imported. 
Table Name  Displays the imported table name. 
  1. Click Save to apply the changes. 

Run, edit, and delete the imported data 

  1. After saving the connection, the Shopify connector appears on the Dataflow page. Also, you can see the list of created tables in the Databases section. 

Alt text 

Item  Description 
Name  Displays the name of the Dataflow. 
Type  Displays connector type symbol. 
Status  Indicates whether the data is imported successfully. 
Tables Count  Displays the number of tables. 
Created Date  Displays date of creation. 
Updated Date  Displays last modified date. 
Last Refresh  Displays the latest refresh date. This date will get updated whenever you refresh the data. 
Group by  Option to view the items in a specific Group (For example, name, type, status). 
  1. Select the horizontal ellipsis in the Actions column and do the following: 
If you want to  Then 
Modify the Dataflow  Select Edit and modify the Dataflow. Click Save to apply your changes.
Execute the Dataflow  Select Run. 
Bring the data to its previous state  Select Rollback. 
Delete the Dataflow  Select Remove and then click the Delete button. All tables in the data source get deleted.
See the run history of the Dataflow  Select Run History. 

❕ Note: You can see the error message corresponding to failure while importing data from a data source in the Dataflow under Run history > Description.

Next step 

After completing the data import, start the Master Data Management (MDM) - Stitch process to develop a unified view of your customers.