Problem

Users needed a simplified, read-only view to quickly access product information without navigating through complex product forms. Specific requirements included:

• View stock availability for a specific warehouse location (Location ID: 8)
• Access product attachments directly
• Filter products by category with visual navigation
• Display only storable products with essential details
• No accidental modifications to product data

Solution

Created a custom Product Info module that provides a dedicated read-only interface synchronized with product catalog.

Key Features

Automated Synchronization

• Automatically creates product.info record when a product is created
• Syncs active/inactive status between products and their info records
• Deletes info records when products are deleted

Read-Only Interface

• Form and tree views with create/edit disabled
• Displays essential product data: name, internal reference, category, UOM
• Shows real-time stock quantity from Location 8
• Product attachments accessible via binary widget

Enhanced Search & Navigation

• Search by product name, internal reference, or display name
• Category-based filtering with hierarchical support
• Search panel with category tree and counters
• Default grouping by product category

Logistics Information

• Net weight and gross weight display
• Unit of measure tracking

Technical Components

• product.info model with computed fields for stock and attachments
• Extended product.product with lifecycle hooks (create/write/unlink)
• Custom views accessible via Sales > Product Info menu
• Filters to show only storable products (type=’product’)

Benefits

✓ Simplified product lookup for warehouse/sales teams
✓ Quick stock availability checks without inventory module navigation
✓ Protected product data from accidental modifications
✓ Faster access to product documents and specifications