WordPress：批量保留所有产品主分类，取消二级分类勾选

Got it, dealing with 600 products one by one is definitely not the way to go—let’s break down practical, time-saving solutions based on your e-commerce platform:

1. Use Your Platform’s Built-in Bulk Edit Tool (Most Recommended) #

Nearly all major e-commerce platforms (Shopify, WooCommerce, BigCommerce, etc.) have a bulk edit feature that lets you overwrite categories instead of adding to them. Here’s the general workflow:

• Go to your product list, select all 600 products (use the "Select All" checkbox, or filter if you need to narrow it down).
• Open the bulk edit panel—look for an option like "Bulk Actions" > "Edit" or a dedicated "Bulk Edit" button.
• Find the Categories field. Crucially, choose the "Replace" or "Set to" option (not "Add")—this will wipe existing categories and set only the one you pick.
• Select your primary category, save the changes, and you’re done.

Pro tip: Some platforms hide the "replace" option behind an "Advanced" toggle in the bulk editor, so keep an eye out for that if you don’t see it right away.

2. Export > Modify > Import (For Platforms with Limited Bulk Tools) #

If your platform’s bulk editor doesn’t support overwriting categories, a CSV export/import is a reliable fallback:

• Export your full product list as a CSV file. Look for columns labeled Categories, Category IDs, or similar (the exact name varies by platform).
• In the CSV, replace every entry in the category column with only your primary category’s name or ID (if your platform uses IDs for categories). If categories were separated by commas/semicolons, just delete all except the primary one.
• Backup the original CSV first—this is non-negotiable in case something goes wrong.
• Import the modified CSV, and make sure to select the option to "Overwrite existing products" (don’t create new ones!). Test with 1-2 products first to confirm the import works as expected before processing all 600.

3. Custom Script/API Call (For Technical Users) #

If you’re running a self-hosted store (like WooCommerce on WordPress) and have some technical know-how, a quick script can automate this:
For WooCommerce, you can use a simple PHP snippet (add it to your theme’s functions.php temporarily, or run it via WP-CLI):

// Replace with your primary category's ID
$primary_cat_id = 123;

// Fetch all published products
$products = get_posts([
    'post_type' => 'product',
    'numberposts' => -1,
    'post_status' => 'publish'
]);

// Update each product's categories to only the primary one
foreach ($products as $product) {
    wp_set_object_terms($product->ID, [$primary_cat_id], 'product_cat', false);
}

Important: Always back up your database before running custom scripts. Remove the snippet after it finishes running to avoid unintended repeats.

Critical Pre-Step #

No matter which method you choose, back up your product data first. A single misclick can mess up your categories, so having a restore point is essential.

内容的提问来源于stack exchange，提问作者Boris