Ubercart Product Workflow and various timing stages with product expiration

Hi Everyone,

I want to be able to schedule a product to be featured at a certain time and that its already accomplished with the module workflow itself and having cron setup correctly. The issue at hand is that once the product is in the Workflow state of Featured it should move the Sidebar product state after 24 hours and should eventually move to the expired product state after another 48 hours.

I am able to unpublished and publish the node using the workflow after a certain time with Rules, but that's not exactly what I want, I need for the state to escalate to the next step after a given time and this seems not to be available with rules.

Ubercart Product Workflow

1. (Creation)
2. Under Review
3. Approved
4. Featured Product -> moved to next state after 24 hours
5. Side bar Product -> move to next state after 48 hours
6. Expired Product

There is another thing as well, once the schedule featured product has actually updated to the featured product state, it should have its alias url updated to a certain link which is actually the default frontpage of the site.

The approved and under review states will not have any actions, it is just to know that the product either still needs to be Reviewed more or if its under Approved to know that its approved to become a featured product when the admin/publisher wants it to be.