WooCommerce – How to Add the 99 Cents Decimal to All Prices

In this post, we show you how to add the 99 cents decimal to all your WooCommerce product prices.

It is a generally accepted idea that the .99 decimal is magic when it comes to boosting our sales. Most businesses use this decimal during seasons like Christmas, Valentine’s Day, etc.

The problem may be that you have hundreds of products and want to add the .99 decimal to all prices. You would have to open and edit them one by one. That’s why we show you how to use a simple formula that allows you to edit all the prices and add this decimal with a few clicks.

We will do this using the WP Sheet Editor – WooCommerce Products. This plugin allows you to view and edit hundreds of products in an intuitive spreadsheet on WordPress. You don’t have to open and edit the products in the normal editor. Instead, you can filter and edit hundreds of products at once.

Once you install and activate the plugin, follow these simple steps to add the .99 decimal to all your product prices:

1- Open the WooCommerce products spreadsheet

Note: If the products spreadsheet hasn’t been set up, you can set it up following the steps in this guide.

To open the WooCommerce products spreadsheet, go to WP Sheet Editor > Edit Products. The spreadsheet will display the products as rows and the fields as columns.

2- Optional: Filter the products you will edit

WP Sheet Editor allows you to search for products by keyword, category, attribute, tag, etc. You can apply massive changes to all the search results. This is really useful if you don’t want to edit all your products.

You can open the Search tool with one click.

Once you’re in the Search tool, you’ll see these search filters:

• Contains keyword – Enter any word in this field and the plugin will find all the products containing that word in the title.
• Enter Product type, Product visibility, Product categories, Product tags, Product shipping classes, or Product attributes – You can enter any of these values to filter the products containing it.
• Search on variations – This checkbox filter the variations only.
• Enable advanced filters – This checkbox enables other filters you can use to search for your products.

Once you select the search filters, click Run Search and the products will be displayed in the spreadsheet.

For example, if you want to search for all the products within the Grosseries category, enter the category and click Run Search.

Now you can see the products filtered and displayed in the spreadsheet.

You can see the search filters you applied above the spreadsheet.

3- Add the 99 cents decimal to all the WooCommerce product prices

Whether you filter the products or not, you need to open the Bulk Edit tool with one click to add the 99 cents decimal to all the product prices.

After opening the Bulk Edit tool, you need to select the following values to add the 99 cents decimal to all your product prices:

a) Add the 99 cents decimal to the regular prices

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Regular Price
• Select type of edit: Custom Formula
• Only for advanced users: Paste the following formula in this field:

Use this formula if you use a PERIOD as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\.\d+)?/"", ""$1.99"")

Use this formula if you use a COMMA as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\,\d+)?/"", ""$1,99"")

• Select Edit only parent products
• Click Execute Now.

b) Add the 99 cents decimal to the sale prices

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Sale price
• Select type of edit: Custom Formula
• Only for advanced users: Paste the following formula in this field:

Use this formula if you use a PERIOD as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\.\d+)?/"", ""$1.99"")

Use this formula if you use a COMMA as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\,\d+)?/"", ""$1,99"")

• Select Edit only parent products
• Click Execute Now.

c) Add the 99 cents decimal to both the regular and sale prices

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Select Regular Price and Sale Price
• Select type of edit: Custom Formula
• Only for advanced users: Paste the following formula in this field:

Use this formula if you use a PERIOD as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\.\d+)?/"", ""$1.99"")

Use this formula if you use a COMMA as decimal separator:

=REPLACE(""[::regex::]/^(\d+)(\,\d+)?/"", ""$1,99"")

• Select Edit only parent products
• Click Execute Now.

This is how the regular and sale price columns look once the 99 cents decimal has been added:

Important questions

1- Can I add the 99 cents decimal to the variation prices?

Yes. You just need to select the Edit only variations option instead of the Edit only parent products option.

2- Can I add the 99 cents decimal to other types of prices?

Yes. You can apply this WP Sheet Editor custom formula to add the 99 cents decimal to other price types. For example, you can add the 99 cents decimal to country price fields created with the Price Based on Country for WooCommerce plugin.

3- Can I remove decimals from my product prices in bulk?

Yes. You can read this tutorial.

That’s really easy!

As you can see, it’s really easy to add the 99 cents to all your product prices. You don’t have to spend hours editing products individually.