I manage a Wordpress Site with custom php code & a custom MySQL database. During the time period Jan 1. thru abut April 15, the customer offers their customers discount prices for buying a service plan during that time frame. The also require a variation on the main page slider where there an alternate image is placed inbetween each existing image where the alternate image pushes the discount pricing.
It's very straignt forward to do this, I've done it several years in a row, but I've always had to do it on Jan 1 (actually Jan 2), but it needs to go live like at 6 AM Eastern & I am in Pacific, so 3AM Pacific.
I would like to do it such that I can set it all up ahead of time & have the customer verify it's working correctly AHEAD of time, for the obvious reasons.
It occurred to me I can do the database part by having two tables, one for the normal pricing & one for discount. Then I can with custom php code make it use the discount pricing ONLY during the dates 1/1 through 4/15 OR if the user is me or the customer contact. Since no login is needed, not sure how to do that. I just thought, I can make a login needed to test the upcoming discount period, then use the alternate table if login is proper.
But how can I use a different carousel for the slider (this part all done in Wordpress) for the testing and the discount date range?