Page 1 of 1

Questions for Table phocacart_order_users

Posted: 21 Feb 2025, 19:00
by elisa
Hi!
I am building a very customized Order Export and there is the table phocacart_order_users I see that in that table the order_id are not unique and in one Line the user data is stored an in another line not.

Can you explain what the table exactly collects and why the order_ids are not unique?
thanks
Elisa

Re: Questions for Table phocacart_order_users

Posted: 21 Feb 2025, 20:50
by Jan
Hi,

the id is auto increment id for this table
the id_order is reference to order table

When you see two items with the same id_order, this means that the:

- one row is for storing user billing address
- and the second row is for storing user shipping address

Internally, type = 0 ... is for storing billing address, type = 1 is for storing shipping address

Image

Image

Jan

Re: Questions for Table phocacart_order_users

Posted: 24 Feb 2025, 15:57
by elisa
Perfect Thank you Jan! Explains a lot of my issues :) Now I can build the export better.

Re: Questions for Table phocacart_order_users

Posted: 27 Feb 2025, 01:58
by Jan
OK