I need to add a 'customer code' field - what's the best method?

[joelryan2k]

I need to add a 'customer code' field to the checkout process. At order process, I need to verify this code against a lookup table of approved customers. Depending on the result, I'll take various actions. I'm a decent programmer so I don't need programming help per se...

 

My questions is, what is the best method to implement this? It doesn't seem to fit into the concept of a payment, shipping, or order total module. Should I add a field to the customers table? Can anyone point me in the direction of a contribution that does something similar?

 

Thanks!

[jbehen]

I need to add a 'customer code' field to the checkout process. At order process, I need to verify this code against a lookup table of approved customers. Depending on the result, I'll take various actions. I'm a decent programmer so I don't need programming help per se...

 

My questions is, what is the best method to implement this? It doesn't seem to fit into the concept of a payment, shipping, or order total module. Should I add a field to the customers table? Can anyone point me in the direction of a contribution that does something similar?

 

Thanks!

 

Is this a code that would change frequently, similar to a coupon code? Or would this be a code unique to the customer, that stays the same for that customer on a semi-permanent basis?

 

If the former, I would make it part of the checkout process. If the latter, I would add a field to the customer table, and make it part of the setup process for the customer.

 

That's my 2 cents, unless I am misunderstanding something.