I was wondering if anyone has come across a scheduled job that will remove expired prices after a certain number of days?
I would envisage this is similar to the remove expired carts but for prices.
Expired prices will not be returned when you use IPriceService, and unlike expired carts I don't think they will cause a performance degradation
but if you want to, you can traverse through the catalog https://leanpub.com/epicommercerecipes/read_sample , limiting to only variants and packages (unless you have prices for products, which is not common), then load prices using IPriceDetailService, delete the expired prices then save back
Good information to know there will not be any performance degradation.
As more a good practice, it would be better to have something what would maintain obselete data. A recent query I ran against a clients PriceDetail table returned over 4 million prices that had expired. This seems expense to me and should be maintained.
Thanks for the info, I have read your book, lots of good information in there and great to see your support to the Episerver community, keep it up.