Sales reports

[therenewalworkshopltd]

I've not really used the sales reports on Ebay as I have had no need to do so.
However, I would very much like to get a report that shows how many items have sold for any particular item I'm selling on a weekly/monthly/quarterly basis etc.

Is there a simple way of doing this?  Or is there a piece of software that can link in and collect that data for you?

Basically I'm looking for something that I can base stock orders on.

[4_bathrooms]

You can schedule a report to run hourly/daily/weekly/monthly from here. The options you are looking for are "Source -> Orders" then "Type -> Paid and dispatched". This will provide a CSV containing all "paid and dispatched" orders for the period. You could then use a pivot table to count the number of each unique value in the "Item number" column.

However, for whatever reason eBay didn't see fit to include something more useful than their assigned item number and the item title to identify the particular item that sold; i.e. there are no columns for the item's SKU or EAN. Without either of those you can't distinguish which variation sold in a multi-variation listing and you would obviously still need to match the eBay item number with your own assigned stock/product identifier.

A quick Google shows several inventory management services and software that are compatible with eBay but not having used any of them I can't make any recommendations. 

[therenewalworkshopltd]

Thank you.

That's not exactly ideal is it.  And sounds like an awful lot of work.

I was using some software a few years back that was basically for Amazon, but had a link to Ebay which was actually ideal.  But you can't use it just for Ebay, which is more than a little frustrating!  Can't remember what it was called now either.

You would think that they would provide something that just gives a straightforward daily/weekly etc sales per item.  Rather than getting totals.  Obviously the data is there, just not that easily accessible.

For now I'm just checking sales history on individual items, but that is far from ideal, especially as the account I'm using, now has over 300 listings!  How do others manage?

[messier44000]

---

@4_bathrooms wrote:

You can schedule a report to run hourly/daily/weekly/monthly from here.

Does that show vat reports. I tried it , but had to give up.

