WooCommerce has no native way to bulk edit product descriptions. To update descriptions across dozens or thousands of products at once, you need a spreadsheet-style bulk editor like WP Sheet Editor, which lets you set, append, prepend, replace, or remove text across your entire catalog in a few clicks instead of opening every product individually.
This guide walks through the setup and every common bulk-editing scenario: filling in missing descriptions, personalizing them with product names, adding text to the start or end, removing unwanted text, and replacing outdated wording.
How to Set Up WP Sheet Editor for Bulk Editing
WP Sheet Editor turns your product catalog into an editable spreadsheet, so every bulk operation below starts from the same setup.
Step 1: Install and activate the plugin
Go to Plugins > Add New Plugin in your WordPress dashboard and search for WP Sheet Editor, or purchase and upload it directly from the official site. Click Install, then Activate.
Step 2: Open the product spreadsheet
Go to WP Sheet Editor > Edit Products. You’ll see every product listed as a row, with columns for ID, Title, Content (this is the description field), Stock, and other product data.
Pricing note: WP Sheet Editor is a paid plugin. Pricing starts from around $99.98/year for a single site at the time of writing. Check the official pricing page before publishing, since plans and promotions change.
How to Bulk Set Descriptions for Products With No Content
Products with a blank description field are the easiest starting point, since you can fill them all at once with a placeholder or general description.
Step 1: Filter products with no description
Open the Search tool, enable Advanced Filters, and set:
- Field: Content
- Operator: =
- Value: leave empty
Click Run Search. This returns every product with an empty description.
Step 2: Set a description for all filtered products
Switch to the Bulk Edit tab and set:
- Select the rows to update: Edit all the rows from my current search (including non-visible rows)
- Field to update: Content
- Type of edit: Set value
- Replace existing value with this value: your general description
Click Execute now. Every filtered product gets the same base description. You can personalize each one further using the method below.
How to Personalize Descriptions With Each Product’s Name
A shared description across similar products (same category, different color or size) reads as generic. Inserting the product name automatically makes each one feel specific without manual editing.
Step 1: Set up the bulk edit
Go to the Bulk Edit tab and set:
- Select the rows to update: Edit all the rows from my current search (including non-visible rows)
- Field to update: Content
- Type of edit: Set value
- Description box: your desired description, with
$post_title$inserted wherever you want the product name to appear
Step 2: Execute the update
Click “I have a database backup, Execute now” to apply the change. Every product description now includes its own name automatically.
How to Bulk Append Text to Product Descriptions
Appending text adds a fixed message to the end of the description field. This works well for calls to action, disclosures, and affiliate links that need to appear across many products without changing the rest of the content.
Add a call-to-action to the end of descriptions
Search for a keyword that identifies the target products (for example, “fashion” in the title or description), then open Bulk Edit and set the same fields as above, with Type of edit set to Append and your call-to-action text entered.
Tip: Add a symbol like $, #, or @, or a blank space, before the appended text. WP Sheet Editor inserts the text exactly as typed, so a separator keeps it visually distinct from the existing description.
Add a disclosure to promotional products
Filter products by category (for example, “promotional products”) using the Search tool, then run the same Bulk Edit append process with your disclosure text.
Add an affiliate link to a specific brand’s products
Create a custom attribute (for example, “Product Brand”) to filter by brand:
- Enable advanced filters
- Field: Product Brand
- Operator: =
- Value: the brand name
Click Run search, then run the Bulk Edit append process with the affiliate link.
How to Bulk Prepend Text to Product Descriptions
Prepending adds text to the beginning of the description, which is useful for information buyers should see before anything else, such as stock status or category.
Prepend stock status
Filter for the relevant products in the Search tab, then in Bulk Edit set Type of edit to Prepend and enter your stock status text, wrapped in a symbol or spacing to separate it from the rest of the description.
Prepend the product category
Filter your target products, then in Bulk Edit set Type of edit to Prepend and enter $product_cat$ as the value. This inserts each product’s category automatically at the start of its description.
How to Remove Text From Product Descriptions
Removing text is useful for shortening long descriptions or cutting outdated content without rewriting each one manually.
Remove everything after a specific phrase
In Bulk Edit, set:
- Field to update: Content
- Type of edit: Remove everything after some text
- Remove everything after this text: the phrase to cut from
- Remove the text too: choose whether to keep or delete that phrase itself
Remove everything before a specific phrase
Same process, with Type of edit set to Remove everything before some text.
Shorten descriptions to a maximum word count
Select the specific products you want to shorten in the spreadsheet, then in Bulk Edit set:
- Select the rows to update: Edit the rows selected manually in the spreadsheet
- Type of edit: Generate excerpt
- Maximum number of words: your target length
This adds an ellipsis at the end to show the description was cut. Review a sample of the results afterward. Automatic shortening can cut a sentence mid-thought.
How to Replace Text in Product Descriptions
Replacing swaps old wording for new without touching the rest of the description, which is faster than a rewrite when you’re updating a single word, symbol, or phrase across many products.
Replace a single word
In Bulk Edit, set Type of edit to Replace, enter the word to replace in “Replace this,” and the new word in “With this.”
Replace a character or symbol
Same process, using a character or symbol in place of a word.
Replace a full phrase
Same process, using a full phrase (for example, swapping a seasonal promotion for a new one) in both fields.
Bulk Edit Product Variations and Short Descriptions
The steps above apply to the main Content field, but two related cases come up often enough to call out directly.
Variations: if your products use variations (size, color, and so on), each variation can carry its own description field. Filter by variation-level fields in the Search tool the same way you would for a parent product, then apply the same Set, Append, Prepend, Replace, or Remove operations in Bulk Edit.
Short descriptions: the short description is a separate field from the main content. To copy your long description into the short description field (or the reverse), use the Bulk Edit tab and set the source field’s value as the “Set value” input for the target field.
Best WooCommerce Bulk Edit Plugin: WP Sheet Editor
WP Sheet Editor is the tool used throughout this guide because it edits products in a spreadsheet interface rather than one product page at a time, with filtering, CSV import and export, and an undo option if a bulk change needs to be reverted.
Key Features
- Spreadsheet view: Edit hundreds of products directly in a grid, without opening individual product pages.
- Advanced filtering: Target products by any field or custom attribute before running a bulk edit.
- CSV import and export: Bring in descriptions from an external file or export your catalog for backup.
- Merge tags: Insert product name or category automatically using
$post_title$and$product_cat$. - Revert option: Undo a bulk edit if the result isn’t what you expected.
Managing Product Feeds Alongside Descriptions
Bulk-editing content is one part of running a large WooCommerce catalog. If you’re also managing product data across multiple sales channels (Google Shopping, Facebook, and similar), that’s a separate task WP Sheet Editor doesn’t handle. CTX Feed is built for that: it’s a free WooCommerce plugin with 80,000+ active installations that generates and auto-updates product feeds for 220+ shopping and marketplace channels. It’s worth mentioning here only because store owners doing bulk description work are often the same people managing feeds, not because it replaces the bulk-edit workflow above.
Frequently Asked Questions
How do I update product information in bulk in WooCommerce?
Use a bulk-edit plugin like WP Sheet Editor, which displays your products in a spreadsheet. Filter the products you want to change using the Search tool, then use the Bulk Edit tab to set, append, prepend, replace, or remove content across all filtered products at once.
Can I bulk edit WooCommerce product descriptions for free?
Not with WP Sheet Editor. It’s a premium plugin, with pricing starting from around $99.98/year for one site at the time of writing. Check the official pricing page for current plans before deciding.
Can I bulk edit variation descriptions, not just the main product description?
Yes. Variations have their own description field. Filter by variation-level fields in the Search tool, then apply the same bulk-edit operations (set, append, prepend, replace, remove) used for main product descriptions.
Can I copy a product’s long description into its short description field?
Yes. In the Bulk Edit tab, set the value you want to copy as the “Set value” input for the short description field, applied across your filtered product set.
Key Takeaways
- WooCommerce has no built-in bulk-edit feature for product descriptions, so a spreadsheet-style plugin like WP Sheet Editor is required for catalog-wide changes.
- The Search tool’s advanced filters let you target exactly which products a bulk edit applies to, by content, category, or a custom attribute.
- Merge tags like
$post_title$and$product_cat$let you personalize descriptions automatically instead of writing one for every product. - Append, prepend, replace, and remove operations cover most real-world editing needs: adding a CTA, inserting stock status, swapping outdated wording, or shortening long descriptions.
- Variation descriptions and short descriptions use the same bulk-edit workflow as the main content field.
- WP Sheet Editor is a paid plugin; verify current pricing before publishing anything with a specific figure.
Free version on WordPress.org. Every Pro licence includes a 30-day money-back guarantee.
