Rating 0 stars - 0 votes

How to bulk add & update attribute values in Magento 2

Magento attributes of multiselect and dropdown input type are widely used by store owners to represent diverse product characteristics. When these characteristics vary for certain range of merchandise within catalog, you should respectively update Magento attribute values for them or create and assign values, if they do not exist in attribute set.

Since Magento admin import is not flexible enough, store owners resort to manual product update, that is not efficient for immense product quantities, or decide this task programmatically, that is not approachable way out for ordinary users.

Store Manager for Magento includes the ability to instantly apply attribute (dropdown and multiselect) changes to numerous items at once.

How to Assign/Update Attribute Values Via Import

Magento import is undoubtedly the most convenient way to input or bulk update product attribute values. Store Manager for Magento lets you quickly assign or rewrite existing attribute value, if this is specified in the spreadsheet.

Suppose your store sells clothes. In order to provide customers more details about garments, you create dropdown attribute ‘Color’ and assign corresponding Color values to each of items. At some point you need to bulk update product attribute values for clothing garments throughout different categories at your store.

In order to update attribute value via import, you should have at least new attribute value and product identifier in the feed you’ll use for import.

Import File
How to Add/Update Magento Attribute Values for Products in Bulk

Currently our test products have ‘Navy’ value of Color attribute assigned. We are going to update Color attribute to ‘Charcoal Heather’ or ‘Black’. The sample file keeps these values as well as some extra details, like price, quantity, category. If you want to update or add other details, just store them in the same spreadsheet.

Run import wizard and proceed with configuration to successfully update attribute. Follow this step-by-step tutorial on Magento import with detailed overview of each step - How to import products in Magento 2

Assign .csv Columns to Database fields
How to Add/Update Magento Attribute Values for Products in Bulk

If attribute values, you have specified in the import file, do not exist, they will be created (assigned as options to corresponding attribute) and updated for imported products.

New values added
How to Add/Update Magento Attribute Values for Products in Bulk

Whenever your products have no attribute values specified at all, you can assign any in the same way, we have just updated. Doing it massively is always handy with import facility.

Assign/Update Attribute Values with Multi Editor

Bulk Magento attribute value update or assign can be fulfilled via Product Multi Editor. It keeps all the attributes, available in product attribute set and lets you easily reset or assign values. In this example we are going to update Manufacturer attribute of multiselect input type. Update runs in the following way:

  1. Select products, you want to assign or update Magento attribute value for in Store Manager.

  2. Activate Product Multi Editor pressing its icon on the toolbar.

  3. Open Product Multi Editor
    Open Product Multi Editor

  4. Find the attribute, value of which you want to update and expand list with all options.

  5. Select attribute value you want to assign, check ‘Update’ button for the attribute and confirm update.

  6. Assign Attributes and click on Update
    Assign Attributes and click on "Update"

Update your products massively and reset/assign necessary Magento attribute values on the fly with Store Manager for Magento.

Update Magento Attribute Values FREE Start Now

Related Articles:

add another dropdown to existing magento configurable products tutorial

Add Another Dropdown/Variant to Configurable Product

Find out how to add drop-down with configurable options and check the way to speed up the procedure. Read More...

how to include additional attributes to magento product grid article

Add Additional Attributes to Magento Product Grid

Find out how to customize Magento product grid and include a column with additional attributes. Read More...

upload magento swatch images to configurable products

Upload Magento Swatches to Configurable Products

Get the full explanation of Magento swatch images and their purpuses and find out the ways to assign them to products via admin and Store Manager. Read More...

what are magento super attributes article

What Are Magento Super Attributes and How to Add Them

Find out what Magento attributes and configurable and learn how to manage price diffirentiation of product variants using super attributes. Read More...

Be the first to comment.
Live Chat