You can download the stock item Excel template by clicking the Download Templates icon in the toolbar of the Stock Items view. 
The following table details the fields in the stock item export/import Excel file. Some of the fields are mandatory, while the other are optional.ColumnTypeMandatory/OptionalDescriptionskuStringMSKU of the stock item. Must be at least 3 characters long.supplierGlnStringOSupplier’s Global Ledger Number.supplierIdStringOSupplier’s product ID.manufacturerProductIdStringOManufacturer’s product ID.nameStringMName of the stock item.baseUnitEnumMBase unit of the stock item.category:group:idString - IDMIdentifier of the stock item’s category in the category type group.category:group:NameString - NameMName of the stock item’s category in the category type group.category:[category name]:idString - IDOIdentifier of the stock item’s category in a category type.category:[category name]:NameString - NameOName of the stock item’s category in a category type.taxpercentDecimalMVAT percent of the stock item. This field is technically optional, but if it is left empty, the VAT percent will automatically be set to 0%, so this field should always be filled in. stockUnitEnumOStock Unit used when counting the stock. If this field is left empty, the system will automatically set the value to be the same as baseUnit when the products are imported.stockUnitNameStringOName of the stock item’s package. For instance: 6-pack.stockUnitSizeDecimalOPackage conversion rate (the amount of Base Units in the package.)stockPackageGtinStringOGlobal Trade Item Number of the package.stockUnitPurchasePriceDecimalOPurchase price of a single stock unit. Used in conjunction with stockUnitName and stockUnitSize to set purchase price for a package.baseUnitPurchasePriceDecimalOPurchase price of a single base unit. If left empty, the purchase price will automatically be set to €0.capacityUnitCodeEnumONet content unit of the stock item. Can be used if baseUnit is set to pcs, btl or pkg.For instance: cl for centiliter net content or kg for kilogram net content.capacityUnitAmountDecimalONet content amount of the stock item. Used in conjunction with capacityUnitCode to set unit amount for net content. For instance: If capacityUnitCode is set to cl, capacityUnitAmount can be set to 70, to have a bottle with net content of 70 cl.isAppliedtoAllStocksBooleanMDefines whether the possible changes made to the purchase price of the stock item are applied to all stocks.Possible values: FALSE (not applied to all stocks) or TRUE (applied to all stocks).
