Forum
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
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?
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?
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!