Pular para o conteúdo
Menu
Esta pergunta foi sinalizada
3 Respostas
182 Visualizações

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
Cancelar
Melhor resposta

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
Cancelar
Melhor resposta

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
Cancelar
Melhor resposta

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
Cancelar
Publicações relacionadas Respostas Visualizações Atividade
3
ago. 25
271
4
ago. 25
1473
Block sale. Resolvido
3
ago. 25
495
2
ago. 25
580
0
ago. 25
301