Item fulfillment via CSV import > tracking numbers with more than 12 digits (Numeric) are truncated when imported into NetSuite

 Here are some ways to edit the csv file to show the correct format of the tracking numbers when imported into NetSuite.

 

Option 1

1. On the Menu tab of the csv file > click Data > Import External Data > Import Data
2. Locate the csv file that needs to be imported.
3. Double click on the file.
4. A Text Import Wizard pop up will show.
5. Set the Original Data Type = Delimited.
6. Click Next.
7. Uncheck Tab checkbox then mark/check the Comma checkbox.
8. Click Next.
9. Click on the Tracking number column.
10. Column Data Format = Text
11. Click Finish.
12. Choose where you want to put the data. (Existing Worksheet or New Worksheet)
13. Save the file.
14. Click Yes on the first warning message that will appear such as "NSFulfillOrder.csv may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook on this format?"
15. Close the csv file.
16. Click NO on the second warning message such as "Do you want to save the changes you made to 'NSFulfillOrder.csv'?" or the formatting will be changed.
17. Do not re-open the file on excel file because this will still show the truncated number but if you do the csv import, the tracking number on the Item Fulfillment will now show the complete number.

Option 2

1. Highlight the tracking number column > right click > Format Cells > Number tab > choose Text > OK.
2. Make sure to double click on each cell to show the correct format.
3. Save the csv file > click Yes on the first warning message that appeared.
4. Close the csv file > click NO on the second warning message or the formatting will be changed.
5. Do not re-open the file on excel file.

Option 3

Set the cells/column for tracking numbers to Text before entering the tracking numbers when doing a new csv file so you don't have to do option 1 and 2 to import the correct tracking numbers.