| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Sales (sale_management) • Discuss (mail) • Invoicing (account) |
| Lines of code | 324 |
| Technical Name |
apg_export_stock_xls |
| License | LGPL-3 |
| Website | https://www.apagen |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Sales (sale_management) • Discuss (mail) • Invoicing (account) |
| Lines of code | 324 |
| Technical Name |
apg_export_stock_xls |
| License | LGPL-3 |
| Website | https://www.apagen |
Export Product Stock in Excel
Purpose: This module allows users to export current product stock levels into an Excel file (.xlsx format) for reporting, reconciliation, and analysis. It adds a new menu under Inventory > Reporting for easy access and offers filtering options before export.
Key Features
- One-Click Stock Export Export product stock levels into an Excel file from Inventory Reporting menu.
- Filter by Warehouse and Category Choose specific warehouse(s) and product categories using a wizard before exporting.
- Downloadable Excel Report Report includes product name, internal reference, stock quantity, unit of measure, location, and more.
- Simple & Efficient Fast export, minimal configuration required, integrates seamlessly with standard Odoo inventory modules.
- Ideal for Audits & Reporting Helps during monthly closures, stock checks, and external reporting requirements.
Odoo 18 Export Product Stock
Inventory > Reporting > Current Stock in Excel
Wizard for Selecting Warehouse and Category
Exported Excel Report Example
How It Works:
After installing the module, a new menu item is added under Inventory > Reporting.
When the user clicks Current Stock in Excel, a wizard opens showing:
- Warehouse Selection
- Product Category Filter
Clicking Export Product will generate and download an Excel file (.xlsx) with filtered product stock information.
Setup Instructions:
1. Navigate to Inventory > Reporting > Current Stock in Excel
2. Select the desired Warehouse and Product Category
3. Click Export Product
4. Excel report is downloaded automatically
Benefits:
- Saves time in preparing manual stock reports
- Improves accuracy and consistency in reporting
- Helps in financial audits, warehouse reviews, and physical inventory counting
About
Developed by Apagen Solutions
Please log in to comment on this module