Home » Forums » Ubercart » Support
2 replies [Last post]
Tue, 12/16/2008 - 14:42
mach5_kel
mach5_kel's picture
Offline
Joined: 03/25/2008
Juice: 79
Was this information Helpful?

It is possible to show all the customers who purchased a product?

Ie. I sell live seminars. One of them got cancelled. Now I need a list of the customers who bought this one specific seminar (store product). But I am having trouble coming up with a list. And going through every single order is going to take a very very long time :S

Thanks!

-Eric

Top
Wed, 12/17/2008 - 18:36
#1 View page
mikejoconnor
mikejoconnor's picture
Offline
AdministratorBug FinderGetting busy with the Ubercode.
Joined: 08/07/2007
Juice: 536
Re: List Customers by Products They Purchaced

Although it isn't the most user friendly method, I would simply run a database query

SELECT * FROM uc_orders o JOIN uc_order_products p on o.order_id = p.order_id WHERE p.nid = 42

Replace 42 with the the nid of the product(seminar) that was canceled.

Commerce Guys | Ubercart Development | Ubercart Training

Top
Wed, 11/24/2010 - 14:47
#2 View page
mach5_kel
mach5_kel's picture
Offline
Joined: 03/25/2008
Juice: 79
Hello, No solutions for this

Hello,

No solutions for this one hey? I never managed to find one myself.

Now I have another client asking for the same thing. They are selling "courses" as products, and need a list of users who purchased the course.

This seems like something that should/would be straight forward. But alas, it is not? Havent other uber-users wondered, which users bought product xyz before? And wanted to have a quick look?

Top