the U.P.C. Database?
IMPORTANT NEWS - COMING IN 2013:
The "long awaited" API.
The U.P.C. - USDA SR25 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)
Mobile Commerce (iPhone, gPhone Applications)
Web 2.0 Applications (Fully Populated Field Content)
Price Book or 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
Load Services for:
Point of Sale (POS) Software
Inventory Verification Services
Grocery Delivery Services
[providing pre-loaded product files for new customers or data synchronization
for existing customers]
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.).
For Product Load
Services, pricing is based, either on Pre-Built Files (Sub Sets for Convenience Stores,
Liquor Stores, etc.), or on a SKU Match basis.
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 - 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