Magento 2.2.5 - what are the mysql tables where shipping and billing address is stored?

Clash Royale CLAN TAG#URR8PPP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
2
down vote

favorite

I want to know the name of the tables where the Shipping and Billing addresses are stored in Magento 2.2.5 for the registered customers

database php-7 magento-2.2.5

share|improve this question

asked 1 hour ago

Usman Yousaf

727

add a comment | 

up vote
2
down vote

favorite

I want to know the name of the tables where the Shipping and Billing addresses are stored in Magento 2.2.5 for the registered customers

database php-7 magento-2.2.5

share|improve this question

asked 1 hour ago

Usman Yousaf

727

add a comment | 

up vote
2
down vote

favorite

up vote
2
down vote

favorite

I want to know the name of the tables where the Shipping and Billing addresses are stored in Magento 2.2.5 for the registered customers

database php-7 magento-2.2.5

share|improve this question

asked 1 hour ago

Usman Yousaf

727

I want to know the name of the tables where the Shipping and Billing addresses are stored in Magento 2.2.5 for the registered customers

database php-7 magento-2.2.5

database php-7 magento-2.2.5

share|improve this question

asked 1 hour ago

Usman Yousaf

727

share|improve this question

asked 1 hour ago

Usman Yousaf

727

share|improve this question

share|improve this question

asked 1 hour ago

Usman Yousaf

727

asked 1 hour ago

Usman Yousaf

727

asked 1 hour ago

Usman Yousaf

727

727

add a comment | 

add a comment | 

2 Answers
2

active

oldest

votes

up vote
2
down vote

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
  – Usman Yousaf
  53 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
  – Ansar Husain
  47 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  42 mins ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you check in admin to open your customer and check billing and shipping address that means first name is blank there
  – Ansar Husain
  40 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
  – Usman Yousaf
  35 mins ago
  

  
  
  
  

add a comment | 

up vote
1
down vote

customer_address_entity is the table where customer address is stored for registered customers. however if if customer is not logged in and for guest checkout address is stored in quote_address table.

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you please check this? magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  24 mins ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f242819%2fmagento-2-2-5-what-are-the-mysql-tables-where-shipping-and-billing-address-is%23new-answer', 'question_page');

);

Post as a guest

Name Email

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
2
down vote

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
  – Usman Yousaf
  53 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
  – Ansar Husain
  47 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  42 mins ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you check in admin to open your customer and check billing and shipping address that means first name is blank there
  – Ansar Husain
  40 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
  – Usman Yousaf
  35 mins ago
  

  
  
  
  

add a comment | 

up vote
2
down vote

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
  – Usman Yousaf
  53 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
  – Ansar Husain
  47 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  42 mins ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you check in admin to open your customer and check billing and shipping address that means first name is blank there
  – Ansar Husain
  40 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
  – Usman Yousaf
  35 mins ago
  

  
  
  
  

add a comment | 

up vote
2
down vote

up vote
2
down vote

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

share|improve this answer

share|improve this answer

answered 1 hour ago

Ansar Husain

1,286217

answered 1 hour ago

Ansar Husain

1,286217

answered 1 hour ago

Ansar Husain

1,286217

1,286217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
  – Usman Yousaf
  53 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
  – Ansar Husain
  47 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  42 mins ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you check in admin to open your customer and check billing and shipping address that means first name is blank there
  – Ansar Husain
  40 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
  – Usman Yousaf
  35 mins ago
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
  – Usman Yousaf
  53 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
  – Ansar Husain
  47 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  42 mins ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you check in admin to open your customer and check billing and shipping address that means first name is blank there
  – Ansar Husain
  40 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
  – Usman Yousaf
  35 mins ago
  

  
  
  
  

Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
– Usman Yousaf
53 mins ago

Do you have any idea like where are the rules like is_required for a specific field i.e. first name for the shipping and billing address are stored?
– Usman Yousaf
53 mins ago

these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
– Ansar Husain
47 mins ago

these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes
– Ansar Husain
47 mins ago

Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
– Usman Yousaf
42 mins ago

Actually, I am facing a problem.. The problem is when a registered customer proceed to place an order and click the place order button on the store he gets an error showing. "Please check the shipping address, First name is a required field". But for the guest customer it works fine without any issue.. Please check this: magento.stackexchange.com/questions/242554/…
– Usman Yousaf
42 mins ago

can you check in admin to open your customer and check billing and shipping address that means first name is blank there
– Ansar Husain
40 mins ago

can you check in admin to open your customer and check billing and shipping address that means first name is blank there
– Ansar Husain
40 mins ago

I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
– Usman Yousaf
35 mins ago

I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer..
– Usman Yousaf
35 mins ago

add a comment | 

up vote
1
down vote

customer_address_entity is the table where customer address is stored for registered customers. however if if customer is not logged in and for guest checkout address is stored in quote_address table.

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you please check this? magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  24 mins ago
  

  
  
  
  

add a comment | 

up vote
1
down vote

customer_address_entity is the table where customer address is stored for registered customers. however if if customer is not logged in and for guest checkout address is stored in quote_address table.

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you please check this? magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  24 mins ago
  

  
  
  
  

add a comment | 

up vote
1
down vote

up vote
1
down vote

customer_address_entity is the table where customer address is stored for registered customers. however if if customer is not logged in and for guest checkout address is stored in quote_address table.

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

customer_address_entity is the table where customer address is stored for registered customers. however if if customer is not logged in and for guest checkout address is stored in quote_address table.

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

share|improve this answer

share|improve this answer

answered 59 mins ago

Naveed

1,7531212

answered 59 mins ago

Naveed

1,7531212

answered 59 mins ago

Naveed

1,7531212

1,7531212

• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you please check this? magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  24 mins ago
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  can you please check this? magento.stackexchange.com/questions/242554/…
  – Usman Yousaf
  24 mins ago
  

  
  
  
  

can you please check this? magento.stackexchange.com/questions/242554/…
– Usman Yousaf
24 mins ago

can you please check this? magento.stackexchange.com/questions/242554/…
– Usman Yousaf
24 mins ago

add a comment | 

 

draft saved

draft discarded

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f242819%2fmagento-2-2-5-what-are-the-mysql-tables-where-shipping-and-billing-address-is%23new-answer', 'question_page');

);

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Name Email

Name

Email

Name Email

Name

Email