Aux Single Added in LWP_VALIDATE_CART

I'm hoping one of the LVP_VALIDATE_CART geniuses out there can help with this one.

For some time I've been using the LWP_VALIDATE_CART procedure to offer upsells in TNEW when a customer adds a Single Performance to their cart.  It's been working very well.

Today I've been trying to use the exact same logic to offer an upsell when a customer adds an Auxiliary Single Performance to their cart, but it seems that the validation isn't working.  It's almost as if the validation point is never called when the auxiliary item is added to the cart.

I've specified 'Aux Single Ticket' as validation point 2 in the LTR_TNEW_VALIDATE_CART system table, and @Aux_Sng_Added  is specified as validation point 2 in the LWP_VALIDATE_CART procedure.

I've then added a single line of code to the Aux_Sng_Added: portion of the procedure.

      set = @PageText = 'You've added an aux item to your cart'

It never shows up in TNEW when I add an auxiliary item to the cart.

This exact same line of logic seems to work for regular Single Ticket items.  

I'm probably missing something simple, but it eludes me.

 

 

  • Bill,

    Would probably need to see the procedure to understand more about the issue.  Looking at the out of the box procedure, it appears to only either return an error as raised or just returns, so not quite sure how you're going about displaying text unless those are the errors you are returning.

    Sounds like you've done some fairly involved customizations though.

    -Ryan

  • This issue ended up somehow resolving itself and the upsell is working correctly now.  I think it’s possible that after I modified the LTR_TNEW_VALIDATE_CART system table to include a validation point for Aux Single Items  it took a while for the modification to actually take effect in TNEW.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan McFadden
    Sent: Monday, February 17, 2014 10:50 AM
    To: Bill Waugh
    Subject: Re: [Tessitura Development Forum] Aux Single Added in LWP_VALIDATE_CART

     

    Bill,

    Would probably need to see the procedure to understand more about the issue.  Looking at the out of the box procedure, it appears to only either return an error as raised or just returns, so not quite sure how you're going about displaying text unless those are the errors you are returning.

    Sounds like you've done some fairly involved customizations though.

    -Ryan

    From: Bill Waugh <bounce-billwaugh2513@tessituranetwork.com>
    Sent: 2/15/2014 2:35:41 PM

    I'm hoping one of the LVP_VALIDATE_CART geniuses out there can help with this one.

    For some time I've been using the LWP_VALIDATE_CART procedure to offer upsells in TNEW when a customer adds a Single Performance to their cart.  It's been working very well.

    Today I've been trying to use the exact same logic to offer an upsell when a customer adds an Auxiliary Single Performance to their cart, but it seems that the validation isn't working.  It's almost as if the validation point is never called when the auxiliary item is added to the cart.

    I've specified 'Aux Single Ticket' as validation point 2 in the LTR_TNEW_VALIDATE_CART system table, and @Aux_Sng_Added  is specified as validation point 2 in the LWP_VALIDATE_CART procedure.

    I've then added a single line of code to the Aux_Sng_Added: portion of the procedure.

          set = @PageText = 'You've added an aux item to your cart'

    It never shows up in TNEW when I add an auxiliary item to the cart.

    This exact same line of logic seems to work for regular Single Ticket items.  

    I'm probably missing something simple, but it eludes me.

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!