There are three text boxes for Address under Customer Address
In which table can I find these three fields? I want to access this info so I can extend the Sales Order Grid with a column populated with data from the 3rd Address Textbox.
Solved! Go to Solution.
By Default Customer address is an EAV attribute so any all the field with customer address is saved into one of the below table based on field input type.
customer_address_entity customer_address_entity_varchar customer_address_entity_datetime customer_address_entity_text customer_address_entity_int customer_address_entity_decimal
Main Entry placed inside customer_address_entity table and they related to one of the other varchar,int,datetime,text or decimal table with saved their field value.
So you cant find exact field name with input type in customer address.
Ok so here is what we're trying to achieve:
We already have a drop down of areas per city for customers to select when they create their account - select a city and then start typing the area and select from a list and save...
now this is visible in the 3rd address textbox under the customer page in admin
is there anyway to retrieve this piece of info as a column in the sales order grid?
does the above make any sense?
Kindly check below links for your query,
This might be help for you.