Download products from Magento 2

Download products from Magento 2

Overview

Products can be downloaded from Magento and imported into Cin7 Omni. Any products that don't already exist in Cin7 Omni will be imported, and all products will be matched by pairing their Cin7 Omni code with the Magento SKU field.

If there are some products that you would not like to import into Cin7 Omni, these can be manually removed during the download process using a spreadsheet.

Download products

Products with slashes "/" in the SKU or name are unable to be downloaded.

To download products from Magento into Cin7 Omni:

  1. Log in to Cin7 Omni using your Administrator account.

  2. Select Integrations from the left navigation and then select Magento.

  3. From the Dashboard, on the Product Status tile, select Download Products.

  4. Select Import Products Created Since Last Import or Import All Products and then wait for the sync to be completed.

  5. On the resulting confirmation page, select Next.

  6. Note if any products that were not successfully matched, and select Next.

  7. If there are any products you do not wish to import, modify the list accordingly. select Next.

  8. Brands and product types will be created or matched. Use the drop-downs to adjust any options, then select Next.

  9. If you would like to check that the import will be completed successfully before making any real changes, select Test.

  10. Select Import New Products to complete the process.

If you wish to download barcodes from Magento, see the following Downloading Barcodes section.

Download barcodes

While downloading products from Magento into Cin7 Omni, you can also download product barcodes from Magento into Cin7 Omni.

  1. Login to your Magento store, select Stores | Product | Add New Attribute.

  2. Create a custom_attribute named as "barcode" (case sensitive) on Magento.

  3. Set Scope to "Global".

  4. Set Values Required to "No" if you want to make the barcode optional.


Once this barcode field is created, Cin7 Omni will automatically download the values in this field on Magento to the barcode field in Cin7 Omni.

Fields downloaded

The following product fields are downloaded from Magento:

Magento Field

Cin7 Omni Field

Notes

Parent Product Id  

 

Used for matching products between Cin7 Omni and Magento.

Variation Product Id

 

Used for matching variants between Cin7 Omni and Magento.

Name

Product Name

 

Description

Description

 

 

Stock Control

Defaults to "FIFO".

Parent Product Sku

Style Code

Configurable product SKU.

Sku

Price Code

Simple product SKU; limit 250 characters.

Barcode

Barcode

See above for how to download barcodes.

Price

Retail Price

 

Special Price

Special Price

 

Weight

Weight

 

Attribute Set Names

Option Label 1, 2, and 3

 

Attribute Set Values

Option 1, 2, and 3

 

 

Channels

Set to the Cin7 Omni Magento module name.

Category 1, 2, and 3

Category 1, 2, and 3 

 

Was this article helpful?

Have more questions? Submit a request