Perfect Brands for WooCommerce - Bulk Edit, Merge, Export/Import

Perfect Brands for WooCommerce allows you to add a brand taxonomy to your WooCommerce store, and it’s a good way to classify your products and make it easy for your customers to find the perfect product for them.

However, while it is possible to edit WooCommerce brand taxonomies individually, it can be a complex and time-consuming process, particularly if you require advanced customization or need to manage a large number of brands.

That’s why, in this tutorial, we’ll show you how to bulk edit taxonomies added by the Perfect Brands for WooCommerce plugin, using a spreadsheet inside WordPress. Besides, we’ll show you how to merge Perfect Brands for WooCommerce, and how to export and import using CSV files.

We’ll do this using the WP Sheet Editor – Taxonomy Terms Pro plugin, which allows you to manage categories, tags, attributes and other custom taxonomies in a spreadsheet.

You can download the plugin here:

Download Categories, Tags, Product Attributes, Taxonomies Spreadsheet Plugin - or - Check the features

After installing and activating WP Sheet Editor – Taxonomy Terms Pro, you can proceed to bulk edit, merge, export and import Perfect Brands for WooCommerce, which we’ll show you below.

How to open the Perfect Brands for WooCommerce spreadsheet

In the wp-admin dashboard:

Go to Products > Brands.
Click on Edit in a Spreasheet.

You’ll see all the Perfect Brands for WooCommerce taxonomies displayed in the spreadsheet, which will display every brand as a field, and every field as a column.

These are the columns you’ll see:

ID – It allows you to see the brand ID.
Hierarchy – It indicates if the brand has a parent brand.
Status – Indicates if the brand is active, you can also select “delete” to remove the brand from your site.
Name – It shows you the brand title.
Slug – It display the URL slug of the brand.
Parent – It shows the parent of a specific brand; you can add the name here to add parent brands.
Count – It shows you how many products below to this brand/how many products have been assigned this brand.
Description – It allows you to add a brand description.
Taxonomy – It displays the type of taxonomy. In this case, it’s pwb-brand.
Full hierarchy – It shows you the full hierarchy schema for each brand.
Pwb Brand Banner – It shows the banner image. You can upload a new banner or select from the media library on each brand.
Pwb Brand Image – It shows the banner logo. You can upload a new logo or select from the media library on each brand.

How to upload Brand Logo and Banner in the spreadsheet

To upload a brand banner, go to the Pwb Brand Banner column, and click on the Upload button there. If you double-click the cell, you can also paste an image URL.

You can do the same to upload a brand logo, just change the column to Pwb Brand Image.

If you click on the Image button on each cell, you can view the image or logo.

Once you’re done editing the brand banner or logo, click on Save to apply the changes.

How to remove Perfect Brands for WooCommerce in bulk

If you want to bulk remove Perfect Brands for WooCommerce, you can manually select all the brands you want to remove.

Just mark them using the checkbox picker.

Now open the Bulk Edit tool and select these values to bulk delete all the selected brands:

Select the rows that you want to update: Edit the rows that I selected manually in the spreadsheet
What field do you want to edit: Status
Select type of edit: Set value
Replace existing value with this value: delete
Click on Execute Now.

How to merge duplicate Perfect Brands for WooCommerce

Sometimes, when we’re just playing with our site or testing things, we end up with duplicate taxonomies. Also, it’s possible to end up with duplicate brands when we import WooCommerce products.

As you can see in the screenshot below, we have three brands with the same name and hierarchy, so we need to merge them.

If you do this the normal way, you have to manually remove the duplicate terms and then assign the products to the remaining brands.

Fortunately, the Merge Terms tool allows us to remove all the terms with the same title and hierarchy.

And the best part is that all the products that belong to the removed brands will be automatically assigned to the remaining brand.

Just open the Merge Terms tool and select Merge all the duplicates with same name and hierarchy in the Replace these terms dropdown, and click on Execute.

How to export Perfect Brands for WooCommerce to a CSV file

WP Sheet Editor allows you to export your brands for WooCommerce to a CSV file.

Click on Export to open the export tool.

Now select these values to configure the export:

What columns do you want to export: You can select specific columns, all the active columns, or all the columns.
Which rows do you want to export: You can export all the rows, all the rows from a search, or all the manually selected rows.
What app will you use to edit this field: You can export the brands for Microsoft 365, Google Sheets, Older versions of Excel, or other spreadsheet editors.

Once you’re done, click on Start new export.