Shopify

In this section, we present how to connect Shopify to MindsDB.

Shopify is an e-commerce platform that enables businesses to create and manage online stores. It is one of the leading e-commerce solutions, providing a wide range of tools and services to help entrepreneurs and businesses sell products and services online.

Data from Shopify can be utilized within MindsDB to train AI models and chatbots using Products, Customers and Orders data, and make predictions relevant for businesses.

Connection

The required arguments to establish a connection are as follows:

• shop_url: a required URL to your Shopify store.
• access_token: a required access token to use for authentication.

Here is how you can create a Shopify access token.

Optionally, if you want to access customer reviews, provide the following parameters:

• yotpo_app_key: a token needed to access customer reviews via the Yotpo Product Reviews app.
• yotpo_access_token: a token needed to access customer reviews via the Yotpo Product Reviews app.

If you want to query customer reviews, use the Yotpo Product Reviews app available in Shopify. Here are the steps to follow:

1. Install the Yotpo Product Reviews app for your Shopify store.
2. Generate yotpo_app_key following this instruction for retrieving your app key. Learn more about Yotpo authentication here.
3. Generate yotpo_access_token following this instruction.

To connect your Shopify account to MindsDB, you must first create a new handler instance. You can do it by the following query:

CREATE DATABASE shopify_datasource
WITH ENGINE = 'shopify',
PARAMETERS = {
  "shop_url": "your-shop-name.myshopify.com",
  "access_token": "shppa_..."
};

Usage

Once you have created the database, you can query the following tables:

• Products table
• Customers table
• Orders table
• CustomerReviews table (requires the Yotpo Product Reviews app to be installed in your Shopify account)
• InventoryLevel table
• Location table
• CarrierService table
• ShippingZone table
• SalesChannel table

Products table

You can query this table as below:

SELECT *
FROM shopify_datasource.products;

Also, you can run more advanced queries and filter products by status, like this:

SELECT id, title
FROM shopify_datasource.products
WHERE status = 'active'
ORDER BY id
LIMIT 5;

To insert new data, run the INSERT INTO statement, providing the following values: title, body_html, vendor, product_type, tags, status.

To update existing data, run the UPDATE statement.

To delete data, run the DELETE statement.

Customers table

You can query this table as below:

SELECT *
FROM shopify_datasource.customers;

To insert new data, run this statement:

INSERT INTO shopify_datasource.customers(first_name, last_name, email, phone)
VALUES ('John', 'Doe', '[e-mail]', '[phone]');

To update existing data, run the UPDATE statement.

To delete data, run the DELETE statement.

Orders table

You can query this table as below:

SELECT *
FROM shopify_datasource.orders;

To insert new data, run the INSERT INTO statement.

To update existing data, run the UPDATE statement.

To delete data, run the DELETE statement.

CustomerReviews table

You can query this table as below:

SELECT *
FROM shopify_datasource.customer_reviews;

InventoryLevel table

You can query this table as below:

SELECT *
FROM shopify_datasource.inventory_level;

Location table

You can query this table as below:

SELECT *
FROM shopify_datasource.locations;

CarrierService table

You can query this table as below:

SELECT *
FROM shopify_datasource.carrier_service;

To insert new data, run the INSERT INTO statement, providing the following values: name, callback_url, service_discovery.

To update existing data, run the UPDATE statement.

To delete data, run the DELETE statement.

ShippingZone table

You can query this table as below:

SELECT *
FROM shopify_datasource.shipping_zone;

SalesChannel table

You can query this table as below:

SELECT *
FROM shopify_datasource.sales_channel;

For more information about available actions and development plans, visit this page.