Skip to Content

Stock Product Matrix

by
Odoo

$ 30.00

v 19.0 Third Party 1
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Invoicing (account)
• Discuss (mail)
Lines of code 1300
Technical Name stock_product_matrix
LicenseLGPL-3
Websitehttps://odootips.com
Versions 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Invoicing (account)
• Discuss (mail)
Lines of code 1300
Technical Name stock_product_matrix
LicenseLGPL-3
Websitehttps://odootips.com
Versions 17.0 18.0 19.0
Stock Product Matrix | Picking Variant Grid
Add product variants to stock pickings through a matrix grid interface

This module extends Stock Picking to support product variant matrix entry and visualization. Perfect for managing transfers of products with multiple variants like size, color, and height combinations.

  • ✅ Matrix Grid Entry - Add variants through Odoo's native matrix configurator
  • ✅ 3+ Attribute Support - Compound rows for products with 3 or more attributes
  • ✅ Real-time Preview Matrix - OWL widget with live quantity updates
  • ✅ Row & Column Totals - Automatic totals in matrix dialog and preview
  • ✅ Availability Indicator - Red highlight for unavailable stock in outgoing pickings
  • ✅ PDF Matrix Report - Print variant matrices in picking reports
  • ✅ Excel Export with Matrix - Export to Excel with variant matrix grid
  • ✅ Search & Pagination - Filter and paginate products in matrix view
▶ Watch on YouTube
📦 Compatible with all Stock Picking operations:
📥 Receipts - Incoming goods from suppliers
📤 Delivery Orders - Outgoing shipments to customers
🔄 Internal Transfers - Between warehouses/locations
↩ Returns - Customer & supplier returns
🛩 Dropship - Direct supplier-to-customer
🏭 Manufacturing - Pick components for production

💡 Works with any picking type configured in your Odoo instance, including custom operation types.

  • ✔ Community
  • ✔
    Enterprise
    (On-premises)
  • ✔ Odoo.sh
  • ✘ Online
Odoo Version
19.0

📷 Screenshot: Product with variant attributes configured

Product Attributes Configuration
📖 Documentation
📋 1. Configure Products with Variants

Products must have variant attributes configured to use the matrix. Go to Inventory > Products > Products and configure attributes.

📷 Screenshot: Product with variant attributes configured

Product Attributes Configuration
Step-by-step:
  1. Go to Inventory > Products > Products
  2. Open or create a product
  3. Go to the Attributes & Variants tab
  4. Add attributes (e.g., Color: Red, Blue, Green)
  5. Add a second attribute (e.g., Size: S, M, L, XL)
  6. Optionally add a third attribute (e.g., Height: 45, 50)
  7. Set "Create Variants" to "Instantly" for each attribute
  8. Save the product - variants will be generated automatically
2 Attributes

Color + Size = standard 2D matrix

3 Attributes

Color + Size + Height = compound rows "S • 45"

1 Attribute

Color only = 1D single-row matrix

⚙ 2. Enable Matrix Process on Picking

To use the matrix in a stock picking, you must enable the "Use Matrix Process" checkbox.

📷 Screenshot: Picking form with "Use Matrix Process" checkbox enabled

Enable Matrix Process
Step-by-step:
  1. Go to Inventory > Operations > Transfers (or Receipts / Delivery Orders)
  2. Open an existing picking or create a new one
  3. Check the "Use Matrix Process" checkbox (located near the top of the form)
  4. Once enabled, the product field in the Operations tab will show a matrix icon (grid icon) for configurable products
  5. A "View Matrix" tab will also appear below the Operations tab
💡 Tip: The "Use Matrix Process" checkbox is available on all picking types: Receipts, Delivery Orders, Internal Transfers, etc.
➕ 3. Add Products to Picking

When "Use Matrix Process" is enabled, adding a configurable product opens the matrix configurator dialog automatically.

📷 Screenshot: Selecting a configurable product triggers the matrix dialog

Add Product to Picking
Step-by-step:
  1. In the Operations tab, click "Add a line"
  2. Select a configurable product (one with variant attributes)
  3. The Matrix Configurator Dialog opens automatically
  4. Enter quantities for each variant combination in the grid
  5. Click "Confirm" to add all variants with their quantities
  6. Move lines are created automatically for each variant with qty > 0
✅ What happens

Each cell with a quantity > 0 creates a separate stock move line for that specific variant.

🔄 Re-open matrix

Click the pencil icon (✏) on any product line to re-open the matrix and modify quantities.

📊 4. Matrix Configurator Dialog

The matrix dialog shows a grid with columns = first attribute and rows = second attribute. It includes row totals, column totals, and a grand total that update in real-time as you type.

📷 Screenshot: Matrix configurator dialog with row/column/grand totals

Matrix Configurator Dialog
Dialog Features:
  1. Grid cells - Enter quantity for each variant combination
  2. Row totals - Sum of all quantities in each row (right column)
  3. Column totals - Sum of all quantities in each column (bottom row)
  4. Grand total - Total of all quantities (bottom-right corner)
  5. Real-time calculation - Totals update instantly as you type
  6. Click "Confirm" to apply, or "Discard" to cancel
Columns

First attribute (e.g., Color)

Rows

Second attribute (e.g., Size)

Totals

Auto-calculated row, column & grand totals

👁 5. Preview Matrix (View Matrix Tab)

The "View Matrix" tab shows a real-time preview of all product matrices in the picking. This is an OWL widget that updates automatically when you add or modify products.

📷 Screenshot: View Matrix tab showing product matrices with search and pagination

