Sell tickets and provide unique identifier

I want to sell tickets to a conference and associated events and want to generate an email that includes a unique identifier that the attendees could bring to the event and show they paid. I see there is such an identifier on the invoice or payment table - item_number, but this includes all items purchased in that transaction, which gets confusing. Is there a way to use the Presentation tab on the Plan to send an email with the item_number on it upon payment?

Thanks

The substitutions available for the presentation tab emails are under "Substitutions in Thank You messages and workflow Emails" fieldset on the same tab. As far as I'm aware you've no access to item_number there since that's unique to the basket and those presentation tab emails are unique to the plan.

Best I can suggest is probably querying for their most recent basket using CB Query Field then substitute that field into the email. Since all this happens at once it should be 100% accurate. Example of this shown below.

www.joomlapolis.com/forum/255-developer-members-support/236273-adding-transaction-number-to-email?start=6#292421

The query field isn't working for me, just gives an empty result. I tried the query directly using phpmyadmin and it does give the expected result. My guess is there is a synchronization problem. I think I can just use the invoice system to provide members with the unique number. It would be nice to make the email option work, is it possible to email the invoice, couldn't find anything about how to do that.

The query in that topic gives the invoice id for the most recently paid basket. You may need to adjust it as the basket may not be paid yet depending on what email you're sending it in. Specifically removing "AND `payment_date` IS NOT NULL" should remove that condition.

I thought that might be the issue so I tried but that did not work either.

My apologies - I screwed up where I put the query! I put it in the validation section under integrations instead of under the parameters section under query. Works now, but there is an issue when people purchase more than one item in a single transaction, as item_number includes all of them, not just the one for the plan that generates the email: for example S837-927-19,M24-927-18. Don't know if there is a way around this one, though they do get split out when the invoice is generated.