eTrade v1 - OnTap Data / Liquor File

 

Description

 

http://www.lmgmarketing.com.au/ - is now called http://www.ontapdata.com.au/ (Dec 2015) Market leaders in collecting and managing data for the liquor industry, and providing business intelligence to support our clients' business strategies.'

 

The OnTap Data / Liquor File is a master Product file containing the Products of over 400 Suppliers to the Australian Liquor Industry. The OnTap Data / Liquor File can be used as a price book in SwiftPOS, allowing the importing Barcodes/Products to the SwiftPOS Database using a simple Price Book Import process. In addition to this there is also an export interface (Scan Data Export) that can be used to export sales data in the OnTap Data / Liquor File Format. For more information  http://www.ontapdata.com.au/

 

The following are features of the OnTap Data / Liquor File

 

  • Electronic Invoices - Allows Supplier Invoices to be delivered in an electronic format and imported into SwiftPOS.
  • Price Book Import - Price Books can be used to import Products into a SwiftPOS database, removing the need to create records manually.
  • Product Code Changes - An imported file can be used to quickly update Product Codes in the database.
  • Promotion Import - Allows Product promotions from OnTap Data / Liquor File to be delivered in an electronic format and imported into SwiftPOS.
  • Scan Data Export - The Scan Data Export is a custom export containing sales data for the OnTap Data / Liquor File interface.

 

To Be Considered

 

  • OnTap was previously known as Liquor File in Task Manager

 


Pre-Requisites

 

  1. In order to use the OnTap Data / Liquor File interface, register with OnTap Data / Liquor File and pay the appropriate fees. Download the DLL file from the OnTap Data website which is used to decrypt the Price Book. Note : The OnTap Data registration is PC specific so Price Book importing will need to be limited to one PC unless multiple registrations are obtained. To register and setup OnTap Data / Liquor File please follow these instructions:
     
    1. Download the SdeDecrypt.zip file from http://www.liquorfile.com.au and extract the contents into the SwiftPOS installation directory, C:\Program Files\Samford Software\Main\.
    2. Run SwiftPOS and expand the Suppliers menu Item, and select Supplier Electronic Trade v1.
    3. Select Liquor File from the dropdown box then select the Price Book Folder either by using the open file dialog or manually entering the file path.
    4. Select the Import Price Book button and the following registration will appear:
    5. Enter a Venue Name into the first field then press the Set Name button.
    6. Record the Customer ID that appears in the registration screen then contact OnTap Data to register for an Unlock Code.
    7. When you receive the Unlock Code enter it into the appropriate field then press the Register button.
    8. For importing Price Book information ...

 


Scan Data Export

 

Note : This has been replaced with the Export Scan Data in the End of Day process.

 

The Scan Data export is part of the OnTap Data / Liquor File interface and is used as a sales data export. The file that is created is a CSV file that uses the following naming convention: IIIDDMMYY.CSV (where III is the Venue ID).

 

 

Note : There are extended file naming options which can be configured in the Batch Reports screen, allowing the file naming convention above to be created.

 

The file should be exported to the same folder that is used for transferring data to OnTap Data / Liquor File. Contact OnTap Data Support with any issues you may have with the Export. The Scan Data export is run from the Custom Reports menu but is not run like a regular report. To run the Scan Data report select the export to CSV or TSV option. This will create the export file in the selected folder.

 

The following specification shows the file format for the Scan Data export.

 

Note : The VenueID field actually refers to the Scan Data Group Prefix for the selected Location Group (Venue). The reason for this is that the Location Group (Venue) ID's cannot be changed after they are created but the Scan Data Group Prefix can.

 

Field Name

Description (As per OnTap Data)

Notes

VenueID

Unique number

Supported

VenueName

Hotel Name

Supported

LiquorFileStockNo

Liquorfile number

Supported

Hotels Stock number

Hotels PLU number

Supported

StockDescription

Item Name

Supported

Unit Size

Size of Product

Supported (Selling Size)

DepartmentNumber

Category Number

Supported

DepartmentDescription

Category Name

Supported

DateofSale

Date when sale made

Supported

QtySold

Number sold

Supported

LocationNo

Department code

Supported

LocationName

Department Name

Supported

PackQty

Pack qty

Supported

SellingPrice

Sell price of item (ex GST)

Supported

CostPrice

Cost Price of Item (ex GST)

Supported

ValueSold

Total $ Sold (ex GST)

Supported

CostOfSales

Total cost of sales (ex GST)

Supported

PurchasedQty

QTY purchased

Supported

PurchasedValue

Purchased value (ex GST)

Supported

QtyInStock

Quantity in stock

Supported

ValueInStock

Value of Product in Stock (ex GST)

Supported

PromotionFlag

Was this Product on promo today?

Not currently supported

PromotionPrice

Price sold for today

Not currently supported

 


OnTap Data / Liquor File

 

Note : This has been replaced with the Export Scan Data in the End of Day process.

 

The stored procedure below allows you to export the Scan Data using an external application.

 

EXEC SS_SCANDATA @ACTION=20, @LOCATION = 1

@ACTION

0 = DO NOTHING

1 = Export data for selected Location

10 = Mark Data as exported (Negative to clear exported flag.)

20 = Return Product Listing.

Used with Action type 1 only

@IGNOREEXPORTFLAG (0 = Do not ignore, 1 = Ignore and export) Default is 0

Used with Action type 1 or 10

@SETEXPORTFLAG (0 = Do not set export flag, 1 = Set exported Flag) Default is 1

@STARTDATETIME (Filter data based on Start Date/Time) Default is NULL

@ENDDATETIME (Filter data based on End Date/Time) Default is NULL

Used with Action Type 1 or 20

@LOCATION (Location number to export data for.)

 


Related Topics

 

  1. Suppliers