Description
What is a SwiftPOS Price Book?
A SwiftPOS Price Book is a folder containing multiple CSV formatted TXT files that constitute all the data related to Product/Price information. The main purpose of these files is to move selected Product/Price related data between multiple SwiftPOS databases.
A Price Book can be exported from both a SwiftPOS Touch terminal and from the SwiftPOS Back Office. Once exported the Price Book files can then be used to import selected Product related data into another SwiftPOS database. Note : Importing the Price Book files back into the same SwiftPOS Back Office database, from which they were exported, will result in nothing visibly occurring, as the data already exists.
Price Book files are formatted in a CSV format and generated with a .TXT extension. This is intentionally done to avoid data being unintentionally changed when opened in Excel. For example, Barcodes are exported with leading zeros. Opening the TMPB_BARCODE.txt file in Excel would result in the leading zeros being removed by Excel.
The following files are currently generated:
- TMPB_BARCODE.txt - Barcodes always have leading zeros. Opening this file in Excel will require the Barcode to formatted as text before the saving of the file. Not doing so, may result in lost data.
- TMPB_CATEGORY.txt
- TMPB_GROUP.txt
- TMPB_MANUFACTURER.txt
- TMPB_MASTERGROUP.txt
- TMPB_PRODUCT.txt
- TMPB_PROMOTION.txt
- TMPB_SUPPLIER.txt
- TMPB_SUPPLIERITEM.txt
To Be Considered
- To copy all of a site's data to a new site's Back Office database, it is recommended to use the Backup/Restore features rather than Exporting/Importing Price Book Data. The export/import of Price Book data is limited to Product/Price related data, whereas the Backup/Restore features include all data.
Barcode File Format (TMPB_BARCODE.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Barcode |
Barcode |
Integer |
YES |
Can be any whole number up to 13 digits long. |
Number |
|
Product Code |
ProductCode |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 13 characters, e.g.: A0000001. |
Text |
Example :
"Barcode","ProductCode"
"0000026092416","PLU3902"
"000008066145","1113"
"000009016260","11192"
"0000090162602","11192"
"0000093248327","16083"
"0000093253758","1063"
"0000093253789","1065"
Category File Format (TMPB_CATEGORY.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Category Name |
Category |
Integer |
YES |
Can be any whole number between and including 0 - 254. |
Number |
|
Description |
Description |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 30 characters, e.g.: Imported Beer. |
Text |
Example :
"CATEGORY","DESCRIPTION"
1,"No Kitchen Print"
2,"COLD DRINKS"
3,"SCALE"
4,"Restricted Category"
5,"Membership Fees"
6,"INSTRUCTIONS DRINKS"
7,"INSTRUCTIONS FISH"
8,"NON-SALE"
9,"FUEL"
10,"Combos"
11,"Beer/Cider MS"
12,"Beer/Cider FS"
13,"Wine"
14,"RTD"
15,"Spirits"
200,"ENTREES"
201,"MAINS"
202,"INSTRUCTIONS COOKING"
203,"DESSERTS"
204,"SAUCES"
206,"KIDS MEALS"
208,"STARTERS"
209,"SIDES/EXTRAS"
232,"HOT DRINKS"
253,"System"
333,"Retailer Category"
Product Group File Format (TMPB_GROUP.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Group Number |
GroupNumber |
Integer |
YES |
Can be any whole number between and including 1 - 999. |
Number |
|
Description |
Description |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 30 characters, e.g.: Tap Beer. |
Text |
Example :
"GroupNumber","Description"
1,"Misc"
2,"Bar - Tap Beer"
3,"Bulk Beer - Kegs"
4,"Spirits"
5,"FUEL"
6,"Membership Fees"
7,"Entrees"
8,"Combos"
10,"Wine"
51,"Port"
54,"Instructions"
60,"Port & Cognac"
90,"UDLs Coolers & Ciders"
101,"Package Beer - Single"
103,"Package Beer - 6 Pack"
104,"Package Beer - Dozen"
105,"Package Beer - Carton"
200,"Softdrink"
210,"BIB Post Mix"
333,"Retailer Group"
412,"Dessert"
875,"Coffee and Tea"
878,"Food"
999,"System"
Manufacturer File Format (TMPB_MANUFACTURER.txt)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Manufacturer Number |
Manufacturer |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 10 characters, e.g.: Allied |
Text |
|
Manufacturer Name |
Name |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 50 characters, e.g.: Allied Distillers Limited |
Text |
|
Rebate |
Rebate |
Decimal |
No |
|
Number |
Example :
MANUFACTURER,NAME,REBATE
ALLIED,Allied Distillers Limited,0
CADBURY,Cadbury Schweppes Pty Ltd,0
COKE,Coca Cola Amitil,0
FOSTERS,Fosters Group,0
NESTLE,Nestle Australia,0
XXXX,Castlemaine Brewery Company,0
Master Groups File Format (TMPB_MASTERGROUP.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Master Group Number |
MasterGroup |
Integer |
YES |
Can be any whole number up to 999, e.g.: 45. |
Number |
|
Description |
Description |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 30 characters, e.g.: Alcohol. |
Text |
Example :
"MASTERGROUP","DESCRIPTION"
1,"Bulk Beer"
2,"Packaged Beer"
3,"Spirits"
4,"Wine"
5,"Ready to Drink"
6,"PreMix"
7,"SoftDrink"
8,"Miscellaneous"
9,"Food"
10,"Sundry Income"
11,"Retail"
Product File Format (TMPB_PRODUCT.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Product Code |
ProductCode |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 13 characters, e.g.: A0000001. |
Text |
|
Long Description |
Description |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 60 characters. |
Text |
|
POS Display |
TerminalDisplay |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 16 characters, e.g.: BABY-BEAN 2KG. |
Text |
|
PLU |
PLU |
Integer |
YES |
Can be any whole number up to 19990, e.g.: 19250. |
Number |
|
Recipe |
ParentCode |
String |
NO |
Product Code of the item to which this item has been reciped, e.g.: A0000002. |
Text |
|
Unused |
Unused2 |
NA |
NO |
NA |
NA |
|
Recipe Quantity |
RecipeQty |
Integer |
NO |
2.55 |
Number |
|
Unused |
Unused3 |
NA |
NO |
NA |
NA |
|
Stock Size |
StockSize |
Integer |
YES |
1 |
Number |
|
Units Per Case |
CaseQty |
Integer |
YES |
24 |
Number |
|
Cost |
Unused4 |
Integer |
YES |
2.50 |
Number |
|
Unused |
Unused5 |
NA |
NO |
NA |
NA |
|
Unused |
Unused6 |
NA |
NO |
NA |
NA |
|
Product Group |
Group |
Integer |
YES |
5 |
Number |
|
Prices |
Prices |
Decimal |
YES |
Must include 10 Price Levels separated by |, e.g.: 0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00| |
** |
|
Category |
Category |
Integer |
YES |
Can be any whole number up to and including 254, e.g.: 45. |
Number |
|
Product Filter |
Family |
String |
NO |
|
Text |
|
UOM |
SizeID |
Short Integer |
YES |
Unit of Measure : 1 = Each, 2 = Pack, 3 = Mililitre,4 = Litre, 5 = Gram, 6 = Kilogram, 7 = Gallon, 8 = Ounce, 9 = Pound. |
Number |
Example :
"ProductCode","Description","TerminalDisplay","PLU","ParentCode","Unused2","RecipeQty","Unused3","StockSize","CaseQty","Cost","Unused5","Unused6","Group","Prices","Category","Family","SizeID","Unused6","Extended Recipe"
" 10","XXXX HEAVY 285ML","4X HEAVY POT",1010,"17",,0.00575757575757576,,285,1,0.00,,,2,7.00|4.00|2.00|6.00|7.00|99.00|4.00|3.05|3.05|3.05,4,"",3,,
"0F5199F9EA1E","Product 71","...",71,"",,,,1,1,0.00,,,1,0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00|0.00,1,,1,,
"10109","VOD/CRUISER PASSION","VOD/CRUISER PASS",10109,"",,,,275,24,2.33,,,90,7.60|7.30|7.30|7.30|7.30|7.30|7.30|6.60|7.30|7.30,2,"",3,,
"10507","VOD/CRUISER LIME","VOD/CRUISERLIME",10507,"",,,,1,24,1.00,,,90,6.20|6.00|6.00|6.00|6.00|6.00|6.00|5.40|6.00|6.00,2,"",1,,
"10510","VOD/CRUISER RASP","VODKA R/BERRY",10510,"",,,,275,24,1.00,,,90,7.60|7.30|7.30|7.30|7.30|7.30|7.30|6.60|7.30|7.30,2,"",3,,
"10513","VOD/CRUISER BLUEBERRY","VOD/CRUS BLUEBRY",10513,"",,,,275,24,1.00,,,90,7.60|7.30|7.30|7.30|7.30|7.30|7.30|6.60|7.30|7.30,2,"",3,,
"10517","VOD/CRUISER ICE","VOD/CRUS ICE",10517,"",,,,1,24,1.00,,,90,7.30|7.00|7.00|7.00|7.00|7.00|7.00|6.30|7.00|7.00,2,"",1,,
"10523","WESTCOAST COOLER","W/CST COOLER SIN",10523,"",,,,250,24,1.00,,,90,2.50|3.30|3.30|3.30|3.30|5.00|3.30|3.00|3.30|3.30,2,"",3,,
"10526","H/LAND SCTCH&COLA CAN","H/LAND SCTCH&COL",10526,"",,,,1,24,1.00,,,90,4.40|4.20|4.20|4.20|4.20|4.20|4.20|3.80|4.20|4.20,2,"",1,,
Note : The excel format has 10 separate price level columns named Price1 to Price10 and should be formatted as Numbers.
Promotion File Format (TMPB_PROMOTION.txt)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Promotion ID |
PROMOCODE |
Integer |
YES |
Can be any whole number up to 19990, e.g.: 19250. |
Number |
|
Promotion Name |
DESCRIPTION |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 30 characters. |
Text |
|
Product Code |
PRODUCTCODE |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 13 characters, e.g.: A0000001. |
Text |
|
Product Description |
PRODUCTDESCRIPTION |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 60 characters. |
Text |
|
Start Buy Period |
STARTBUYPERIOD |
Date/Time |
YES |
|
Date |
|
End Buy Period |
ENDBUYPERIOD |
Date/Time |
YES |
|
Date |
|
Promotion Start Date |
SPECIALSTARTDATE |
Date/Time |
YES |
|
Date |
|
Promotion End Date |
SPECIALENDDATE |
Date/Time |
YES |
|
Date |
|
Cost of a Case Excl. Tax |
CASECOSTEX |
Decimal |
NO |
|
Number |
|
Cost of a Case Incl. Tax |
CASECOSTINC |
Decimal |
NO |
|
Number |
|
Promotion Price |
SPECIALSALEPRICE |
Decimal |
YES |
|
Number |
|
Promotion Category |
SPECIALCATEGORY |
Integer |
NO |
|
Number |
|
Promotion Rebate |
SPECIALREBATE |
Decimal |
NO |
|
Number |
|
Promotion Points |
SPECIALBONUSPOINTS |
Integer |
NO |
|
Number |
|
Promotion Group |
PROMOGROUP |
Integer |
NO |
|
Number |
Example :
PROMOCODE,DESCRIPTION,PRODUCTCODE,PRODUCTDESCRIPTION,STARTBUYPERIOD,ENDBUYPERIOD,SPECIALSTARTDATE,SPECIALENDDATE,CASECOSTEX,CASECOSTINC,SPECIALSELLPRICE,SPECIALCATEGORY,SPECIALREBATE,SPECIALBONUSPOINTS,PROMOGROUP
23,Tuesday Special,10039,Bangers & Mash,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,7.7500,3,0.0000,0,0
23,Tuesday Special,10040,Garlic Prawns,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,11.0000,3,0.0000,0,0
23,Tuesday Special,10041,Grilled Lemon Chicken,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,10.5000,3,0.0000,0,0
23,Tuesday Special,10042,Lasagne,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,8.7500,3,0.0000,0,0
23,Tuesday Special,10064,T-Bone Steak,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,13.2500,3,0.0000,0,0
23,Tuesday Special,10065,Rump Steak 400g xx,2017-02-16T00:00:00,2017-03-16T00:00:00,2017-03-03T00:00:00,2017-03-10T00:00:00,0,0,12.1000,3,0.0000,0,0
Supplier File Format (TMPB_SUPPLIER.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Supplier ID |
Supplier |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 10 characters, e.g.: QFFS. |
Text |
|
Supplier Name |
SupplierName |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 50 characters, e.g.: Combined Foods. |
Text |
|
Address Line 1 |
Address1 |
String |
NO |
Can be any combination of letters and numbers with a maximum length of 30 characters. |
Text |
|
Address Line 2 |
Address2 |
String |
NO |
Can be any combination of letters and numbers with a maximum length of 30 characters. |
Text |
|
State |
State |
String |
NO |
Can be any combination of letters and numbers with a maximum length of 10 characters. |
Text |
|
Postcode |
PostCode |
String |
NO |
Can be any combination of letters and numbers with a maximum length of 10 characters. |
Text |
|
Phone Number |
Phone |
String |
NO |
Can be any whole number with a maximum length of 20 digits. |
Text |
|
Fax Number |
Fax |
String |
NO |
Can be any whole number with a maximum length of 20 digits. |
Text |
Example :
"Supplier","SupplierName","Address1","Address2","State","PostCode","Phone","Fax"
"ALM","Australian Liquor Marketers","PO BOX 7224",,"QLD","4814","07 3355 1122","07 3355 1123"
"CUB","Carlton United Brewers","GPO BOX 182",,"QLD","4001","07 32120174","1300 362336"
"XXXX","Castlemaine Perkins","GPO BOX 44",,"QLD","4001","07 33617400","07 33684000"
Supplier Items File Format (TMPB_SUPPLIERITEM.TXT)
|
Field Description |
Field Name |
Data Type |
Mandatory |
Comments |
Excel Column Format |
|
Supplier ID |
SupplierID |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 10 characters, e.g.: QFFS. |
Text |
|
Supplier Order Code |
SupplierCode |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 13 characters, e.g.: XXXX375ml. |
Text |
|
Product Code |
ProductCode |
String |
YES |
Can be any combination of letters and numbers with a maximum length of 13 characters. |
Text |
|
Manufacturer ID |
ManufacturerID |
String |
NO |
Can be any combination of letters and numbers with a maximum length of 13 characters. |
Text |
Example :
""SupplierID","SupplierCode","ProductCode"
"ALM","ALMSGLBEER","BEERSGL"
"CUB","CUBSGLBEER","BEERSGL"
"XXXX","XXXXSGLBEER","BEERSGL"
"ALM","ALMBLKWINE","BULKWINE"
"ALM","ALMSPIRIT","SPIRITBOTT"
"ALM","ALMWINE","WINEBOTT"
"ALM","ALMRUM","RUM"
"ALM","ALMSDCAN","SOFTDRINK"
"ALM","ALMUDL","UDL"
"ALM","ALMCOOLER","COOLER"
"ALM","ALMBRANDY","BRANDY"
Related Topics
