Hi,

This issue happens because Odoo’s export and import formats for product attributes and their values are not fully compatible. When you export products with variants, Odoo shows each attribute value in the form “Attribute: Value” (for example, “Size: S”), but during import, Odoo only recognizes the value name (like “S”) or the external ID of that attribute value. Since the system doesn’t find a record called “Size: S”, it raises the “No matching record found” error. To solve this, the correct approach is to first export and import all product attributes and values separately, ensuring they have proper external IDs in both databases. Once those records exist in the target database, you can export the products again using “I want to update data (import-compatible export)” mode, which gives you import-friendly column names like “Product Attributes / Values / Value” instead of “attribute_line_ids/product_template_value_ids.” This makes Odoo use “S, M, L” rather than “Size: S, Size: M, Size: L.” You can then import the product file successfully. In short, the reliable process is: (1) export and import attributes and values with external IDs first, (2) export products using import-compatible format, and (3) ensure both environments share the same external IDs so the system can match records automatically.

Refer:

1. https://www.odoo.com/documentation/18.0/applications/essentials/export_import_data.html

2. https://www.cybrosys.com/blog/how-to-import-product-attributes-and-product-variants-in-odoo-17

Hope it helps.