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 | ||
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. |