Function Description
This module adds brand and variant value fields to POS order analysis, supporting multi-dimensional data analysis.
Main functions
1. Brand Analysis (Product Brand)
- POS orders can be grouped and analyzed by product brand
- Display brand information in pivot table and list view
2. Variant Values Analysis
- Supports analysis by **single attribute value**
- For example:
- Group by "Color": Red, Black, White, etc.
- Group by "Size": S, M, L, XL, etc.
- Group by any other product attribute
Instructions for Use
Pivot Table Analysis
1. Enter POS Order Analysis
- Navigate to: Point of Sale → Reporting → Orders
2. Group by brand
- In the pivot table, click "Row" or "Column"
- Select the "Brand" field
- The system will summarize data by brand.
3. Group by attribute value (core function)
- In the pivot table, click "Row" or "Column"
- Select the "Variant Values" field
- The system will expand and display all attribute values, for example:
- Color: Red
- Color: Black
- Size: M
- Size: L
- You can see the sales data for each attribute value
4. **Multi-dimensional Combined Analysis**
- Multiple dimensions can be used simultaneously, for example:
- Row: Brand
- Column: Variant Values
- This allows analysis of "sales performance for each color/size under each brand"
List View
- In the list view, you can see for each order line:
- Brand Information (with Color Tags)
- Variant value information (with color labels, displaying all attribute values of this product)
Example Scenario
Scenario 1: Analyze sales performance by color
```
Product 1: T-shirt - Color: Red, Size: M → Sales Quantity: 10, Amount: 500
Product 2: T-shirt - Color: Black, Size: L → Sales Quantity: 8, Amount: 400
Product 3: Pants - Color: Red, Size: 32 → Sales Quantity: 5, Amount: 600
After grouping by "Variant Value", you can see:
- Color: Red → Total Quantity: 15, Total Amount: 1100
- Color: Black → Total Quantity: 8, Total Amount: 400
- Size: M → Total Quantity: 10, Total Amount: 500
- Size: L → Total Quantity: 8, Total Amount: 400
- Size:32 → Total Quantity: 5, Total Amount: 600
```
### Scenario 2: Brand + Size Combination Analysis
```
Row: Brand
Column: Variant Value (Size)
Result:
S M L XL
Brand A 100 200 150 50
Brand B 80 180 200 100
```
Technical Notes
- `product_brand_id`: Many2one field, linked to product brand
- `product_template_variant_value_ids`: Many2many field, linking to product variant values
- Variant values are displayed with colored labels, with each attribute value having a different color for easy identification.
Permissions
The variant value field requires the "Product Variant" permission group (`product.group_product_variant`)
Dependency Modules
- `point_of_sale`: POS Basic Module
- `product_brand`: Product brand module
Version
- Odoo 18.0
- Module version: 1.0.0
- Module version: 1.0.0
