Last updated 12/02/2021
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:
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.
By default Update Products is switched off; to enable:
To upload products:
The fields that are uploaded are detailed below.
|Magento Field||Cin7 Field||Notes|
|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|
|attribute_set_id||Determined by attribute set mapping|
|type_id||"simple" or "configurable"|
|status||Defaults to 2|
|visibility||Defaults to 4|
|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|
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:
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.
Cin7 can only upload products to Magento once, and changes thereafter will have to be made manually in both systems.