To find the import page log in to the admin back office and then navigate to Network > Imports. On the next page (image below) you can find multiple sections, first we are going to explain the Product Total Price Import that is being used when creating new products or updating already existing products.
To download the example file, right click the ‘here’ in the ‘Example file can be found here’ and copy the link address and open it in a new tab in the browser. After downloading the file open and follow the instructions in it.
In short:
There are several fields: ID, ExternalItemID, Name, Description, ImageURL, ProductType, WeightPercentAllowance, ArticleNumber, BarcodeNr, PriceType, RentalPrice, RentalTax, Deleted, TotalPrice, TotalPriceTaxRate, Tax and ExternalCost
| Titel | Description |
| ID | This field is currently not in use, so set is a 0. This is something that is planned to be used in the future. |
| ExternalItemID | This field connects the products in the system and in the import file. This needs to be unique when creating a new product or be exactly the same if we are updating a given product. |
| Name | This field contains the Name for the product. |
| Description | This field contains the Description of the product. |
| ImageURL | Here after uploading images in the system, you can link them with the name of the corresponding image. |
| ProductType | Set this field to 0 for normal products and 5 for products sold as KG products. |
| WeightPercentAllowance | In this field is specified the weight difference allowed between products (for ex. some items like sandwiches will never be all the same weight) |
| ArticleNumber | This field should contain the article number of the product |
| BarcodeNr | This field should contain the barcode number of the product |
| PriceType |
|
| RentalPrice | This field should contain the rental price of the product, if this is a rental product if not set to 0 |
| RentalTax | This field should contain the rental tax of the product, if this is a rental product if not set to 0 |
| Deleted | If you want to delete a product set this field to 1 if not set it to 0. |
| TotalPrice | This field should contain the price of the product |
| TotalPriceTaxRate | This field should contain the tax price of the product |
| Tax |
This one is not used, so keep it at 0. It's required for the server to have a storage position for the Tax that is calculated.
|
| ExternalCost | In this field you (the customer) can keep the purchase cost of the product. |
TotalPrice and TotalPriceTaxRate work together. Default value is 0 for these. If they have a value above 0, then it will override the Price and Tax column with a generated value based of TotalPrice and TotalPriceTaxRate.
Ex. TotalPrice 100 with a TotalPriceTaxRate of 10 will set Price to 9,09 and Tax to 0,91.
Overriding prices - Import Generic Price
To override prices for already created products use the Import Generic Price file. Download the file the same way as described above.
After downloading the file open it and follow the instructions.
Make sure that you fill the Price, Tax and Product (with the product ID from the admin back office). Then you can use multiple fields or some to override the price for a specific kiosk or multiple.
For example you can override the price for kiosk ID 10 by entering the number 10 in the kiosk field together with the new price and the product id.
Or if you want to override it for a certain operator then enter the operator ID in the same name field and the new price with the product ID.
There is also the possibility if there are two kiosks on the same location to be overridden with different prices from each other with entering the kiosk id, location id and the operator id in the fields.
To import the files just click the Import file button in the section you are importing to. Then select the file and click Open. Than after few seconds you will be shown if the file is successfully imported or not with the Return Data.