The Fastest Way to Import Product Categories in WooCommerce

Organizing a WooCommerce catalog around multi-level category trees usually requires building parent-child relationships by hand. When dealing with supplier feeds containing hundreds of nested subcategories, manual entry easily leads to duplicate terms and broken store navigation.

In this guide, we'll share the fastest way to import product categories in WooCommerce using automatic field mapping to detect hierarchy paths and link parent-child terms in minutes without manual spreadsheet cleanup.

What Makes Category Imports Complex in WooCommerce?

Product categories in WooCommerce are not simple text fields stored on a product row. They are WordPress taxonomy terms stored across three interconnected database tables:

• wp_terms: Stores the category name and URL-friendly slug.
• wp_term_taxonomy: Identifies the taxonomy as product_cat, tracks the term description, and records the parent ID that defines where the category sits in a hierarchy.
• wp_term_relationships: Links each product post ID to its corresponding term taxonomy IDs.

Because categories rely on this relational structure, importing them presents several challenges that basic import plugins fail to handle cleanly:

1. Inconsistent Hierarchy Formats

Distributor feeds rarely format category hierarchies the same way. A spreadsheet might deliver categories as:

• A single delimited path: e.g., Apparel > Men's > Shirts or Apparel / Men's / Shirts.
• Separate parent and child columns: e.g., Column A contains Main Category, Column B contains Subcategory, and Column C contains Tertiary Subcategory.
• Multiple category assignments: A single product might belong to several distinct categories at once, such as Shirts|Clearance|Summer Collection.

2. The Manual Admin Work

