Using CSV Import for Serialized Items
Use the following procedure to import serialized items.
To use CSV import for serialized items:
-
Create a CSV file to be imported:
-
Enter 1 in the Item Type column.
-
Enter Serialized in the Costing Method Column.
-
In the Serial Number column, enter the serial numbers for the items you have on hand. Separate serial numbers with a comma or space. The number of serial numbers entered for an item must match the number entered in the Quantity On Hand column for that item.
-
Save your file as a .csv file when you are finished.
-
-
In NetSuite, go to Setup > Import/Export > Import CSV Records.
The Import Assistant opens. For more information, see CSV Imports Overview.
-
On the first page of the Import Assistant:
-
Select Items from the Record Type list.
-
Select Serialized Inventory Item from the Subtype list.
-
Click the Select button to browse to the CSV import file you created.
-
Click the Next button.
-
-
Continue completing options in the Import Assistant.
For more information, see Importing CSV Files with the Import Assistant.