Hi. How can we help?

Adding and editing scannable barcodes

In Retail POS, you are able to add multiple barcodes that can be scanned alongside the SKU (Stock Keeping Unit). These can be captured on standard and variant products, and used for scanning/selling and inventory management without sacrificing the ability to identify products internally using a SKU.

Supported barcode types:

  • Auto-generated: Retail POS's automatically generated SKUs
  • Custom codes: any other code
  • EAN: European Article Number
  • ISBN: International Standard Book Number
  • ITF: Interleaved Two of Five
  • JAN: Japanese Article Number
  • UPC: Universal Product Code

How multiple barcodes work

A product SKU (Stock Keeping Unit) is typically the primary product code used for selling, inventory management, and customer-facing material such as receipts, labels, and e-Commerce.

However, products often have multiple codes used externally. Take a book for example, which may have a UPC, EAN, and ISBN, as well as an internal SKU, on the one product.

SKU codes

Retail POS allows you to capture all these codes and scan them for the following tasks:

  • Receiving Stock.
  • Add/Edit Promotions.
  • Adding products to the Sell Screen.
  • Adding Products to Quick Key Setup.
  • Adding products to a Stock Order.
    • Not supported via CSV import.

The first code captured in Retail POS forms the front-of-house code found throughout Retail POS and on your receipts, labels, and e-Commerce integration. The secondary codes are only visible on the Add Product and Edit Product pages.

Preview of product

This means you can scan different barcodes on the sell screen without making them visible to the customer, such as the UPC, or sacrificing the ability to identify products using the SKU.

These codes are for internal use only. They can be imported in bulk by CSV file, but they cannot be exported from the system once they are imported — either by CSV export or integration.

Adding and editing multiple barcodes on standard products

  1. Navigate to Catalog > Products.
  2. Click Add product to create a new Standard Product; or locate an existing product and click Edit product.
  3. Under Inventory you will find SKU code type and SKU code.
    Custom SKU code
  4. Select the SKU code type from the drop-down.
    list of SKU code types
  5. Enter or scan the barcode into the SKU code field
    Inputting of SKU code
  6. To add more codes, click Add another code.
    You can add more types of SKU code
  7. Repeat steps 4-6 until all codes are captured
  8. Click Save

Adding and editing multiple barcodes on variant products

  1. Navigate to Catalog > Products.
  2. Click Add product to create a new Product with Variants; or locate an existing product and click Edit product.
  3. In the Variants section, click to expand the variant(s) you wish to add or edit codes on (click the Add variants button if there aren't any yet).
    Multi Barcodes Product variants
  4. Select the SKU code type from the drop-down.
    Variant product SKU Type
  5. Enter or scan the barcode into the SKU code field.
    Variant Product SKU Code
  6. To add more codes, click Add another code.
    Variant products adding SKU codes
  7. Repeat steps 4-6 until all codes are added or edited.
  8. Click Save.

Importing multiple barcodes in bulk via CSV/XLSX

Retail POS supports bulk importing of multiple barcodes via CSV/XLSX spreadsheet but does NOT currently support editing or exporting via CSV/XLSX spreadsheet.

You can now import multiple barcodes in bulk using CSV/XLSX. This allows you to quickly and easily capture multiple barcodes for each product across a large catalog.

We strongly recommend reading the below guide carefully and ensuring that all steps are followed accurately to prevent any errors from occurring.

Once imported, the barcodes will need to be edited on an individual product basis within the Retail POS app. Refer to the sections above for instructions.

  1. To begin, navigate to Catalog > Products.
  2. Export your current product catalog as a CSV/XLSX. You can either export your entire catalog, or a portion of it using the filters. Once you have identified and selected the desired products, click Export list and select CSV format or XLSX format.
    Export list button
  3. Open the downloaded CSV/XLSX file in Microsoft Excel, or use free spreadsheet software such as Google Docs, Open Office or Libre Office.

    Once open, you MUST delete all of the inventory columns (including their headers) to prevent unwanted changes to inventory levels when reimported.

  4. Next, you can add columns for each of the barcode types you wish to add to your products.
    Retail POS can recognize EAN, ISBN, ITF, JAN, and UPC barcodes, as well as custom codes. Use the relevant column headers as follows:
    • sku_code_upc
    • sku_code_isbn
    • sku_code_ean
    • sku_code_itf
    • sku_code_jan
    • sku_code_custom
    Imported CSV/XLSX file
  5. Populate the cells with the relevant barcodes. Each product can have none, one or more of each barcode type. If the cell is left blank, the barcode type will simply be ignored for that specific product when imported.

    To record a barcode other than the regular SKU as the primary code (which forms the front of house code found throughout Retail POS and on your customer receipts), such as an ISBN or UPC, you can populate the code into its respective column and copy the same code into the SKU column.
    SKU upc
    You can still record your regular SKU code against the product by inserting it into a custom code column instead.
    SKU custom

  6. When the CSV/XLSX has been completed, navigate back to Catalog > Products and click Import.
    Import products button
  7. Click Choose a File to Upload... and select the file you have just created. The CSV/XLSX validator will read all columns and assign them to the corresponding data fields within Retail POS.
    Uploading CSV/XLSX file
    If the validator detects any errors you will be taken to the column matching screen below. Here you'll be able to view any unmatched columns and fix them by selecting the correct column from the drop-down menu or clicking Don't import to ignore the column.
    Unmatched columns
  8. When the unmatched columns have been matched or ignored, scroll down and click Continue.
    Continue button
  9. If no errors are identified, click Continue with import.Once the import is complete, you will receive a notification stating "Your product import has completed. X records were added, X records were updated and X were ignored."

    If any records were ignored, click View ignored products (CSV) to determine what needs to be corrected.

    Your import will be successful if no records were ignored. You can now see the imported barcodes for each individual product on th Edit product page in the Catalog > Products section.

    Multi Barcodes Variant Product SKU

Your product Supplier code will continue to be used in stock orders and will be captured in the Supplier code data field on the Add Product or Edit Product page.

What's next?

Importing products using a spreadsheet

Import products into your Retail POS store in bulk.

Learn more

Managing product categories

Use product categories to organize and track your catalog.

Learn more

Was this article helpful?