I need someone to show me how to write a cron job that will adjust the "position" value of a product based on sales. For example, the best selling product over a 90 day period has a value of 1 and a product which hasn't sold yes has a position of 99999.
Why ?
I want to display the best selling products at the top of the page when "recommended" order by has been selected (which is the default value).
I guess the easiest way to do this is to rank the products based on sales quantity. I could get technical and start adding in product profit and cash margin, but I will keep it simple for the moment and just use qty sold over an adjustable time period (which I will say is 90 days)
I don't know how to write a cron job, as I'm quite new to Magento.
Can someone show me an example of how to do this.
TIA
