Address IDs in Order Table

Question related to upgrade from v2 to OC v4.0.2.3

When converting data from previous versions, in oc_order we now have payment_address_id and shipping_address_id.

1. As far as I can see, not creating these IDs does not cause any issues for historical orders. Is this correct?

2. Does anyone have a handy bit of SQL that can be used to query address table and assign these IDs?

Thanks

redactuk wrote: ↑

Wed Jun 26, 2024 6:43 pm

Question related to upgrade from v2 to OC v4.0.2.3

When converting data from previous versions, in oc_order we now have payment_address_id and shipping_address_id.

1. As far as I can see, not creating these IDs does not cause any issues for historical orders. Is this correct?

2. Does anyone have a handy bit of SQL that can be used to query address table and assign these IDs?

Thanks

Yes, from what I understand, the address_id column in order table for OpenCart 4 is not required, you can just set it to 0.

For reconciling address IDs with the actual addresses, you could probably just run a SQL query to match all fields, i.e. address_1, address_2, country_id, city, zone_id, etc. But there could also be a possibility that addresses have duplicates so it could return multiple IDs as well. I would suggest to just ignore the address id.

Thanks for reply.

Yes, we've done some further testing and nothing seems to break if ID is not present.
As you suggest, we'll write some SQL at some point to see if we can populate them.