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


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.

| improve this answer | |

There are tables where stored these address



| improve this answer | |
  • 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 Sep 19 '18 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 – Ansar Husain Sep 19 '18 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/… – Usman Yousaf Sep 19 '18 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 – Ansar Husain Sep 19 '18 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.. – Usman Yousaf Sep 19 '18 at 8:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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