1. Game name. Accessories and consoles are split out and listed below the games.
2. Genre. Cos VGPC had it and I figured “why not…”.
3. Date, of last price update, cos I do them manually atm.
4. Minimum observed eBay price as of last update.
5. Maximum…
6. Profit from the minimum price when selling on eBay, currently with my own overheads included (ie. 9p envelopes, 33p 1st class (should-be-39p-but-i-bought-500-argh) stamps).
7. Recommended insertion (starting bid) price, based off CeX + fees on the CeX value.
8. CeX cash buy in price.
That’s what I’ve had in OOo Calc spreadsheets for the past year. And thanks to eBay’s new “free P&P for all in video game cats” due in 3 days, it’s now simple to calculate fees in a single equation, which is why I’ll now be using iGPC for all my postage/really-just-increased-starting-bid calculations. Don’t worry though, the public iGPC won’t have all the nonsense included, probably just a median eBay price and possible profits (based on widely available UK envelope and stamp costs). And it would be finished but for nearly 100 PS2 games getting listed yesterday.
EDIT: I stand corrected. Insertion (starting bid + fees) costs need multiple passes, that is – true starting bid (net profit) plus all fees (percentage (9% fvf + 3.4% pp) and set), then the fees need a second percentage (9% + 3.4%) calculating on them, then that second percentage needs percentage fees calculating on that, and you could go on forever but that three passes seems to get damn close.
Visualised, take a £4.00 value you want to make from an item. Calculate fees by:
(4 * 0.124) + .2 + .66 + .1 + .09 = 1.546
0.124 is 0.09 + 0.034, .2 is PayPal set fee, .66 is postage, .1 is eBay insertion, .09 is packaging. Then calculate percentage fees for those fees:
1.546 * 0.124 = 0.191704
And again:
0.191704 * 0.124 = 0.023771296
So your starting value would be 4 + 1.546 + 0.191704 + 0.023771296 = 5.7614753. Ish. And just for the proof, let’s work backwards:
5.7614753 – (0.023771296 + 0.191704 + 1.546) = 4.00 exactly.
See what I mean? No? Well you best just leave it to iGPC to work it out for you then 