Bring eBay Data into Excel
Sales reporting is hugely important, but unfortunately can be rather time consuming. On eBay it is a real pain to analyse sales on a per item basis, as sales relating to each SKU are spread across multiple listings. Sales data therefore requires analysing the sell through rate and average selling price of each product, deducting relevant fees and then comparing this against the trade price. Your sales management tool may do this for you, but otherwise it is a time consuming manual process
I was therefore very excited to hear from Andy Geldman from Auction software review that a company called Prime2S had created an Excel plugin which pulls data from eBay using the API. Functions available will for example pull items numbers for listed items, fees associated with items numbers and feedback details. These functions could be used to entirely automate the creation of eBay reports. They could very useful in building an automated versions of Scott Wingo’s eBay Dashboard, which he suggests in his book eBay Strategies.
It is a pity the Prime2S haven’t produced their own spreadsheets using their plugin, missing a trick there I think…..