Jump to content

Customer addresses, ps_address


joho

Recommended Posts

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)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...