Stock Traceability Excel Export

This module enhances the standard Odoo 18 Inventory Traceability Report by adding the ability to export the traceability report directly to Excel (XLSX).

Odoo provides PDF printing for the traceability report by default, but exporting the data into Excel is not available out-of-the-box. This module introduces a simple and powerful Excel export button inside the traceability report interface.

With this feature, users can easily download and analyze stock traceability data in Excel for reporting, auditing, and operational analysis.

Module Supports Both ERP / Community Editiom

Module Features

• Export Stock Traceability Report to Excel
• New Excel Button added in Traceability Report UI
• Includes important stock movement details
• Supports unfolded traceability hierarchy
• Works directly from Odoo backend
• Fully compatible with Odoo 18

Excel Report Includes

The exported Excel report contains the following columns:

• Reference
• Product
• Date
• Lot / Serial Number
• Source Location
• Destination Location
• Quantity

How It Works

1. User opens the Stock Traceability Report.
2. System loads the hierarchical traceability lines.
3. The module adds an Excel Export Button in the report view.
4. User clicks the Excel button.
5. Odoo collects all unfolded traceability lines.
6. Backend controller generates the Excel file.
7. The Excel file downloads automatically.

Usage Instructions

1. Install the module.
2. Go to Inventory.
3. Open Traceability Report.
4. Select a product, lot, or serial number.
5. Expand the traceability lines if needed.
6. Click the Excel button.
7. The report will download as an XLSX file.

Key Benefits

• Easy Excel export for traceability reports
• Faster stock auditing
• Better reporting and analysis
• Helps supply chain monitoring
• Useful for compliance and traceability checks
• Clean Excel formatting

Technical Highlights

• Extends Odoo Stock Traceability Report
• Custom HTTP controller for Excel download
• Uses XlsxWriter for Excel generation
• Frontend extension using OWL patch
• Fully integrated with Odoo reporting structure
• No core file modifications

Security & Stability

• No modification of Odoo core modules
• No database structure changes
• No external API calls
• Uses standard Odoo inheritance
• Safe for production environments

Screenshots