I have been trying to search for a module that fits my need, but I haven't found one special module doing what I want.
I have a website for my university parliament and we are planning on selling university clothing. What I want to do, is to make an order form where people can type in their names, phone numbers, select their class, and their order, and then send them an e-mail with an order confirmation. Payment should not be an option with this module, as that will be handled externally, and filled in the database by a moderator as soon as the payment have been fulfilled.
It should also be possible to search for a particular order when the students come to pick it up, and mark that order as completed.
Webform is a the closest module I have found for this, but the problem is that I haven't found a way of being able to process all the raw data that I get in, as well as being able to search for an e-mail address/phone number or so on to find that particular order and see what kind of clothes/size that particular student have ordered. It should also be able to sort orders by for example size (for example only by sweater S, sweater M, sweater L, sweater XL and so on), or by class (1st year group A, 1st year group B and so on).
By using webform I managed to make the order form and get the raw data, to something like this: