Inventory Data
General Information
-
Inventory data provided for initial loading and configuration must comply with the formatting structure of data template provided.
Data Columns
The table below lists the columns and which columns are required or optional.
Column Name | Column Required | Notes |
---|---|---|
Category | Required | |
Name | Required | |
Description | Required | |
UOM | Required | |
UOM Factor | Required | |
Re-Order Level | Required | |
Quantity | Optional | |
Max Purchase Order Limit | Optional | |
Cost | Optional | |
Sales Price | Optional | |
Lot | Optional | |
Location | Optional | |
Expiration | Optional | |
Manufacturer Name | Required | |
Address1 | Optional | |
Address2 | Optional | |
City | Optional | |
State | Optional | |
Zip | Optional | |
Contact Name | Optional | |
Contact Phone | Optional | |
Contact Email | Optional | |
Web Address | Optional | |
Notes | Optional | |
Manufacturer Part Name | Optional | |
Manufacturer Part Number | Optional | |
Stock Number | Optional | |
Vendor Name | Required | |
Address1 | Optional | |
Address2 | Optional | |
City | Optional | |
State | Optional | |
Zip | Optional | |
Contact Name | Optional | |
Contact Phone | Optional | |
Contact Email | Optional | |
Web Address | Optional | |
Notes | Optional | |
Vendor Part Name | Optional | |
Vendor Part Number | Optional | |
Stock Number | Optional |