eBay

gopetersen · ‎08-04-2018

This is not a combined-shipping overcharge.

This is something new. It APPEARS to be a miscalculation. The data was downloaded directly from eBay (.csv format).

Can anyone explain why eBay added $0.10 to the total?

Buyer Overcharged. Can anyone explain? Or is eBay miscalculating?

gopetersen · ‎08-14-2018

It just happened again and the two transactions have something in common. They are both within my home state.

If you add price + shipping + sales tax, it is less than the total eBay charged the buyer.

In the first instance (previous post), the buyer was overcharged by 1.3%, in the second, 1.8692%, so it's not a consistent percentage.

I set up my database so it flags me (puts up a big red icon) if the totals don't come out right. If eBay's math is wrong, I know right away. eBay could deliberately or erroneously overcharge by small amounts and many sellers would not notice for a long time (if at all). I want to know what this extra charge is.

eBay occasionally makes small changes to the .csv (usually without warning us), but it doesn't happen often, and I can't see a category in the .csv that accounts for this extra charge. According to the .csv figures, there were no COD or insurance charges.

What could account for an extra charge in varying percentages?

berserkerplanet · ‎08-14-2018

Tax on S&H applied inconsistently? Do you have it set up to tax S&H also?

Calculator charges buyer tax on s&h also, but shouldn't be and displays correct tax for item only in your dataset?

Something somewhat similar was happening to a seller in a PS forum thread a while back - buyer correctly charged sales tax on item price + s&h, but packing slip showing tax on only item price. No solid resolution even though eBay was aware. Maybe the fix moved the bug from the packing slip to somewhere else.

thatsallfolks · ‎08-14-2018

What was the amount of the payment that you received from the buyer?

What tax rate was applied to the purchase?

mikgile-39 · ‎08-14-2018

Perhaps Ebay is using a tax table with a set tax. A tax table can have minor variations from a actual percentage. That may be why when you do the math based off of percentage the total is .10 less than what the buyer was charged.

gopetersen · ‎08-15-2018

The tax is explicitly shown in the .csv file that we download from eBay, just as I illustrated in the first post. Those are eBay's numbers.

gopetersen · ‎08-21-2018

I am sick of doing eBay's troubleshooting for them. I am often the first to report a problem. Nothing gets done about it, then I finally figure out what's going wrong, post it and they get their tech support for free.

Why can't their PAID EMPLOYEES find these problems and fix them? This should have been fixed a week ago. They should be SO ashamed.

I think I've figured out what is happening because it is consistently wrong for in-state transactions.

Here it is what is going on...

The eBay PAID AWAITING SHIPMENT list shows the amount paid $3.34.
The eBay PAYMENT RECEIVED amount is $3.34.

BUT

eBay's Sales Record shows the payment was $3.28.
eBay's .CSV file shows a total payment of $3.28.

So, the Sales Record and .CSV file are WRONG. In this case, they are off by 1.829%.

Which means eBay is passing on the wrong figures to everyone's spreadsheet or database (this is NOT what the buyer paid) AND if the seller prints the Sales Record as an invoice/receipt, then the total paid in the receipt is ALSO wrong and does not match the PayPal amount.

--

Why are the figures mismatched?

I think what is happening is that eBay may have recently split the sales tax into two numbers, the rate at the seller's location and the rate at the buyer's location, and the difference is being added as a separate number rather than the two being combined as they were before BUT this number is NOT included in the Sales Record and is NOT included in the .CSV file, so these sources are wrong.

If you get in-state sales and you are downloading the Sales Records and printing receipts or using the online Sales Record to print receipts, you are likely giving the buyer (and your spreadsheet) the wrong number.

pleasepretty · ‎08-21-2018

Can you imagine an accountant, (an accountant, mind you), overlooking such an egregious error? Cuz I can't.

You know ebay. You didn't just get here.

You might have noticed that the boards are lacking in sparkling conversation. Everyone has left. A few are still here. Two. Two are still here.

Did you ever sell your humidor? I secretly coveted that.

gopetersen · ‎08-21-2018

@pleasepretty wrote:
Can you imagine an accountant, (an accountant, mind you), overlooking such an egregious error? Cuz I can't.

You know ebay. You didn't just get here.

You might have noticed that the boards are lacking in sparkling conversation. Everyone has left. A few are still here. Two. Two are still here.

Did you ever sell your humidor? I secretly coveted that.

It's amazing that this wasn't fixed within days (and that it happened in the first place).

LOL! Yes, the humidor was rather nice. I eventually delisted it and sold it locally. 🙂

pleasepretty · ‎08-21-2018

Bummer. That was a cool piece. I thought after we opened up Cuba....You know everyone was booking Carnivals to Cuba...then she'll get her price.

How are you doing at that other place? You liked it there once but I've heard they've taken a wrong turn.

I do miss all the banter.

gopetersen · ‎08-21-2018

It was very good until they changed to rules to let in sweatshop products, then it was bad for a while, now it's picking up again (though not as brisk as here). I have never once encountered software bugs on the other site.

pleasepretty · ‎08-22-2018

Thats great. Really great to hear. And you have 821 listings! You deserve to have it all. You really went through some hard times and pulled yourself through.

I'd call you a spectacular success.

I'm glad its brisk for you.