Price history

[invista6]

Hi!

I need to create  simple module to add price history. I want it to create a table with:

product_id;wholesale_price;retail_price:date_upd;employe;

This table should update every time one of this filds change.

Can I do this modifying product controler? Any help will be apreciated.

 

P.S. The reason i'm trying to this is because i didn't find anythig like this in the market.

 

Best regards

Pedro

 

[cyberdoc]

Nice idea.. one approach could be to use two hooks , when the admin opens a product to edit and when he updates it. save the last value in a variable and if a change is there, add into the table accordingly.. Just a suggestion of my approach