SwiftPOS Price Book

 

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:

 

  1. 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.
  2. TMPB_CATEGORY.txt
  3. TMPB_GROUP.txt
  4. TMPB_MANUFACTURER.txt
  5. TMPB_MASTERGROUP.txt
  6. TMPB_PRODUCT.txt
  7. TMPB_PROMOTION.txt
  8. TMPB_SUPPLIER.txt
  9. TMPB_SUPPLIERITEM.txt

 

To Be Considered

 

  1. 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

 

  1. Export/Import Price Book Operation
  2. SQL Tools
  3. Suppliers