Download products in Shopify

Download products in Shopify

Downloading products imports product information from Shopify to Cin7 Core, to create new products, match information with existing products, or update products which already have a connection to Shopify.

This article covers downloading products from Shopify to Cin7 Core, see List products on Shopify for how to send product information in the other direction, and for instructions such as unlisting a product, unlinking a product, and changing a product link.

Prerequisites

  • You need to Connect to Shopify.

  • If it's the first time you are connecting Shopify and Cin7 Core, you should turn off Update stock levels in Shopify in your Shopify settings.

  • You need to set Master data source in your Shopify settings to Shopify or Source system.

  • You must have products already created in Shopify.

Before you download products for the first time...

You may be connecting an existing Shopify store to a new Cin7 Core account. There are some important things to be aware of when connecting your store and downloading products for the first time.

Stock quantity information always flows from Cin7 Core to Shopify, never from Shopify to Cin7 Core.

When you download products, Cin7 Core will download your product information such as SKU, name, descriptions, measurements, and more to create products or link to existing product. No stock quantities are downloaded from Shopify.

Newly created products have 0 stock quantity in Cin7 Core. If stock levels update, this can overwrite your quantities in Shopify.

We recommend you turn off Update stock levels in Shopify from your Shopify settings until you perform a stocktake in Cin7 Core and can confirm stock quantities are correct. Once you have confirmed stock levels in Cin7 Core you can safely turn on automatic stock updates.

Download or import products

Cin7 Core automatically downloads products from Shopify any time they are included in a captured sale. You can also manually download products at any time.

  1. In your Cin7 Core Shopify integration, go to the Catalog section.

  2. Click Download, then Products. This will open a pop-up window.

  3. Optionally, exclude downloading archived products, draft products, and images to increase the download speed.

  4. Click Load from Shopify to start the download process. This operation may take some time.

Cin7 Core will now start trying to match Shopify products with products already in your Core inventory like so:

  1. Cin7 Core first checks if it is a product or product family.

  2. Cin7 Core checks if there is a product or product family in Core with a matching SKU or that has been linked to this Shopify product before. By default, Core will only process the first product with a matching SKU by default, skipping duplicates. See Duplicate SKUs in Shopify for more information on this scenario.

    1. If Core finds a match, Cin7 Core updates the existing product or product family variants.

    2. If Core does not find a match, Cin7 Core creates a new product or product family with variants.

Downloading product images

Cin7 Core and Shopify usually use images in different ways. Cin7 Core images are usually smaller and used for visual identification of products to pick, while Shopify and other sales channels have larger, better quality images, to advertise the product for sale.

To make sure that the images for each platform are not accidentally altered, if Cin7 Core detects that a product in Core already has one or more images, it will not download any images from Shopify for that product. If you want to download images from Shopify, you need to remove any existing images from the product in Cin7 Core.

Update products

Product information synchronizes only when that product is manually downloaded. This is to avoid overwriting information accidentally. This operation does not update product stock quantities.

  1. In your Cin7 Core Shopify integration, go to the Catalog section.

  2. Click Download, then Products.

  3. All products that are already linked will be updated in Cin7 Core with product information from Shopify.

Products with additional units of measure

You may have products in Shopify that have multiple units of measure. For example, a canned drink could be sold as a single unit, a case of 6, and a case of 12, all sold under different SKUs.Cin7 Core uses Additional units of measure to link these SKUs and let the system recognize that they are multiples of the same item. This lets you calculate stock levels taking into account all of the different formats. For example, if you had on hand 180 single units of canned drink, your stock availability would show:

  • 180 single units available

  • 30 cases of 6 available

  • 15 cases of 12 available

When Cin7 Core downloads products from Shopify, it does not link products with additional units of measure automatically.

  • If you treat these formats interchangeably and often assemble or disassemble cases based on sales demand, you should use additional units of measure in Cin7 Core to link products after download.

  • If you only sell each SKU as a separate product without assembling or disassembling into larger or smaller units, adding additional units of measure is unnecessary.

Removing a product in Shopify

Removing a product in Shopify does not affect the product in Cin7 Core.

If automatic stock updates are enabled, attempting to update the quantity of a product deleted from Shopify will unlink the product in Cin7 Core and change its status to Not listed.

Duplicate SKUs in Shopify

In Cin7 Core, the unique identifier is the product SKU.In Shopify, the unique identifier for a product is the product Name. This can cause Shopify products with the same SKU to not be imported to Cin7 Core.

You can enable Duplicate SKUs in Shopify from your Shopify settings.

  • When this setting is enabled, Cin7 Core uses the auto-assembly feature to process duplicate SKUs from Shopify as a single product in Cin7 Core. Please see Duplicate SKUs in Shopify for detailed information including how this affects stock updates, sale orders, and catalog listings.

  • When this setting is disabled, Cin7 Core will only download the first instance of an SKU it encounters from Shopify. Other products with the same SKU will be skipped until you can change Shopify SKUs to unique values and try to download the products again.

Product field mapping

Data mapping for products between Cin7 Core and Shopify is as follows:

Cin7 Core                                                        

SHOPIFY                                                          

SKU

Listing SKU if defined, otherwise first 50 characters from combination of (Product title + Option 1 Value + Option 2 Value+ Option 3 Value)                                                                                                                     

Name

Product title + Option 1 Value + Option 2 Value + Option 3 Value

Category

Product Type

Description

HTML Product Description

Weight

Weight*

Barcode

Barcode

Price Tier. Default is Price Tier 1

Price

Images

Small product image. See Downloading product images.

Product Tags

First 256 characters of Product Tags

Option 1 Value

Option 1 Value

Option 2 Value

Option 2 Value

Option 3 Value

Option 3 Value

Variation

Variation

Brand

Vendor (Shopify will use the store name if Brand is left blank in Core)

HS code

HS (Harmonized System) code

Country of Origin (COO)

Country/Region of Origin

*Value will be passed from Shopify to Cin7 Core or vice versa with no numerical conversion if units of measure do not match. Please check units of measure match before syncing.

Was this article helpful?

Have more questions? Submit a request