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.
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.
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 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.
4. Select the SKU code type from the drop-down.
5. Enter or scan the barcode into the SKU code field
6. To add more codes, click Add another code.
7. Repeat steps 4-6 until all codes are captured
8. Click Save
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).
4. Select the SKU code type from the drop-down.
5. Enter or scan the barcode into the SKU code field.
6. To add more codes, click Add another code.
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 Catalog > Products.
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.
Open the downloaded CSV/XLSX file in Microsoft Excel, or use free spreadsheet software such as Google Docs, Open 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
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.
You can still record your regular SKU code against the product by inserting it into a custom code column instead.
When the CSV/XLSX has been completed, navigate back to Catalog > Products and click Import.
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.
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.
When the unmatched columns have been matched or ignored, scroll down and click Continue.
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.
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.