Hello,

I need to export orders only to get delivery name and address info for importing into my UPS software. The files downloaded have multiple, lines of duplicate customer info for customers who order more than one item in their order. I'm thinking it is cuased by this portion of the querry:

products_model as v_products_model,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values

Customers who order only one item, have only one line of data.

I have tried remming these lines out with "--" but when I do that the file comes back entirely empty, with only the column headers.

What can I do to not have duplicate customer data? For each order, I want ONE line, containing name, address, email, etc.

BTW I've discovered I need to pull delivery_XXXXX instead of customer_XXXXX for each of those fields and have fixed the code to pull that info I need for shipping address labels.

Thanks very much,

Greg