Upload products to Magento
Overview
Cin7 Omni can upload product information into Magento. As Magento has more fields than Cin7 Omni, 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 Omni 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.
Upload products
By default Update Products is switched off; to enable:
From the left navigation, select Integrations then Magento.
Click on Settings.
Check Enable Upload Products.
At the bottom of this page, click Save Settings.
To upload products:
From the left navigation, select Integrations, then Magento.
From the Product Status tile, click Upload Products.
Follow the wizard to prepare your products for upload starting with downloading and mapping attributes to options in Cin7 Omni.
You can filter products using the search box if you do not wish to upload all products.
Assign all new products to the relevant attribute set using the spreadsheet.
When products are uploaded from Cin7 Omni to Magento, the products upload as 'disabled' by default.
To download these products in a spreadsheet click Download Products. Once you have added the attribute sets, upload the spreadsheet again.
Click Upload Products to start the upload.
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 Omni.
The fields that are uploaded are detailed below.
Upload fields
Magento Field |
Cin7 Omni 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 Omni |
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 |
|
Upload barcodes
While uploading products from Cin7 Omni to Magento, you can also upload product barcodes from Cin7 Omni to Magento.
In order to do this, follow these steps:
Login to your Magento store, click on Stores>Product>Add New Attribute
Create a custom_attribute named as 'barcode' (case sensitive) on Magento
Set the 'Scope' field to 'Global'
Set the 'Values Required' to 'No', if you want to make the barcode optional
Once this barcode field is created, Cin7 Omni will upload the values in the barcode field in Cin7 Omni to the 'barcode' field on Magento when you upload products.
FAQs
I have changed product details in Cin7 Omni, can I upload this change to Magento?
Cin7 Omni can only upload products to Magento once, and changes thereafter will have to be made manually in both systems.