Forum

Thread tagged as: Shop

Customer/Attendee list in perch_shop

One of the things we are trying to sell is tickets to events...

Wondering if there's a way to generate a list of attendees for an event. Each event is a product. So it would be generation a list of customers who purchased a particular product.

Thanks, Monty

Monty Lewis

Monty Lewis 2 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

At the moment you'd need to export the orders and process them externally.

Ok. I'll give that a shot. Thanks!

Actually, can you point me to which tables would get me there?

I would start with perch2_shop_order_items, look for the productID I need...

I see there's an orderID in that table... But which table has the orderID and the customerID so that I can get the names?

Drew McLellan

Drew McLellan 2638 points
Perch Support

In the Orders app there's an Export option. Use that!

Oh.

There's no reference to what was purchased in that export... So that doesn't help.

Am I missing something obvious?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Which export option are you using?

I see. I missed the significance of the first dropdown.

So I would output the 'Order items' and then output the 'Customer Addresses' then compare order numbers to see who is going to what.

Yikes.

Hi Monty,

I might be totally wrong but I think you can apply tags to a customer based on what products they have purchased. If this is not a figment of my imagination would this help?

Oh, that's an interesting thought! Let me follow that through and see if I can get a list from that. Thanks!