Skip to Content

Export Product Stock in Excel

by
Odoo 17
v 18.0 Third Party 19157
Download for v 18.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Purchase (purchase)
• Sales (sale_management)
• Discuss (mail)
• Invoicing (account)
Lines of code 322
Technical Name export_stockinfo_xls
LicenseAGPL-3
Websitehttps://www.cybrosys.com
Versions 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Purchase (purchase)
• Sales (sale_management)
• Discuss (mail)
• Invoicing (account)
Lines of code 322
Technical Name export_stockinfo_xls
LicenseAGPL-3
Websitehttps://www.cybrosys.com
Versions 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0
Community
Enterprise
Odoo.sh

This Module Helps To Generate Advanced PDF & XLS reports for Product Stock.

Export Product Stock in Excel

Email Us Skype Us

Key Highlights

Current Stock XLS.

Retrieve the current stock report in XLS format for the corresponding warehouse.

Select Category for Products.

select Product Categories for generating an XLS report.

Negative Stock.

Negative stock will be highlighted in "Red" cells.

Export Product Stock in Excel

Are you ready to make your business more organized?
Improve now!

odoo@cybrosys.com +91 9074270811
acc_bg

Navigate to the following steps: Reporting -> Current Stock in Excel.

When selecting 'Current Stock in Excel,' a Wizard will appear allowing the selection of a Warehouse and Category.

When you click on 'Export Product with Stock Info,' an XLS report is generated as follows.

Current Stock XLS.

Select Category for Products.

Negative Stock.

Latest Release 18.0.1.0.0

4th December, 2024
Add
  • Initial Commit

Related Products

Our Services

Odoo Customization
Odoo Implementation
Odoo Support
Odoo Migration
Odoo integration
Odoo Consultancy
Odoo Licensing
Hire Odoo Developer
....

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Does it work for a multi-warehouse report?
by
INGENNIA DIGITAL EIRL
on 8/15/25, 1:45 AM

Excellent module. I just have one question. I tried it, and when I report more than one warehouse, I get the following error:

RPC_ERROR

Odoo Server Error

Occured on cahuanasac-odoo-test1-21011548.dev.odoo.com on 2025-08-15 05:37:28 GMT

Traceback (most recent call last):

  File "/home/odoo/src/user/export_stockinfo_xls/controllers/export_stockinfo_xls.py", line 50, in get_report_xlsx

    report_obj.get_xlsx_report(options, response)

  File "/home/odoo/src/user/export_stockinfo_xls/wizard/stock_report.py", line 184, in get_xlsx_report

    sheet.merge_range(8, w_col_no1, 8, w_col_no, record, format11)

  File "/usr/lib/python3/dist-packages/xlsxwriter/worksheet.py", line 142, in cell_wrapper

    return method(self, *args, **kwargs)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "/usr/lib/python3/dist-packages/xlsxwriter/worksheet.py", line 2247, in merge_range

    raise OverlappingRange(

xlsxwriter.exceptions.OverlappingRange: Merge range 'AD9:AY9' overlaps previous merge range 'AD9:AN9'.


The above server error caused the following client error:

RPC_ERROR: Odoo Server Error

    at makeErrorFromResponse (https://cahuanasac-odoo-test1-21011548.dev.odoo.com/web/assets/7e33814/web.assets_web.min.js:3148:163)

    at decoder.onload (https://cahuanasac-odoo-test1-21011548.dev.odoo.com/web/assets/7e33814/web.assets_web.min.js:3134:7)