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 in additional information into Magento, such as SEO information.
There are a few prerequisites for products to be uploaded
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.
By default Update Products is switched off; to switch it on:
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|
|tax_class_id||Defaults to 2 if taxable is set else 0|
|attribute_set||Determined by attribute set mapping|
|type||"simple" or "configurable"|
|product_websites||Defaults to "base"|
|status||Defaults to 2|
|visibility||Defaults to 4|
|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|
Cin7 can only upload products to Magento once, and changes thereafter will have to be made manually in both systems.