Applying a discount to your WooCommerce products is only the first step of a successful sale. To drive conversions, you need to actively promote those discounts so customers recognize the value immediately while browsing your store.
Natively, WooCommerce requires you to open each product individually to add promotional text to titles, update descriptions, or mark items as “Featured” in your catalog. If you are running a store-wide sale with hundreds of discounted items, manual updates are not a practical option.
In this tutorial, we will show you how to identify all active discounts in your catalog and bulk promote them using a spreadsheet interface. We will cover how to append promotional text to product titles, update your descriptions in bulk, and automatically push sale items to your featured catalog.
We will use the WP Sheet Editor – WooCommerce Products Spreadsheet plugin to execute these changes without writing custom code or running complex SQL queries.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Video Tutorial
Open the WooCommerce Products Spreadsheet
Once you have installed and activated WP Sheet Editor, navigate to WP Sheet Editor > Edit products in your WordPress dashboard.
You will see your entire WooCommerce catalog displayed in a continuous grid, allowing you to view and edit all product data from a single screen.
1. Append “On Sale” to Product Titles in Bulk
Adding a clear indicator like “On Sale!” or “20% OFF” directly to your product titles ensures that customers see the promotion immediately, regardless of where the product appears on your site or in search engine results.
a) Open the Bulk Edit tool
Click on the Bulk Edit tool located on the top toolbar. This tool allows you to apply modifications to massive groups of products simultaneously.
b) Filter your discounted products
Before applying the text, you must isolate the products that currently have an active sale price.
In the Bulk Edit window, select I want to search rows to update from the first dropdown menu.
Tick the Enable advanced filters checkbox and configure the search parameters to find items with a sale price greater than zero:
- Field key: Sale Price
- Operator: >
- Value: 0
Click on Run search to filter your catalog.
c) Append the message to product titles
Once the search is complete, you will be returned to the Bulk Edit configuration. Set the following values to add your promotional text:
- What field do you want to edit: Title
- Select the type of edit: Append
- Enter the value to append to the existing value: Add a space, followed by your message (e.g.,
- On sale!). The space prevents the text from merging directly into the last word of your title.
Click on Execute now.
2. Append Promotional Messages to Product Descriptions
You can use the exact same workflow to add promotional details—such as return policies, limited-time urgency, or coupon codes—directly to your main product descriptions.
a) Open the Bulk Edit tool
Click the Bulk Edit tool on the toolbar.
b) Filter your discounted products
Select I want to search rows to update.
Apply the same advanced filter to target your active sales:
- Field key: Sale Price
- Operator: >
- Value: 0
Click Run search.
c) Append the message to product descriptions
Configure the Bulk Edit tool to update the description field:
- What field do you want to edit: Descriptions
- Select the type of edit: Append
- Enter the value to append to the existing value: Type your promotional paragraph or note (e.g.,
This product is on sale! Limited stock available.).
Click on Execute now.
3. Feature Discounted Products in the Catalog
WooCommerce includes a native “Featured” status, which many themes use to display products in dedicated homepage sliders, sidebars, or priority catalog sections. Bulk enabling this status for your discounted items is highly recommended for visibility.
a) Open the Bulk Edit tool
Open the Bulk Edit tool.
b) Filter your discounted products
Select I want to search rows to update.
Filter for your discounted items one final time:
- Field key: Sale Price
- Operator: >
- Value: 0
Click Run search.
c) Mark the filtered products as Featured
To enable the featured star for all these products simultaneously, use these settings:
- What field do you want to edit: Is featured?
- Select the type of edit: Set value
- Replace existing value with this value: Tick the checkbox (which translates to ‘Yes’).
Click on Execute now.
Implementation Notes
These three workflows provide a reliable framework to ensure your discounts gain maximum visibility across your store. By utilizing WP Sheet Editor to manage these changes in bulk, you avoid repetitive manual data entry and maintain a synchronized promotional strategy across your entire WooCommerce catalog.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features