Title: Price format correction Last modified: April 22, 2026 --- # Price format correction * Resolved [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/) * On many products, the price has been mentioned as x.00000 , due to which the products (without sale price) are getting dispalyed in On Sale products. Ones we remove the extra 00, it gets removed from the On Sale products. * There are many such products, how do I correct them in bulk. The wordpress is using WPML, and is in two languages. Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/price-format-correction/page/2/?output_format=md) [→](https://wordpress.org/support/topic/price-format-correction/page/2/?output_format=md) * [LovingBro (woo-hc)](https://wordpress.org/support/users/lovingbro/) * (@lovingbro) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18887894) * Hi [@raunharmantech](https://wordpress.org/support/users/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: 2. - 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** 3. Guide here: [https://woocommerce.com/document/product-csv-importer-exporter/](https://woocommerce.com/document/product-csv-importer-exporter/) 4. **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. 5. **WPML consideration** Since you’re using WPML, ensure that: 6. - Price fields are synchronized across translations - After cleanup, run WPML troubleshooting tools to sync product data across languages 7. WPML guide: [https://wpml.org/documentation/getting-started-guide/](https://wpml.org/documentation/getting-started-guide/) 8. **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](https://pastebin.com/) or [https://gist.github.com](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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890550) * How I share the product export through pastebin. It is a csv file * [LovingBro (woo-hc)](https://wordpress.org/support/users/lovingbro/) * (@lovingbro) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890553) * Hi [@raunharmantech](https://wordpress.org/support/users/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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890592) * [https://www.dropbox.com/scl/fi/32f4l4yeaq5yn3mm8b781/wc-product-export-22-4-2026-1776856823563.csv?rlkey=q7vcn85bjnc72h2e9lt04eutq&st=y33umar8&dl=0](https://www.dropbox.com/scl/fi/32f4l4yeaq5yn3mm8b781/wc-product-export-22-4-2026-1776856823563.csv?rlkey=q7vcn85bjnc72h2e9lt04eutq&st=y33umar8&dl=0) * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890610) * 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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890633) * screenshot attached. * [https://drive.google.com/file/d/17B8Se4k33PNYujmPNTLW7AhamTXJ2B1c/view?usp=sharing](https://drive.google.com/file/d/17B8Se4k33PNYujmPNTLW7AhamTXJ2B1c/view?usp=sharing) * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18890979) * 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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18891690) * Please ignore the previous file. The fresh file is at: [https://www.dropbox.com/scl/fi/knspfb4wuwkloahfzez29/wc-product-export-27-4-2026-1777276417878.csv?rlkey=ty7di814yxdadic3yrs79k5xa&st=evq0aisf&dl=0](https://www.dropbox.com/scl/fi/knspfb4wuwkloahfzez29/wc-product-export-27-4-2026-1777276417878.csv?rlkey=ty7di814yxdadic3yrs79k5xa&st=evq0aisf&dl=0) * Screen shot of the product page (backend) showing the price is : [https://www.dropbox.com/scl/fi/26hof647z3xetuifwsxym/Screenshot-From-2026-04-27-13-36-34.png?rlkey=hte9u16curhagcagi1n6d240o&st=8m6p1uq1&dl=0](https://www.dropbox.com/scl/fi/26hof647z3xetuifwsxym/Screenshot-From-2026-04-27-13-36-34.png?rlkey=hte9u16curhagcagi1n6d240o&st=8m6p1uq1&dl=0) * The price at the backend is showing as 34.950000 * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18891808) * 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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18891862) * The price is entered as 34.95 only . This web store was previously running on Presta Shop and in 2024, we migrated to WooCommerce. Almost 80% of the products are the migrated ones only. It coud be that while migration the product price changed to multiple decimals (the migration was done through Cart2Cart). * “ould you please go to **WooCommerce → Settings → General**, scroll down, and check how many decimal places are set there?” Previously it was not set to any decimal. Last week it set to 2 decimal points. * “please share the page URL where you are seeing these products listed as sale products.” * [https://gniautoparts.co.in/oe/en/](https://gniautoparts.co.in/oe/en/) * under Sales & Specials . I am using Elementor Widget (WooCommerce Product– On Sale). Tried shortcode also [https://www.dropbox.com/scl/fi/4ntpjzrs6dpw5r84wri91/Screenshot-From-2026-04-27-16-18-30.png?rlkey=jiwljqx2mo7vvr147e1tyuqhi&st=1jxp7czr&dl=0](https://www.dropbox.com/scl/fi/4ntpjzrs6dpw5r84wri91/Screenshot-From-2026-04-27-16-18-30.png?rlkey=jiwljqx2mo7vvr147e1tyuqhi&st=1jxp7czr&dl=0) * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 3 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18892148) * 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. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 2 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18896334) * I have corrected the price columns. But as the products are around 5000 (total of eng & french), Woocommerce Product import is not happening. I tried webtoffee Product Import/ export, there also after around 2500 products, it started giving errors. * Please suggest how to import. * The correct product csv file is [https://www.dropbox.com/scl/fi/m0nu5vtsn81fehl722ykz/en-wt-product-export-30-4-2026-1777544078709.csv?rlkey=q8stal6607muge6axsudaxv6j&st=06u0u7ck&dl=0](https://www.dropbox.com/scl/fi/m0nu5vtsn81fehl722ykz/en-wt-product-export-30-4-2026-1777544078709.csv?rlkey=q8stal6607muge6axsudaxv6j&st=06u0u7ck&dl=0) * It is exported through Webtoffee Woocommerce Product Import Export plugin * And the file that was exported using WooCommerce Product Export is [https://www.dropbox.com/scl/fi/ilpcm9028si8ltymk8hwm/wc-produts.csv?rlkey=n86zqw2vc92934xmc8zcqwefl&st=7e0rn3lk&dl=0](https://www.dropbox.com/scl/fi/ilpcm9028si8ltymk8hwm/wc-produts.csv?rlkey=n86zqw2vc92934xmc8zcqwefl&st=7e0rn3lk&dl=0) - This reply was modified 3 months, 2 weeks ago by [raunharmantech](https://wordpress.org/support/users/raunharmantech/). * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 2 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18896341) * 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](https://woocommerce.com/products/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](https://woocommerce.com/document/product-csv-importer-exporter/#how-to-increase-the-csv-import-maximum-size) * I hope this helps. * Thread Starter [raunharmantech](https://wordpress.org/support/users/raunharmantech/) * (@raunharmantech) * [3 months, 2 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18896348) * Thanks for the instant reply. Can we break the csv file into four parts. And then import each file seperately. * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [3 months, 2 weeks ago](https://wordpress.org/support/topic/price-format-correction/#post-18896350) * 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 Viewing 15 replies - 1 through 15 (of 22 total) 1 [2](https://wordpress.org/support/topic/price-format-correction/page/2/?output_format=md) [→](https://wordpress.org/support/topic/price-format-correction/page/2/?output_format=md) You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fprice-format-correction%2F%3Foutput_format%3Dmd&locale=en_US) to reply to this topic. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3640790) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 22 replies * 4 participants * Last reply from: [Kay U a11n](https://wordpress.org/support/users/kingsleyinfo/) * Last activity: [3 months ago](https://wordpress.org/support/topic/price-format-correction/page/2/#post-18908734) * Status: resolved