Scan Data Export

 

Back Office > Data Export > Export Scan Data

 

Description

 

This feature is used to export Sales (Scan) data from SwiftPOS Back Office. The data exported is picked up by the Liquorfile interface in Australia for the different buying groups. Use this screen to configure the required settings, as well as to run an ad-hoc export of data. Exporting can also be included as part of the End of Day process.

 

To Be Considered

 

  1. Fixed File Name Variables can be used to extend the file naming options of the CSV files generated by the export when used in conjunction with the EOD. This feature is available as part of Batch Reports.

 


Pre-Requisites

 

  1. Ensure the Scan Data Group Prefix is configured for each Location Group (Venue). This prefix is used in the naming of the CSV files generated by the export process. For more information ... Note : If this is NOT set for a particular Location Group (Venue), then no data will be exported for that LG.

 


Export Scan Data

 

 

This screen is accessed from here.

 

Export Filters

 

  • From/To - Select from the drop down calendar the date range for which sales data is to be exported. An export (CSV type) file will be created for each day in the date range selected that had sales specified.
  • Location Group - Select from the drop down list the Location Group (Venue) for which sales data is to be exported or select << ALL >.
  • Location - Select from the drop down list the Location for which sales data is to be exported or select << ALL >.
  • Export Path - Select/Enter the path/folder to which the exported sales data will be written. The path/folder entered should be the same folder that is used for transferring data to the Liquorfile interface. Contact Liquorfile support if unsure.

 

Footer

 

  • Export - Select to export sales data based on the Export Filters selected. Sales data will be exported in the form of a CSV type files and placed in the Export Path selected. Each CSV file created represents the sales for a particular day across all Locations within a Location Group (Venue). For more information re the naming and format of the CSV files ...
  • Close - Select to exit.

 


Export Scan Data File Format

 

Sales data is exported in a CSV type file with the following naming convention: XXXDDMMYYYY.CSV  - where XXX is the Scan Data Group Prefix and DDMMYYYY is the date for each day of sales data exported.

 

Field Name

Field Description

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

 


Related Topics

 

  1. Data Export
  2. End of Day
  3. Import/Export Overview