• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 51 views
  • Users 0 members are here
Related

Procedure to update customer no on order

Sadie Prater (Past Member)
$organization

Hello,

I have been working on several projects aimed at reducing the number of anonymous, general admission, and constituent 0 orders in the system and I have found a way to gather email address and order numbers independently, but now I need to attach them in the system.

What I would like to do is call a procedure that will look up the order number and write in the correct constituent from a local table.  Has anyone written a procedure to do this?  I  am assuming this is more involved than just updating T_ORDER.constituent_no.  Can anyone tell me what all I would need to touch or what procedure system calls when you key it from the front end?

Thanks in advance.

 

SADIE PRATER

Systems Analyst

Perot Museum of Nature and Science

Parents
  • $organization

    Hi Sadie

    I must admit I haven;t updated custoemr number, but you can do it through the client. So if you have a time when your Test environment is quiet, run a sql trace and then update a customer number in an order via the Tess client and see what it actually does update. 

    That said think transcations, line items and sub line items just have order number, is payments that have the customer_no attached and not sure you need to move payments.

    Probably need to refresh tickey history after doing it to ensure that picks up the changes.

    Alternative is to add your new customer_no as the initiator of the order (or recipients) which would tag the order(tickets) back to the customer but have less impact and depending on your setup may still populate ticket history so can be used in lists etc.

    Mark

Reply
  • $organization

    Hi Sadie

    I must admit I haven;t updated custoemr number, but you can do it through the client. So if you have a time when your Test environment is quiet, run a sql trace and then update a customer number in an order via the Tess client and see what it actually does update. 

    That said think transcations, line items and sub line items just have order number, is payments that have the customer_no attached and not sure you need to move payments.

    Probably need to refresh tickey history after doing it to ensure that picks up the changes.

    Alternative is to add your new customer_no as the initiator of the order (or recipients) which would tag the order(tickets) back to the customer but have less impact and depending on your setup may still populate ticket history so can be used in lists etc.

    Mark

Children