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):
- variant.csv
- date.csv
Prerequisites:
The Items entity must be completed before uploading the Inventory entity.
Important note: Fields bolded and marked with an asterisk (*) are mandatory.
File name: inventory.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique system ID for the entity. This ID is used anytime you would like to make updates or changes to the order in TDI or when using TDI to associate additional details to the order. If you do not have an existing ID to use in this field, you will need to create one. |
_ |
No character restrictions, but the ID should not contain spaces. |
|
item* |
ID number of the item. |
_ |
No character restrictions. Find the ID for the item in the ID column of the item.csv upload sheet. |
|
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. |
|
location |
Facility associated with the item. |
- |
No character restrictions. Location IDs can be found in the ID column of the location.csv upload sheet. |
|
baseNumber |
Base level of inventory for the item. This is the smallest unit that you want to keep track of. |
Enter the label for the base level of your inventory. |
No character restrictions. |
|
altBaseNumber |
Alternative name for the baseNumber field. Use this if you and your customer use different names to refer to the same thing. |
Enter the alternative label for the base level of your inventory. |
No character restrictions. |
|
secondaryNumber |
Second level of inventory for the item. |
Enter the label for the second level of your inventory. |
No character restrictions. |
|
altSecondaryNumber |
Alternative name for the secondaryNumber field. Use this if you and your customer use different names to refer to the same thing. |
Enter the alternative label for the second level of your inventory. |
No character restrictions. |
|
tertiaryNumber |
Third level of inventory for the item. |
Enter the label for the third level of your inventory. |
No character restrictions. |
|
altTertiaryNumber |
Alternative name for the tertiaryNumber field. Use this if you and your customer use different names to refer to the same thing. |
Enter the alternative label for the third level of your inventory. |
No character restrictions. |
|
storageLocation |
Storage location associated with the item. |
- |
No character restrictions. Location IDs can be found in the ID column of the location.csv upload sheet. |
|
subStatuses |
Various substatus code(s) associated with an inventory record (for example, Available, Committed, Damaged). | - | Value can be single e.g. refurb or multiple e.g. "refurb,walmart" (in this case it should be wrapped with double quotes). |
|
holdCodes |
Various hold code(s) associated with an inventory record. | - | Value can be single e.g. CHROL or multiple e.g. "CHROL,PROD" (in this case it should be wrapped with double quotes). |
File name: variant.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique system ID for the entity. This ID is used anytime you would like to make updates or changes to the order in TDI or when using TDI to associate additional details to the order. If you do not have an existing ID to use in this field, you will need to create one. |
_ |
No character restrictions, but the ID should not contain spaces. |
|
contextId* |
ID of the inventory the item is associated with. |
_ |
No character restrictions, but the ID should not contain spaces. |
|
type* |
Variant code that designates the item’s inventory status. |
Available: 35011 Expected: 35012 Committed: 35013 On hold: 35014 Damaged: 35015 On hand: 35016 Original: 35017 Current: 35018 |
Enter the appropriate type code. |
|
baseQty |
Quantity of the item. |
- |
No character restrictions. |
|
baseQtyUnit |
Quantity unit of the item. |
Enter the appropriate unit code of the item. |
|
|
netWeight |
Net weight of the item. |
- |
No character restrictions. |
|
netWeightUnit |
Net weight unit of the item. |
lb: 1520 kg: 1521 t: 1522 oz: 1523 ton: 1524 g: 1525 lt: 1526 |
Enter the appropriate weight unit code of the item. |
|
grossWeight |
Gross weight of the item. |
- |
No character restrictions. |
|
grossWeightUnit |
Gross weight unit of the item. |
lb: 1520 kg: 1521 t: 1522 oz: 1523 ton: 1524 g: 1525 lt: 1526 |
Enter the appropriate weight unit code of the item. |
File name: date.csv
|
Field |
Descriptions |
Values/codes |
Format/restrictions |
|
id* |
Unique system ID for the entity. This ID is used anytime you would like to make updates or changes to the order in TDI or when using TDI to associate additional details to the order. If you do not have an existing ID to use in this field, you will need to create one. |
_ |
No character restrictions, but the ID should not contain spaces. |
|
contextId* |
ID of the inventory the item is associated with. |
_ |
No character restrictions, but the ID should not contain spaces. |
|
type* |
Date types that can be associated with an item. |
Best by date: 35401 Code date: 35402 Depleted date: 35403 Expiration date: 35404 Production date: 35405 Slaughter date: 35406 Received date: 35407 |
Enter the appropriate date type code. |
|
value* |
Date that the date type code is applied to the item. |
_ |
Format: YYYY-MM-DD |
<%= heading %>