Ebay Line level /Product level Sales Report for a specific period for no of units sold for each item

[distinctlook]

Hi, 

I am trying to figure out how I can generate the below report but I couldn't find a way. If you know I would appreciate your advice. Thank you

Ebay Line level /Product level Sales Report for a specific period for no of units sold for each item

[ojewellery]

You can do it by producing a series of reports and playing with them in excel.

All listings to get all your active SKU

All orders to get sales

Then you can use formula on the all orders to generate volume sales per SKU and if wanted average sold price (average discount)

Finally you can add a column to your all active SKU spreadsheet and add a column looking up the volume sales per SKU.  Those without sales will show as 0

Once set up its quite quick to use the same template excel sheets to cut and paste into each month/ quarter/ year.

[distinctlook]

Thank you very much for your helpful suggestion. Kind Regards,