Hi all - we just launched our CS Cart powered store this week and we’re looking at all of the transactions data and we’re kind of puzzled. We’re seeing a mismatch between when the credit card merchant processes a transaction and when we’re seeing orders come through into the sales reporting with in CS Cart.
We are also seeing transactions for instance that went through today (2/12/11) look as though they were processed on 2/13/11, a full day later.
Is this normal based on how CS Cart is supposed to behave? Does it compensate for transactions that may have to go through and actually complete or something like that?
Thanks for any help you can offer!
[quote name=‘LarryU’]Hi all - we just launched our CS Cart powered store this week and we’re looking at all of the transactions data and we’re kind of puzzled. We’re seeing a mismatch between when the credit card merchant processes a transaction and when we’re seeing orders come through into the sales reporting with in CS Cart.
We are also seeing transactions for instance that went through today (2/12/11) look as though they were processed on 2/13/11, a full day later.
Is this normal based on how CS Cart is supposed to behave? Does it compensate for transactions that may have to go through and actually complete or something like that?
Thanks for any help you can offer![/QUOTE]
First guess is your server time zone
I believe we figured it out.
I thought it was the server time as well, but we discovered that it’s purely based on when your credit card transaction service (Authorize.net in our case) actually secures the payment. So the submit date happens and then about 24 hours later you get the transaction confirmed and now CS Cart reports the sale.
Authorize.net is a “transactional payment processor”. It only returns data in response to the transaction request. There is no callback at any later time.
Now, there is a settlement date/time which usualy happens in the middle of the night. But cs-cart doesn’t have access to settlement information and it is usually the total amount for the last 24 hours, not individual transactions.
To me, what you’re stating doesn’t make any sense… What am I missing?
I use Authorize.net and my orders are immediate… I looked at one that I received last night. The order was placed at 9:23pm and CS-Cart logged the order at 9:23pm. My email from Auth.net was at 9:23pm… The merchant Email Receipt does show 10:23pm.
[quote name=‘tbirnseth’]Authorize.net is a “transactional payment processor”. It only returns data in response to the transaction request. There is no callback at any later time.
Now, there is a settlement date/time which usualy happens in the middle of the night. But cs-cart doesn’t have access to settlement information and it is usually the total amount for the last 24 hours, not individual transactions.
To me, what you’re stating doesn’t make any sense… What am I missing?[/QUOTE]
I agree, it doesn’t make any sense to me either. If you look at the screenshot, every single transaction is hours different than what we’re logging in our orders.
[url]http://img153.imageshack.us/i/screenshotng.jpg/[/url]
So this creates an issue where those transactions on the top of the authorize.net are actually supposed to be on 2/12, but because of the 6-7 hour time difference, they are on 2/13’s report. Makes for a really weird way to track sales.
Am I just missing something glaringly obvious here or does this look wrong?
![http://img153.imageshack.us/i/screenshotng.jpg/[/url]](http://img153.imageshack.us/i/screenshotng.jpg/%5B/url%5D){kind=link}
You do have your timezone in Anet set to the same value as your cart, right? That would be all I can think of… Mine are all in sync.
That was it right there. Thank you a ton. I didn’t even think to check a.net to see if they had a setting for it.
It didn’t help that I also JUST found where to set the timezone of the cart itself lol.
/facepalm
Lots to learn (I learn every day) and there are no dumb questions other than the questions that aren’t asked.
Glad it was a simple solution…