export orders per site as Order Line Items Columns

right now how to get the result i am looking for is go into all the orders in admin>reports>export orders>csv>create export>orderline items, then open it in excel and filter to get to the website you want and use count-if to get the amounts of that product, size and colour amounts

this is a very long way just to find out how many of a product did we sell on an affilte store

and streamling this would save me days of work

being able to export a products sales data for a year

or on each site

or being able to see how many of each size has been sold each year on the product page

Comments