In Odoo, the product field in the invoice line items is designed to display product variants by default. The reason behind this is that each variant represents a unique combination of attributes (such as color, size, etc.), which may have different prices and stock levels. This allows for more accurate invoicing and inventory management.

However, if you’d like to see all of your products when creating an invoice, you can follow these steps:

1. Enable Product Templates: Go to Inventory > Configuration > Settings. Under the “Products” section, enable the option “Product Variants.” Save your changes.

2. Update Product Templates: Go to the Products menu in either the Inventory or Sales apps, click on each product template, and make sure you’ve created at least one variant for it.

3. Select Products in Invoice Line Items: Now when you create an invoice and add line items, you should be able to select from all of your products (including templates with multiple variants). Just start typing the name of a product or browse through the list.

Please note that enabling product templates will affect other areas of Odoo as well (e.g., sales orders, and purchase orders), so make sure this change aligns with your business requirements.

I hope this helps! Let me know if you have any further questions or need additional guidance.

Hi,

Can you see if there is some sort of domain applied for your product field ? may be from a custom module.

Also by default odoo will show all products in the invoice line, you can get the total product count in the database from products menu and then click on search more from the products m20 field in invoice lines and see whether the same number of products is shown there. In the opened view, you will see total count like 1-80/6000

EDIT:

Each product will have a record in product variant model, so i hope everything is good and you miss this peace of information.

For eg: create a product without variants, you will see the created product in variant table also.

Thanks