How to Adjust Decimal Accuracy for Product Prices in Odoo (Backend and eCommerce)

When working with Odoo, businesses often need to configure the display of product prices to match their local conventions or preferences. Decimal precision, which determines how many digits are displayed after the decimal point, can play a crucial role in maintaining consistency between the backend and frontend.

In this blog post, we’ll walk through how to adjust decimal accuracy for product prices in Odoo, ensuring the changes reflect not only in backend modules like Sales or Inventory but also on the eCommerce website.

Step 1: Adjust Decimal Precision for Product Prices

1. Enable Developer Mode
   To access advanced configuration settings, you need to enable Developer Mode:

   • Go to Settings > General Settings.
   • Scroll down and click Activate the Developer Mode.

2. Navigate to Decimal Accuracy Settings

   • Go to Settings > Technical > Database Structure > Decimal Accuracy.
   • Look for the Product Price entry.

3. Set the Desired Precision

   • Open the Product Price record.
   • Change the decimal accuracy to your desired number of decimal places (e.g., 0 for whole numbers or 2 for two decimal places).
   • Save your changes.

This step ensures that product prices in backend modules like Sales, Purchases, and Inventory reflect the updated precision.

Step 2: Adjust Currency Rounding for eCommerce

While changing decimal accuracy affects the backend, the eCommerce module might still display prices differently. To align the eCommerce website with the desired precision, you need to configure the currency rounding factor.

1. Go to Currencies List

   • Navigate to Settings > Accounting > Configuration > Currencies.

2. Edit Your Currency

   • Find and select the currency you are using for your eCommerce website (e.g., USD, EUR).
   • Open the currency record.

3. Set the Rounding Factor

   • Update the Rounding Factor field to match your desired accuracy:
     • Use 1 for whole numbers (e.g., $5).
     • Use 0.01 for two decimal places (e.g., $5.99).
   • Save your changes.

4. Verify Active Currency
   Ensure that the updated currency is active and associated with your eCommerce website.

Step 3: Test the Changes

After updating both the decimal precision and currency rounding factor, it’s time to test the changes:

1. Check Backend Modules

   • Navigate to modules like Sales or Inventory and verify that product prices are displayed with the desired precision.

2. Visit the eCommerce Website

   • Open your eCommerce website.
   • Browse product pages, the shopping cart, and checkout pages to ensure the prices reflect the updated decimal accuracy.

Tips and Best Practices

• Keep Business Needs in Mind
  Consider your business requirements and local conventions before making changes. For example, whole numbers might be appropriate for retail, while two decimal places are standard in most accounting systems.

• Test Across Devices
  Ensure the changes are consistent across desktop and mobile views.

• Backup Before Making Changes
  Always take a backup of your database before making significant configuration changes.

Conclusion

With just a few simple steps, you can configure decimal accuracy in Odoo for both backend modules and the eCommerce website. Adjusting the Decimal Accuracy for Product Price ensures backend consistency, while updating the Currency Rounding Factor brings your website in line with your desired format.

By following this guide, you can create a seamless experience for your team and your customers, ensuring that prices are displayed accurately and professionally across all channels.

If you found this guide helpful, feel free to share it with others working on Odoo customizations! Have additional tips or questions? Drop a comment below!