the U.P.C. Database?
NEW DATA for 2013 (Ready Now):
Specialized Grocery Data
The U.P.C. - USDA SR26 Interface.
Nutritional Values for Perishable Foods and Spirits.
At the outset,
YES I have the U.P.C. Database. In fact, I have many U.P.C. Databases.
you send me an E-Mail requesting database files, YOU need to know
what to ask for.
Before I tell you,
let's look at the structure of a U.P.C.:
The first six digits
above - 614141 (in this example) - are the Company Prefix assigned by GS1
US (formerly the Uniform Code Council).
The next five digits
- 00027 - are the Company's internal Stock Keeping Unit (SKU) or product
The final digit
- 2 - is a computer generated check digit.
While Company information
is available from GS1 US, product information (the SKU and corresponding
U.P.C.) is not.
For those of you still
reading, I would assume that you are seeking MORE than just Company
information. To that end, what you are really seeking is an
Electronic Product Catalog
information - such as U.P.C., Manufacturer, Brand, Item Name, etc.
CATEGORIES of items - such as Food, Health & Beauty, Spirits, etc.
FULL data elements, such as:
- Total Fat, Fat UOM, % Daily Value, etc.
- (for Fritos Corn Chips) Corn, Corn Oil, Salt, etc.
- Product Dimensions, Pack Size, Parent Child, etc.
- Endorsements, Allergy Information, Warnings, etc.
images are also available.
My current "flagship"
products include these Electronic Product Catalogs:
Goods, Perishable, and Non Perishable)
Health & Beauty (Analgesics, First Aid, and Skin Care)
General Merchandise (Office, Toys, and Household)
Snacks & Sodas (Chips, Jerky, Bottled Beverages)
Spirits (Beer, Wine, Liquor, and Mixers)
Tobacco (Cigarettes, Cigars, Smokeless)
Catalog - Example Applications
Rich Data Content Applications
Product Catalog Normalization and Completion
Positioning and Strategy
Brand Name / Manufacturer Cross Reference
Medical / Health Content Applications and Studies
2005 Sunrise (GTIN) /
2010 Sunrise (DataBar) Issues
State Bottle Bill Initiatives
WIC Product Data
Point of Sale (POS) Software
Inventory Verification Services
Grocery Delivery Services
Catalog - Particulars:
Product Catalogs, pricing is based on:
Category (Food, Snacks, Spirits, etc.)
Depth of Data (Basic [for Point of Sale], E-Commerce [for Web Applications], Full
[for Advanced Product Search])
and Application Platform (Single User, Web Site, Kiosk, etc.).
Pre-Built Files (Sub Sets for
Convenience Stores, Liquor Stores, Tobacco Stores, etc.) are also available.
Monthly and Quarterly
Updates are available.
Databases can be
delivered in Text, Excel, or Access formats.
Should you wish
further information, Catalog Pricing, or Data Samples, please contact me
at 214-548-6960, or via E-Mail.
For those who require Professional
Consulting in the areas of: U.P.C. / EAN Creation, (Coupon) Family Code Management, Data Synchronization,
or Database Normalization, click Here.
For those who want to build an
application that uses Coupon U.P.C.'s, click Here.
Catalog - Death of the API:
For the past three years I have worked with Microsoft (Azure), with other Developers,
and with other API-Based Data Providers - to develop THE API. However, after spending
considerable time and effort, it's become clear that most of my Client Base does not
need the "look-up" capability, but rather, complete Data Files.
Think Grocery Delivery Services, which require Sales Tax Rates and Sales Taxability.
Think Health and Wellness Firms, which require the ability to isolate "alternatives".
Think Emerging Sector Health Applications, which have the need to "append" other Fields
(Sustainability, Non-GMO, etc.).
Bottom Line - while an API "sounds" appealing, it is in fact, limiting (at least to my
Clients), and absent a Market, there is no need for the API.
Catalog - Alternate Sources:
For those seeking Data in
Consumer Electronics, Computer Hardware and Software, Household Appliances and Housewares,
Office Products and Furniture, and Hardware, contact:
Sherry Frederick at Etilize Inc.
For those seeking Data in Books, contact:
Peter Ashekian at Bowker
For those seeking Data in DVD's, Music, and Video Games, contact:
Rovi Corporate Web Site