How to Add Multiple Variants to an Order via Grid in Odoo 18
Overview
A product variant represents a distinct version of a product, characterized by unique features or attributes that set it apart from other variations within the same product line. This approach allows businesses to offer diverse options under one product category, enhancing the customer's ability to find a version that perfectly suits their preferences and needs.
Variant Grid Entry
In Odoo, Variant Grid Entry is a user-friendly interface designed to streamline the selection and addition of multiple product variants to a sales order using a grid-based format. This feature is particularly useful for managing products with numerous variations, such as colour, size, or material. When selecting product variants for sales, there are primarily two methods: Order Grid Entry and the Product Configurator. This blog focuses on exploring the Order Grid Entry feature in detail.
Working
Enable variants and variants grid entry in settings
Create new product to configure its variants for grid entry
Move to configuration > attribute Create New attributes
Set the sales price, cost prices, Product type, invoicing policies, etc of the product and save the product. There we can see the Attribute & Variant tab and there we can set up the variant for the product. Once the product is created,
Then create New sale order
Add created product to the lines
In this pop up window add Quantity , Select the variant and click confirm
The products and its variants are added automatically
Conclusion
The "Add Products by Grid" functionality in Odoo is an efficient and user-friendly feature that streamlines the process of adding multiple products to a transaction (e.g., sales orders, purchase orders, inventory transfers). It allows users to:
Bulk Product Selection: Users can select multiple products from a grid interface, typically presented in a tabular format, making it easier to view and compare items.
Editable Quantity and Price: Within the grid, users can directly input or adjust quantities, prices, or other product-related details, saving time compared to adding products one by one.
Improved Productivity: This approach minimizes clicks and navigation, enhancing productivity for users managing large product lists or repetitive tasks.
Custom Selection & Updation: The grid can often be customized to display additional product attributes (e.g., variant options, stock availability) based on business needs. Changes in the grid typically update the associated document (e.g., order total, inventory levels) in real time, ensuring accuracy.
The "Add Products by Grid" functionality provides a more efficient, accurate, and scalable way of handling product selection, especially in scenarios with a high volume of products. It enhances user experience while aligning with Odoo's goal of streamlining business workflows.
If you are looking for an ERP implementation partner with diverse industry experience feel free to contact us. We have proven track record of successful implementations across various sectors including Odoo for Manufacturing, Odoo for Trading, Odoo for FMCG, Odoo for Oil & Gas, Odoo for Diary, Odoo for Pharma, Odoo for Cosmetic Clinic, Odoo for Contracting Companies, Odoo for HVAC, Odoo for Logistics, Odoo for Automobile, Odoo for Laundry, Odoo for Field Service, Odoo for E-Commerce & many more