Use Importer to manage and configure this feature in your EQuipWeb system.

Use the Alt Barcode Importer to assign additional barcodes to your products in bulk. Some products have multiple barcodes (different pack sizes, supplier codes, or regional variants) — upload them all at once from a spreadsheet.

When to use this: When you need to add multiple alternative barcodes to existing products at once using a spreadsheet.

Prerequisites

• User must have appropriate role permissions (see Access & Permissions above)

Alt Barcode Import

📝 General Description

This importer uses the standard EQuip import workflow: download a template, fill in the data offline, then upload the completed file. Each row maps one alternative barcode to an existing product. Once imported, all alternative barcodes function identically to the primary barcode at the POS — scanning any barcode resolves to the same product.

Use Importer to manage and configure this feature in your EQuipWeb system.

11.5.1 Import Workflow

Step 1: Export Template → Download blank CSV/Excel template
Step 2: Fill Data     → Enter product item numbers + alternative barcodes
Step 3: Import        → Upload the completed file
Step 4: Review        → Check the import history grid for success/error status

UI Elements

Use Importer to manage and configure this feature in your EQuipWeb system.

11.5.2 Template Columns

Example Template Data

Use Importer to manage and configure this feature in your EQuipWeb system.

11.5.3 Import Validation

The system validates each row during import:

Import History Grid

Use Importer to manage and configure this feature in your EQuipWeb system.

11.5.4 POS Behavior After Import

Once imported, alternative barcodes work seamlessly at the POS:

Use Importer to manage and configure this feature in your EQuipWeb system.

💡 Example

Scenario: A supermarket receives a shipment of products from a new Japanese supplier. The products have both local SG barcodes (already in the system) and original Japanese barcodes on the packaging. Cashiers need to scan either barcode.

Setup:

1. Navigate to Alt Barcode Importer → Click Export Template.

2. Open the template in Excel.

3. Fill in:

4. Save the file and click Import.

5. Check the import history — all 3 rows should show "Success".

6. Now cashiers can scan either the SG barcode or the JP barcode for these products.

[!TIP] Use the QtyPerUOM field when importing carton or multi-pack barcodes. This way, scanning a carton barcode at the POS automatically sets the quantity to the correct number of individual items — saving time during bulk receiving.

[!WARNING] Each barcode must be globally unique across the entire system. If you try to import a barcode that already belongs to another product, the import will fail for that row. Check for duplicates before importing.

Use Importer to manage and configure this feature in your EQuipWeb system.

Access & Permissions

[!NOTE] Exact permissions depend on the Privileges Setup configured for each role. Contact your administrator if you cannot access this page.

Use Importer to manage and configure this feature in your EQuipWeb system.

How to Import Alternate Barcodes

1. Navigate to Data Importer & Exporter > Alternate Barcode Importer from the sidebar menu.
2. Click Download Template to get the Excel template.
3. Fill in the data: Item Number (existing product) and the Alternate Barcode value.
4. Save the completed file.
5. Click Choose File and select your completed template.
6. Click Import to upload.
7. Review the validation results — ensure all Item Numbers match existing products.
8. Click Confirm Import to finalize.

Expected Result: Alternate barcodes are linked to the specified products. Scanning either the original or alternate barcode at POS will find the same product.

FAQ

Q: What file format should I use for import? A: Use .xlsx (Excel) format. Download the blank template from the importer page to ensure correct column structure.

Q: Can I undo an import? A: No. Imports cannot be automatically reversed. You would need to manually correct or delete the imported records.

Q: Why does my import show validation errors? A: Check the error details for each row. Common issues include: missing required fields, duplicate codes, invalid date formats, or referencing categories/departments that don't exist yet.

Use Importer to manage and configure this feature in your EQuipWeb system.

Troubleshooting

Use Importer to manage and configure this feature in your EQuipWeb system.

Related Menus

• Product Setup > Product List — imported product destination
• Membership Setup > Membership List — imported member destination
• Master Data > Supplier Setup — supplier data reference

Use Importer to manage and configure this feature in your EQuipWeb system.

Open Questions / Confirmation Needed

[!NOTE] The following items may vary depending on your system version and configuration:

• Exact permission settings depend on your Privileges Setup configuration
• Sync timing to POS terminals depends on network conditions and sync schedule
• Some features may require additional licensing or module activation
• Field behavior may differ between EQuip versions

If you encounter behavior not described in this manual, contact your system administrator or EQuip support team.

Expected Result: Changes are saved successfully and reflected across the system after the next POS sync.

Field Reference

[!NOTE] Additional fields specific to this page are documented in the sections above. The table above shows common fields present across most pages.