> ## Documentation Index
> Fetch the complete documentation index at: https://docs.skypoint.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Shopifyimport

# 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:

* [Shopify Account](https://accounts.shopify.com/lookup?rid=b2c3149a-a288-42ff-9916-0ba6717332d0)
* URI
* API password
* API key.

<Note>
  You can refer to the Shopify Setup guide document to learn more about the Prerequisites.
</Note>

## Import Data using Shopify connector

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

The **Dataflow** window appears.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifyDataflow.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=f5dd2789fdd585ddc1a6fddf0a77a7f5" alt="Alt text" width="1911" height="346" data-path="doc_snippets/ShopifyDataflow.png" />

2. Click **New Dataflow** to create dataflow.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifyDataflowName.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=1b73173e7f98ce5f13cea3e5d1bce8db" alt="Alt text" width="680" height="430" data-path="doc_snippets/ShopifyDataflowName.png" />

3. 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.
</Note>

4. 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.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifyConnector.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=dcfa56515666141e623e12162aa3d1af" alt="Alt text" width="1353" height="787" data-path="doc_snippets/ShopifyConnector.png" />

3. Select the Shopify connector to start the configuration.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifySetDataflowName.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=4e0ee26f10c6425367cedcb2fc953d6a" alt="Alt text" width="531" height="704" data-path="doc_snippets/ShopifySetDataflowName.png" />

4. Enter the **Display Name** to identify your Dataflow.

5. In the **Description** box, you can enter an explanation of the connector.

6. Click **Next**.

<img src="https://mintcdn.com/skypoint/nPdgNYOq-2eeVuRI/doc_snippets/ConnectToShopify.png?fit=max&auto=format&n=nPdgNYOq-2eeVuRI&q=85&s=4908ae631b497c88081262fc97ae5099" alt="Alt text" width="1212" height="782" data-path="doc_snippets/ConnectToShopify.png" />

## 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**.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifyTableDetails.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=f4ba493ef0e9a52f24c4219daf693520" alt="Alt text" width="1593" height="1068" data-path="doc_snippets/ShopifyTableDetails.png" />

3. 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.
</Note>

| Item                      | Description                                                 |
| :------------------------ | :---------------------------------------------------------- |
| Purpose                   | Option to assign a purpose (Data, Metadata) for each table. |
| <center>Data</center>     | Loads customer data.                                        |
| <center>Metadata</center> | Loads Metadata.                                             |
| File Name                 | Displays the name of the file that you imported.            |
| Table Name                | Displays the imported table name.                           |

4. 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](https://skypointcdpdocs.z22.web.core.windows.net/docs/entities.html) section.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/ShopifyOutput.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=34484945488ef5f703037c3fac578ad6" alt="Alt text" width="1892" height="398" data-path="doc_snippets/ShopifyOutput.png" />

| 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, which updates each time you refresh the data. |
| Group by     | Option to view the items in a specific Group (For example, name, type, status). |

2. 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>
  In the Dataflow, you can view the error message for data import failures from the data source under **Run History** > **Description**.
</Note>

# Setup guide

## Overview

This document will help you gather all credentials for connecting [Shopify](https://accounts.shopify.com/lookup?rid=9a773bd0-16b4-425b-95d0-a6767c33b4a7) with Skypoint AI.

## Prerequisite

You require an active Shopify store and relevant [permissions](https://shopify.dev/apps/auth/admin-app-access-tokens#permissions-required-to-assign-scopes-to-a-custom-app) 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**.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Appsandsales.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=68f6480946566eda61886b52b11d7f88" alt="Alt text" width="1344" height="750" data-path="doc_snippets/Shopify_Appsandsales.png" />

3. Click **Allow custom app development**.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Allowcustomapp.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=e7a1a480254a773b1b291fe15becfc4d" alt="Alt text" width="1192" height="561" data-path="doc_snippets/Shopify_Allowcustomapp.png" />

4. Click **Create an app** to integrate your store’s data with external services or build a custom storefront.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Createanapp.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=6ac5a959a8ed5e6a9f348e6b2d192bc3" alt="Alt text" width="1012" height="742" data-path="doc_snippets/Shopify_Createanapp.png" />

5. A **Create an app** pop-up appears.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Createanappopup.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=81e379927659cb047045cd3074dfda77" alt="Alt text" width="696" height="432" data-path="doc_snippets/Shopify_Createanappopup.png" />

* Type your **App name** in the text area.
* Select the **App developer** from the drop-down list.

6. Click **Create app**.

Your app gets created.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Appcreatedoutput.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=76b582f18ec94a3d077da7d22747b71d" alt="Alt text" width="936" height="539" data-path="doc_snippets/Shopify_Appcreatedoutput.png" />

7. Click **Configure Admin API scopes**.

8. Select your preferred **Admin API access scopes**.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_AdminAPIscope.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=eb217ab34d4df388867eaa725e1e2088" alt="Alt text" width="947" height="568" data-path="doc_snippets/Shopify_AdminAPIscope.png" />

9. Configure the **Storefront API scopes**.

10. Click **Save** and then click **Install app**.

A confirmation pop-up appears.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_Installapppopup.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=d9d298da5f380fd4a3f6e80959e73853" alt="Alt text" width="611" height="241" data-path="doc_snippets/Shopify_Installapppopup.png" />

11. 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**.

<img src="https://mintcdn.com/skypoint/2X7jtvmKL6_-6PTU/doc_snippets/Shopify_APIcredentials.png?fit=max&auto=format&n=2X7jtvmKL6_-6PTU&q=85&s=ce4ff32e24930b501b5074dbc6d21de2" alt="Alt text" width="922" height="731" data-path="doc_snippets/Shopify_APIcredentials.png" />

<Note>
  You can use the Admin API access token as the API password while configuring your Shopify import connector.
</Note>

## Next step

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

# ERD

<a href="/doc_snippets/shopify_erd.png" target="_blank">
  <img alt="SHOPIFY ERD" src="https://mintcdn.com/skypoint/a9uBRLOX_0QMuhDZ/doc_snippets/shopify_erd.png?fit=max&auto=format&n=a9uBRLOX_0QMuhDZ&q=85&s=011f51a8019c73c45699b8c3e79f36e2" width="8114" height="9270" data-path="doc_snippets/shopify_erd.png" />
</a>
