I have around 700 product variants and each variant has two barcode

The problem is I have added a barcode of one variant into another, now when I am trying to add to its variant it wouldn’t allow. How can I search for it?

One options that comes to my mind is exporting the entire item list and looking it up in CSV but I am not able to figure out how to do it?

You haven’t mentioned what version you are running.

ERPNext: v11.1.29 (master)

ERPNext Support: v0.0.1 (master)

Frappe Framework: v11.1.28 (master)

You can use Data Import for this.

  1. Go to **Data Import ** by searching the same in the Awesome bar (Ctrl + G)

  2. New > Document Type - Item > Action - Update

Click on Download Template select the fields to download (make sure to download the Item Code field) along with the barcode field. Check Download with Data

image

You can change the filetype to Excel.

This will export the system data in a spreadsheet where you can correct the data. After this, just attach the sheet to the document and begin the import process.

Thank you for replying, it worked. I was able to locate the barcode but the problem still remains.

|“11278-DPU-XXL”|11278-DPU-XXL|

|“G12674020024”|G12674024025|

This message I see at the bottom of the variant page-
You changed values for Barcode from G12674020024 to G12674024025 in row #1 – 2 months ago

But now the system won’t let me associate this barcode G12674020024 with other variant.

How do I fix this?