• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 217 views
  • Users 0 members are here
Related

T_Web_Order

Michelle Kosmatka
$organization

Hello all,

I'm working on abandoned cart numbers for the Marketing team.  I've pulled my data from T_WEB_ORDER and I want to verify that I'm interpretting things correctly.  I can't find the system table listed in the system table documentation for Tess or TNew.

When I'm looking at a customer_no that ties back to the TN Express Web User, can I make the assumption that they dropped out of the process before logging in?

When I see a customer_no tied to an actual patron account in Tessitura but not acorresponding order in T_Order, I'm assuming they dropped after logging in but before completing the purchase.

Obviously, if it's in T_WEB_ORDER and T_ORDER, I can see the completed order in Tessitura.

I want to be sure I'm interpretting things correctly before moving along in the process.  Also, if anyone knows where I can find table details on T_WEB_ORDER, I'd appreciate the direction.

Implementing abandoned cart emails is going to be a slow process.

Thanks!

M

Parents
  • $organization

    Thanks Mark.  It’s nice to know I’m reading something correctly.

     

    M

     

    Michelle Usadel
    Tessitura Application Specialist | The Phoenix Symphony | Tel.  602-452-0441 | Fax. 602-253-1772
    www.phoenixsymphony.org | 1 N. 1st Street, Ste. 200, Phoenix, AZ 85004


     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Ridley
    Sent: Wednesday, May 24, 2017 1:43 AM
    To: Michelle Usadel <musadel@phoenixsymphony.org>
    Subject: Re: [Tessitura Technical Forum] T_Web_Order

     

    Yes you are interpreting that correctly.

    If you are seeing the anonymous user account as the customer_no on T_web_order then the custoemr never logged in during that session.

    If the custoemr_no is in then the customer had logged in (may have done so initially which we get as members ahve to log in to get their benefits) but then never completed the order.

    You may also want to check that the customer didn't place another order on the same day for that show. I have had a few instances where a customer has placed a successful order but has maybe not seen it acknowledged correctly and started to place the order again before the email confirmation came through and then abandoned that order.

    Mark

     

    Mark

    From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com>
    Sent: 5/23/2017 2:24:55 PM

    Hello all,

    I'm working on abandoned cart numbers for the Marketing team.  I've pulled my data from T_WEB_ORDER and I want to verify that I'm interpretting things correctly.  I can't find the system table listed in the system table documentation for Tess or TNew.

    When I'm looking at a customer_no that ties back to the TN Express Web User, can I make the assumption that they dropped out of the process before logging in?

    When I see a customer_no tied to an actual patron account in Tessitura but not acorresponding order in T_Order, I'm assuming they dropped after logging in but before completing the purchase.

    Obviously, if it's in T_WEB_ORDER and T_ORDER, I can see the completed order in Tessitura.

    I want to be sure I'm interpretting things correctly before moving along in the process.  Also, if anyone knows where I can find table details on T_WEB_ORDER, I'd appreciate the direction.

    Implementing abandoned cart emails is going to be a slow process.

    Thanks!

    M




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization

    Thanks Mark.  It’s nice to know I’m reading something correctly.

     

    M

     

    Michelle Usadel
    Tessitura Application Specialist | The Phoenix Symphony | Tel.  602-452-0441 | Fax. 602-253-1772
    www.phoenixsymphony.org | 1 N. 1st Street, Ste. 200, Phoenix, AZ 85004


     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark Ridley
    Sent: Wednesday, May 24, 2017 1:43 AM
    To: Michelle Usadel <musadel@phoenixsymphony.org>
    Subject: Re: [Tessitura Technical Forum] T_Web_Order

     

    Yes you are interpreting that correctly.

    If you are seeing the anonymous user account as the customer_no on T_web_order then the custoemr never logged in during that session.

    If the custoemr_no is in then the customer had logged in (may have done so initially which we get as members ahve to log in to get their benefits) but then never completed the order.

    You may also want to check that the customer didn't place another order on the same day for that show. I have had a few instances where a customer has placed a successful order but has maybe not seen it acknowledged correctly and started to place the order again before the email confirmation came through and then abandoned that order.

    Mark

     

    Mark

    From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com>
    Sent: 5/23/2017 2:24:55 PM

    Hello all,

    I'm working on abandoned cart numbers for the Marketing team.  I've pulled my data from T_WEB_ORDER and I want to verify that I'm interpretting things correctly.  I can't find the system table listed in the system table documentation for Tess or TNew.

    When I'm looking at a customer_no that ties back to the TN Express Web User, can I make the assumption that they dropped out of the process before logging in?

    When I see a customer_no tied to an actual patron account in Tessitura but not acorresponding order in T_Order, I'm assuming they dropped after logging in but before completing the purchase.

    Obviously, if it's in T_WEB_ORDER and T_ORDER, I can see the completed order in Tessitura.

    I want to be sure I'm interpretting things correctly before moving along in the process.  Also, if anyone knows where I can find table details on T_WEB_ORDER, I'd appreciate the direction.

    Implementing abandoned cart emails is going to be a slow process.

    Thanks!

    M




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data