How to update product attributes in nopCommerce (Step-by-Step Tutorial)

Recently, I attended nopCommerce Days 16 (nopCommerce annual conference) in Amsterdam, Netherlands and I came across a business owner who mentioned that it is not easy to update product attributes in nopCommerce. His main concern was all about the manual effort that goes into keeping the product attributes up to date for each product as there is no easy way to perform a mass update. He was one of the attendees in my workshop for store owners and I answered his question by explaining him that the latest nopCommerce 3.80 support import and export of product attributes. 

Today, I am going to demonstrate how easy it is to perform a product attributes mass update via import/export feature in the latest nopCommerce 3.80.

The latest nopCommerce 3.80 certainly makes it very easy to manage all product attributes. No more manual update is needed for each product to keep product attributes up to date. If your product attributes changes all the time, you can simply make use of the import/export feature in product catalog area (in Administration section). 

Steps / Process

In the section: Admin > Catalog > Products

I am creating / adding 2 "new" separate products in nopCommerce 3.80

1. Shoes
2. Speakers

Note: While adding / saving, I have advanced mode ON and unique SKU for each product

In both products, I have added 2 color attributes:

Product 1 : Shoes

Product 2: Speaker

After adding / saving both products, the product pages on public store looks like thos (below):

Product 1 : Shoes (on public store)

Product 2: Speaker (on public store)

Now, I am going to use "Export (selected)" option in nopCommerce and export both of these products in an Excel file.

In the exported excel sheet, simply click on the (+ sign) on the left margin to expand the attributes for each product like this:

In the exported excel sheet, I have updated the color attributes for "Produc 2: Speaker" and added a new attribute (save the excel sheet now).

Now, let's import our updated excel sheet via import option in product catalog (in Administration section):

We should see a successful import message like this (below):

After the successful import, we should see the updated attributes (with newly added 3rd attribute value) for "Product 2: Speaker".

Here is a screenshot of the product details page on public store with update product attributes:

Hence, we can see that how easy it is up perform a mass update on product attributes via import/export feature in nopCommerce. If you are a store owner and manage a list of products (and attributes) in an excel sheet, you can easily add all of your product attributes in the "nopCommerce excel import template" and keep your nopCommerce store site up to date.