Inventory Item Import Errors
This section describes errors that you might see on an inventory item import. See the following:
Invalid Locale Reference Key XX
The error occurs when:
-
The Multi-Language feature is enabled, and
-
You are creating an inventory item, and
-
The CSV file contains following columns:
-
Item Name
-
Purchase Tax Code
-
Sales Tax Code
-
Quantity On Hand
-
Price
-
Price Level
-
Location
-
Translation Language
-
Translation Display Name
-
To resolve this error, first import the item without the translation, and then update the imported items with the translation data.
Importing the Item
To import the item, make sure you choose the following options:
-
Set Data Handling to Add.
-
On the Field Mapping page, set the following:
-
Item Name = Item Name/Number
-
Purchase Tax Code = Purchase Tax Code
-
Sales Tax Code = Sales Tax Code
-
Quantity On Hand = Locations 1: Quantity on Hand
-
Location = Locations 1: Location
-
Price = Pricing 1: Price (Req)
-
Price Level = Pricing 1: Price Level
-
-
If Quantity Pricing is enabled, add to the mapping the field 0 = Pricing 1: Quantity (Reg)
Update the Imported Items
Next, update the imported Items with the translation data using the same CSV file, but with different data handling, and different mapping.
-
Set Data Handling to Update.
-
On the Field Mapping page, set the following:
-
Item Name = Item Name/Number
-
Purchase Tax Code = Purchase Tax Code
-
Sales Tax Code = Sales Tax Code
-
Translation Language = Translation 1: Language
-
Translation Display Name = Translation 1: Display Name
-
The record you are attempting to load has a different type: inventoryitem from the type specified: serializedinventoryitem
The record type selected in the Import Assistant must match the item type. This error means you tried to update an inventory item but picked "serialized inventory item" as the record type. Make sure you select "inventory item" for the import.
The following CSV file(s) have errors in them and can't be imported into the system: Multiple values found for a dropdown field that can only take one when importing a record with External ID that uses special character
To fix the field mapping error, select items as the import type and inventory item as the record type.
On the Advanced Options menu, set the Custom Multi-Select Value Delimiter field to any special character that is not used in the string "SNG-EDUC|SKU-1004921210/08/2010|14:06:00"
For example, do not use the pipe (|) or slash (/). Also, do not use a space as a delimiter.
If you set the Custom Multi-Select Value Delimiter to NULL, you’ll get an error because NetSuite treats it like a Space.