Skip to main content

Connecting to Shopify

Import data

Overview

Shopify is an eCommerce platform for online stores and retail point-of-sale systems. You can use Skypoint AI’s built-in connector for importing data from Shopify. This document will guide you through the process of connecting Shopify to Skypoint AI.

Prerequisite

You must have the following details to configure and import data using Shopify import connector: :::note You can refer to the Shopify Setup guide document to learn more about the Prerequisites. :::

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 The name must start with a letter and can only include letters and numbers, with no spaces between them. :::
  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 select only those data fields that you want to import and process. :::
ItemDescription
PurposeOption to assign a purpose (Data, Metadata) for each table.
Data
Loads customer data.
Metadata
Loads Metadata.
File NameDisplays the name of the file that you imported.
Table NameDisplays 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
ItemDescription
NameDisplays the name of the Dataflow.
TypeDisplays connector type symbol.
StatusIndicates whether the data is imported successfully.
Tables CountDisplays the number of tables.
Created DateDisplays date of creation.
Updated DateDisplays last modified date.
Last RefreshDisplays the latest refresh date, which updates each time you refresh the data.
Group byOption 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 toThen
Modify the DataflowSelect Edit and modify the Dataflow. Click Save to apply your changes.
Execute the DataflowSelect Run.
Bring the data to its previous stateSelect Rollback.
Delete the DataflowSelect Remove and then click the Delete button. All tables in the data source get deleted.
See the run history of the DataflowSelect Run History.
:::note In the Dataflow, you can view the error message for data import failures from the data source under Run History > Description. :::

Setup guide

Overview

This document will help you gather all credentials for connecting Shopify with Skypoint AI.

Prerequisite

You require an active Shopify store and relevant permissions to create a custom app as well as assign API scopes.

Enable Custom app development

Follow the below steps to enable custom app development in your Shopify admin:
  1. Go to Settings > Apps and sales channels.
  2. Click Develop apps for your store.
Alt text
  1. Click Allow custom app development.
Alt text
  1. Click Create an app to integrate your store’s data with external services or build a custom storefront.
Alt text
  1. A Create an app pop-up appears.
Alt text
  • Type your App name in the text area.
  • Select the App developer from the drop-down list.
  1. Click Create app.
Your app gets created. Alt text
  1. Click Configure Admin API scopes.
  2. Select your preferred Admin API access scopes.
Alt text
  1. Configure the Storefront API scopes.
  2. Click Save and then click Install app.
A confirmation pop-up appears. Alt text
  1. Click Install.

To find the Configuration credentials

Follow the below step to find the required credentials for configuring Shopify import connector:
  • Go to Apps and sales channels > API credentials to find the API key, API access token, and URI.
Alt text :::note You can use the Admin API access token as the API password while configuring your Shopify import connector. :::

Next step

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

ERD

SHOPIFY ERD