Archive: ean

So now that everyone uses Google Shopping, Google are making life difficult for the merchants and they all have to jump through hoops. The current push from Google is enforcing some things that are very difficult for small companies to conform with :- * EAN Numbers – This is the BIG one, Google are making [...]

Check out this little query for checking for obviously invalid EANs. Note this is not checking the check digit for validity, it is purely looking for data that is in no way possibly an EAN number. PLAIN TEXT SQL: UPDATE products SET ean = '' WHERE ean != '' AND ean NOT REGEXP '[0-9]{13} assuming [...]

Just found this MySQL snippet for validating EAN numbers. http://snipplr.com/view.php?codeview&id=17928 I have modified it a bit to suit my requirements (namely totally corrupted EAN data). PLAIN TEXT SQL: SELECT ean FROM products WHERE (LENGTH(ean) != 13) || (SUBSTRING((10 - (((( SUBSTRING(ean FROM 2 FOR 1) + SUBSTRING(ean FROM 4 FOR 1) + SUBSTRING(ean FROM 6 [...]