• Contents

Uploading Products into Magento 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 in additional information into Magento, such as SEO information.

There are a few 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 ticked in its product details page.

We recommend that if products already exist in Magento, you first download and map products - see Downloading Products from Magento. This will avoid creating duplicate products in Magento.

The Product information to be uploaded can be determined by the Product Settings.

Uploading Products

By default Update Products is switched off; to switch it on:

  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. Navigate to your Magento module.
  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. To download these products in a spreadsheet click Download Products. Once you have added the attribute sets, upload the spreadsheet again.
  7. Click Upload Products to start the upload.
  8. 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
tax_class_id Defaults to 2 if taxable is set else 0  
name Product Name  
attribute_set Determined by attribute set mapping  
type "simple" or "configurable"  
product_websites Defaults to "base"  
status Defaults to 2  
visibility Defaults to 4  
description Description  
short_description Description  
Images Main Product Images  
cin7_import Cin7 Batch ID UTC time of update (text format)
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
price Price or Special Price (see note) This is determined by the Update Pricing settings.
special_price Special price (if applicable, otherwise blank) This is determined by the Update Pricing settings.
special_from_date Special Price Start Date  
special_to_date 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  

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.