If you manage a WooCommerce store with a large product catalog, adding categories one by one is not a sustainable workflow. The fastest way to import WooCommerce product categories in bulk is to upload a CSV file using WP Sheet Editor – a plugin that handles subcategories and hierarchies automatically, unlike the native WordPress importer.
In this tutorial, you will learn the exact steps to import your full category structure from a CSV file, and how to restrict access to specific categories using Password Protect WordPress Pro and its Access Levels extension.
📋 Why Can’t You Import WooCommerce Categories with the Native WordPress Importer?
The native WordPress importer works for basic content migration, but it has significant limitations when it comes to WooCommerce product categories. It does not reliably handle subcategory hierarchies, parent-child relationships, or bulk creation from a structured CSV file. That means if you have dozens of categories with nested subcategories, the native importer is not the right tool.
WP Sheet Editor – Taxonomy Terms Pro solves this by providing a spreadsheet interface specifically designed for taxonomy terms. It reads your CSV columns, maps them to the correct WooCommerce fields, and preserves the full hierarchy on import.
🗂 How Do You Prepare a CSV File to Import WooCommerce Product Categories?
Before importing, you need a properly structured CSV file. Here’s what to include:
- name – the category name as it will appear on your site
- slug – the URL-friendly version of the name
- description – optional but recommended for SEO
- parent – the name of the parent category for subcategories
For example, if you have a category called “Session Transcripts” that belongs to a parent category called “Digital Downloads”, your CSV row would include “Digital Downloads” in the parent column. That’s how WP Sheet Editor knows to create the correct hierarchy on import.
⚙️ How to Import WooCommerce Product Categories in Bulk: Step by Step
Follow these steps to import your WooCommerce product categories using WP Sheet Editor.
Step 1. Install and activate the plugin. You need WP Sheet Editor with the Taxonomy Terms Pro version active. The free version does not support WooCommerce product categories – make sure the Pro version is active before continuing.
Step 2. Prepare your CSV file. Include category names, URL slugs, descriptions, and parent categories for each entry you want to import.
Step 3. Set up the spreadsheet. In your WordPress dashboard, go to WP Sheet Editor. On the setup screen, check Product categories and click Save.
Step 4. Configure the Columns Manager. You will see the Columns Manager screen. Enable or disable columns as needed, then click Save.
Step 5. Open the spreadsheet editor. On the top toolbar, click Import.
Step 6. Upload your CSV file. A pop-up will appear. Upload your CSV file and click Next.
Step 7. Select columns to import. Click Import all the columns to bring in everything from your file. Or select individual columns if you only need specific fields.
Step 8. Handle existing items. A dropdown will appear asking how to handle the import. Select “Import all rows as new” and click Next.
Step 9. Confirm and run the import. Review the preview table to verify your data looks correct. Click “The preview is fine, start import.” Your WooCommerce categories are now live on your site.
🔒 How Do You Password Protect WooCommerce Categories After Importing Them?
Once your categories are imported, you may want to restrict access to specific ones. That means only users with the correct password can browse those categories and their products. Here’s how it works using Password Protect WordPress Pro and its Access Levels extension.
Step 1. Go to Password Protect WordPress, then Access Levels.
Step 2. Click Add New Base. Enter a name and a description, then click Save Changes.
Step 3. Find the base you just created. In that row, click Edit Levels.
Step 4. Select the WooCommerce product categories you want to protect.
Step 5. To set different access tiers, assign your categories to specific levels. Categories at a given level are unlocked by any password assigned to that level or higher.
Step 6. Switch to the Add New Password tab and click Add Password. Enter a password, add a label, select the level, set a usage limit and expiry date if needed, then click Add New.
Once your password is configured, your selected categories are protected. Only users with that password can access them.
❓ Frequently Asked Questions
Can I import WooCommerce product categories for free?
The free version of WP Sheet Editor does not support WooCommerce product categories. You need the Taxonomy Terms Pro version to import product categories, subcategories, and hierarchies from a CSV file.
Does WP Sheet Editor preserve subcategory hierarchies on import?
Yes. If your CSV file includes a parent column with the correct parent category name, WP Sheet Editor will create the full hierarchy automatically during import.
What columns should my CSV file include for WooCommerce categories?
At minimum, include name, slug, description, and parent. The parent column is what allows WP Sheet Editor to build subcategory relationships correctly.
Can I password protect WooCommerce categories without protecting individual products?
Yes. Password Protect WordPress Pro with the Access Levels extension lets you restrict access at the category level. You assign categories to access tiers and set a password for each tier – individual products do not need to be configured separately.
What happens if I import categories that already exist in WooCommerce?
If you select “Import all rows as new” during the import process, WP Sheet Editor will create new entries regardless of existing categories. To update existing ones instead, use the “Create new items and update existing items” option and map the slug column.
Video Transcript
An easy way to import WooCommerce categories in bulk is to upload a CSV file using a plugin named WP Sheet Editor – unlike the native WordPress importer, it handles subcategories and hierarchies automatically.
Here’s the exact process.
Step 1. Install and activate the plugin. Make sure the Taxonomy Terms Pro version is active before moving to the next step.
Step 2. Start by organizing your category data in a CSV file. Include category names, URL slugs, descriptions, and images for each category you want to import.
Step 3. In your WordPress dashboard, go to WP Sheet Editor, set up a spreadsheet by checking Product categories and click Save.
Step 4. You’ll see the Columns Manager. Enable or disable columns as needed, then click Save.
Step 5. Now you’ll see the spreadsheet editor. On the top toolbar, click Import.
Step 6. A pop-up will appear. Upload your CSV file and click Next.
Step 7. Click Import all the columns to bring in everything from your file. Or select individual columns if you only need specific fields.
Step 8. A dropdown will appear asking how to handle the import. Select “Import all rows as new” and click Next.
Step 9. Click “The preview is fine, start import.”
Your WooCommerce categories are now live on your site.
If you also want to control who can see those categories, Password Protect WordPress Pro and its Access Levels extension let you restrict access by password, directly from your WordPress dashboard.
To do so, go to PPWP, then Access Levels. Click “Add New Base”. Enter a name and a description, then click Save Changes. Find the base you just created. In that row, click Edit Levels. Select the WooCommerce product categories you want to protect. To set different access tiers, assign your categories to specific levels. Categories at a given level are unlocked by any password assigned to that level or higher. Switch to the Manage Password tab and click Add Password. Enter a password, add a label, select the level, set a usage limit and expiry date if needed, then click Add New. Once your password is configured, your selected categories are protected. Only users with that password can access them.
Subscribe for more WordPress security tutorials!
