Note: When the Include Data checkbox is checked, the template is created with the existing item data. Otherwise the system creates a blank template to enter new items.

Column Name	Required	Note
ItemSK		This is never editable.
ItemID	X	This is not editable when editing existing items. Must be unique when importing new items.
ItemDescription	X
SalesInvoiceDescription
BarCodeLabelDescription
ShippingDescription
ItemType	X
ItemClass	X
ItemAttributeClass	(X)	This is required if attribute values are being imported. Attribute values cannot be imported without the Attribute Class property.
ProductionBatchClass
QualityTestClass
ManageItemsBy	X
IsVariableWeight
AllowVariableOrderedQty
RequiresWholeUnits
IsLotTracked
IsInactive
UOMSchedule	X
UnitDecimals
WeightDecimals
PriceDecimals
SalesOrderUnitUOM
SalesOrderWeightUOM
SalesOrderPriceUOM
InventoryUnitUOM
InventoryWeightUOM
DefaultReportingUOM
UnitTareWeight
ShippingWeight
PalletConfiguration
CostUOM
CostGroup
ValuationMethod
StandardCost
ActualCost
MarketCost
IsTaxableForSales
IsVisibleToWMS
ExpirationDays
HoldCodeNewLots
HoldCodeSalesReturns
UPC
GTIN
ItemAttributes		Each item attribute is displayed as a column. If the item attribute is a list type, users can import new values and these are added to the attribute list. Note that the Attribute Class must be provided when importing attribute values.
BrokerageExpenseAccount
BrokerageAccrualAccount
BrokerageWriteOffAccount
FreightExpenseAccount
FreightAccrualAccount
FreightRevenueAccount
TransferFreightExpense
TransferFreightAccrual
InventoryBalanceSheetAccount
InventoryAdjustmentAccount
DepreciationAccount
CostOfGoodsSoldAccount
SalesAccount
MarkdownAccount
SalesReturnsAccount
InventoryReturnedAccount
InventoryInUseAccount
InventoryInServiceAccount
InventoryDamagedAccount
CycleCountVarianceAccount
DropShipItemsAccount
PurchasePriceVarianceAccount
UnrealizedPurchasePriceVarianceAccount
AssemblyVarianceAccount
ItemCertificates		Each item certificate is displayed as a column.

Browser not supported