Magento 2 – How to Import Additional Attributes and Images

importmagento2productproduct-attribute

I am trying to import csv in Magento 2. There are no errors given by Magento while importing, but column additional_attributes is totally ignored and additional_images is ignored if it contains multiple values. I used following import options:

Field divider: ,

Value divider: |

Fields enclosure: active

The csv looks like, this:

sku,additional_attributes,additional_images
123,"manufacturer=ABC,material=Wood|Metal,color=red","2.png,3.png"

Why are those values getting ignored?

Edit: If I deactivate the fields enclosure checkfield I receive the following error:

1. Value for 'manufacturer' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 1

The values equals exactly the value specified for that attribute in the backend.

SOLUTION: I replaced al the | with a , in my csv except for the additional_attributes column. During the import I used the default configuration, both delimiters as , field enclosure checkbox unchecked. Now it is working.

Best Answer

SOLUTION: I replaced all the | with a , in my csv except for the additional_attributes column. During the import I used the default configuration, both delimiters as , and field enclosure checkbox unchecked. Now it is working.

Related Solutions

Magento – Additional Attributes of current product

<?php

     (array) $excludeAttr = array();
     (array) $data = array();
        $product = $this->getProduct();
        $attributes = $product->getAttributes();
        foreach ($attributes as $attribute) {
//            if ($attribute->getIsVisibleOnFront() && $attribute->getIsUserDefined() && !in_array($attribute->getAttributeCode(), $excludeAttr)) {
            if ($attribute->getIsVisibleOnFront() && !in_array($attribute->getAttributeCode(), $excludeAttr)) {
                $value = $attribute->getFrontend()->getValue($product);

                if (!$product->hasData($attribute->getAttributeCode())) {
                    $value = Mage::helper('catalog')->__('N/A');
                } elseif ((string)$value == '') {
                    $value = Mage::helper('catalog')->__('No');
                } elseif ($attribute->getFrontendInput() == 'price' && is_string($value)) {
                    $value = Mage::app()->getStore()->convertPrice($value, true);
                }

                if (is_string($value) && strlen($value)) {
                    $data[$attribute->getAttributeCode()] = array(
                        'label' => $attribute->getStoreLabel(),
                        'value' => $value,
                        'code'  => $attribute->getAttributeCode()
                    );
                }
            }
        }

    ?>

<?php if($_additional = $data): ?>
<?php foreach ($_additional as $_data): ?>
<?php echo $_helper->productAttribute($_product, $_data['value'], $_data['code']) ?>
<?php endforeach;?>
<?php endif; echo "ssss";?>

Please try this

Magento – Magento 2 csv import : How to escape commas in additional_info

You don't need to modify any code or your import file (as provide above) to get this to work.

You can change the separator used for the 'additional_attributes' column by changing the value for the 'Multiple value separator' on the product import screen in the admin area to something other than a comma (see image below).

Please note I tested this using Magento CE 2.0.7, adding an attribute called 'magic_rules_text' and adding the same content in your original question.

I initially had the same issue when the value for 'Multiple value separator' was left at ','. I changed this to ';' and the full content imported to the attribute correctly.

Related Topic