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.
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 products
There are three ways to download products from Shopify:
Download products manually
Download products automatically
Download products with sales
Download products manually
Go to Integrations → Shopify.
Open the Catalog.
Click Download → Products.
-
Configure you download:
Enable Download archived products to include archived Shopify products
Enable Download draft products to include draft Shopify products
Enable Enable image download to include Shopify product images.
Choose a Created or updated after date. Only products created after this date will be downloaded.
Click Load from Shopify.
Download products automatically
Configure your Shopify integration to automatically download new products and product updates:
Go to Integrations → Shopify.
Open Setup.
Enable Download products automatically.
Save.
Now, when you create or update products in Shopify, they will sync to Core automatically.
Your first automatic product download will include active products created or updated since you enabled this setting. Subsequent automatic product downloads will include active products created or updated since you last downloaded product updates. Historical product updates, as well as draft and archived products, must be downloaded manually.
Download products with sales
When you download sales orders from Shopify, any new products on sales orders will be downloaded too. Product updates don’t download with sales.
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 updates will download to Core when you download products manually or automatically. Product updates don’t download when you download sales orders. Stock levels aren’t included.
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. |
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.
Product types in Cin7 Core do not perfectly align with Shopify's physical item and quantity tracking settings. This is how Cin7 Core assigns a product type to product downloads:
| Shopify Physical item | Shopify Track quantity | Cin7 Core Product type |
|---|---|---|
| Yes | Yes | Stock |
| Yes | No | Non-inventory |
| No | Yes | Stock |
| No | No | Service* |
*Service products are added as an additional charge when downloading orders and refunds