Stock take - end of year


How do I extract data showing product quantities and prices?

ie, if I have 1000 products, how do I get a list with quantity and price for each product?

thank you

I found that most data can be exported, however quantities for options are not correct. If for example I have a product with 3 colors, 6 red, 2 green, 3 blue…instead of giving total quantity as 11, it shows something random like 8. Can anyone help? Thank you