Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
3 Відповіді
258 Переглядів

I have an Odoo webshop and I would like to generate an Excel file that shows the number of sold items per product. Is this possible in Odoo, and if so, what would be the best way to set it up? I'm only using the webshop module. 

Аватар
Відмінити
Найкраща відповідь

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

Аватар
Відмінити
Найкраща відповідь

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.

Аватар
Відмінити
Найкраща відповідь

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

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
3
серп. 25
352
How to merge companies Вирішено
4
серп. 25
1497
Block sale. Вирішено
3
серп. 25
533
2
серп. 25
626
0
серп. 25
375