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