Creating Custom Customer Fields

Custom customer fields can be a little daunting to implement, due to the fact that each customer is a collection of integrated sections. However if this is a step that needs to be taken, well here is the process that I have followed, helped by many online tutorials.

Administrator View

Administrator -> Customers -> Manage Customers

Select a customer from the grid.

On the left hand side there will be a section Customer Information, select Addresses. The Edit Customer’s Address will not be viewing the new customer fields and this will be visible by making entries into customer_eav_attribute for each of the custom fields to be inserted.

Example DB entry:
INSERT INTO ``.`customer_eav_attribute` (`attribute_id`, `is_visible`, `input_filter`, `multiline_count`, `validate_rules`, `is_system`, `sort_order`, `data_model`) VALUES (‘‘, ‘1’, NULL, ‘1’, NULL, ‘0’, ‘0’, NULL). The 2 values attribute_id () and is_visible (1) will be set as required, and the other values should be default.

Once this entry has been made it should be possible to see the values in the form. However it will probably be necessary to change the DB sort order for the new custom fields to position them on the form.

Resources:
Add custom fields to magento customer address

Leave a Reply

Your email address will not be published. Required fields are marked *