Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
428 Tampilan

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. 

Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Jawaban Terbai

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.

Avatar
Buang
Jawaban Terbai

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

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
2
Sep 25
295
3
Sep 25
477
4
Agu 25
1622
Block sale. Diselesaikan
3
Agu 25
619
2
Agu 25
720