Import additional select, multi-select attributes with Product CSV in Magento 2 using adding additional_attributes column.
Create a CSV file with the first column is the sku and the second column will be additional_attributes.
You must add a multi-select attribute value with the pipe separator.
Let’s take a Material Multi-select attribute from the Magento opensource Sample data,
Attribute code is material and value we want to set as,
Wool, Canvas, and Burlap.
Column value will be material=Wool|Canvas|Burlap with each value separated as Pipe Separator ( | ).
You don’t need to add any single or double quotes for the value. The value will be plain without a quote.
if you want to add a single value, no need to add a pipe separator.
You can also add multiple attributes using the additional_attributes column with comma-separated each attribute.
Like, material and color attribute.
activity=Running,material=Wool|Canvas|Burlap,color=Red
Your Final CSV will look like,
sku,additional_attributes 24-MB01,activity=Running,material=Wool|Canvas|Burlap,color=Red
You need to import CSV from the Admin Panel,
- System -> Import
- Choose Product from the Entity Type Dropdown.
- Select your CSV with Add/Update Import Behavior.
Check the Product from the Backend with the updated value.
Read Simple Product import, Simple Product Import