Import field names for Products and Product categories

All columns that are to be imported must be formatted as text in the xl sheet, otherwise that column/field may not be imported into 24SevenOffice.

NOTE! Price fields must be imported without letters or currency signs.
Field name/Column heading Note
ProductBatchNo Product Batch number
ProductStatus Active = 1, Inactive = 0
ProductCashPercent Margin percentage cash price
ProductCategory Product category that this product is to belong to
ProductCode Suppliers Product code
ProductDescLong Detailed description of product
ProductDescShort Brief description of product
ProductEAN – EAN nummer EAN Number (Barcode)
ProductEAN2 – EAN nummer(2) EAN Number Barcode (2)
ProductName Product name
ProductNo Product number
ProductCost Indirect purchase cost
ProductPrice Product Sales Price
ProductPrice2 Product Sales Price 2
ProductPrice2AutoCalc Auto calculate price for Sales Price 2: 0 for no or 1 for yes
ProcuctPrice2Percent Margin price 2
ProductPriceAutoCalc Auto calculate price for standard sales price, 0 for no or 1 for yes
ProductPriceCash Cash sales price
ProductPriceCashAutoCalc Auto calculate Cash price, 0 for no or 1 for yes
ProductPriceCashIncTax Cash price including VAT
ProductPriceIn Purchase price
ProductPriceIncTax Purchase price including VAT
ProductPricePercent Profit margin
ProductPriceProfitMargin Contribution amount
ProductSupplierPrice Suppliers price
ProductPriceWeb Sales price for web shop
ProductPriceWebAutoCalc Auto calculate price for web shop, 0 for no or 1 for yes
ProductPriceWebPercent Profit margin web price
ProductRequireSerialNo Does the product require serial number tracking, 0 for no or 1 for yes.
ProductStockInfluence Stock item or non-stock item? 1 for stock item or 0 or leave blank if non-stock item.
ProductStockLocation Warehouse location
ProductStockMin Minimum quantity in stock
ProductStockQty Stock quantity
ProductStockReorderQty Order number when reached ”minimum quantity in stock”
ProductWeight Product weight in Kilo
ProductSupplierCode Supplier’s product number
ProductSupplierCurrencyId Currency ID for product (You will find ID in Financials>Accounting>Currency)
ProductSupplierId Supplier’s ID number(to link product to supplier)
ProductSupplierName Suppliers product name
ProductSupplierWebsite Suppliers web page
ProductWebDeal Special offer for ecommerce
ProductWebDealDateFrom Start date special offer for ecommerce
ProductWebDealDateTo End date Start date special offer for ecommerce
ProductWebDealInStockOnly Only show product in ecommerce if it is in stock
ProductWebExtra Show as add on (ecommerce)
ProductWebExtraDateFrom Start date Show as add on (ecommerce)
ProductWebExtraDateTo End date Show as add on (ecommerce)
ProductWebNewArrival Show as new product (ecommerce)
ProductWebNewArrivalDateFrom Start date Show as new product (ecommerce)
ProductWebNewArrivalDateTo End date Show as new product (ecommerce)
ProductWebShow Display in ecommerce
ProductWebShowCat Display product category in ecommerce
ProductWebShowFront Display on front page in ecommerce


Import of product categories
Fieldname/ Column
Categori ID ID number for Product category
Name Product category name
ParentId ID number for (parent) Product category i.e. if this one is a sub-category
and you want to link


Also see