Forums / Managing Customers and Orders / I need a special report, customers and products

I need a special report, customers and products

Locked

Views: 1,101

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
27 Jan 2008, 5:58 AM
#1
weeblesue avatar

weeblesue

New Zenner

Join Date:
Oct 2007
Location:
Houston, Texas
Posts:
26
Plugin Contributions:
0

I need a special report, customers and products

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

28 Jan 2008, 10:14 PM
#2
wolfsz avatar

wolfsz

Zen Follower

Join Date:
Mar 2006
Location:
Australia
Posts:
286
Plugin Contributions:
3

Re: I need a special report, customers and products

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

Wolf Skafte-Zauss
http://e-commerce-pros.com
Tools for E-commerce Professionals