TDI field mapping tables - Items

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.

Unit of Measure Codes List

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.

Freight Class codes table

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.

Attribute Type codes table

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.

Unit of Measure Codes List

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.

Attribute Type codes table

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.

 

 

Was this article helpful?

0 out of 1 found this helpful