Sell tickets and provide unique identifier

Each purchase row in a basket is given an item number. There's no avoiding that as it's simply how it works. So if you query for that from the most recent basket you'll get all of them if there's multiple. It maybe better to use the invoice instead of item_number.

It looks like the invoice is the way to go but I cannot find a way to automatically email the invoice to the user. I know it is available on the profile but I would like insure the user gets it without taking additional action on their part. This seems like an obvious thing to do but I couldn't find it in the manual or the admin panel for cbsubs.

You'd just substitute in your query field. That should send the correct invoice for their most recent basket.

sorry to be dense but do you mean construct my own formatted invoice using all the fields in payment basket or is there a way to get the same invoice that the user sees when they look on their profile?

The invoice number the user sees is the same one the query provided will retrieve. It's stored with the basket. Examples as follows.

Most Recent Paid Invoice #:
Most Recent Invoice # (regardless of state):

Unless I'm missing something your query will return the invoice number, I would like to email the invoice itself, what a user sees when they go to their profile and clicks on "Click here to view the list of invoices"