UPC, EAN, ISBN, ITF, JAN and other scannable barcodes in Retail POS (X-Series)

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.

Multiple-Barcodes-Standard-Product.png

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

  • Adding products to the Sell Screen
  • Adding Products to Quick Key Setup
  • Adding products to a Stock Order
  • Receiving Stock
  • Add/Edit Promotions

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.

Multi-Barcodes-Standard-Product-Primary-SKU.png

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 products individually

Standard products

1. Navigate to CatalogProducts.

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.

Multi-Barcodes-Standard-Product-SKU.png

4. Select the SKU code type from the drop-down.

Multi-Barcodes-Standard-Product-SKU-Type.png

5. Enter or scan the barcode into the SKU code field

Multi-Barcodes-Standard-Product-SKU-Code.png

6. To add more codes, click Add another code.

Multi-Barcodes-Standard-Product-Add-SKU.png

7. Repeat steps 4-6 until all codes are captured

8. Click Save

Variant products

1. Navigate to CatalogProducts.

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-Variant-Product-Variants.png

4. Select the SKU code type from the drop-down.

Multi-Barcodes-Variant-Product-SKU-Type.png

5. Enter or scan the barcode into the SKU code field.

Multi-Barcodes-Variant-Product-SKU-Code.png

6. To add more codes, click Add another code.

Multi-Barcodes-Variant-Product-Add-SKU.png

7. Repeat steps 4-6 until all codes are added or edited.

8. Click Save.

Importing multiple barcodes in bulk via CSV/XLSX

  Before beginning

It is important to note that while Retail POS supports bulk importing of multiple barcodes via CSV/XLSX, it does NOT currently support editing or exporting via CSV/XLSX.

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 Adding and editing multiple barcodes on a single product section above for instructions on how to do this.

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.

To begin, navigate to CatalogProducts.

The first thing you'll need to do is 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.

Multi-Barcodes-Export-List.png

Open the downloaded CSV/XLSX file in Microsoft Excel, or use free spreadsheet software such as Google DocsOpen Office or Libre Office

  Important

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

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

Screen_Shot_2021-03-24_at_11.31.37_AM.png

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.

  Tip

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.png

You can still record your regular SKU code against the product by inserting it into a custom code column instead.

sku-custom.png

When the CSV/XLSX has been completed, navigate back to CatalogProducts and click Import.

import.png

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.

import_products.png

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_column.png

When the unmatched columns have been matched or ignored, scroll down and click Continue.

continue_button.png

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 the Edit product page in the Catalog > Products section.

Multi-Barcodes-Variant-Product-SKU.png

  Important

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.

Did this answer your question?
Have more questions? Contact us so that we can help you out.