MarCat

Same barcode on two different products: how to fix it at the supermarket counter

When one scan brings up the wrong item, two products share a barcode. Here is why it happens, how to find every clash in your item list, and how to fix each kind.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 17 November 2026

The cashier scans a pack of mango juice. The screen says orange juice. Same price, so nobody notices. Next week it is a 1 kg pack of salt scanning as the 500 g pack, and now the price is wrong too.

This is a different problem from one product with two MRPs, where old and new packs of the same item share a barcode. Here, two different products come up on the same scan. The bill looks fine, but your stock is wrong for both items, your sales report credits the wrong flavour, and sometimes the customer pays the wrong price.

Three problems that look the same at the counter

When a scan brings up the wrong thing, it is one of these:

What you see What it is Where to read more
Same item, two MRPs come up Old and new MRP stock Two MRPs guide
A different flavour, size or product comes up Two products share one code This guide
Nothing comes up The pack has no code, or the code is not in your item list MRP sticker with barcode

Sorting out which one you have is the first step, because the fixes are different.

Why two products end up with one code

India's barcodes starting with 890 come from GS1 India, and the GS1 standard says every new product gets its own code. That includes each new flavour and each pack size, and any change to the net quantity printed on the pack needs a new code. So a properly coded brand should not give you a clash.

Clashes still reach a supermarket in a few common ways:

  1. Small makers with made-up numbers. A local namkeen, pickle or masala maker prints a barcode on the pack without registering, or uses one number for all flavours.
  2. Your own store codes collide. You gave your repacked sugar a code that you made up, and one day a branded product arrives carrying the same number.
  3. Typing mistakes in the item list. While adding items, someone scanned the wrong pack, or copied a row and changed the name but not the barcode.
  4. Combo and offer packs. A shrink-wrapped "buy 2" pack where the outer wrap shows the code of the single pack inside.
  5. Codes carried over from old data. When an item list moves from one system to another, a duplicate that was hidden before can start showing.

Only the first one is outside your control. The other four are item list problems, and you can clean them up.

How to find every clash in your item list

You do not have to wait for a cashier to catch them one by one. Once a month, or before you add a big batch of items:

  1. Export the item list to Excel with at least: item name, barcode, size, MRP.
  2. Sort by the barcode column.
  3. In a new column, enter =COUNTIF(B:B,B2) (if barcode is column B) and copy it down.
  4. Filter that column for values greater than 1.

A made-up result:

Item Barcode Size MRP Count
Juice, mango 8901234567890 1 ltr ₹110 2
Juice, orange 8901234567890 1 ltr ₹110 2
Salt 8909876543210 1 kg ₹28 2
Salt 8909876543210 500 g ₹15 2

Be careful with one thing: if you keep a separate row for each MRP of the same product, those rows will also show a count of 2, and they are not a mistake. Check each group with the actual packs in your hand before you change anything.

Fixing each kind

Cause Fix
Typing mistake Scan the real pack again and correct the barcode on the wrong row
Copied row Same: scan each pack and put the right code on each row
Your store code clashes with a real product Change your store code, reprint labels for those packs, and pick store codes from a range that will not collide (see the label guide)
Small maker uses one code for all flavours Ask the maker or distributor to fix it. Until then, give each flavour its own store code and stick your label on each pack
Combo pack shows the single-pack code Make the combo its own item with its own store code and label, or bill it as the single items it contains

When you stick your own label on a pack, put it where it does not cover the MRP, the dates or any printed declaration. Cover only the old barcode if you must, so that the scanner reads yours.

Then fix the stock

Once the codes are correct, the stock on both rows is still wrong, because every past sale went to one item. Count both products on the shelf and in the store room and correct each row. Do it the same day, or the next sale starts the drift again.

A rule for the counter

Give every cashier one simple rule: if the screen does not match the pack, do not bill it as shown.

  1. Remove that line from the bill.
  2. Search the item by name and bill the right one.
  3. Write the barcode on a slip, or keep one pack aside, for the owner.

The slip box at each counter becomes your list for the next item list clean-up. Without it, the cashier fixes the bill and the cause stays.

Where software helps

A clash is easiest to fix at the moment it is created. Billing software that shows the item name and pack size clearly on every scan helps the cashier notice a mismatch, and an item list you can export lets you run the duplicate check above in minutes. Label printing from the item list makes store codes easy to put on packs that need them.

How MarCat handles it

We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. This is what MarCat does here:

  • Scan and bill. Scanning a barcode brings up the item, its price and its GST on the bill.
  • One barcode, two MRPs. When one barcode has more than one MRP of the same item, the counter shows each MRP with its stock and the cashier picks the one on the pack.
  • Barcode labels from the item list. Pick items and print labels with item name, barcode and selling price on common label roll sizes or A4 sheets. Codes are typed in the item list; MarCat does not make up codes, so you choose your store code range.
  • Your data is yours. You can export your items whenever you want and run the check above.

If you want to see scanning and labels on a real counter, message us on WhatsApp at +91 96787 65518.

Questions

Can two different products have the same barcode?
They should not. Under the GS1 standard every new product, including each new flavour and each new pack size, gets its own code. In practice a store still meets clashes: made-up codes from small makers, store codes that collide with real ones, and typing mistakes in the item list.
How do I find duplicate barcodes in my item list?
Export the item list to Excel, sort it by barcode, and add a COUNTIF column. Any barcode that appears more than once is a row to check by hand with the actual packs in front of you.
Is this the same as one product with two MRPs?
No. Old and new MRP packs of the same product sharing one code is normal and has its own fix. This guide is about two different products, such as two flavours or two sizes, scanning to one code.
What should the cashier do when a scan shows the wrong item?
Remove the line, bill the item by searching its name, and put the pack aside or note the barcode for the owner. Never bill a different product at its price just to keep the queue moving.