Skip to content

customer_address_id is null on orders and quotes #3645

@sengaigibon

Description

@sengaigibon

Not sure if this is an issue..:
On checkout:
Step 1, customer already has addresses, but I create a new one for shipping.
Step 2, I chose a different billing address from the address book.
I finish the checkout without problems.
The new address is in the table customer_address_entity, visible in the customer's address book, no problem.
But if I look into the database, tables quote_address and sales_order_address, the entry for the last billing address is there but in both cases with the field customer_address_id is equal to NULL, is this normal??
I don't think this represent a problem. In the backend if I look into the order, I can see all the details of both addresses ('cos this data doesn't come from customer_address_entity, right?).

I added custom fields 'city_id', 'district_id' and 'district' to table customer_address_entity, and only field 'district' to quote_address and sales_order_address, but I don't have problems storing the data into these tables.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Issue: Format is not validGate 1 Failed. Automatic verification of issue format is failed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions