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.
|PriceListId||Pricelist ID. Mandatory. This can be found under the module Administration-Settings-Economy-Product and Price list.|
|ProductId||Product id.ProductId or ProductNo is mandatory|
|ProductNo||Product number can be used instead of ProductId.|
|Product Name||Alternate product name (max. 150 characters).|
|ProductDescShort||Alternatively short description (max 500 characters).|
|ProductDescLong||Alternatively long description (max 4000 characters).|
Price list imports update price lists for products. The price lists themselves are posted under Administration - Settings - Finance - Product - Price list, and the prices that are imported are entered on the product cards on the Price list tab. When creating a new order, you can choose in the order which price list you want to use on the Invoice information tab in the order.
At step 2/5 of the import, you can choose whether or not to update the existing price list. If you choose no here, the import will only be used to enter new price lists.