Odoo doesn't have a built-in report for this specific requirement, but you can achieve it using a custom report or a third-party reporting tool.

  Method 1: Custom Report (for developers):

    Use Odoo's reporting framework (primarily Python and QWeb) to create a report that queries the `sale.order.line` model, groups by product, and sums the quantities.

  Method 2: Third-Party Reporting Tool:

    Several apps on the Odoo App Store offer advanced reporting features. These often provide a user-friendly interface to create custom reports without coding.

  Method 3: Pivot View (Simpler, less precise):

    Create a pivot view on the Sales Orders, using Product as the row and Quantity as the measure. Export this view to Excel. Note: This might not be perfectly accurate for complex scenarios.

If you'd like to explore this further for your use case, you're welcome to connect with us at Pragmatic Techsoft.

Hi,

* Go to the Sales > Reporting > Sales.

* Add the custom filter as follows.

Website sale report can be inserted into Excel by clicking on the 'Insert in spreadsheet' button.

For additional information, refer to the following

* https://www.cybrosys.com/odoo/odoo-books/v18-ce/ecommerce/reporting/

Hope it helps

Navigate to Website > Reporting > Online Sales Analysis

For measure select ordered qty and totals (if you wish to include)

for the rows select product (by clicking on the row header cell)

Use the download to xls 

Use the filters to select date ranges