cancel
Showing results for 
Search instead for 
Did you mean: 

customer address fields in database

SOLVED

customer address fields in database

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.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: customer address fields in database

Kindly check below links for your query,

https://magento.stackexchange.com/questions/45572/how-to-add-customers-shipping-address-detail-in-ad...

 

This might be help for you.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

View solution in original post

3 REPLIES 3

Re: customer address fields in database

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.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: customer address fields in database

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?

Re: customer address fields in database

Kindly check below links for your query,

https://magento.stackexchange.com/questions/45572/how-to-add-customers-shipping-address-detail-in-ad...

 

This might be help for you.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial