Product price/cost history

Hi,

it would be nice to have in nopCommerce easy way to get report with product price/cost history in time.

I supposed, that i have to add some aditional table (ProductVariantPriceHistory) and for every Price change on ProductVariant i should save item with NewPrice, Date and ProductVariantId to this table. But for now i can't understand how nopCommerce works internally with saving data (what classes i have to write; what interface, ...). Can anybody please guide me to some direction?

Thanks

Hi
the table and DB side is more easy with triggers and inserting old price records on price_change. did you experienced any on how to easily report that to user?
look at https://www.digikala.com/Product/DKP-145805/ and click on histogram on top left of picture. this is price changes during the days