Print Page - Discount calculation rule ends 5 hours off

Title: Discount calculation rule ends 5 hours off
Post by: rainman2000 on November 10, 2013, 14:49:04 PM

Hi All,

I'm using Joomla 2.5 and VM 2.0.22b (can't upgrade yet). I am located in Eastern Time Zone and my server is located in Eastern Time Zone (GMT-5). I have Joomla configured for New York time. My discount calculation rules end when there is still 5 hours remaining for the discount. It's OKay at 5 hours and 1 second, but when it reaches 5 hours it ends the discount so it seems this is related to the 5 hour offset somewhere in Virtuemart. However, my order transactions all have the correct times on them. Please advise.

Thanks!

Title: Re: Discount calculation rule ends 5 hours off
Post by: rainman2000 on November 10, 2013, 18:25:13 PM

So, obviously the ending the discount at UTC/GMT time but how do I make it end at the server's local time? This is critical as we have a sale coming up Tuesday to use this so any help is greatly appreciated.

Thanks!

Title: Re: Discount calculation rule ends 5 hours off
Post by: Milbo on November 11, 2013, 11:27:48 AM

Check the code if the offset is used.

Title: Re: Discount calculation rule ends 5 hours off
Post by: rainman2000 on November 11, 2013, 20:05:26 PM

Thanks Milbo,

Okay so it was actually the timer integrated with Virtuemart that was the problem and not Virtuemart. Since the time shown in the database is UTC/GMT I was able to just move it forward 5 hours to convert it to Eastern Time and then add offset code in the timer and it works fine. ;)

Title: Re: Discount calculation rule ends 5 hours off
Post by: Milbo on November 14, 2013, 10:04:33 AM

So your offset in joomla was not set correctly?

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: rainman2000 on November 10, 2013, 14:49:04 PM