Barcode field containing non barcode numbers

[matt]

For some releases, people are entering non-barcode numbers in the barcode field.

Eg.
Wii Fit
045496901073 (00100)
http://www.rfgeneration.c...132-S-01910-B&type=bb

The barcode is 045496901073 (standard 12 digit UPC that can be validated through an algorithm)

Try validating it here yourself:
http://www.hipaaspace.com..._Code/UPC_Validation.aspx

The (00100) text is secondary piece of data stored as a second barcode that happens to be positioned next to the main UPC.

See this thread: http://www.rfgeneration.c...m/index.php?topic=16335.0

Because barcode  search is looking for an exact match searching the site for the UPC returned by my barcode scanner I'm not finding the games that have this extra data stored in the barcode field.

Maybe barcode search needs to be less strict? Matching a string (with all whitespace removed) on "contains" rather than "equals".

Maybe there needs to be another place for the Nintendo data to go?

Any thoughts?

[Shadow Kisuragi]

Yeah, I'm aware it's not standard EAN. Unfortunately, at the time, I thought our barcode search was doing LIKE rather than =, so it would do a fuzzy search, but guess not.
It likely needs to go away and be specified in another method. There is information contained within the metadata (such as the 3rd digit indicating manufacture location, and the 5th digit for revision), though I've not seen it used for any other reason by Nintendo yet.

[matt]

Thanks. Happy you're aware of the issue

[douglie007]

can it just be made to do a partial search like the game names?