I`m sure vat reports were much easier to find in the last 1/4 unless I am missing something.

Though with less than 1% of my sales here, it wouldn't be a long report.

[therenewalworkshopltd]

They are just the standard sales reports, which you can schedule.

Though there are some changes you make, I doubt it will be of use.

So if what you wanted wasn't on them, they won't be there either.

[4_bathrooms]

---

@messier44000 wrote:

---

Does that show vat reports. I tried it , but had to give up.

What exactly are you looking for? Are you looking for eBay's VAT invoices issued to the seller? Or are you looking for a report of sales VAT collected by eBay for things like sales to the EU where eBay was responsible for charging and remitting (EU) VAT?

[4_bathrooms]

---

@therenewalworkshopltd wrote:

You would think that they would provide something that just gives a straightforward daily/weekly etc sales per item.  Rather than getting totals.  Obviously the data is there, just not that easily accessible.

For now I'm just checking sales history on individual items, but that is far from ideal, especially as the account I'm using, now has over 300 listings!  How do others manage?

---

I suspect sellers with fewer orders/listings just manually input their sales data into their existing POS/ERP solution like we do. If we had hundreds of active eBay listings and/or we were receiving hundreds of eBay orders per week I have enough programming knowledge to get the data through eBay's API. If that wasn't the case I'd be looking at a third-party solution.

eBay allows a limited number of API calls per day but those limits are far in excess of what a single retailer would ever likely require. Increased API call limits are available by request (and approval) but are currently still free - this is what the third-party providers use. It's possible eBay deliberately makes the information available through seller hub limited and difficult to use in case they ever decide to monetise their API License Agreement for bulk users. 

[messier44000]

Vat report to give to my accountant every 3 months showing vat on monthly fees

I am sure it was a couple of clicks before. Had been so easy to find for the last 17 years, 

but not so now.

On my website, its 2 clicks , or 3 clicks if you include using the printer to get a full vat report

Thanks for replying

[sheba-knows-best]

Will this help?

Seller HUB

Performance Tab

Select SALES

Select the date range you want (custom or week, or 90 days etc)

Scroll down to LISTING INSIGHTS

Type in the exact title if you want a specific item

Or type say 'leather 12' for generic

or....

Seller HUB

Performance Tab

Select TRAFFIC

Select the date range you want (custom or week, or 90 days etc)

Scroll down to LISTINGS

Type in the exact title if you want a specific item - or leather coat for generic

Make sure you select active listings or sold listings

NB. Look to right for quantity sold

[messier44000]

Thanks everyone for the help, but this still does not show a vat report in PDF

What I got last 1/4 and for the last 17 years with a few easy click was

Gross sales - ££s

Vat at 20% shown

Net sales - ££s

Simples

But now all I can get is 8 pages of fees and net sales but no vat report.

OK with me jumping ship to concentrate elsewhere its such a low end result 

hardly worth the bother.

For those who follow F1, to use an analogy , its like Lewis Hamilton coming up with a 

strategy to win the race, but the Ferrari pit crew apply their own strategy and they drop 10 places.

Just currently 2 listing left. Do not intend renewing

[therenewalworkshopltd]

Why not just use something like Link My Books instead of messing around with the reports?

[sheba-knows-best]

I'm confused... the OP doesn't want to know about VAT does he? He wants to know what sells well...

[sheba-knows-best]

... which I think my post above helps with? (Just in case you missed it). I am aware it doesn't help with VAT...

[therenewalworkshopltd]

To be honest, I thought that was to do with the VAT question and skimmed it.  🙂

Going back, whilst I appreciate it, it's not quite what I'm looking for.

Running the reports daily is about the best I can expect here I think, or looking to use software.

Whilst getting number of sold per week/month etc is useful in an overall type of capacity, it's getting those daily sales, to work out what quantities to buy from your suppliers is what I'm after.

I'm looking to expand anyway to a website as well, so will probably end up going down the route of multichannel inventory management.  Though no doubt it will take a fair bit of time to be worth it.

I just find it very strange that you can't get a single report of Ebay that shows you this information in a coherent and sensible manner.  If you sell on the River, you can get this kind of info in about a dozen different flavours!  It is vastly superior to Ebay.

[sheba-knows-best]

I get it.

I'm on a different trajectory... looking to contract - I use it to identify the 20% of work that makes me 80% of sales.

[messier44000]

Sorry all for the bother and maybe misunderstanding.

Last 1/4 to find a vat report for the accountant showing gross, vat and net for fees.

All I needed to do before was Payment - reports - print for each month. Then I got the PDF file . Done

But now ........

Just want a vat report. But reckon we are all heading down different paths.

Ended my last two listings to take a break till the start of the new financial year.

Feel like I am being made to look 6 years old rather than my current 60+

[4_bathrooms]

---

@messier44000 wrote:

Thanks everyone for the help, but this still does not show a vat report in PDF

What I got last 1/4 and for the last 17 years with a few easy click was

Gross sales - ££s

Vat at 20% shown

Net sales - ££s

Simples

But now all I can get is 8 pages of fees and net sales but no vat report.

OK with me jumping ship to concentrate elsewhere its such a low end result 

hardly worth the bother.

For those who follow F1, to use an analogy , its like Lewis Hamilton coming up with a 

strategy to win the race, but the Ferrari pit crew apply their own strategy and they drop 10 places.

Just currently 2 listing left. Do not intend renewing

---

When you said "VAT on monthly fees" I thought you were looking for eBay's VAT invoices - the only VAT-related thing I've seen eBay supply in PDF format. 

If you're looking for your output VAT on eBay sales you can use the transaction report in my first post or the earnings report here. Neither has a breakdown of gross, net and VAT totals - they just have gross amounts but it's easy enough to add columns in the spreadsheet with formulas for calculating the net amount and the VAT charged from the gross amount.  

[messier44000]

---

@4_bathrooms wrote:

"When you said "VAT on monthly fees" I thought you were looking for eBay's VAT invoices "

---

Sorry for the slow reply. Thank you 4 Bathrooms, that was the page I was looking for.

Have bookmarked it.

Though with my latest total vat for a month being 6p, since closing down listings 

its not exactly a large amount 😉