Skip to Content
This question has been flagged
productimportcategories
2 Replies
1067 Views
Avatar
Luc Bernard

How to import Products with Categories correctly?

When I export products with their categories I get a file with:

olumn-headers:


  • 'categ_id': for admin Product category
  • 'pos_categ_ids': for POS categories
  • 'public_categ_ids': for E-commerce categories

Column-content:

  • for all 3 columns: 'Parent Category / Category' (category path with ' / ')
  • for POS and E-commerce categories: multiple paths joined by ','

But when I try to import new products with exactly the same settings and paths I get this error:

"No matching records found for the following name in the field ...category:"

How to solve this?


Avatar
Discard
Codesphere Tech

Yes. I am happy to help you.

Avatar
Mohammed Umair
Best Answer
Hi,

The issue occurs because Odoo exports category values using the full hierarchy path (for example All / Saleable / Chairs), but during import by name, Odoo matches only the category record name, which is usually the last part (Chairs).

So instead of importing:
All / Saleable / Chairs

please import only:
Chairs

This applies to:
categ_id → Product Category
pos_categ_ids → POS Categories
public_categ_ids → Website / eCommerce Categories

For multiple POS or Website categories, separate them with commas, for example:
Furniture,Office

If there are duplicate category names under different parents (for example Furniture / Accessories and Electronics / Accessories), Odoo cannot reliably determine which one to use when importing by name.

In that case, the recommended approach is to import using External IDs instead of category names.
Please change the columns to:
categ_id/id
pos_categ_ids/id
public_categ_ids/id

and use values such as:
product.product_category_5
website_sale.public_category_office
pos.category_furniture

For multiple POS or Website categories, you can provide multiple External IDs separated by commas.
Example:
website_sale.public_category_office,website_sale.public_category_sale
Using /id is the safest and most reliable approach, especially when there are duplicate category names.

Please refer Official Odoo documentation for reference:

https://www.odoo.com/documentation/18.0/applications/essentials/export_import_data.html#import-from-another-application

https://www.odoo.com/documentation/18.0/applications/essentials/export_import_data.html#difference-between-database-id-and-external-id

Hope this helps for you.

Thanks!

Best regards,

Mohammed Umair

Email:-mohammedumair368@gmail.com

Avatar
Discard
Avatar
Codesphere Tech
Best Answer

Hello,
I suggest exporting the products along with the product category name and external ID. This will allow you to easily identify which product belongs to which category.

If you plan to import, you can use the existing external IDs to correctly assign categories to the products.
It is better if you could give sample file for your data
Thanks

Avatar
Discard
Luc Bernard
Author

Can I send it to you privately?

Related Posts Replies Views Activity
Product import xslx Solved
product import
Avatar
Avatar
Avatar
Avatar
3
Aug 25
2767
Product import: how to format the External ID of its category?
import categories
Avatar
Avatar
1
Nov 23
3912
Import Products by SKU Solved
product import
Avatar
Avatar
2
Mar 24
6797
PRODUCT LISTS IMPORTING ISSUE Solved
product import
Avatar
Avatar
1
Feb 22
3921
No import button Solved
product import
Avatar
Avatar
5
Nov 21
14917