How To
      Back to home
      1. Swiftpos Help Guides
      2. Back Office
      3. How To

      Export Invalid/Unknown Barcodes

      Back Office - How To

      This outlines the How To Export Invalid/Unknown Barcodes.

       

      The content is targeted at Resellers and Swiftpos Venue administrators who have a sound knowledge of and experience with Swiftpos. For further information or assistance, please contact your Swiftpos Reseller or Swiftpos Support.

       

      Subjects      ▲ ▼

       

      About      ▲ ▼

       

      What To Consider?      ▲ ▼

      Retail Barcodes normally have a check sum number built into the last character of the Barcode. This does not apply to other Barcodes that are used to represent a Member or a Voucher. Sometimes, Venues have imported Barcode files that are padded with leading zeros of up to 14 characters. Since these are not considered valid Barcodes, they will not scan successfully in Touch.

       

      When Is It Used?      ▲ ▼

      Used to report on any Barcodes that are invalid/unknown or non-manufacturer Barcodes and then provide a correct alternative in the form of the reported Manufacturer Barcode.  It is designed to support housekeeping activities in Swiftpos.

       

      How To?      ▲ ▼

       

      How To Export Invalid/Unknown Barcodes?      ▲ ▼

      In Back Office, do as follows:

      • Navigate to and select the Export Invalid/Unkown Barcodes Report Data (CSV) option in the SQL Tools menu.
      • This will ensure an export file is generated with the file name Exported Data.csv, and will prompt for a folder to be selected in which to save the CSV file. The following is a sample of the content of the generated export file:

       

      Inventory_Code,PLU_Number,Description,InventoryBarCode,BarCodeType,LookupIndex,ManufacturerBarCode
      10034,10034,Wild Turkey Premix 340ml,09319194000545,,9319194000545,9319194000545
      80511,80511,Carlton Mid Strength 375ml,0080686002499,,080686002499,080686002499


      • To report on Invalid/Unknown Barcodes refer HERE.

       

      End of article      ▲