Questions for Table phocacart_order_users

[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

[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





Jan

[elisa]

Perfect Thank you Jan! Explains a lot of my issues :) Now I can build the export better.

[Jan]

OK