Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How to update fixed-price pricelists

Savoir-faire Linux
on 7/22/14, 9:19 AM 540 views

I am using version 7 with official addons only.

I am using one pricelist per customer with fixed price for each product. Price is not calculated from any other pricelist.

From a future date, prices will be increased, so I need to update prices of my pricelists.

Savoir-faire Linux
On 7/22/14, 9:39 AM

Ending current pricelists versions

To update the prices from a specific date, you need to set the end date of the current pricelist version:

  1. Go to Sales > Configuration > Pricelists > Pricelists Versions
  2. Select the pricelists versions with the following filter:
    1. Start date < today
    2. End date > today OR End date is not set
  3. Click Export
  4. In the export window, add the name, start date and end date fields and then click "Export to File"
  5. In the file, change the date in the column end_date (for example 2014-12-31)
  6. Import the file

Creating new pricelists versions with updated prices

  1. Go to Sales > Configuration > Pricelists > Pricelists Versions
  2. Select the pricelists versions with the same filters as above and click export
  3. In the export window, add all the fields and click "Export to File"
  4. In the file, remove the id column (first column)
  5. In the file, change the data in the following columns:
    1. name : set a new name
    2. date_start : matching the end date entered before (for example 2015-01-01)
    3. date_end
    4. items_id/price_surcharge
  6. Import the file

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 7/22/14, 9:19 AM
Seen: 540 times
Last updated: 3/16/15, 8:10 AM