We keep on trying to improve things here at Carvalho Custom to make things easier for our clients, so we have brought out a new excel order form that will allow the person who puts the order together for a club to easily add together all the individual orders received from club members.
So the idea is that the club clothing administrator will receive a load of orders from club members, which s/he will input one by one into our new order form; then when this is finished, s/he presses a button and all the individual orders are added together to make a total club order, which can then be emailed to us to produce. The order form can also be used in the traditional way of just inputting a total order for a club or organisation – the system is just more user-friendly than a standard order form and it will automatically calculate the final price for you based on the total quantities ordered.
So the order form performs three roles – it provides a convenient way of recording the individual orders of club members, it saves you the hassle of having to consolidate the individual orders into a total order and it will automatically calculate the final total price and the price for each individual. You can download the new order form here (please make sure you activate the macro when you start, by clicking on the option when prompted – you will get a security warning when you do this, but it is completely safe!).
When you download the order form (it is in excel), the first thing you should do (once you have activated the macro) is to click on the instructions button, although it should be reasonably self-explanatory. You can click on the red triangles scattered round the order form for further instructions.
Essentially the way it works is that you first select the items that you intend to order, then you can choose either input the total club order in one go, or you can input all the individual orders from the club using the ‘Add Multiple Orders’ button . You then just hit the ‘Calculate Total Price’ button and the program will finish off the order form for you.
This is a new system for us and we are sure to need to make some changes, so please let us know what you think!