Customer addresses, ps_address

[joho]

The ps_address table hold addresses. And it seems like if a customer (or admin) changes an address, it will create a new record for the changed address, and update the "deleted" column to a value of '1'. The "active" column doesn't seem to change, however, I've only found values of '1' in there.

Can someone confirm that this is how PS works?

Also, it seems like when orders are created, the ORIGINAL record number (id_address) is used in ps_orders.

How is that supposed to work.

I have four addresses for customer '2' in ps_address. The first one has an "id_address" column value of '3'. It seems like all orders I create while logged in as that user are created with an "id_address" column value of '3'. But that record is flagged as deleted. My currently active address is on record '11'.



(It's so sad that there aren't better developer and API docs available)

[joho]

Looking at this .. I'm thinking this could quickly get out of hand.

A new order that I create does indeed get the correct record number for the address record. PS does, however, not update exisiting non-invoiced orders with address changes.

[Burhan BVK]

Once a customer checks out, they can not change the address. The updated address can only be used in the new orders. That is why a new entry is created each time you update an address.
Only the admin can change the address in an existing order.