Delete Unused Barcodes

This outlines the How To Delete Unused 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
• How To?

 

---

About      ▲ ▼

• When Is It Used?

 

When Is It Used?      ▲ ▼

Used as a housekeeping function to clear the Swiftpos database of an excessive number of potentially unused Barcodes. Barcodes are held in the ProductBarCodeTable in the Swiftpos database.

 

---

How To?      ▲ ▼

• Delete Unused Barcodes?

 

How To Delete Unused Barcodes?      ▲ ▼

In Back Office, do as follows:

• Navigate to and select the Delete Unused Barcodes option in the SQL Tools menu.
• This will ensure the following prompt is displayed:

 

 

• Select either:
  • Yes - RECOMMENDED. Select to backup existing Barcodes to a CSV file before the deletion process. Select a folder and confirm the file name before the backup is created. To restore the Barcodes from the backup created, refer HERE.
  • No - Select to continue without backing up existing Barcodes.
• Once the above prompt has been responded to and the appropriate action taken, the following prompt will be displayed:

 

 

• To delete Barcodes, either:
  • Select the Never Used option to delete Barcodes that have never been scanned and were created before the date selected in the date field.
  • Select the Not Used Since option to delete Barcodes that have never been scanned since the date selected in the date field.
• Select OK to start the process.
• A message will be displayed confirming the number of Barcodes deleted. For example:

 

 

• Select OK to close the message.
• To restore the Barcodes from the backup created above, refer HERE.

 

End of article      ▲