UPDATE
I’ve used the Firebear ImportExport Extension for now. That works without any problem. Its pricey but worth the money if magento cant get something “simple” like this working.
Good day,
we recently switched from Magento 2.3.x to Magento 2.4.6p2 on a fresh installation so i can rebuild our store without using old data and migrations.
I’ve created a multiselect attribute for some notes wich our supplier provides as numbers with a string as declaration.
For example:
2,97 where 2 = only suitable for xy & 97 = Not certified for ab
I’ve created the attribute and filled all the values, now its time to import. I’ve created the product import CSV and created a row with the attribute and the numbers which are also listed on admin view. The importer seems to take every entry as one so that 2,97 are one value and not seperated by the comma. I’ve also set the Multiple value separator on the importer to , but that doesnt seem to work.
Is there a work arround for that?
CSV Structure
sku;notes
KW_35290831_108031;2,97
Field separator: ;
Multiple value separator: ,
Magento Errors
Data validation failed. Please fix the following errors and upload the file again.
1. Value for 'notes' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s)
Each value is saved in the attribute but values with more than one number gets recognized as one by magento. Adding each possible value combination is no solution for the issue.