U.P.C. Databases
& SKU Matching

U.P.C. Consulting and Data Cleansing Services


The U.P.C. is today's most widely recognized barcode. It can be seen in every facet of the Supply Chain - from Retailers to Wholesalers to Manufacturers to Distributors. And yet, it is the one component of a Supply Chain that is - sadly - considered LAST when planning, implementing, or executing systems.

Part of the problem lies in the fact that the GS1 (formerly the Uniform Code Council) system of U.P.C.'s is voluntary in nature (required ONLY by certain trading partners), and part of the problem exists because GS1 Standards are numerous and not well known.

The Challenges:

Invalid or incomplete U.P.C.'s (and EAN's) lead to inaccurate Product identification, incorrect Coupons, failure to meet current and future Compliance issues, and the inability to fully utilize the U.P.C. System.

The Solution - Professional Expertise:

My name is Gregg London. As an APICS CIRM and Supply Chain Systems Integrator, I provide the following Professional Services:

GS1 COMPANY PREFIX ACQUISITION - from assessing the specific U.P.C. needs (number of U.P.C.'s needed, Coupon Requirements, etc.), to providing assistance in the completion of the GS1 Membership Application

U.P.C. / EAN / SCC NUMBER CREATION - from product number and SKU sequence to creation of U.P.C. / EAN / SCC numbers to GTIN planning to GLN planning

U.P.C. / EAN / SCC IMAGE CREATION - from image placement assistance to Image creation (Bar Height, Resolution, Output Format, etc.) to Image Verification

U.P.C. COUPON CODES - from review of Coupon Requirements through Family Codes and Coupon Value Codes to creation of the Number and Digital Image to cross-reference report creation

CUSTOM U.P.C. / EAN SEQUENCING - from review of current Products and Product Lines to Item MPN requirements to Coupon requirements to U.P.C. / EAN SKU for symmetry and consistency

GS1 PREFIX VALIDATION - verification of existing U.P.C.'s and EAN's to Code correction (if needed) to identification of correct Company Name per GS1 Prefix

ITEM CATEGORIZATION - assignment of Item Categorization Schema from either the National Association of Convenience Stores (NACS) or the United Nations Standard Products and Services Code (UNSPSC) to the U.P.C. and/or EAN

2005 SUNRISE AND GLOBAL TRADE ITEM NUMBER COMPLIANCE - from initiative education to back-end systems and GAP analysis to database modification and migration

2014 SUNRISE AND DATABAR COMPLIANCE - from initiative education to back-end systems and GAP analysis to database modification and migration to implementation of new Imaging Systems

FAMILY CODE MANAGEMENT - from review of current U.P.C. structure (and Family Codes if present) to creation and maintenance of valid codes to trading partner distribution

HARMONIZED SYSTEM / TARIFF SCHEDULE - from initiative education to back-end systems and GAP analysis to assignment of requisite HS or HTS Codes through ongoing Standards Maintenance

Converting Data Records from this: BKDLY PTTCR ORGL L/FT 12.5OZ
into this: (Frito Lay Company) Baked Lays Potato Chips Light Original 12.5 Oz,
and U.P.C.'s from this: 4900027280, or this: 49000-27280 into this: 049000272802

For more "in depth" information on Data Cleansing - click Here.

Contact Information

For further information, please contact me at 469-277-6750, or via E-Mail.

©2017 Gregg London