Before starting an upload, make sure you have read the information available in the Introduction to TDI and Importing data with TDI articles and followed the guidance provided.
Mandatory file:
Optional file(s):
Prerequisites:
None are required, but we recommend uploading Groups and Customers before Items, in accordance with the recommended upload order.
Important note: Fields bolded and marked with an asterisk (*) are mandatory.
File name: Item.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique item ID for the entity. This ID is used anytime you would like to make updates or changes to the Item in TDI or when using TDI to associate additional details to the Item. If you do not have an existing ID to use in this field, you will need to create one. |
- |
Important note: ID cannot contain any spaces. |
|
name* |
The name of the Item. |
- |
No character restrictions. |
|
customId |
Optional additional Item identifier. |
- |
No character restrictions. |
|
account* |
Customer account ID associated with the Item. |
- |
No character restrictions. Find the account ID for the Customer in the ID column of the customer.csv upload sheet. |
|
status |
Status of the Item. |
Active : 35001 Inactive: 35002 |
Enter the appropriate status code from the previous column. |
|
countryOfOrigin |
Country of origin. |
- |
No character restrictions. |
|
Type |
Indicates the item type. A product can act as a parent entity to an Item. |
Product: 35072 Item: 35071 |
Enter the appropriate item type code from the previous column. |
|
shelfLife |
Shelf life of the Item. |
- |
Integers only. |
|
shelfLifeCode |
A code assigned to a shelf-life Item to indicate its storage time period. |
Days: 35351 Weeks: 35352 Months: 35353 Years: 35354 |
Enter the appropriate item shelf-life code from the previous column. |
|
catchWeight |
Catch weight for the Item. |
Inbound: 35051 Outbound: 35052 Both: 35053 None: 35054 |
Enter the appropriate item catch-weight code from the previous column. |
|
isPerishable |
Indicates if the Item is perishable. |
True/False |
Enter True if the Item is perishable or False if it is not. |
|
isOdorSensitive |
Indicates if the Item is odor sensitive. |
True/False |
Enter True if the Item is odor sensitive or False if it is not. |
|
isHazmat |
Indicates if the Item is hazardous. |
True/False |
Enter True if the Item is hazardous or False if it is not. |
|
notes |
Enter any notes about the Item. |
- |
No character restrictions. |
|
externalIdType |
Selector for an optional additional item identifier type. |
Other #: 3545 Item #: 35451 Manufacturer part #: 35452 Serial #: 35453 SKU #: 35454 Warehouse #: 35455 |
Enter the appropriate item identifier code from the previous column. Required if entering an external ID value. Note: Any additional external IDs need to be configured in the externalIds.csv. |
|
externalIdValue |
Optional additional item identifier. |
- |
No character restrictions. |
|
unitOfMeasure |
Packaging unit of measure for the Item. |
Enter the appropriate UOM code. The list of codes is linked in the previous column. Required if entering length, width, and/or height of the item. Note: Any additional item packaging information will be configured in the package.csv file. |
|
|
length |
Length of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
width |
Width of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
height |
Height of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfDimension |
Measuring unit used to define package dimensions. |
in: 1530 cm: 1531 ft: 1532 m: 1533 mm: 1534 yard: 1535 |
Enter the unit of dimension code found in the previous column. |
|
netWeight |
Item weight less the weight of packaging and shipping materials. |
- |
Integers only, but can use decimal (Float character allowed). |
|
grossWeight |
Total Item weight. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfWeight |
Unit used to define Item weight. |
lb: 1520 kg: 1521 t: 1522 oz: 1523 ton: 1524 g: 1525 |
Enter the appropriate item weight code. |
|
freightClass |
Item's freight class. |
Enter the appropriate freight class code. Code table is linked in the previous column. |
|
|
nmfc# |
National Motor Freight Class number. |
- |
No character restrictions. |
|
nmfcSub |
NMFC sub code. |
- |
No character restrictions. |
|
itemValue |
Dollar value of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
currency |
Currency used to define Item value. |
USD: 1550 CAD: 1551 INR: 1552 EUR: 1553 AED: 1554 AFN: 1555 |
Enter the code for the appropriate currency. |
|
ti |
Number of packaged Items that can fit on a pallet in a single tier (layer). |
- |
Integers only. |
|
hi |
Number of tiers (layers) that can fit on a pallet stacked. |
- |
Integers only. |
|
volume |
Volume of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfVolume |
Unit used to define Item volume. |
in³: 1850 gal: 1851 l: 1852 Imp. gallon: 1853 Cubic Meter: 1854 Cubic Yard: 1855 Cubic Foot: 1856 |
Enter the code for the Item unit of volume. |
|
minTemp |
Minimum temperature acceptable for Item storage. |
- |
Integers only, but can use decimal (Float character allowed). |
|
maxTemp |
Maximum temperature acceptable for Item storage. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfTemp |
Unit used to define minimum and maximum Item storage temperature. |
°F: 1510 °C: 1511 |
Enter the code for either Fahrenheit or Celsius. |
|
isStackable |
Indicates if the Item is stackable. |
True/False |
Enter True if the Item is stackable or False if it is not. |
|
maxStackCount |
Indicates the maximum number of stacked Items. |
- |
Integers only. |
|
attributeType |
A pre-defined additional attribute type on an inventory Item. |
Enter the appropriate attribute type code. Attribute type codes are linked in the previous column. Required if attribute value is provided. |
|
|
attributeValue |
The default value for the additional attribute. |
- |
No character restrictions. |
|
isPrimary |
Indicates the primary packaging unit. |
True or False |
Enter True if it is the primary packaging unit or False if it is not. Important note: Enter True if you want the weights, dimensions, and units information to populate for items in shipments. |
|
groupId |
If the Item should belong to a group, enter the Turvo reference ID for the group to establish the mapping. Note: If the item belongs to multiple groups, additional groups will be configured in the optional group.csv file. |
_ |
No character restrictions. Find the reference ID for the respective group in the Group.csv upload sheet. |
|
identification |
UN number of the hazardous item. |
_ |
Enter the UN number of the hazardous item without spaces. |
|
shippingName |
Proper shipping name of the hazardous item. |
_ |
Enter the shipping name of the hazardous item as it is written in the Code of Federal Regulations. |
|
hazardClass |
Hazard class of the hazardous item. |
_ |
Enter the number of the hazard class only. Do not enter the word “Class.” |
|
packingGroup |
Packing group of the hazardous item. |
_ |
Enter the packing group number as a Roman numeral: I, II, or III. |
|
emergencyContact |
Emergency contact for the hazardous item. |
_ |
Enter the name of the emergency contact for the hazardous item. |
Filename: package.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique package ID for the entity. If you do not have an existing ID to use in this field, you will need to create one. |
- |
Important note: ID cannot contain any spaces. |
|
contextId* |
Refers to the respective Item ID. |
- |
No character restrictions. Item IDs can be found in the ID column of the item.csv upload sheet. |
|
unitOfMeasure* |
Packaging unit of measure for the Item. |
Enter the appropriate unit of measure code. Unit of measure codes are linked in the previous column. |
|
|
length |
Length of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
width |
Width of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
height |
Height of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfDimension |
Unit used to define package dimensions. |
in: 1530 cm: 1531 ft: 1532 m: 1533 mm: 1534 yard: 1535 |
Enter the code for the appropriate unit of dimension. |
|
netWeight |
Item weight less the weight of packaging and shipping materials. |
- |
Integers only, but can use decimal (Float character allowed). |
|
grossWeight |
Total Item weight. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfWeight |
Unit used to define Item weight. |
lb: 1520 kg: 1521 t: 1522 oz: 1523 ton: 1524 g: 1525 |
Enter the code for the appropriate unit of weight. |
|
freightClass |
Freight class of the Item. |
Freight Class codes table |
Enter the code for the appropriate freight class. Freight class codes are linked in the previous column. |
|
nmfc |
National Motor Freight Class number. |
- |
No character restrictions. |
|
nmfcSub |
NMFC sub code. |
- |
No character restrictions. |
|
itemValue |
Dollar value of the packaged Item. |
_ |
Integers only, but can use decimal (Float character allowed). |
|
currency |
Currency used to define Item value. |
USD: 1550 CAD: 1551 INR: 1552 EUR: 1553 AED: 1554 AFN: 1555 |
Enter the code for the appropriate currency. |
|
ti |
Number of packaged Items that can fit on a pallet in a single tier (layer). |
- |
Integers only. |
|
hi |
Number of tiers (layers) that can fit on a pallet stacked. |
- |
Integers only. |
|
volume |
Volume of the packaged Item. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfVolume |
Unit used to define Item volume. |
in³: 1850 gal: 1851 l: 1852 Imp. gallon: 1853 Cubic Meter: 1854 Cubic Yard: 1855 Cubic Foot: 1856 |
Enter the code for the Item unit of volume. |
|
minTemp |
Minimum temperature acceptable for Item storage. |
- |
Integers only, but can use decimal (Float character allowed). |
|
maxTemp |
Maximum temperature acceptable for Item storage. |
- |
Integers only, but can use decimal (Float character allowed). |
|
unitOfTemp |
Unit used to define minimum and maximum item storage temperature. |
°F: 1510 °C: 1511 |
Enter the code for either Fahrenheit or Celsius. |
|
isStackable |
Indicates if the Item is stackable. |
True/False |
Enter True if the Item is stackable or False if it is not. |
|
maxStackCount |
Indicates the maximum number of stacked items. |
- |
Integers only. |
|
attributeType |
A pre-defined additional attribute type on an inventory Item, such as a default hold code or a manufacturing date. |
Enter the appropriate attribute type code. Attribute type codes are linked in the previous column. Required if attribute value is provided. |
|
|
attributeValue |
The default value for the additional attribute. |
- |
No character restrictions. |
|
isPrimary |
Indicates the primary packaging unit. |
True/False |
Enter either True if this is the primary packaging unit or False if it is not. |
File name: externalIds.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique external ID for the entity. This ID is used anytime you would like to make updates or changes to the external IDs in TDI or when using TDI to associate additional details to the account. If you do not have an existing ID to use in this field, you will need to create one. |
- |
Important note: ID cannot contain any spaces. |
|
contextId* |
Refers to the respective Item ID. |
- |
No character restrictions. Item IDs can be found in the ID column of the item.csv upload sheet. |
|
type* |
The external ID type. |
Other #: 3545 Item #: 35451 Manufacturer part #: 35452 Serial #: 35453 SKU #: 35454 Warehouse #: 35455 |
Enter the appropriate item identifier code. |
|
value* |
Value of external ID in the user interface. |
- |
No character restrictions. |
|
account |
Customer account name. |
- |
No character restrictions. |
File name: group.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique system ID for the entity. If you do not have an existing ID to use in this field, you will need to create one. |
- |
Important note: ID cannot contain any spaces. |
|
contextId* |
Refers to the respective Item ID. |
- |
No character restrictions. Item IDs can be found in the ID column of the item.csv upload sheet. |
|
groupId* |
This ID corresponds to the Group that the Item above should be added to. |
_ |
Find the reference ID for the respective group in the ID column of the Groups mandatory upload sheet. No character restrictions. |
<%= heading %>