I need a special report, customers and products

[WeebleSue]

I need a listing of customers, what they ordered, and the attributes.

For instance,
Name##########__qty__item##########__attrib1__attrib2____total
Customer1___1___T-shirt1##########blue____large___$10.00
Customer2___1___T-shirt1##########red##########small___$10.00
Customer3___1___T-shirt2##########blue____large___$10.00
Customer4___1___T-shirt1##########black____XL____$10.00

I can get a customer list, total orders, and products ordered, but not customer + order + attributes.

I have searched the downloads and the things like SuperOrders don't do this.

Any help out there?
Thanks.
Susan

[wolfsz]

Hi there
This info is in the orders_products_attributes table. I assume you have written a SQL query to get the results you have achieved so far. You will need to add a join over orders_products and and order_products_attributes based on the orders_id. The only way to display the result however would be in several lines eg
Name##########__qty__item total
attrib1
attrib2

If you like post your query as it stands and I will post the changes you need mto make