3

I am working on magento 2.1.3

I was trying to import product with multiple option attribute.

Eg : Attribute name : tv_features

values are : TV Monitor,Smart TV,UHD TV,3D TV

How can i represent multiple option attribute in additional_attributes column..??

Eg : has_options=0,quantity_and_stock_status=In Stock,required_options=0,brand_name=LG,tv_screen_type=LED,tv_screen_size=65",tv_features=Smart TV,UHD TV,3D TV, tv_hdmi_ports=3, tv_usb_ports=3

Improve this question
3
  • Are you want to import multiple select value attribute?
    – Rakesh Jesadiya
    Commented Feb 22, 2017 at 5:02
  • Yes correct.. I want to import multiple value attribute
    – Sudheesh K Surendran
    Commented Feb 22, 2017 at 5:05
  • I am still facing this issue on a M2 2.4.2 installation. found a valid solution ?
    – Gustavo Ulyssea
    Commented Aug 6, 2022 at 0:35

1 Answer 1

Reset to default
8

You have to use PIPE(|) separator for multiple select attribute value.

ex.

tv_features=Smart TV|UHD TV|3D TV

Using Pipe separator you can import your multiple select attribute value in magento 2.

Improve this answer
3
  • but it is not working, I am also using pipeline separator
    – Jaisa
    Commented Jul 22, 2020 at 17:54
  • Pipe did not work for me - the system did not seperate the values by the pipe, instead it added new attributes to the system like: "Smart TV|UHD TV|3D TV". Comma seperated also did not work as I get the infamous "column contains an incorrect value". I think it is fair to say at this point I dislike Magento.
    – Mark
    Commented Apr 7, 2021 at 9:54
  • Does not work for me
    – Gustavo Ulyssea
    Commented Aug 6, 2022 at 0:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.