Purchase Product Matrix
Fast ordering of multi-variant products with intuitive matrix interface
The Purchase Product Matrix module enables fast ordering of products with multiple variants (size, color, material) through an intuitive matrix interface, saving time compared to adding each variant individually.
The system displays all variants in a 2D table, allows bulk quantity entry, and automatically creates corresponding order lines.
Key Features
Key points
• Matrix View: Display variants in 2D table (e.g., Size x Color)
• Bulk Quantity Entry: Enter quantities for multiple variants at once
• Auto Line Creation: Automatically create order lines for variants with quantity > 0
• Attribute Filtering: Filter variants by attributes to focus on needed groups
• Quick Total: Display total quantity and value directly in matrix
• Vendor Pricelist: Automatically apply vendor prices for each variant
• Copy/Paste Support: Support copy/paste from Excel for fast entry
• Template Reuse: Save purchase patterns for reuse
Usage Workflow
Steps
1. Create Purchase Order: Create new PO, select vendor as usual.
2. Add variant product: Click Add a product, select product with variants (e.g., T-shirt with Size S/M/L/XL and Color Red/Blue/White).
3. Open Matrix View: Click "Configure" button or grid icon. Matrix displays with Size in rows, Color in columns.
4. Enter quantities: Enter quantities in corresponding cells. E.g., Size M, Color Red = 50 pieces. Leave blank for cells not purchasing.
5. Confirm: Click Confirm. System automatically creates order lines for variants with quantity > 0.
6. Complete order: Review order lines, adjust if needed, confirm PO.
Product Configuration
Key points
• Product Attributes: Set up attributes (Size, Color, Material) in Product → Attributes
• Product Template: Create product template with attributes, generate variants
• Vendor Info: Add vendor pricelist for each variant or use common price
• Matrix Dimensions: Select 2 main attributes to display in matrix (rows x columns)
• Default Values: Configure default quantities for frequent purchase patterns
Real-World Scenarios
Product Matrix Applications
| Scenario | How to Use | Benefits |
|---|---|---|
| Purchase fashion apparel | Product: T-shirt. Attributes: Size (S/M/L/XL/XXL), Color (5 colors). Matrix 5x5 = 25 variants. Enter quantity for each cell. | Instead of adding 25 separate lines, enter all in 1 matrix. Save 90% time. |
| Purchase electronic components | Product: Resistor. Attributes: Resistance (10 values), Tolerance (3 values). Matrix 10x3. | Easily order complete component set with different specifications. |
| Seasonal ordering | Winter needs more size L/XL, less size S. Enter appropriate quantities in matrix. | Flexibly adjust quantities based on actual needs per variant. |
| Copy from Excel | Vendor sends Excel price list. Copy quantities, paste into Odoo matrix. | Fast data entry from external sources, reduce errors. |
| Recurring purchases | Save monthly purchase pattern (e.g., 100 size M, 80 size L). Reuse for future orders. | Consistent purchasing, no need to re-enter from scratch. |
Best Practices
Key points
• Choose appropriate attributes: Select 2 attributes with most values as rows/columns for easy viewing
• Use keyboard: Tab to move between cells, enter numbers quickly without mouse
• Filter attributes: If too many variants, filter to show only needed group (e.g., only size L/XL)
• Check total: Monitor total quantity and value at matrix bottom to control budget
• Seasonal templates: Create separate templates for summer/winter with different size ratios
• Vendor-specific matrix: Each vendor may have different variant sets, save separate templates