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 every brand source on your store at the same time:

  • WooCommerce Brands, the brands you manage in Products → Brands.
  • Perfect WooCommerce Brands, when that plugin is active.
  • YITH WooCommerce Brands Add-On, when that plugin is active.

If you use more than one of these, every brand from each source gets its own row in the same file. The Brand Taxonomy column, which is in the default field list, shows which source each row came from. That’s handy when two sources have a brand with the same name.

One more source can show up. If your store has a global product attribute with the slug brand (in Products → Attributes), its values are exported as brand rows too. In the Brand Taxonomy column, those rows read pa_brand, so you can find them and remove them in your spreadsheet if you don’t need them.

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 also use Perfect WooCommerce Brands or YITH WooCommerce Brands Add-On, on their own or together with it.
Brand dataAt least one brand exists in Products → Brands, or in the brands plugin you use. 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 six of them:

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

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 six.

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
Brand TaxonomyWhich brand source the row came from: product_brand (WooCommerce Brands), pwb-brand (Perfect WooCommerce Brands), yith_product_brand (YITH WooCommerce Brands Add-On), or pa_brand (a global Brand attribute)

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

The Export Fields step for Brands showing the 6 default field chips (Term ID, Brand Name, Brand Slug, Brand Description, Count, Brand Taxonomy) and the Add more fields control

Step 3: Check the filters and sort order

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.

Your brands export in alphabetical order by Brand Name, A to Z. If you need a different order, sort the file in your spreadsheet. Leave Sort by on Default order, then click Continue to move on.

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, 6 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.

A scheduled Brands export uses the same alphabetical order as Quick Export, and you get a full delivery setup on top: email, FTP/SFTP, POST to URL, 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
Check that the missing brand exists in one of the brand sources the export reads: WooCommerce Brands in Products → Brands, Perfect WooCommerce Brands, or YITH WooCommerce Brands Add-On. Brands kept in any other brands plugin don’t appear in the file. Remember the export is sorted by Brand Name, so a brand from a second source can sit further down the file than you expect.
The Count column reads 0 for a brand I know has products
Check the Brand Taxonomy column to see which source that row came from. Count only counts products assigned to the brand in that same source. If you use two brand sources, the same brand name can appear twice, and only one of those rows has your products. Open the product and check which brand source its brand is set in.

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, Perfect WooCommerce Brands, and YITH WooCommerce Brands Add-On. If you use more than one, the export includes the brands from all of them. 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