This question has been flagged
1 Reply
5570 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.

Avatar
Discard
Author Best Answer

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
Avatar
Discard