Is your team selling combinations you don't offer?
Imagine you are a product manager at a fashion company. Your sales team uses Odoo to create orders, and you have a polo shirt with 4 colors and 4 sizes: 16 variants. But it turns out you have never sold the red size S because suppliers don't produce it. However, the system shows it as available. One day, a salesperson mistakenly promises a customer that red polo in size S. The order arrives, there is no stock, and you have to explain to the customer that you can't fulfill it. You lose credibility and time. How do you avoid this? In this article we will show you how to exclude unwanted combinations and keep your catalog clean with Odoo and the help of Ganemo.
Excluding individual variants: the first step
In Odoo, when you have attributes such as color and size, all possible combinations are generated. To prevent an unwanted combination, such as red in size S, go to the product, open the attributes tab, select the attribute value (red) and mark the exclusion for that product and size. That way, when generating a quotation, that combination will not be available. For example, in our fashion company, after excluding red-S, the salesperson will no longer be able to select it. If they choose size S, red doesn't even appear, and if they insist, Odoo shows a warning message. This avoids misunderstandings and saves time on corrections. With Ganemo, you can manage these exclusions in bulk if necessary.
Variant matrix: efficiency when adding multiple products
What happens when you need to add many variants to an order? The standard selection interface can be tedious if you have to click one by one. Odoo lets you enable grid variant entry from Settings > Sales. Once enabled, you can configure per product whether you use the standard configurator or the grid. For example, a wholesale customer orders 10 units of several combinations: white M, white L, black M, etc. With the grid, you can enter quantities directly in a table, saving time. In a real case, our customer had 70 variants (4 colors, 5 sizes, 2 materials). Without the grid, adding them one by one took 30 minutes; with the grid, 2 minutes. In addition, you can sort the columns by your own criteria: if you prefer color as the main column, drag it to the top. This is useful for mobile users, who can scroll vertically. With Ganemo, the grid setup is simplified even further.
Hiding rows or columns in the grid: the problem of discontinued values
Over time, some attributes can become obsolete. For example, a design from last season that is no longer sold, or a material that was discontinued. If you delete the value from the product, you lose the sales history. That is why you need to hide it in the grid without deleting it. By default, Odoo does not offer this functionality. That is where Product Archive Lock by Ganemo comes in, a third-party module that lets you hide rows or columns in the sales grid. For example, in our company, the red color was discontinued, but it has historical sales. With Ganemo, you open the red attribute value, check “Hide in grid” and that's it. When adding the product to an order, the red column disappears. The same goes for rows: if cotton is no longer used, you hide it. This keeps the grid clean and avoids confusion. One of our customers had 20 colors, 10 of which were no longer sold; after hiding them, the grid became manageable. This module is native to Ganemo and is available in the Odoo app store. If you are a Ganemo client with active maintenance, you have it included. If not, you can purchase it or contact a partner.
When NOT to use these exclusions?
Important: these exclusions are for combinations that you never plan to sell. Do not use them for out-of-stock products, because you would then lose the chance for customers to show interest. For out-of-stock situations, Odoo has minimum inventory and replenishment rules. Exclusion is only for cases such as discontinued designs, obsolete materials or last season's colors. That way, your grid reflects only what you actually offer.
How to get Product Archive Lock?
This module is not preinstalled. Search for it in the Odoo app store under the name “Product Archive Lock” and make sure the author is Ganemo. If you are a Ganemo client, ask your account manager to install it. If not, any partner can do it. Ganemo offers support and customization so your Odoo adapts to your business.
Conclusion
Managing variants in Odoo is simple once you know the right tools. Excluding unwanted combinations prevents sales errors, and hiding rows or columns keeps your grid tidy. With Ganemo, these features are enhanced, saving time and improving the salesperson experience. Having trouble with variants in Odoo? Contact Ganemo and optimize your management.