When you choose to import products, you get a choice as to whether you want to update existing products. Tick YES if desired. By default it is unchecked for NO.
Furthermore, you have to choose what to match the products against. By default, it is checked for Product number, but you can also choose to match on the Supplier's part number.
Below you will find an overview of the product information that can be updated.
All columns to be imported must be formatted as text. If this is not done, you risk that data will not be imported into 24SevenOffice.
Remember that price fields must be imported without letters and currency characters.
products | |||||
Import Name | Explanation | ||||
ProductBatchNo | batch number | ||||
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 | ||||
ProductEAN2 | EAN Number (2) | ||||
Product Name | product Name | ||||
Product Cost | Indirect cost | ||||
Product Price | Defines output price | ||||
ProductPrice2 | Defines output price 2 | ||||
ProcuctPrice2Percent | Coverage contribution price 2 | ||||
Product Price Cash | Defines cash price | ||||
ProductPriceCashIncTax | Defines cash price including VAT | ||||
ProductPriceIn | Defines the price | ||||
ProductPriceIncTax | Defines the price including VAT | ||||
Product Price Percent | Contribution margin | ||||
ProductPriceWeb | Product price on web store | ||||
ProductPriceWebPercent | Coverage web price | ||||
ProductRequireSerialNo | Whether the product requires serial number | ||||
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 | ||||
ProductSupplierPrice | Supplier's price | ||||
ProductSupplierCode | Vendor item number (Can be changed if you have not chosen to match in this field) | ||||
ProductSupplierCurrencyId | Currency ID on the product (Id »one can be found by going to the Financial Accounting and Currency module) | ||||
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 | ||||
ProductCategory | Product category name |
The following fields are not updated | |||||
Import Name | Explanation | ||||
ProductNo | product number | ||||
ProductSupplierName | Provide a product name | ||||
ProductSupplierId | Supplier's customer number (the supplier added under Categories & groups in the product window) | ||||
ProductPriceAutoCalc | Automatic calculation of output price1 | ||||
ProductPrice2AutoCalc | Automatic calculation of output price2 | ||||
ProductPriceCashAutoCalc | Cash calculation of cash price | ||||
ProductPriceWebAutoCalc | Auto Calculation of Offers, web price | ||||
ProductStockInfluence | Inventory management of products | ||||
Product Price Profit Margin | Percentage for autocalculation of coverage contributions |