13-04-2024 12:06 PM
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
13-04-2024 3:35 PM
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.
14-04-2024 11:31 AM
Thank you very much for your helpful suggestion. Kind Regards,