01-19-2023 03:52 PM - edited 01-19-2023 03:53 PM
I just downloaded my Transaction report and the Orders report and noticed that the Buyer Name is different in the two reports.
I get the Transaction Report from here: My eBay > Selling > Payments > Reports > Transaction Reports > See All
Orders report comes from here: My eBay > Selling > Reports > Downloads
Transaction Buyer Names:
Mike Smith
Tony Olivetti
Richard Dunn, Sr.
Orders Buyer Names:
Michael Smith
Mark Anthony Olivetti
Richard Dunn
As of today, I see that on the Selling > Orders page you can now view up to 2 years of orders instead of just 90 days (FINALLY!). [Though on orders older than 90 days, the buyer's Name, Shipping Address, Email, and Phone Number are all stripped out. So not entirely helpful. Same is true for downloaded Order Reports, buyer details are stripped out.] Looking at this list, it reflects the Buyer Name that is in the Orders report.
So where is the Transaction Buyer Name coming from? Not that I care, I just hope the developers know where it's coming from and standardize it with Orders Buyer Name.
[EDIT] OK, so after some digging around in the Orders Report, it appears that what the Transaction Report is calling "Buyer Name" is actually the "Ship To Name" in the Orders Report.
On one hand, the Transaction Report should change it's heading from "Buyer Name" to "Ship To Name" since all the other address fields are only the Ship To address. But on the other hand, the Ship To person is not necessarily the person who initiated the transaction and made the purchase, so the Transaction report should be using the Buyer Name and Buyer addresses. Unless, like the Order report, it would show both the Buyer and the Ship To info. Then the two reports become more redundant and could be merged (which could be a good thing).
01-19-2023 04:45 PM
Those names are close enough. I am thinking that the person might be Mike Smith on Ebay but Michael Smith on the payment. Perhaps the item was shipped to the son and bought by the father. I would not lose a minute of sleep over those almost identical names.
01-20-2023 12:27 PM - edited 01-20-2023 12:30 PM
The problem is that "almost identical" to the human mind is not "identical" to Excel, and spreadsheet treats them as if they were "Elephant" and "Paris".
I am using this data to create imports into Quickbooks, and the data must be identical or it creates all kinds of errors and bogus results. To your own example of the father and son, the "Ship To Name" is not the "Buyer Name" and should not be labeled as "Buyer Name".
The two reports must be fixed.