2

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

Improve this question

2 Answers 2

Reset to default
4

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
1
6

There are tables where stored these address

 customer_address_entity

 quote_address

 sales_order_address
Improve this answer
6
  • 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, 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
    – Ansar Husain
    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/…
    – Usman Yousaf
    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
    – Ansar Husain
    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..
    – Usman Yousaf
    Sep 19, 2018 at 8:32

Your Answer

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

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