Okay, I've ordered a few sets from Bricklink over the last year or two and that's a piece of pie. I'm now trying to make some orders for pieces to be filled by a store or three and it's hard work. I'd like to know how others go about this because unless you're after some general pieces, it takes ages. What do you do to compare prices and shipping to find a price you're happy with?
I'm having a stab at this project (finally) so I'm after about 60 different pieces of varying quantities ranging from 1 to 40 (sadly more 1's and 2's than anything else). I have a spreadsheet that has the Peeron part numbers and descriptions as well as the quantity in each set and a total. I have then listed a few stores and their prices, shipping and naturally I need to be mindful of store requirements like average lot price etc.
It's quite a lot of work (not entirely surprising) so I'm wondering if there's a better / smarter way I can go about this (as well as being generally interested in how others go about this)?


