All columns to be imported must be formatted as text in the Excel sheet. If this is not done, you risk that data will not be imported into 24SevenOffice.
NOTE: When using decimals in prices etc, comma must be used as a decimal separator.
Remember that price fields must be imported without letters and currency characters.
products | |||||
Import Name | Explanation | ||||
ProductBatchNo | batch number | ||||
Product Status | Active = 1, Inactive / Expired = 0 | ||||
Product Cash Percent | Cash contribution cover | ||||
ProductCategory | The product category in which the product should be located | ||||
Product Code | Defines the supplier's product code | ||||
ProductDescLong | Further description of the product | ||||
ProductDescShort | Brief description of the product | ||||
ProductEAN - EAN number | EAN number | ||||
ProductEAN2 - EAN number (2) | EAN Number (2) | ||||
Product Name | product Name | ||||
ProductNo | SKU | ||||
Product Cost | Indirect cost | ||||
Product Price | Defines output price | ||||
ProductPrice2 | Defines output price 2 | ||||
ProductPrice2AutoCalc | Auto calculate the price for price 2, the value is 0 for no or 1 for yes | ||||
ProcuctPrice2Percent | Coverage contribution price 2 | ||||
ProductPriceAutoCalc | Calculate the price for the standard price, the value is 0 for no and 1 for yes | ||||
Product Price Cash | Defines cash price | ||||
ProductPriceCashAutoCalc | Defines cash calculation autocalculation | ||||
ProductPriceCashIncTax | Defines cash price including VAT | ||||
ProductPriceIn | Defines the price | ||||
ProductPriceIncTax | Defines the price including VAT | ||||
Product Price Percent | Contribution margin | ||||
Product Price Profit Margin | The profit margin | ||||
ProductSupplierPrice | Supplier's price | ||||
Product Price Group | Product Price Group | ||||
ProductPriceWeb | Product price on web store | ||||
ProductPriceWebAutoCalc | Auto calculate the price for the web price, the value is 0 for no or 1 for yes | ||||
ProductPriceWebPercent | Coverage web price | ||||
ProductStockInfluence | Decides whether the product should be inventory controlled, 1 if it is inventory controlled, 0 or empty if it is not inventory controlled | ||||
Product Stock Location | Storage Location | ||||
ProductStockMin | Minimum quantity in stock | ||||
ProductStockQty | Inventories | ||||
ProductStockReorderQty | Order proposals reach the smallest number in stock | ||||
Product Weight | The weight of the product in Kg | ||||
ProductSupplierCode | Vendor Part Number | ||||
ProductSupplierCurrencyId | Currency ID on the product (Id »one can be found by going to the Financial Accounting and Currency module) | ||||
ProductSupplierId | Supplier's ID number (to link supplier to product) | ||||
ProductSupplierName | Supplier's product name | ||||
ProductSupplierWebsite | Supplier's website | ||||
ProductWebDeal | Web Offers | ||||
ProductWebDealDateFrom | Start the date of the offer on the web | ||||
ProductWebDealDateTo | End date for web deals | ||||
ProductWebDealInStockOnly | Only show product on web if in stock | ||||
ProductWebExtra | View as extras (e-commerce) | ||||
ProductWebExtraDateFrom | Start date for when to display the product as an extra item (e-commerce) | ||||
ProductWebExtraDateTo | End date for when to display the product as an extra item (e-commerce) | ||||
ProductWebNewArrival | View as new product (e-commerce) | ||||
ProductWebNewArrivalDateFrom | Start date for when to display the product as an extra item (e-commerce) | ||||
ProductWebNewArrivalDateTo | End date for when to display the product as an extra item (e-commerce) | ||||
ProductWebShow | Show on web shop | ||||
ProductWebShowCat | Display the category on the webshop | ||||
ProductWebShowFront | Show on cover | ||||
CalculateInpriceFromSupplierPrice | If the value is 1, the import will calculate the price based on the supplier's SupplierPrice price, otherwise the ProductPriceIn price will be used (if the price is in the import file) |
Import of product categories | |||||
Import Name | Explanation | ||||
ProductCategoryId | Category ID for the product category | ||||
ProductCategoryName | Name of category | ||||
ProductCategoryParent | Defines which categories are linked upward in the hierarchy |