Adding fields to Customers Table

[chadderuski]

I have added a new field to the CUSTOMERS table so I can add their company account number from our main system to their online account profile.

I am able to edit and save the new field while editing the customer's info from within the admin. This is fine, and preferable.

What I need now is to load this field so that I can add it to e-mails and orders.

It looks like this customer info is loaded in login.php ... it that correct, or is there some other location I need to use?

Some direction would be very helpful! Thank you!

-chaddro

[chadderuski]

I have managed to solve this myself I believe.

I edited the 'includes/modules/pages/login/header_php.php' and added the
field to the database query, and added it to the $_SESSION[] variables.

This way I can access the variable with $_SESSION['customers_acct_no'] anywhere I need it (namely checkout and e-mails).

Not so hard after all!

[bifficus]

Hi, I found your thread while trying to do something like you.

I think I missed a simple part of your process:

I added a field to the customers table as well, but it doesn't show up for me in admin. When I click on any of the customers... no luck. The field isn't there.

What am I missing?

Thanks!

[Tharina]

bifficus did you find an answer... I have the same problem