How to keep history of products prices

Hello Phong,

Using the menu : Sales/Configuration/Pricelists/Pricelists you can define the Pricelist in OpenERP v6.

As we know the Pricelist may have more then one Pricelist Versions having different start and end dates.

Each Pricelist Version can be defined by more then one *Rules* which can be associated with product, product category etc...

Now if you want to keep track of all price variation, you can have the only option to use Pricelist Version efficiently.

Suppose you want to increase 10% price of Basic PC from the date of 01/03/2011 and also want to keep track of it's price before 01/03/2011.

Keep in mind that Pricelist feature of OpenERP does not affect actual sales/cost price displayed on the Product's form but it is used to increase/decrease price of the product at the time of sale/purchase.

As for example, define one Pricelist...

Pricelist Name: Pricelist from 01/03/2011
Pricelist Type: Sale Pricelist

which has a Pricelist Version...
Name: Version 1.0 for Pricelist from 01/03/2011.
Start Date: 03/01/2011

For this Pricelist Version define the *Rule* as below:
Rule Name: Sales price of Basic PC from 03/01/2011
Product: [PC1] Basic PC
Based on : Public Price
New Price = Base Price * ( 1 + 0.1 ) + 0.0

(Don't forget to attach this new pricelist to the customer for which you want to create Customer invoice.)

The above configuration will help you to increase your product's price by 10% from the date of 01/03/2011 (When you create customer invoice) without any changes in the sales price which is displayed on the Product's form.

Hence you preserves the product's old price on the product's form (Sales Price) and also you can create customer invoice for this product with 10% price hike from the date of 01/03/2011.

Hope this will help you...

Hi Riken,

Thank you very much for your suggestions. However, I think the current price-list version feature only solves part of my issue. What I want to increase the price might be arbitrary, 10-15% maybe the range, but not all products will increase the same percentage, thus I might end up making individual rules for each product. Another thing, due to rounding effects (e.g. the smallest value we should pay in retail is 100VND), the percentage will also not be the same. I'm looking for places where I can enter directly a number for the new price, not formulas. I think the current price-list version feature is more suitable for promotion campaigns, special offers rather than to keep track the adjustment of prices (from many reasons other than promotion).

Are there any modules in the community/extra repository that helps me to achieve what I want to do?

Thanks and best regards,

Phong.

Hello Phong,

As per my knowledge concern, this kind of functionality (keep track of history of price variation) is not there in the community/extra repository.

One more thing which may be useful to you.

You can define the *Rule* for pricelist version according to 'Product Template' and 'Product Category', using this you can define new price in pricelist for bulk of specific kind of products.

Also in order to put limit on margin on profit, you can configure 'Min. Margin' and 'Max. Margin' in the *Rule* of pricelist version.

Thanks.