• Contents

Uploading Products into Magento 2.0 from Cin7

Last updated 12/02/2021

How to upload products from Cin7 into Magento.

Overview


Cin7 can upload product information into Magento. As Magento has more fields than Cin7, after uploading you'll need to add additional information into Magento such as SEO information.

The following are prerequisites for products to be uploaded:

  • The product in Cin7 has not already been matched to an existing product in Magento.
  • The product has the Magento channel selected in its product details page.

It is recommended that if products already exist in Magento, you first download and map products to help avoid creating duplicate products in Magento. See the Downloading Products from Magento Help article for additional information.

What Product information is uploaded can be determined by the Product Settings.

Uploading Products


By default Update Products is switched off; to enable:

  1. From the left navigation, select Integrations then Magento.
  2. Click on Settings.
  3. Check Enable Upload Products.
  4. At the bottom of this page, click Save Settings.

To upload products:

  1. From the left navigation, select Integrations, then Magento.
  2. From the Product Status tile, click Upload Products.
  3. Follow the wizard to prepare your products for upload starting with downloading and mapping attributes to options in Cin7.
  4. You can filter products using the search box if you do not wish to upload all products.
  5. Assign all new products to the relevant attribute set using the spreadsheet.
  6. When products are uploaded from Cin7 to Magento, the products upload as 'disabled' by default.
  7. To download these products in a spreadsheet click Download Products. Once you have added the attribute sets, upload the spreadsheet again.
  8. Click Upload Products to start the upload.
  9. Some products may have invalid attribute or attribute set mapping. You will be presented with a list of these errors and you will need to correct them before uploading again. These errors may be caused by missing options for a mapped attribute or missing attributes which are required for the assigned attribute set. You will need to fix this either by re-uploading the corrected product mapping spreadsheet, correcting the Map Attribute Sets section of the wizard, or by editing the product details in Cin7.

The fields that are uploaded are detailed below.

Uploaded Fields


Magento Field Cin7 Field Notes
Product Details
isConfigurable If there are multiple options then 1 else 0  
taxable Defaults to 1 If the product is set to an exempt, tax free, or zero rated then this field will be 0
name Product Name  
attribute_set_id Determined by attribute set mapping  
type_id "simple" or "configurable"  
status Defaults to 2  
visibility Defaults to 4  
description Description  
short_description Description  
Images Main Product Images  
Product Option Details
attributes    Attributes are set based on the Attribute Sets and Attributes mapped in the wizard steps
sku Code/SKU/Style Code For simple products this will be the Style Code in Cin7
Barcode Barcode Refer uploading barcodes section below for more details
Price Price or Special Price (see note) This is determined by the Update Pricing settings.
salePrice Special price (if applicable, otherwise blank) This is determined by the Update Pricing settings.
salePriceDatesFrom Special Price Start Date  
salePriceDatesTo Start Date plus number of days  
qty   The number of items in stock, determined by the stock settings.
weight  Weight of the product or variant  
Image Option Images  

Uploading Barcodes


While uploading products from Cin7 to Magento, you can also upload product barcodes from Cin7 to Magento.

In order to do this, follow these steps:

  1. Login to your Magento store, click on Stores>Product>Add New Attribute 
  2. Create a custom_attribute named as 'barcode' (case sensitive) on Magento
  3. Set the 'Scope' field to 'Global'
  4. Set the 'Values Required' to 'No', if you want to make the barcode optional

Once this barcode field is created, Cin7 will upload the values in the barcode field in Cin7 to the 'barcode' field on Magento when you upload products.

FAQs

I have changed product details in Cin7, can I upload this change to Magento?

Cin7 can only upload products to Magento once, and changes thereafter will have to be made manually in both systems.