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.
Price-list | |||||
Import Name | Explanation | ||||
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. | ||||
PriceOut | retail prices | ||||
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.