Adding Custom Field to Customer Table

[experimenter]

Hello to all
A new zencart geek is here.
I have installed it on my development server and and works fab.

I need to add a field to Customers table to store this customer's id (integer) from our ERP system.

I have seen the "Additional Customers Fields" add-on but it seems complicated will probably increase server overhead . I wondered if it is not easier to edit some forms/classes to add this functionality directly. This field will only be used in zen admin and a custom data export script. It will not appear in the customer shopping interface.

How many files need to be involved to accomplish this?
Are there any other add-ons with similar functionality?

Thank you for your advice in advance

[Twbeebe]

Hello, if all you need is ONE field to add your info, there is already an extra field inside to the /ADMIN/CUSTOMER/<Customer File> called "Suburb" ?? I have not found anything that addresses it externally, yet, only editable from the admin side.. You could probably find the code in the database, change it, change the code call name and page location to suit, or leave it as it and accept it's odd name ?

Personally I want to add some code to the Customer Sign Up Page to have them tell me what their County is, since California seems to Tax State, County, City, Transit Districts, etc.. I could reduce the Fat Overcharge on everyone else not living in the affected area(s), by a specific county's taxation laws.

Good Luck.

[Website Rob]

Here are some threads to wet your whistle.

http://www.zen-cart.com/forum/showthread.php?t=6888
Adding New Product_types

http://www.zen-cart.com/forum/showthread.php?t=88895
Adding new Field in admin for products

http://www.zen-cart.com/forum/showthread.php?t=57924
How-To: Add new Properties to your Products

[Twbeebe]

Here are some threads to wet your whistle.

http://www.zen-cart.com/forum/showthread.php?t=6888
Adding New Product_types

http://www.zen-cart.com/forum/showthread.php?t=88895
Adding new Field in admin for products

http://www.zen-cart.com/forum/showthread.php?t=57924
How-To: Add new Properties to your Products

Hello Website Rob, thank you for responding.. based on my original email to 'experimeter', above, I went in to find out why the catalog side was asking for "Address 2:" and why the Admin side showing "Suburb:".. turns out it was a coding, bug issue, correctable by me, so I acheived what I wanted and reported the bug which is at http://www.zen-cart.com/forum/showthread.php?t=109021.