Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3 Odpovědi
361 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Nejlepší odpověď

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
Zrušit
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
3
zář 25
434
4
srp 25
1574
Block sale. Vyřešeno
3
srp 25
580
2
srp 25
657
0
srp 25
420