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

2 Answers 2


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.


There are tables where stored these address



  • 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? Commented Sep 19, 2018 at 8:13
  • these all fields are attributes and if you go in table eav_attribute you can see here is_required column for these attributes Commented Sep 19, 2018 at 8:19
  • 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/… Commented Sep 19, 2018 at 8:25
  • can you check in admin to open your customer and check billing and shipping address that means first name is blank there Commented Sep 19, 2018 at 8:26
  • I have checked the admin as well. And the firstname is already there in firstname field in the address section of customer.. Commented Sep 19, 2018 at 8:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.