Workflow for Event Orders?

[Biomech]

Good morning all

I'm just going through the process of ordering prints for one of my events and I'm positive theres a better workflow here and would like your opinions.

For this particular event, I shot the day then gave the organiser (charity) a disc of los res images and an order form which listed all of the prints. The organiser then spoke to the members over time and filled the form in with the required prints for each image number.
Sitting at the computer now I'm having to cross reference the sheet with the Lightroom gallery and pick out the required photos.

I got around 50 orders this time, but I can foresee this being very time consuming for bigger events. How does everyone here go about the task? Is there any software that can import a csv/xls spreadsheet of image names and filter the gallery based on that?

Thanks for your time

[Jim Poor]

I use Photo Cart for my events. It's better and far less expensive than other carts on the market.

Using a cart will also keep you from having to burden the organizer with handling your ordering process. I can't imagine that going over well in most cases.

When an order is placed in the cart, you can export the file names to a text document and then paste them into the search field in LR.

Paper orders are a huge pain if you do any sort of volume.