Creating nested categories by hand under Products › Categories requires adding the top-level parent first, waiting for it to save, then creating each child category and manually selecting its parent from a dropdown list. On stores with hundreds of nested subcategories, manual entry takes hours and introduces typos that create duplicate terms (such as Men's Clothing and Mens Clothing) that clutter store navigation.

3. Parent-Child Relationship Integrity

If an import tool does not parse parent-child links accurately, child subcategories import as flat, top-level categories instead of nesting under their intended parents. An effective import engine must recognize these hierarchy patterns on upload and map them to WooCommerce's taxonomy tables without requiring hours of manual spreadsheet restructuring.

How To Quickly Import WooCommerce Product Categories

WP All Import provides the fastest way to import product categories into WooCommerce by automating the three steps that usually take the most time: detecting category columns, identifying whether terms are flat or hierarchical, and mapping parent-child relationships into the database.

Here is the step-by-step workflow using Automatic Setup:

Step 1: Upload Your Product Category Spreadsheet

Navigate to All Import › New Import in the WordPress main menu.

At the very top of the screen, click the Set up automatically banner to open the automated import workflow.

Selecting Your Product Category File Source

The interface presents four file source tabs to choose from:

• Upload a file: Upload a CSV, Excel (.xlsx or .xls), or XML file directly from your computer (supports files up to 256 MB).
• Download from URL: Paste a direct link to an external distributor feed or a shareable Google Sheets link (with permissions set to "Anyone with the link can view"). The plugin fetches the file and keeps the link stored for scheduled updates.
• Existing file: Select a file that has already been uploaded to the /wp-content/uploads/wpallimport/files/ directory on your server.
• FTP/SFTP: Enter your server host, port, username, and password to download catalog files directly from an external supplier storage server.

Choosing the Import Target Post Type

Under Choose What to Import, select WooCommerce, then select Products (Simple, Variable, Grouped) if you are importing a product catalog with categories attached. (If you are importing category terms alone without products, we have that covered in a different section down below).

Providing Optional Setup Instructions

Before running the automated analysis, you can expand the Add Setup Instructions field. This allows you to give the wizard extra context about non-standard category columns in plain English. For example, you can enter instructions such as:

• "The category path uses '>' as a hierarchy delimiter"
• "Column C contains parent categories, and Column D contains subcategories"
• "Map the 'Department' column as a top-level product category"

Once your import is ready, click Start Automatic Setup. The plugin analyzes your spreadsheet content, detects category headers, and builds the database field relationships automatically.

Step 2: Verify the Mapped Product Category Fields

Once the automated analysis finishes, the screen displays the Your Import Is Ready summary card. This interface lets you review the mapped fields before anything touches your database.

The summary card shows two key metrics:

1. Total Records: Displays the total number of records that will be imported from your file.
2. Fields Mapped: Shows the exact number of database fields paired with spreadsheet columns.

Inspecting the Field Mappings List

Directly beneath the summary card, scroll through the Field Mappings list. Look specifically at the Taxonomies entry:

• It confirms which spreadsheet column was identified as the category source.
• It displays the detected category structure (such as a single category, multiple categories, or a multi-level hierarchy path).

If your spreadsheet has clean headers and standard category formatting, you can click Run Import to start importing products with categories immediately.

If your file has unusual category paths or you want to inspect how specific fields were mapped, click Manual Setup to open the pre-filled template editor.

Step 3: Preview Categories and Confirm the Import

Before writing data to your live store, WP All Import allows you to verify that your category relationships are configured accurately.

Inspecting the Live Preview

In the template editor header, click the Preview button to review your catalog across two perspectives:

• WP Admin View: Shows the backend WooCommerce product edit screen, allowing you to verify that category checkboxes are ticked in the Product categories taxonomy box.
• Frontend View: Renders an interactive live product page. You can inspect category breadcrumbs (e.g., Home / Apparel / Men's / Shirts) and click category badges to confirm that parent-child navigation displays properly.

Completing the product Import with Categories

On the same page, click Run Import. A real-time progress bar displays the number of records processed, categories created, and parent-child terms linked.

When the import completes, navigate to Products › Categories in your WordPress dashboard to confirm that your parent categories and nested subcategories display in their proper hierarchy.

How to Handle Complex Product Category Hierarchies

While Automatic Setup detects clean category columns on upload, vendor spreadsheets often present complex category structures. When spreadsheet paths use unusual separators, multiple categories per item, or separate parent and child columns, you can click Manual Import to open the pre-filled template editor.

Inside the template editor, scroll down to the Taxonomies, Categories, Tags section. Expanding this panel exposes the granular controls WP All Import uses to build category structures:

1. Enabling the Product Categories Panel

Check the Product categories box to open the configuration options. The interface gives you two top-level choices:

• Products have only one Product Category: Select this for simple catalogs where every item belongs to a single flat category.
• Products have hierarchical (parent/child) Product Categories: Select this when products belong to multi-tiered category trees (such as Sports > Golf > Clubs > Putters).

2. Choosing Your Hierarchy Layout Approach

Under the hierarchical option, the plugin provides three methods to map your spreadsheet columns to WooCommerce category trees:

Method A: An Element in My File Contains the Entire Hierarchy (Most Common)

Select this option if your spreadsheet delivers full category paths in a single cell (e.g., Apparel > Men's > Shirts).

• Drag your spreadsheet category column from the right-hand panel into the hierarchy field.
• In the delimiter field, enter the character used to separate category levels (such as >, /, or |).
• The plugin automatically splits the string at each delimiter, creates the parent categories, and nests each child subcategory underneath.

Method B: Manually Design the Hierarchy with Drag & Drop

Select this option if your spreadsheet delivers categories in separate columns (e.g., Column A is Department, Column B is Category, and Column C is Subcategory).

• Click Manually design the hierarchy with drag & drop to build a visual tree matching your spreadsheet structure.
• Drag your top-level category column into Level 1.
• Drag your second category column into Level 2, and so on.
• The plugin reads each row, associates the columns in sequence, and generates the nested taxonomy hierarchy in WooCommerce.

Method C: Mapping Rules (Translating Vendor Categories)

If your vendor spreadsheet uses category names that differ from your store’s navigation (e.g., the vendor file says Tops, but your store uses Shirts), you do not need to edit the spreadsheet in Excel:

• Expand the Mapping Rules section.
• Enter the incoming vendor category value on the left, and enter your target WooCommerce category name on the right.
• WP All Import translates the terms automatically as the import runs.

3. Handling Multiple Category Assignments

If a single product belongs to multiple independent categories (for example, a jacket listed under both Men's Apparel and Winter Clearance), you can check Products have multiple Product Categories. You can specify a secondary delimiter (such as a pipe | or comma ,) to allow the plugin to assign the product to multiple category paths simultaneously.

How to Import Standalone Product Categories (Without Products)

There are many scenarios where store owners need to build their category navigation before products arrive, such as setting up site menus, configuring SEO landing pages, or migrating taxonomy trees between stores.

You can easily import product categories directly as standalone WordPress taxonomy terms using the same WP All Import plugin:

Step 1: Start a Taxonomy Import

1. In the WordPress dashboard, go to All Import › New Import and click the Set up automatically banner.
2. Upload your category file (CSV, Excel, or XML).
3. Under Choose What to Import, select Taxonomies, then choose Product Categories from the subtype dropdown.
4. Click Start Automatic Setup.

Step 2: Configure Category Fields in the Template Editor

If you open the template editor for a standalone taxonomy import, the interface organizes fields into two primary panels:

The Name & Description Panel

• Name: Automatic Setup pairs your category name column with the Name field.
• Slug: Leave blank to let WooCommerce generate URL-friendly slugs automatically, or drag a custom slug column from your file.
• Description: Drag your category description text into the main content editor (supports HTML formatting).

The Other Category Options Panel

This panel manages the parent-child taxonomy links:

• Parent Term: To create nested subcategories, drag your parent category column into the Parent Term field. You can match parent categories by parent term name, term ID, or slug.
• Category Thumbnail: Expand the Images section to import category banner photos or thumbnail images. The plugin downloads the image from your spreadsheet URL, registers it in the Media Library, and assigns it to WooCommerce's internal thumbnail_id field.
• Display Type: Choose how the category page behaves on your storefront: Default, Products, Subcategories, or Both.

Click Confirm & Run Import to generate your complete WooCommerce product category tree in seconds.

Final Thoughts: Quickly Importing Product Categories in WooCommerce

Creating product categories manually inside the WordPress admin is slow, repetitive, and prone to formatting errors that clutter store navigation with duplicate terms.

WP All Import provides the fastest way to import product categories into WooCommerce with its Automatic Setup. It eliminates manual configuration by analyzing spreadsheet rows on upload, detecting delimiter paths, and mapping parent-child relationships automatically, turning a tedious database task into an automated workflow.

The plugin handles both full catalog spreadsheets with embedded category paths and standalone category trees built before products arrive, managing the taxonomy relationships on its own. With live frontend previews to check breadcrumbs before publishing and background batching to prevent server timeouts, it is the most dependable way to get product categories from a spreadsheet into WooCommerce quickly.

Frequently Asked Questions - Importing Product Categories in WooCommerce

Can you import parent and child subcategories from a single spreadsheet column?

Yes. WP All Import parses full hierarchical category paths from a single spreadsheet cell (such as Clothing > Men's > Shirts). In the Taxonomies, Categories, Tags panel, select the option indicating that an element contains the entire hierarchy, specify the delimiter character (such as >), and the plugin creates each parent category and nests all child subcategories underneath automatically.

How do you import product category thumbnail images in WooCommerce?

To import category thumbnail images, run a standalone taxonomy import targeting Product Categories. In the Images section of the template editor, drag the image URL column into the image field. WP All Import downloads the photo into the WordPress Media Library, generates WooCommerce thumbnail sizes, and assigns the media ID to WooCommerce's category thumbnail_id meta field.

What happens if a product belongs to multiple categories in the spreadsheet?

If a product belongs to multiple categories, separate the categories in your spreadsheet using a secondary delimiter (such as a pipe | or comma ,). In WP All Import, enable the option for multiple product categories and specify your delimiter. The plugin reads each value and assigns the product to all listed categories simultaneously during the import pass.

How do I map vendor category names to different categories in my store?

To map vendor category names without editing your spreadsheet, expand the Mapping Rules section within the Taxonomies, Categories, Tags panel. Enter the vendor's incoming category name on the left and your target WooCommerce category name on the right. WP All Import translates the values dynamically as the import executes.

Where are product categories stored in the WordPress database?

Product categories are stored across three core database tables in WordPress. Category names and slugs are stored in the wp_terms table, their taxonomy type (product_cat) and parent IDs are recorded in the wp_term_taxonomy table, and product-to-category assignments are stored in the wp_term_relationships table.

Related Information

• The Best Plugins to Import WooCommerce Product Variations
• The Best Plugins to Import WooCommerce Products from XML
• The 5 Best Plugins to Import WooCommerce Products with Images
• How to Bulk Edit Variation Prices in WooCommerce
• How to Export a Product Variation in WooCommerce