Data Import Error – “The following values do not exist for Item Group”

1

image
image1918×906 66.1 KB

Hi everyone,

I’m trying to import Item data into ERPNext using the Data Import tool, but I’m getting an error during import.

Error message:

“The following values do not exist for Item Group: finished goods”

I selected:

  • Document Type: Item
  • Import Type: Update Existing Records

In my Excel file, the Item Group column contains values like:

  • finished goods

But the import is not proceeding because of this validation error.

My questions:

  1. Does the Item Group name in Excel need to exactly match the Item Group available in ERPNext?
  2. Is the issue because of lowercase/uppercase mismatch?
  3. Do I need to create the Item Group manually before importing?
  4. Is there any recommended format for importing Item Groups correctly?

I have attached the screenshot for reference.

Any guidance would be really helpful.

Thanks in advance! :folded_hands:

2

Best practice before importing

In Excel:

  • Use exact copied names from ERPNext
  • Remove trailing spaces
  • Avoid different capitalization
  • Avoid duplicate names
  • Use Data → Trim/Clean if needed

A super practical trick:

  1. Export existing Item Groups from ERPNext
  2. Copy-paste names into your import sheet
  3. Use those exact values

Note: Every value used in a Link field must already exist in ERPNext before importing. This includes fields like Item Group, UOM, Warehouse, Brand, Company, Customer, Supplier, etc. If the linked record does not exist or the name does not exactly match, the import will fail.