Product Special Price Limited Time Offer

With the dynamic eCart configuration I would like to be able to offer special sale/limited time offer price for a specific product. This is instead of a percentage discount. I believe that this was addressed somewhere but now I cannot find the details of how to set up for this option. Should I set up a ProdSpecialPrice column in the Products table? Can someone guide me in the right direction please & thank you?

You can do it however you want to. A ProdSpecialPrice field in the database with a ProdPriceExpires date maybe to make it expire at a certain date. There are many ways you could do it. How do you want it to work?

Yes, using two columns ProdSpecialPrice & ProdPriceExpires date sounds like a good idea. I will include them in the tables and Admin backend to control value and date (timestamp). A simple method to set up would be best. Might be good to show regular price and the special price for the product so the customer can see the benifit. Beyond that I am not sure.

I think at that point you could add both of those values as columns in your cart.. I'll call them Expires and SpecialPrice, then set up a calculation.

UsePrice = ((strtotime([Expires]) > time())?[SpecialPrice]:[Price])

Then I forgot to mention you would also have to update the totalprice calculation:

TotalPrice = ((strtotime([Expires]) > time())?[SpecialPrice]:[Price]) * [Quantity]

Much appreciated Ray! I am still waiting for direction from tech support on the issues with DataAsssit. I have a lot of work once I can move ahead to create user and shopping admin backend. I will update the tables and referance this as soon as I can get using eCart.