Custom report with modifiers separated per listing

[afpoklahoma]

I have an event and I've included modifiers for each ticket (Food Allergies and ID number). I'd like to run a report that shows me the sale with the modifiers in separate columns. Is that possible?

[ryanwanner]

Hello @afpoklahoma !

With this report, do you need a summary of all the modifiers ordered, or are you needing it broken down per transaction?

If it's the summary, you should be able to get everything you need at Dashboard -> Reports -> Modifier Sales.

If you need it broken down by individual sale, it'll take some hoop-jumping.

Head to Dashboard -> Transactions. Choose the date range you need, then click the Export button in the top right. Choose Items Detail CSV.

When that report loads, you will have a list of every item ordered for your date range. The modifiers will be listed in their own column separated by a comma. One other column will have the customer's name listed as well.

It's not an elegant solution, and someone smarter than me probably has macros for parsing only the data you need, but it's a start!

Hope this helps