Visser Labs – WooCommerce Plugins

  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. Data Exports
  5. How to export WooCommerce brands with Store Exporter Deluxe
  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. How to export WooCommerce brands with Store Exporter Deluxe

How to export WooCommerce brands with Store Exporter Deluxe

Your store might carry products from a dozen different brands, but WooCommerce has no built-in way to pull that list out as a file. If you need to hand a brand list to a supplier, check which brands actually have products attached, or back up your brand descriptions and logos before a redesign, you’re stuck copying rows by hand from Products → Brands.

Store Exporter Deluxe gives you a proper export instead. Pick the fields you want, choose a format, and download every brand on your store in one file.

This article covers a one-off Quick Export of your brands first, then how to run the same export automatically on a schedule.

Which brands does this export?

A Brands export reads one brand source:

  • WooCommerce Brands, the brands you manage in Products → Brands. This is the default.
  • YITH WooCommerce Brands Add-On. When this plugin is active, the export reads its brands instead of WooCommerce Brands.

A Brand product attribute isn’t part of the Brands export. If you store brands as an attribute, those values don’t appear in this file. For the full list of plugins Store Exporter Deluxe supports, see Store Exporter Deluxe supported plugins list.

Prerequisites

RequirementDetails
PluginStore Exporter Deluxe is installed and active
WooCommerceVersion 9.6 or later, which includes the built-in Brands feature. You can use YITH WooCommerce Brands Add-On instead.
Brand dataAt least one brand exists in Products → Brands, or in YITH WooCommerce Brands Add-On if you use it. An empty brand list has nothing to export.
Admin accessAn account that can manage WooCommerce exports. Administrators have this by default.

Where to find Quick Export

Open WooCommerce → Store Export from the WordPress admin menu. That opens the Store Exporter Deluxe dashboard.

In the sidebar, Quick Export is its own button near the top, above the EXPORTS group. Click it to start a new export.

The Select Export Type step in Quick Export with the Brands tile highlighted

Step 1: Choose the Brands export type

On the Select Export Type step, click the Brands tile. You can also get here from All Export Items, where every export type is listed with a short description.

Step 2: Pick your brand fields

On the Export Fields step, the columns you’re about to export appear as chips under Selected Fields. Brands start with five of them:

  • Term ID
  • Brand Name
  • Brand Slug
  • Brand Description
  • Count

From there you can shape the column list:

  • Click Add more fields to open the Select Export Fields popup and add anything that isn’t already a chip.
  • Click Manage Fields to open the same popup with the full list.
  • Drag a chip to change the column order in your file.
  • Click the pencil icon on a chip to rename that column heading. The underlying data stays the same.
  • Click the X on a chip to drop that column.
  • Use Reset to Default to go back to the starting five.

Available brand fields:

FieldWhat it is
Term IDThe brand term’s internal WordPress ID
Brand NameThe brand’s display name
Brand SlugThe URL-friendly version of the name
Parent Term IDThe term ID of the parent brand, for brand hierarchies
Brand DescriptionThe description text entered on the brand’s term page
Brand ImageThe brand’s image, as a URL
CountHow many products are assigned to that brand

For the full list across every export type, see Available export fields in Store Exporter Deluxe.

The Export Fields step showing the 5 default field chips and the Add more fields control

Step 3: Sort your brands

Open the Filters & Sorting step. The left panel shows “No filters available for this export type.”

Brands exports don’t have filters, so every export includes all your brands. To get a smaller list, trim the file in your spreadsheet.

Sorting does work. In the Sorting panel on the right:

  1. Pick a field in Sort by. Your options are Term ID and Brand Name, or leave it on Default order.
  2. Under Order, click Ascending or Descending. Both buttons stay greyed out until you’ve chosen a Sort by value.
The Filters and Sorting step showing the No filters available message beside the Sorting panel, with Ascending and Descending greyed out

Step 4: Set your format and run the export

  1. On the Export Options step, pick a file format. CSV suits most jobs, since nearly every spreadsheet and import tool reads it.
  2. Optional: if you saved a setup on the Export Templates screen, pick it from the Export Template dropdown. This saves you from rebuilding your field list by hand.
  3. Check the summary bar. It shows EXPORT TYPE, FIELDS, FILTERS, FORMAT, and ESTIMATED ROWS. FILTERS always reads 0 on a Brands export, because Brands exports don’t have filters.
  4. Click Run Export.
  5. In the Export in Progress window, click Download File.
The export summary bar showing Export Type Brands, 5 Fields, 0 Filters, CSV format, and estimated rows

Exporting brands on a schedule

If you need a fresh brand list every week for a supplier or a syncing tool, build it as a scheduled export instead of running Quick Export by hand each time.

  1. Go to Scheduled Exports in the EXPORTS group.
  2. Click New Schedule.
  3. Set Export Type to Brands.

The Filters step has the same Sort by options as Quick Export, and you get a full delivery setup on top: email, FTP/SFTP, Google Sheets, and more. For detailed instructions on building a schedule, see How to schedule exports in Store Exporter Deluxe.

The Export Type field on the Add New Scheduled Export General step, set to Brands

Troubleshooting

My brand list is missing rows
The Brands export reads one brand source. That is WooCommerce Brands in Products → Brands, or YITH WooCommerce Brands Add-On when that plugin is active. Brands you keep in another brands plugin, or in a Brand product attribute, don’t appear in the file. Check that the missing brand exists in the brand source the export reads.
The Count column reads 0 for a brand I know has products
Count shows how many products are assigned to that brand in the brand source the export reads. A product that has its brand set only through a Brand product attribute, or through another brands plugin, doesn’t count towards that row. Open the product and check that its brand is set in the brand source the export reads.

FAQ

Can I export only brands that have products assigned?
Not directly. There’s no filter for this on the Brands export type. Export the full list and sort or filter it in your spreadsheet, using the Count column to find the brands with zero products.
Can I filter by a date range or brand status?
No. The Brands export type has no filters in Store Exporter Deluxe, so every export includes every brand on your store. See Step 3 above for the workaround.
Which brand plugins does this work with?
WooCommerce Brands, which is built into WooCommerce, and YITH WooCommerce Brands Add-On. The export reads one of them at a time. See “Which brands does this export?” above.
Can I export brand images?
Yes. Add the Brand Image field to export the URL of each brand’s image.

Need more help?

If you’re using Store Exporter Deluxe, open a support ticket and our team will help you get your brand export working.

If you’re using the free Store Exporter plugin, ask on the WordPress.org support forum and our team will get back to you there.

Was this article helpful?

Related Articles

Resources & Help