Shopify Store Integration Overview

[accordions id=’9944′]

Integration workflow

Integrating your Shopify store with Sellercloud comprises 3 short procedures:

  1. Configure the API to connect to your Shopify store.
  2. Set the defaults and enable automatic controls.
  3. Required before going live: If you have listings on Shopify, import them into Sellercloud.

Follow the directions below to complete each of these required procedures.


Configuring the API to connect to your Shopify store

  1. Click Company Settings > Toolbox > Website > General.
  2. Click Edit to open the settings.
  3. In the Store Type dropdown field, choose Shopify > Save. You will return to this page later to set the defaults and controls.
    sellercloud website general settings shopify store type
  4. Click Toolbox > Website > Shopify General. This Toolbox item only appears if you selected an integrated website (for example, Shopify) in Step #2 !
    sellercloud shopify general settings
  5. Click Edit to open the settings.
  6. Copy the unique Shopify website URL from your Shopify admin portal’s Domains page, and enter it into the Website URL field. Do NOT enter the suffix “.myshopify.com” – that is already provided after the field.
  7. Ensure that Enable Shopify Locations is checked > Save.
  8. Click Action Menu > Get Token.
  9. Optional: Select Enable Fraud Check to pull in Shopify’s order Risk Analysis and place flagged orders on hold. Creating a saved search is recommended for such orders; showing these orders on your dashboard lets you easily monitor and manage these orders.
  10. Click Save.
  11. About Shopify locations, proceed as follows:
    1. If you have Shopify locationsMap them to your Sellercloud warehouses.
    2. If you do not have Shopify locationsLearn more here and then create them in Shopify (following their instructions).

Setting the defaults and automatic controls

  1. Click ToolboxWebsite > General.
  2. Click Edit to open and choose the settings > Save:
    sellercloud shopify settings
  • Website General Settings:
  • Options:
    • Enable Order Download Limit – Select if there are existing shipped orders in Shopify, and to prevent orders before that date from downloading into Sellercloud, choose an Order Download Limit Date
    • Select Allow Order Download and Allow Tracking Upload
    • Allow New Product Upload – Select this to post new products
    • Allow Inventory Upload – Select when you are ready to have Sellercloud control your inventory on Shopify. Be aware that products that are not Shopify-enabled will be updated with a quantity of zero!

Understanding the Shopify Product Import plugin

This plugin is used to import products from an Excel file that’s been exported from Shopify. The plugin will check if the WebsiteProductID and WebsiteProductVariantID match if the product exists. If the product isn’t listed and they don’t match on Shopify, the plugin will update the product with all data from Shopify.

This plugin also supports importing variations. If a matrix parent and/or child exist, the plugin will update existing products and create missing ones. If the matrix doesn’t exist, it will be created through a separate job. If a matrix parents exists without all matrix children added, it will be overwritten in a separate job.

The matrix parent will be matched by:

  • Matrix children with WebsiteProductID from the file
  • Matrix parent’s WebsiteProductID from the file and existing matrix children (that may have the same, another or no WebsiteProductID)
  • Matrix children’s ProductID from the file (regardless of the WebsiteProductID
  • Matrix parent’s ProductID (the first part of the child product IDs that is common for them)
  • If no matrix parent is matched, a new matrix parent will be created using the ProductID from step 4
For steps 1-3, if there are multiple matrix parents, the one with most children will be used. Also, the existing parent ID must be different than the matrix children IDs.

Using the plugin

  1. Click CatalogImport Product Info > Import Info via Plugin/Profile.sellercloud shopify integration import plugin
  2. In the Select Plugin field > Choose Shopify Product Import, then click the file icon to find and select the downloaded file of Shopify listing.

Importing Shopify listings

Before going live! If you have products on Shopify, you must import these listings into Sellercloud. Why? Shopify’s WebsiteProductIDVariantID must be applied to a product in Sellercloud for it to sync the inventory and price with Shopify. (When posting a new product, Sellercloud will make an API call for the “Variant ID.”)

  1. Click Toolbox > Website > Shopify General.
  2. Click Action Menu > Download Listings.
    sellercloud shopify download listings
  3. Select a date range when the products were created on Shopify > Click Download Listings.

    This produces a queued job that exports a file of all current Shopify listings with their variant IDs. Click on the job number to open the Job Details page where you monitor the job and ensure its successful completion.

    sellercloud shopify download listings date range
    sellercloud shopify download listings
  4. When the job is done, click the .xlsx file on the Job Details page to download it to your device.
  5. Click Catalog > Import Product Info > Import Info via Plugin/Profile.
  6. In the Select Plugin field > choose Shopify Product Import, then click the file icon to find and select the downloaded file of Shopify listings.
    1. If you do not see the Shopify Product Import plugin, contact Sellercloud Support to place it on your server.
  7. Click Import Products Info.
    sellercloud import shopify listings
    This creates a queued job; click on the job number to monitor it for successful completion.

Was this article helpful?

Related Articles