Price format correction

Hi @raunharmantech,

Thanks for clearly outlining what’s happening here, I can see how the extra trailing zeros in prices like x.00000 would incorrectly flag products as “On Sale”, especially when there’s no actual sale price set. That can definitely cause confusion across your catalog, so let’s work through a scalable way to fix this.

From what you’ve described, this is likely happening because WooCommerce treats even slight differences between regular price and sale price values as a valid sale condition. So entries like 100 vs 100.00000 can unintentionally trigger the “On Sale” status.

Since you have many products and are using WPML, the best approach would be to correct this in bulk rather than manually editing each product. Here are a few options you can consider:

1. Bulk edit via CSV export and import
   You can export your products, clean up the price formatting, and re-import:
   • Go to Products → Export
   • Open the CSV file and normalize the Regular price and Sale price columns by removing unnecessary decimal zeros
   • Re-import via Products → Import
   Guide here: https://woocommerce.com/document/product-csv-importer-exporter/
2. Database-level update (advanced option)
   If you’re comfortable working with the database or have developer support, you can run a query to normalize price meta values in bulk. This is faster but should be done with a backup in place.
3. WPML consideration
   Since you’re using WPML, ensure that:
   • Price fields are synchronized across translations
   • After cleanup, run WPML troubleshooting tools to sync product data across languages
   WPML guide: https://wpml.org/documentation/getting-started-guide/
4. Double-check for hidden sale prices
   Some products might still have a sale_price meta value stored even if not visible in the UI. Bulk cleanup should ensure both regular and sale prices match correctly or remove unintended sale values.

If you’d like, you can share a sample of your product export via https://pastebin.com or https://gist.github.com, and I can help review the formatting before re-importing.

Once this cleanup is done, your “On Sale” products list should reflect only the intended discounted items. Let me know how it goes or if you’d like help with any of the steps above.

Hi @raunharmantech,

Thanks for your follow-up here, I can see you’re trying to share the CSV export so we can take a closer look and guide you properly.

Since CSV files aren’t well suited for Pastebin, you can upload the file to a file sharing service like Google Drive or Dropbox, then share the public link here. That way we can access the file and review the price formatting directly.

If possible, please ensure the link is set to “anyone with the link can view” so we can open it without restrictions. Once you’ve shared the link, I’ll be happy to take a look and help you clean up the pricing values.

Hi there!

Thank you for sharing the CSV file.

I’ve checked it, and I can see some products have prices like 100.00.

Could you please confirm whether those products (with prices like 100.00 and no sale price set) are the ones causing the issue?

I tried to replicate this on my end, but I’m not able to reproduce the issue—prices are appearing correctly, and products are not being marked as “On Sale” unexpectedly.

To investigate further, could you please share more details on how you are displaying “On Sale” products on your site? For example:

• Are you using a shortcode?
• A plugin?
• Or the default WooCommerce on-sale filter?

Also, could you confirm whether removing the “.00” from values like 100.00 fixes the issue on your side?

In the meantime, as a workaround, you can:

• Edit the CSV file
• Remove the “.00” from the price values
• Re-import it into WooCommerce
• Make sure to select “Update existing products”

Once we have a bit more information, we can investigate this further.

Hi there!

Thank you for sharing the screenshot. It looks like the link isn’t publicly accessible at the moment could you please remove any restrictions or update the permissions so I can view it?

Also, could you please share the additional details I requested in my previous message? That will help me investigate this further.

Once I have that information, I’ll be able to assist you more effectively.

Hi there!

Thank you for sharing the screenshot. I can see the price is set to 34.950000.

To assist you further, could you please confirm whether you intentionally set the price as 34.950000, or did you enter it as 34.95 and it automatically change to 34.950000?

Also, could you please go to WooCommerce → Settings → General, scroll down, and check how many decimal places are set there?

Additionally, please share the page URL where you are seeing these products listed as sale products.

I’m asking for these details so I can try to replicate the issue using the same settings and determine whether it’s related to the default configuration or possibly caused by a plugin on your site.

Hi there,

Thank you for providing more detailed information about the issue that really helps narrow things down.

I checked the product data from your CSV, and I can see that some prices are stored as 34.950000. At the same time, there doesn’t appear to be a sale price set for those products. This makes me suspect that something during the migration (via Cart2Cart) may have introduced these extended decimal values, which could be affecting how WooCommerce interprets or displays them.

Just to verify this further, have you tried re-importing the CSV after cleaning up the price values?

If not, could you please:

• Remove the trailing zeros (e.g., change 34.950000 to 34.95) for all affected products in the CSV
• Save the file
• Re-import it into your site
• Make sure to select the option to update existing products during the import

This will help ensure the product prices are stored correctly and may resolve the issue you’re seeing with sale listings.

Let us know how that goes.

Hi there!

Thank you for the update.

When importing a large number of products (like 5000+), it’s common to run into limits such as timeouts or server resource restrictions, which is likely why the import is failing partway.

When stores need to import a large number of products, the performance of your server becomes crucial. To ensure a smooth import process when using a CSV file, consider breaking it into smaller batches. This reduces the chances of errors and allows for easier troubleshooting if issues occur.

For handling extensive imports, we recommend using the Product CSV Import Suite. This extension supports the import of thousands of products, including complex ones and custom data from extensions like Product Vendors, Brands, Google Product Feed, and more.

For more details you can use this guide: https://woocommerce.com/document/product-csv-importer-exporter/#how-to-increase-the-csv-import-maximum-size

I hope this helps.

Hi there!

Yes, absolutely you can split the CSV file into multiple parts (for example, 4 files) and import them separately. That’s actually the recommended approach for large product imports.

Just make sure:

• Each file includes the header row
• There are no duplicate IDs or SKUs (unless you’re updating existing products)
• You import them one by one and let each import fully complete before starting the next

This should help avoid timeouts and errors during the import process