Should email confirmations sent either from the client or the web be written to t_order_seat_hist with the event code "confirmation"? Or does that only happen when the Order Confirmations report is run? Is there any other way to see when an email confirmation was generated (besides looking at the timestamp on the email itself)?
It should write a row to the contact log with the order_no as the issue number and the to address in the notes field.
Ah! Thanks. I completely forgot about the contact log.
Hi Amanda and Brian,
So here is a really stupid question.....where can I find the contact log?
A little while ago I wanted to find out when a confirmation was sent but couldn't figure out where these transactions were kept.....it wasn't all that important at the time so I left it unsolved. I'm sure it will come up in the future though so if you could point me in the right direction that would be great.
Tash
From the Constituents module, Contacts tab, last radio button on the right is Contact Log. (No question is stupid!)
Hahaha! Wow, OK...allot simpler than I thought. Here I was thinking it was hidden in some obscure table. Thanks heaps.
In case anyone is looking at this thread in the present day -- this may have been true then, but it isn't now! The Contact Log isn't a table -- it's a procedure (AP_CUSTOMER_LOG) that pulls the data out of the various tables. So in the case of email confirmations, there IS an obscure table where this stuff is actually stored: T_LOG_ORDER_EMAIL.
Hey Nick. We are having issues with email confirmations when people order online. Some are getting their confirmations. Some say they aren't getting the confirmation. We don't see web confirmations in the Contact Log at all. We only see the confirmations that we generate ourselves for phone orders. So what would we need to do on our end that would make the web confirmations register in the contact log along with the ones we send ourselves? Please don't say custom code in the Web API cause that's expensive.
Thanks in advance.
Hi Adria,
All I know is that TNEW does not write order confirmation emails to the T_LOG_ORDER_EMAIL table. It seems the method of sending the email through the client is different from the method for sending via the Web API.
An enhancement request should probably be made for emails sent from the SendOrderConfirmationEmail method to be logged to that table.