HI All,
I'm wondering if anyone has any advice on how to output
>All customers, plus their postcode and country
>Who have booked a,b,c,d production seasons
>Their order number
>Each item in that order
>how many tickets for each item
Note: I don't seek totals across a production season or a particular postcode. I need each order number listed out separately, with each performance under that order listed. If a customer has multiple orders, I need them separately listed.
Any advice would be truly appreciated. I feel like SQL might be the way to go?
(My non-sql approach: I have outputted single order listing against a list of people with the production seasons in their basket w/n the date range. I"ve then cleaned up this excel export for false positives, then imported the list of constituents back into a list, then output their address info. I've then combined the list.
It's given me a pretty good result. But it's complicated that some orders will have n/a performance in their basket, such as transport.)
Thanks in advance for thoughts and ideas.
I believe the standard Order Export Utility provides all the data you're looking for. Even though it's called a utility it doesn't update any data so it's safe to pull as often as necessary
Hi Ronan,
Would you care to provide an example (i n an Excel spreadsheet?) of what you need the output to look like? I'm working on something similar and what I'm doing might suit you....
MArtin
Hi Martin it would look along the lines of the above
Does it include unpaid sub lineitems?
Feel free to email me directly at martin.keen@nida.edu.au
Martin