VI Cross Reference Customer Email to Customer Number

I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to the sales order. How do I do that?

  • 0

    If you don't have many customers ordering on your e-Commerce platform, I suppose you could set up a Temp field in VI to read the email address. Then you could set up as many "Customer Number" fields as needed, and set selection criteria to read the email address and assign the correct customer number. If you have many customers it could be really clunky, though, and I'm not sure if there's a limit to how many selection criterias (sp? criterium? Nerd) you can use in 1 VI job.

  • 0

    Untested Idea:

    VI to a generic customer number, then do a script on the SO header table (post-validate on the email address) to query the customer table for that value, then override the CustomerNo at that point.  VI results wouldn't likely show the results of the scripted customer # change, but it might work.

    Or hire a Master Developer to come up with some Perform logic to do a lookup...