Shopify

Shopify is an e-commerce platform that allows anyone to sell online, at their retail location and everywhere in between.

Data integration: Skyvia supports importing data to and from Shopify, exporting Shopify data to CSV files, replicating Shopify data to relational databases, and synchronizing Shopify data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Shopify backup.

Query: Skyvia Query supports Shopify.

Shopify-Specific Features and Limitations

Skyvia has the following limitations for Shopify:

  • Some of the Shopify objects can be accessed only via their parent objects. For example, to query CustomerAddresses, Shopify API requires the ID of the corresponding Customer. To get ProductVariants records, Shopify API requires the ID of the corresponding Product.

    Skyvia does not require the ID of the parent object from user. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes much time and consumes many API calls. It uses at least one API call for every parent object record (for example, product). Thus, working with ProductVariants can be very slow.

    Because of this, it is strongly recommended to use filters on the parent object fields when querying data from such child objects. This reduces the number of parent object records, for which child object data must be queried.

  • Some of the Shopify tables can store complex structured data. Skyvia represents this information in such tables as a JSON field Lines. You can Import data directly to the nested fields of such tables. To do this you can use our Nested Objects mapping feature in Import packages. Just select the Nested Objects checkbox in the package to enable the feature. Then, in the mapping settings, you can map the fields of the nested items.

Shopify Connections

When creating a Shopify connection, you simply log in with Shopify. The OAuth authentication token is stored on the Skyvia server. Your Shopify account login and password are not stored on the Skyvia server.

To create a Shopify connection, perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, click Shopify.
  4. In the Connection Editor page, specify a connection name that will be used to identify the connection.

  5. Specify your Shopify Store. You need to specify the full domain name, not just the store part of it: mystore-300.myshopify.com or https://mystore-300.myshopify.com

    Connection Editor window

  6. Click Sign In with Shopify.

  7. In the opened window, enter your email and click the Next button.

    MyStore window 1

  8. Afterwards, enter your password and click the Log in button.

    MyStore window 2

  9. To get started, you will need to verify your email. Click the Verify email address button.

    MyStore window 2

  10. Follow the link sent to your mailbox.

  11. Click it and wait until the necessary data are transmitted.
  12. Click Create Connection to create the connection.

Supported Actions and Actions Specifics

Shopify connector supports the following actions: