Layout file pricelist.csv
This file contains items to sell which can be organized in blocks (menu's).
- The seperator used in csv (comma seperated value) files can be either "," or ";".
The use use of a specific seperator can be forced using "csv_seperator" in preferences.txt.The regional and language options of your computer may cause a conflict
between the Spreadsheet program and the casgregister program.
The cashregister program uses a decimal dot and not a comma for decimal numbers !! - Menu sections are optional and don't have to be used, just items is enough.
A menu section is defined as: "menu A",,,,,"Note to the menu A"
The keyword is: menu. Example: "menu Pizza's",,,,,"any text"An end menu section is defined as: "end_menu",,,,,""
It defines the end of any started menu, continue with a new menu or an item or nothing.
Menu's within menu's are allowed. See the example pricelist.csv
- An item is defined as follows:
"item description",value_1,value_2,value_3,value_4,"Note to item"[,"barcode"]
Item example: "Pizza Carrello",5.50,3.50,1,10,"tomaten, kaas, oregano"
"item description" = The description of the item, in the example "Pizza Carrello"
value_1 = retail price including tax, in the example 5.50
value_2 = wholesale price excluding tax, in the example 3.50
value_3 = TAX class, references to TAX1 = 1, TAX2 = 2, TAX3 = 3, TAX4 = 4, TAX5 = 5
value_4 = the number of items in stock, in the example 10. Negative stock values are not possible.
"note" = any addional information with the item, in the example "tomaten, kaas, oregano"
"barcode" = optional, the barcode of the item. The example, Pizza Carrello, has no barcode.To allow the use of "," and ";" within "item description" and "note" they must be between quote's.
To allow the use of any text as "barcode" it must be between quote's.
