Ever wondered how I calculate postage costs? Well, I just decided to automate it. What fun.
=IF(F10 < =1;(((D10-(D10-C10)/2.7)-0-((D10-(D10-C10)/2.7)*0.034)-0.13-0.66-0.2)*0.091)+0+((D10-(D10-C10)/2.7)*0.034)+0.13+0.66+0.2;(((D10-(D10-C10)/2.7)-0.1-((D10-(D10-C10)/2.7)*0.034)-0.13-0.66-0.2)*0.091)+0.1+((D10-(D10-C10)/2.7)*0.034)+0.13+0.66+0.2)
That's how :) A mario star to anyone who figures out what even one of those values represents :) Extra stars to someone who can tell me how to refactor the damn thing to stop code reuse :(
Update: Yay for comp sci training.
Update 2: Had someone ask about this again last night. So instead of fancy looking spreadsheet stuff, here's the actual equeation, lest I ever forget it :)
T = Ta + Tb
Ta = I + E + P + Ps + Pp
Tb = V * 0.091
T is total P&P field price.
Ta is all fees other than eBay final value percentage (10%), being:
I = insertion (0.05 or 0.10p)
E = the envelope (13p)
P = postage (66p)
Pp = PayPal percentage (3.4% of the total item value)
Ps = PayPal set fee (20p)
Ta is ebay percentage fee. This is calculated by taking Ta away from the total projected selling cost ( Value, V) then timsing the remainder by 9.1%. This should be 10%, but I need to take in to account that preferably I need to know Tb before I can calculate what Tb is. Which isn't possible without a multi-pass algorithm. Which I don't know if I can do in a simple spread sheet. Luckily for almost all items it's just about 0.9% of V-Ta. Meh, I'll never remember what that means...
Anyway, escentially it moves all fees, postage, packaging and payment processing costs in to the P&P field to ensure extra fees aren't charged on top of other fees. 10% is enough, ebay. You can forget getting another 10% of that 10% (ie. 11%). Especially as you've pretty much forced the UK in to giving you a further 3.4% + 20p for everything.
And as it's constantly annoying seeing people complain about this all over the place, excuse me while I rant. My (and many other's) starting bid values plus P&P never exceed the current market value (well, not unless CeX's value does, only 1 game does though afaik, fable ftw!). The total value is then left up to bidders. If you want to bid the market value *and* pay postage on top of that, that's your choice, not mine. eBay's fees and your inevitable choice to use PayPal are generally what's causing you an extra ~15%. Still, if you'd like to make an offer on items on the Buy page here, you may claw back some of that 15% :)