|
Title: Barcode field containing non barcode numbers Post by: matt on September 12, 2016, 08:54:18 AM For some releases, people are entering non-barcode numbers in the barcode field.
Eg. Wii Fit 045496901073 (00100) http://www.rfgeneration.com/cgi-bin/getinfo.pl?ID=U-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/Medical_Data_Validation/Universal_Product_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.com/forum/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? Title: Re: Barcode field containing non barcode numbers Post by: Shadow Kisuragi on September 12, 2016, 01:09:27 PM 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. Title: Re: Barcode field containing non barcode numbers Post by: matt on September 12, 2016, 01:47:27 PM Thanks. Happy you're aware of the issue
Title: Re: Barcode field containing non barcode numbers Post by: douglie007 on April 26, 2017, 05:57:59 AM can it just be made to do a partial search like the game names?
|