eBay

selective_distribution · ‎14-02-2025

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 · ‎19-05-2025

Ultimately Ebay certainly doesn't seem to care about anyone really understanding this fluently, with private sellers especially being able to work-out what is going on with pricing. They've effectively ruined rounded pricing on most private sales listings (whether that's 6.00, 5.99. or 5.95 per seller preference), as most sellers have absolutely no idea on what the finished price will be on listing, which all makes the site look and feel shabby and naff.

Buyers are also affected when bidding, not understanding whether they're bidding with or without the BPF included half the time. All equalling less sales in the confusion.

And to make matters worse, Ebay fail to comment on ANYTHING properly... on the Wed thread staff chat, they keep saying 'we're looking into this', or 'we'll get clarification on this' – it's all one-dimensional platitude type answers to keep sellers sweet hoping for future answers, but no actual answers.

paulh5038 · ‎17-06-2025

Yes, this tool is perfect for our needs but the link isn't working. If the member who posted it could re-post, many would be most grateful.

paulh5038 · ‎17-06-2025

That works well. Thanks.

txt.ltd · ‎10-07-2025

@sml192 wrote:
@txt.ltd wrote:
Any price can be calculated using:

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

Every cost is either fixed (£) or variable (%)
That formula doesn't work as it just applies all of the variable costs to all of the fixed costs which isn't the case.

Yes, it works every time. It indeed applies all variable costs to fixed costs, which is the ultimate point of variable costs. Show me how it doesn't work with an example?

jimthing · ‎17-07-2025

@jimthing wrote:
@4_bathrooms wrote:

=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
AFAICS this works for all figures now – great work!

Though for others using this, you may have to change the figure in red above to be anywhere from 0.70 to 0.75 to be accurate with what Ebay shows.

Looks like this needs updating, for listings post-Wed.06.Aug.2025, per today's (Thu.17.Jul.2025) email on changes to policy ("Get paid faster and a lower buyer fee"):

Quote:

1. From 6 Aug, you’ll also receive your funds within 24 hours of the buyer paying.

2. We’ve now reduced the fixed portion of the Buyer Protection fee from £0.75 to £0.10. Buyers still pay the fee and it’s included in the item price, so there are no surprises at checkout. Here’s how it’s calculated:

• Flat £0.10 per item.
• 7% of item to £20.
• 4% portion of item £20 to £300.

• 2% portion of item £300 to £4000.
• 0% portion of item >£4000.

Also:

When your buyer purchases multiple identical items in the same order, they only pay the flat fee once.

A live calculator is coming soon, where you’ll be able to enter a price and see the Buyer Protection fee in real-time, so you’ll know exactly what your buyers will pay. When making or reviewing offers, you’ll also see the fee split out from the total item price.

From today, you’ll be able to see the updated rates on your listings, and will notice the greatest impact on items priced £10 or less. If you have any active auctions and offers, they’ll continue to include the existing rates.

So can someone update the original calculation below, please!:

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

Thanks in advance.

jumberella · ‎17-07-2025

Hi

Yes I saw this. EBay might have lowered the fee by reducing the flat fee from .75p to .10p but they have increased the protection fee from 4% to 7% on items up to £20 in value. That is not a reduction.

I immediately rang eBay to question how can 7% be a reduction and it was explained to me by the operative that in real terms the .10p plus 7% on an item costing £20 was 5p less than the previous total fee of .75p plus 4% so it is a reduction. Ha. Thanks EBay. I asked that my complaint be recorded as this is a minute reduction dressed up as something else.

I also said that eBay community had already developed calculations to make it easier for sellers to process if they wanted to absorb the protection fee rather than have items listed with odd amounts added to their listing price. EBay is a bit late providing a tool to determine the fee. By doing this it implies that eBay expects sellers to absorb the fee so it’s a ‘reintroduction’ of seller fee by another method or listing prices greater than the seller will actually achieve.

I’ve lodged my complaint. Maybe others will do the same.

Regards
Jumberella

Sent from my iPhone

jimthing · ‎17-07-2025

NOTE: It's just the spreadsheet calculation we want on this thread, please.

Other threads discuss the pros/cons of it.

jumberella · ‎17-07-2025

All too complicated for me.

Just wanted to pass on my experience to be helpful to others. I do mention eBay are providing a fee calculation tool. The new fee structure will alter any original calculation.

Make of it what you will.

Sent from my iPhone

sml192 · ‎18-07-2025

@jimthing wrote:
@jimthing wrote:
@4_bathrooms wrote:

=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))
Looks like this needs updating, for listings post-Wed.06.Aug.2025, per today's (Thu.17.Jul.2025) email on changes to policy ("Get paid faster and a lower buyer fee"):

Quote:
1. From 6 Aug, you’ll also receive your funds within 24 hours of the buyer paying.

2. We’ve now reduced the fixed portion of the Buyer Protection fee from £0.75 to £0.10. Buyers still pay the fee and it’s included in the item price, so there are no surprises at checkout. Here’s how it’s calculated:

• Flat £0.10 per item.
• 7% of item to £20.
• 4% portion of item £20 to £300.
• 2% portion of item £300 to £4000.
• 0% portion of item >£4000.

So can someone update the original calculation below, please!:
=IF(A1<=300,ROUND((A1-0.72)/1.04,2),ROUND((((A1-312)-0.72)/1.02)+300,2))

Thanks in advance.

This should work, although as before may be slightly out due to roundings:

=IF(A1<=20,ROUND((A1-0.10)/1.07,2),IF(A1<=300,ROUND((((A1-21.40)-0.10)/1.04)+20,2),IF(A1<=4000,ROUND((((A1-312.60)-0.10)/1.02)+300,2),ROUND((A1-86.60)-0.10,2))))

jimthing · ‎18-07-2025

@sml192 wrote:

This should work, although as before may be slightly out due to roundings:

=IF(A1<=20,ROUND((A1-0.10)/1.07,2),IF(A1<=300,ROUND((((A1-21.40)-0.10)/1.04)+20,2),IF(A1<=4000,ROUND((((A1-312.60)-0.10)/1.02)+300,2),ROUND((A1-86.60)-0.10,2))))

@sml29 - Many thanks!

Boy is that long. How the heck do you work these things out...any tips? Lol!

Will have to give it a go to see if it works, after the new system kicks in. Probably the highlighted bit in red will be anywhere from 0.07 to 0.10, as per the previous incarnation had to do – gee thanks Ebay for the over complication.

professor-yaffle · ‎19-07-2025

@sml29 - Many thanks. Been pulling my hair out trying to update my not very elegant formula for the the new fees. Yours is straight to the point. Don't suppose you have another formula to reverse it (i.e. put in the amount you want to get the amount the buyer will pay)? I do like a good excel formula but this is making my head hurt. Can I just copy your homework 😁