• Contents

Downloading Products from Magento 2

Last updated 12/02/2021

How to download products from Magento into Cin7.

Overview


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

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

Downloading Products


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

To download products from Magento into Cin7:

  1. Log in to Cin7 using your Administrator account.
  2. From the left navigation, select Integrations and then 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 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.

Downloading Barcodes

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

To do this:

  1. Login to your Magento store, click on 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 will automatically download the values in this field on Magento to the barcode field in Cin7.

Fields Downloaded


The following product fields are downloaded from Magento:

Magento Field Cin7 Field Notes
Parent Product Id   Used for matching products between Cin7 and Magento.
Variation Product Id   Used for matching variants between Cin7 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 Magento module name.
Category 1, 2, and 3 Category 1, 2, and 3