New Fees calculation.

[selective_distribution]

OK, I understand that there are new fees applied, and I have just noted that an item I had listed at £9.99 is now listed at £11.11! The odd 11p makes it look a very unappealing price. I could list it at £10.99 and take the hit, but my question is .....do I now have to go through EVERY listing I have and adjust the price? What is the calculation in fees to do this? I guess I have to calculate the new fees in every new listing also.....is there a formula to calculate this? What a nightmare!......Thanks eBay!

[jimthing]

[Note: please ignore any post above; edited here with corrections!]

@superchallenge - Thanks again for attempting to answer. 

TBH, I'm not sure I completely follow. As I said above, your formula gave the fee at 13.75 but the actual correct fee was minus 30p at 13.45. I'm aiming at a getting to the final price hence starting with that cell in any formula is what is needed.  🤷

The way I've been doing it on items under £300 is using this formula (A1 being the cell with the FINAL PRICE you want to advertise the listing to be at): 

(A1-0.75)÷1.04

Then as Ebay say in the BPF cost guidance, as the 0.75 bit can be 'up to 0.75', you typically have to manually knock between 1 to 5 pence off that bit of the formula, so it can be anywhere from 0.70 to 0.75 in the above formula. But the formula gets you close enough to be able to quickly fiddle it into being correct. 

If it's possible for <£300 items, can my formula here be adapted to include the next two tiers too?...

Is there such a way that can do similar but include the 300-4000 tier and  >4000 nil-rated tier?

[txt.ltd]

---

@selective_distribution wrote:

OK, I understand that there are new fees applied, and I have just noted that an item I had listed at £9.99 is now listed at £11.11! The odd 11p makes it look a very unappealing price. I could list it at £10.99 and take the hit, but my question is .....do I now have to go through EVERY listing I have and adjust the price? What is the calculation in fees to do this? I guess I have to calculate the new fees in every new listing also.....is there a formula to calculate this? What a nightmare!......Thanks eBay!

---

The formula for any price is:

(sum of fixed costs) / ( 1 - (sum of variable costs as decimal) )

[superchallenge]

I don't really know what else to say. I explained why my initial formula gave the 30p extra in my second reply.

The example, instructions, and formula I gave in my second reply calculate a fee of £13.46 on a £349.99 item.

So if you want to list the item at £349.99, you take the calculated £13.46 from £349.99 and your starting price would be £336.53. The correct fee is £13.45, as you say...but again, that's due to a rounding issue. We don't know exactly how eBay is calculating it or dealing with rounding.

Obviously, you'd need to check the advertised prices and adjust as needed since the rounding might be adding or removing a penny, but this is probably as close as you're going to get.

[snappyfish]

Try this to help 

https://ebaybpfcalculator.netlify.app/

[jumberella]

Brilliant. Thank you.


Sent from my iPhone

[jimthing]

---

@snappyfish wrote:

Try this to help 

https://ebaybpfcalculator.netlify.app/

---

Doesn't work. Clearly setting my price £624.77 (i.e. way ABOVE the final price) is not correct. 

[snappyfish]

Maybe a bug, it worked for me showing £336.54 price needed to enter. 

[jimthing]

---

@snappyfish wrote:

Maybe a bug, it worked for me showing £336.54 price needed to enter. 

---

Works now. Weird. Maybe a temporary bug or something...? 

If only I could get a formula that works in Apple's Numbers app for Mac. 

[inspector_price]

The quick way to work back from buyer price to the price you should enter is:

1. Take off 72p (i.e. £10.99 - 0.72 = 10.27)
2. Then divide by 1.04 (10.27 / 1.04 = 9.87)

Bear in mind there are some amounts you cannot reach, like £13.99. I have tried.

For spreadsheet users, the formula you need is =SUM(K2-0.72)/1.04 where K2 is the listing price including buyer fees that you would like to see. In a spreadsheet that will get you back to the price you need to list at.

And yes, you'll probably have to adjust every listing unfortunately :((

[jimthing]

---

@inspector_price wrote:

The quick way to work back from buyer price to the price you should enter is:

---

We have a formula for items <300. We're asking for a formula that includes items between 300 to 4000 at 2%, and >4000 at nil percent. 

[jimthing]

I just asked on the weekly Seller chat for Ebay to give us a formula. Let's see if that happens or not! 

https://community.ebay.co.uk/t5/Chat-with-the-eBay-Community/Weekly-Chat-with-the-eBay-Community-Tea... 

" Hi @jimthing 

Thats a good suggestion, I can definitely see how it would help. I'll pass this over to the site team and ask if it's something they can implement or even add something to help pages that can do the calculation for you. 

Thanks,

Dave "

[jimthing]

I also asked: 

"Another suggestion would be to add the option to simply enter the FINAL price, instead of the pre-BPF price. "

https://community.ebay.co.uk/t5/Chat-with-the-eBay-Community/Weekly-Chat-with-the-eBay-Community-Tea...

+ 

"Can Ebay add the option to simply enter the FINAL price, instead of the pre-BPF price, on the listing page? 

So sellers can set the final price they want to sell at including the BPF.  "

https://community.ebay.co.uk/t5/Chat-with-the-eBay-Community/Weekly-Chat-with-the-eBay-Community-Tea... 

No response on those posts, though. 

[4_bathrooms]

I might provide an Excel/Calc formula soon incorporating an if/else statement for <£300 items (unless someone beats me to it).

To go back from a fixed amount for >£300 values:

((value - 312.72)/1.02)+300

So; if you wanted the final price to be £400:

((400 - 312.72)/1.02)+300 = £385.57

The first £300 is charged at 4%. For an item over £300 this will always be £12.00.

The fixed amount is (currently) 72p.

Add £300 to the two above then deduct from the amount you want to start with.

Divide what is left by 1.02 to subtract the 2% from the remaining amount over £300.

Then add 300 to that amount to arrive at the starting price.

[4_bathrooms]

Here you go:

=ROUND(IF(A1<=300,(A1-0.72)/1.04,((A1-312)-0.72)/1.02)+300,2)

Just replace A1 with the cell containing the value you want to show.

[jimthing]

---

@4_bathrooms wrote:

Here you go:

=ROUND(IF(A1<=300,(A1-0.72)/1.04,((A1-312)-0.72)/1.02)+300,2)

Just replace A1 with the cell containing the value you want to show.

---

Is the 0.72 correct, as I tested by randomly changing it to 0.50, and the answer shown remained the same? 

Also the answer was correct for >300 items, but tested using 24.95 and it gave 323.30 pre-BPF price??

[jimthing]

Maybe test the answers against the online calculator: https://ebaybpfcalculator.netlify.app  😉

[superchallenge]

Maybe just use the online calculator? 😉

Or pay a developer?

[jimthing]

lol. 

Why does Ebay have to make simple things so hard, one has to wonder if they ever consider their users with all the abysmal feature changes that screwed up a load of things that worked really well beforehand. 

[sticky-art-uk]

or stop worrying about a non existent problem.

We've changed nothing and still getting plenty of sales, a few pence and an odd number isn't going to put anyone off. If they want it they'll have it.

[superchallenge]

Of course you haven't changed anything. BPF doesn't apply to business sellers.