Stock Item Excel Fields

sku

String

M

SKU of the stock item.

Must be at least 3 characters long.

supplierGln

String

O

Supplier’s Global Ledger Number.

supplierId

String

O

Supplier’s product ID.

manufacturerProductId

String

O

Manufacturer’s product ID.

name

String

M

Name of the stock item.

baseUnit

Enum

M

Base unit of the stock item.

category:group:id

String - ID

M

Identifier of the stock item’s category in the category type group.

category:group:Name

String - Name

M

Name of the stock item’s category in the category type group.

category:[category name]:id

String - ID

O

Identifier of the stock item’s category in a category type.

category:[category name]:Name

String - Name

O

Name of the stock item’s category in a category type.

taxpercent

Decimal

M

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

stockUnit

Enum

O

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

stockUnitName

String

O

Name of the stock item’s package. For instance: 6-pack.

stockUnitSize

Decimal

O

Package conversion rate (the amount of Base Units in the package.)

stockPackageGtin

String

O

Global Trade Item Number of the package.

stockUnitPurchasePrice

Decimal

O

Purchase price of a single stock unit. Used in conjunction with stockUnitName and stockUnitSize to set purchase price for a package.

baseUnitPurchasePrice

Decimal

O

Purchase price of a single base unit.

If left empty, the purchase price will automatically be set to €0.

capacityUnitCode

Enum

O

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

capacityUnitAmount

Decimal

O

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

isAppliedtoAllStocks

Boolean

M

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