Uploading Vendor and Vendor-item association files

Inventory Managers or Operations Managers can upload vendor details in a CSV file.

Each row defines a new or existing vendor and its associated address and contact information for use in the Inventory dashboard.

The values in the file are used to update your vendor listing in the Inventory.

Usage considerations

  • Any file name can be used.
  • The file header contents and column order must be identical to the sample template. No empty columns for spacing are permitted.
Restriction:
  • English is the only supported language for inventory content.

Sample vendor upload template

An example, included in the vendor-sample.csv sample fie, is as follows.
Where:
VENDOR_REFERENCE
Mandatory: Your internal vendor ID. In the Vendor Management screen of the Inventory Dashboard, this is the entry you will select on to manually edit vendor information.
VENDOR_NAME
Mandatory: Your name for the vendor.
EMAIL
Mandatory: The primary email contact address for the vendor.
PHONE
Mandatory: The primary contact telephone number for the vendor.
VENDOR_ADDRESS
Mandatory: Your vendor's street address. (in the sequence of AddressLine1, city, state, country, zip/postalcode).
STATUS
Optional: The allowed states for Status are 1, 0 or no value. 1 means the vendor is active.0 or no value means they are inactive.
MARK_FOR_DELETION
Optional: This field permits two states: 1 or 0. 0 or a null entry means that the vendor details are not deleted.1 means that the vendor details are deleted. This is a "soft" delete, meaning that the vendor is not available for new operations. When MARK_FOR_DELETION is set to 1, vendors with active purchase orders cannot be deleted and will be skipped.

Sample vendor–item association template

An example, included in the vendorSkuRel-sample.csv sample fie, is as follows.
Where:
VENDOR_ID
The primary database key for your vendor. This is a generated integer.
PARTNUMBER
Your unique identifier for the product or service provided by the vendor.