Shopify

Shopify is a cloud-based e-commerce platform that allows the setting up of an online store and the sale of products. It has a complete set of features that allow the creation and customisation of an online store, selling in multiple places, including web, mobile, social media, online marketplaces, brick-and-mortar locations, and pop-up shops, managing products, inventory, payments, and shipping.

For the API docs, please refer to the official documentation.

How to Connect

There are two ways to connect to Shopify: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Shopify button in the list of connectors or type ‘shopify’ in the search field and select it:

3. Enter the required data and click the Shopify button:

The Shopify API connector introduces a new virtual schema shopify that contains the following stored procedures:

In addition to these public API procedures, there are a couple of views in another virtual schema shopify_examples that shows an exemplary usage of the public API.

If not needed, you can delete all the example views directly by dropping shopify_examples.