OdooWiki OCA HUB

Pricelist Cache

pricelist_cache folder_open OCA/sale-workflow open_in_new
Hidden License: AGPL-3

Provides a cron task who caches prices for all products and all pricelists. The goal is to be able to generate a whole catalog of prices and products for a given customer in a decent time.

Everyday, the cron task will trash the previous day's cache, and rebuild it from scratch. It means that at any moment, the prices stored in the cache are those of the current day, and will not be recomputed before the next day.

However, new prices will be cached in the following cases:

  • new product is created
  • new pricelist is created
  • new pricelist item is created

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Stores precomputed product prices for every pricelist so customer price lists can be displayed quickly. Adds buttons on pricelists and customers to view cached prices, plus a daily job that rebuilds the cache.

This module keeps a stored copy of the price of each product for each pricelist, so Odoo does not have to recalculate everything when you want to see a customer's prices.

Where you see it: - On a pricelist form, a button "Display Pricelist Prices" opens a read-only list of cached product prices. - On a customer form, a button "Display Customer Prices" shows the cached prices for that customer's pricelist, limited by a product filter you can choose on the customer. - Under Sales > Configuration there is a "Pricelist Cache" menu opening a wizard where you pick a customer, a pricelist and optionally a product to preview cached prices.

Automatic behaviour: - A daily scheduled job ("Reset pricelist cache") empties the cache and rebuilds it for all pricelists. - Creating a product, a pricelist or a pricelist item triggers a background update of the affected cached prices. - Pricelist items with start/end dates are skipped and refreshed later by the daily job. - If the cache for a pricelist is not ready, the customer price button shows an error asking you to retry later.

It touches product.pricelist, product.pricelist.item, product.product, res.partner and adds the product.pricelist.cache model and wizard.

Required by other modules

Menus it adds

menuitem_pricelist_cache_wizard
Models and fields (6)
  • res.partner · extends an existing modelis_pricelist_cache_available, pricelist_cache_product_filter_id
  • product.product · extends an existing model
  • product.pricelist · extends an existing modelparent_pricelist_ids, is_pricelist_cache_computed, is_pricelist_cache_available
  • product.pricelist.item · extends an existing modelcateg_id, date_end, applied_on, company_id, date_start, product_id, min_quantity, product_tmpl_id, base_pricelist_id, pricelist_cache_update_skipped
  • product.pricelist.cache · new modelprice, product_id (Product Variant), pricelist_id (Pricelist)
  • product.pricelist.cache.wizard · new modelpartner_id, product_id, pricelist_id, display_cache_line_ids (Cached prices)

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 4 confirmed, 5 with no information of 9 versions.

Sources · Odoo 18.0

Confirmed on 2026-11-03 in branch 18.0 of OCA/sale-workflow.

terminal Installation and usage

No verified information

Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.