Preview Matrix View
Step-by-step:
  1. After adding products with variants, click the "View Matrix" tab
  2. Each configurable product is displayed as a separate matrix table
  3. The matrix shows demanded quantities (product_uom_qty) for saved pickings
  4. For unsaved changes, the matrix shows a dirty overlay with current edits
  5. Use the search bar to filter products by name
  6. Use pagination to navigate through multiple products (5 per page)
🔍 Search

Type a product name to filter the matrix list instantly.

📄 Pagination

Navigate between pages when there are more than 5 products.

✏ 6. Edit Quantities via Matrix (Pencil Icon)

To modify quantities after initial entry, click the pencil icon (✏) on any product line in the Operations tab. This re-opens the matrix dialog with current quantities pre-filled.

📷 Screenshot: Pencil icon on product line and re-opened matrix dialog

Edit via Matrix
Step-by-step:
  1. In the Operations tab, find the product line you want to edit
  2. Click the pencil icon (✏) on the right side of the product line
  3. The matrix dialog opens with current quantities pre-filled
  4. Modify quantities as needed - totals update in real-time
  5. Click "Confirm" to apply changes
  6. The move lines are updated accordingly (new variants added, zeroed variants removed)
💡 Tip: Setting a variant quantity to 0 in the matrix will remove that move line from the picking when you confirm.
📊 7. Products with 3+ Attributes

For products with 3 or more attributes, the matrix uses compound rows. The first attribute becomes the columns, and all remaining attributes are combined into row headers using the " • " separator.

📷 Screenshot: Matrix with 3 attributes showing compound rows (Size • Height)

3+ Attributes Matrix
How it works:
  1. Configure a product with 3+ attributes (e.g., Color, Size, Height)
  2. Columns = First attribute values (e.g., Red, Blue, Green)
  3. Rows = Cartesian product of remaining attributes (e.g., "S • 45", "S • 50", "M • 45", "M • 50", ...)
  4. All combinations are displayed in a single flat matrix - no tabs or sections
  5. Row and column totals are calculated for the entire matrix
Example: A T-Shirt with Color (Red, Blue), Size (S, M, L), Height (45, 50) produces:
T-ShirtRedBlueTotal
S • 45538
S • 50246
M • 45718
M • 50369
Total171431
📄 8. PDF Report

The PDF report includes variant matrices when the picking has configurable products. The matrix is printed as part of the picking delivery slip.

📷 Screenshot: PDF report with variant matrix tables

PDF Matrix Report
Step-by-step:
  1. Open a picking with configurable products and "Use Matrix Process" enabled
  2. Click Print > Picking Matrix Report (or the corresponding report action)
  3. The PDF includes a matrix table for each configurable product
  4. Each matrix shows row headers, column headers, quantities, and totals
  5. Products with 3+ attributes show compound row headers (e.g., "S • 45")
Report Contents:
  • Matrix tables for each product template with variants
  • Row and column totals
  • Grand total per product
  • Professional gradient header with product name
📊 9. Excel Export

Export picking data to Excel with a variant matrix grid. The Excel file includes professional formatting with headers, totals, and color-coded cells.

📷 Screenshot: Excel export with variant matrix grid and formatting

Excel Matrix Export
Step-by-step:
  1. Open a picking with configurable products and "Use Matrix Process" enabled
  2. Click Print > Picking Matrix Excel (or the corresponding action)
  3. An .xlsx file is downloaded automatically
  4. The file contains a sheet with picking info (partner, date) at the top
  5. Each product has a matrix block with headers, quantities, and totals
  6. Cells are color-coded: headers in dark, totals highlighted, grand total in primary color
  7. Unavailable stock cells are highlighted in red
💡 Requirement: The xlsxwriter Python library must be installed for Excel export to work. Install with: pip install xlsxwriter>=3.1.0
📦

Installation

Install this module after Stock and Product Matrix (Odoo core modules).

Odoo Dependencies:
  • stock - Odoo Inventory / Stock module
  • product_matrix - Odoo's product matrix module
  • account - Odoo Accounting module
Python Dependency:
  • xlsxwriter >= 3.1.0 - Required for Excel export
  • Install with: pip install xlsxwriter>=3.1.0
📥 Install Steps
  1. Ensure stock and product_matrix are installed
  2. Install xlsxwriter Python library
  3. Place module in your addons path
  4. Update Apps List and install Stock Product Matrix
✅ After Install

A new "Use Matrix Process" checkbox and "View Matrix" tab appear in the stock picking form view for all operation types.

❓ What products work with the matrix?

Products with multiple variants configured through product attributes (e.g., Size, Color). The product must have at least one attribute with "Create Variants" set to "Instantly".

❓ How does the matrix handle 3+ attributes?

The first attribute becomes columns, and all remaining attributes are combined into compound row headers using the " • " separator. For example, Size + Height becomes "S • 45", "M • 45", etc.

❓ What does the red highlight mean in the matrix?

Red-highlighted cells indicate that the forecast availability is less than the demanded quantity. This only applies to outgoing and internal transfer pickings.

❓ Do I need xlsxwriter installed?

Yes, xlsxwriter is required for the Excel export feature. Install it with pip install xlsxwriter>=3.1.0. The module will still work without it, but Excel export will not be available.

❓ Can I use this on Receipts, Delivery Orders, and Internal Transfers?

Yes, the module works on all picking types. Simply enable the "Use Matrix Process" checkbox on any picking.

❓ Does the preview matrix update in real-time?

Yes, the View Matrix tab uses an OWL widget that detects changes in the picking's move lines and updates the matrix preview automatically, even before saving.

❓ What Odoo versions are supported?

Odoo 19 - Community and Enterprise on-premises.

📧

Need Help?

Contact us for technical support, bug reports, or feature requests.

Contact Support

⏰ Response time: 24-48 hours

⭐ If you like this module, please leave a review on Odoo Apps ⭐

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 or have a question related to your purchase, please use the support page.