Insert Document Name
Unified Supply Chain, Inc. (USCI) Data Synchronization Implementation Guide Version 1.0
Confidential & Proprietary
Data Synchronization Implementation Guide REVISION HISTORY Date
Ver #
Description of Change
Author
06/21/2016
1
Initial document
K.Danner
Data Synchronization Implementation Guide TABLE OF CONTENTS 1 2 3
USCI DATA SYNCHRONIZATION INFORMATION ....................... 4 1.1 International USCI GLN.................................................... 4 1.2 USCI Summary and Contacts............................................ 4 STEPS TO BEGIN SYNCING YOUR DATA WITH USCI ................. 5 ATTRIBUTE REQUIREMENTS ..................................................... 8 3.1 REQUIRED DATA ATTRIBUTES .......................................... 8 3.2 Nutritional: ...................................................................... 9
Data Synchronization Implementation Guide 1
USCI DATA SYNCHRONIZATION INFORMATION 1.1
USCI GLN
Production: 0073245000012 1.2
USCI Summary and Contacts Primary Program Analyst
Secondary Program Analyst
Contact:
TJ Stommes
Contact:
Diane Pafiolis
Phone:
952.830.0417
Phone:
952.830.0493
Email:
[email protected]
Email:
[email protected]
SUMMARY Company Overview: The DQ® System and Unified Supply Chain Inc. (USCI). The DQ® system is now on its 76th year with more than 6,700 locations throughout the U.S., Canada and 27 other countries. Although much has changed in the world and in the DQ® system through the years, success is as simple today as it was in 1940. Happy fans lead to successful restaurants. In 2004, Unified Supply Chain Inc. (USCI) was formed as a wholly owned subsidiary of International Dairy Queen (IDQ). It was created to streamline the supply chain operations of IDQ, allow for transparency through franchisee participation in the supply chain and to provide Dairy Queen® franchisees a competitive position against the other QSR chains. As USCI was formed, the franchisee Supply Chain Advisory Council (SCAC) was elected to advise USCI on all supply chain issues while ensuring accountability. USCI and the SCAC continue to work together, making tremendous strides in lowering costs for DQ® operators while ensuring stable and dependable supply and this is the main reason we are adopting the GS1 Standards. USCI would like to achieve more accurate data while creating efficiencies. Now that we have started the initiative with GS1 Standards we now have the opportunity to utilize the GDSN technology as well as pave the way to traceability of product to store operation. GDSN/GS1 Initiative: USCI and the SCAC are committed to protecting our brand and taking proactive measures to enhance food safety and franchisee profitability. Data accuracy and Food safety is our top priority and the GDSN (Global Data Synchronization Network) standards will allow us product traceability that we need to protect our fans and our franchisees while reducing costs and creating efficiencies. Implementing the GS1 standards and utilizing the technology of GDSN into our supply chain is a significant step forward for our supply chain and franchisee profitability.
Data Synchronization Implementation Guide 2
STEPS TO BEGIN SYNCING YOUR DATA WITH USCI
Have your accurate item data loaded into your home data pool and ensure it is ready for publication a. Contact your Data Pool for any education you might require to complete this step.
Understand USCI’s Attribute Requirements a. USCI’s attribute requirements are detailed beginning on page 7 of this document. USCI strongly recommends organizing, loading and sending these attributes via the GDSN as soon as possible. b. 1WorldSync customers please refer to the 1WorldSync Foodservice Attribute Mapping Guide located on the 1WorldSync Solution Center/Foodservice tab/Implementation folder. This guide will map all the Foodservice Common Names to a 1WorldSync attribute and location. c. All mandatory attributes are required at the case level and below. If a product is sold to USCI at a packaging level above the case, all mandatory attributes are required at that packaging level above the case down to the lowest level of packaging. d. A full list of attributes can be found in Section 3.
Complete the USCI Trading Partner Form located at http://www.1worldsync.com/web/us/international-dairy-queen
USCI will place a subscription to your company’s GLN. Please wait to see USCI’s subscription on your solution provider or data pool interface before publishing items
USCI will send email to the supplier’s primary data synchronization contact when we are ready for the first publications.
Publish items a. Publish all items as Initial Load b. Publish items only sold to USCI
USCI will provide feedback on publications using the following method a. Catalogue Item Confirmation: CICs i. RECEIVED – Product record has been received and has passed the USCI GDSN validations. This response will typically be sent within a few hours after receiving the publication. ii. REVIEW - Product does not pass USCI’s GDSN validations or product has failed USCI’s audit process and therefore has data discrepancies to be reviewed and addressed. Reason for Review status will be transmitted in CIC999. iii. SYNCHRONIZED - Product has been released by USCI to our catalog and will be updated as revisions occur. This response will be sent after all validations and audits have been successfully completed iv. REJECT - Product has been rejected by USCI. The item will be removed from USCI’s Catalog and a Rejected CIC status will be sent.
Data Synchronization Implementation Guide
Send ongoing item maintenance notifications through your GDSN Certified Data Pool to USCI. USCI utilizes GDSN product information in their new item set up process. Suppliers are required to publish and pass, all audit requirements on every item sold to USCI, to help facilitate the new item set up process and increase the speed to market on new items. The expectation of USCI is all required attributes for new item requests will be published through the GDSN within 72 hours.
Ongoing Data Synchronization After USCI’s initial data synchronization process is complete, during ongoing day-to-day operations, you may observe changes in the way USCI subscribes to your items. Additional subscriptions may be placed for specific GTINs and/or changes may be made to subscriptions at the GLN level. If these changes are visible to you via your GDSN tools, you do not need to make any changes to your existing publications. You should also continue to perform your standard process for publishing any new items to USCI. Removal of a Previous Subscription Even if you notice that USCI has removed a previous subscription to your items, USCI will continue to receive your item updates, per the standard behavior of the GDSN. Your item updates to USCI will stop only if you receive a CIC “Rejected” message. GDSN Foodservice Attributes List For most attributes, USCI follows the GS1 US Foodservice Initiative recommendations. The two exceptions to date will be supplying your current Manufacturer Product Code (MPC) to insure synchronization with legacy systems and the future requirement for 100-gram nutritional data. Providing Your Current Manufacturer Product Code (MPC) USCI requires you to provide a Manufacturer Product Code (MPC) which is used to help align your GTIN with USCI’s internal catalog items. This value is supplied for each item via two attributes: “additionalTradeItemIdentificationType” = SUPPLIER_ASSIGNED and “additionalTradeItemIdentificationValue” = {your MPC}. 100-Gram Nutritional Data In addition to nutritional data corresponding to “Serving Size”, USCI will require the new “100-Gram Product Information” variant for nutritional data. This is a best practice from the GS1 US Foodservice Initiative. Prior to requirement date, USCI will work closely with you and the various data pools to ensure all parties can test their systems adequately and comply with GS1 US best practices.
Data Synchronization Implementation Guide
Data Synchronization Implementation Guide 3
ATTRIBUTE REQUIREMENTS The following are the definitions for the GDSN Attribute quantifiers as found in the GDSN, Foodservice and USCI Required Attributes table found in the next section. MANDATORY (Required=R) - These attributes are mandatory or core attributes for the GDSN Message. A message cannot be published without these elements. DEPENDENT (Conditional =C) - Dependent attributes become GDSN Mandatory based on the population of another attribute, or based on the value populated for another attribute. These dependencies are driven either by validation rule or by invoking a class (or group) of attributes OPTIONAL (Optional Attributes to USCI)- These attributes add value to the foodservice supply chain, and consequently may be requested by foodservice data recipients. If the number of trading partners requesting these attributes increases to the point that they are needed by the majority of the industry, they may become Foodservice Best Practice (Threshold).
3.1
REQUIRED DATA ATTRIBUTES
USCI currently requires the following mandatory set of attributes: Alternate Item Number – Manufacturer’s Product Code Brand Name Country of Origin Dimensions – Height, Width, Depth and Unit of Measure in Inches Functional Name Global Product Classification Code Gross Weight (All packaging unit of measure in Pounds (LBS) - included case, dispenser, baggage ) Net Weight (Actual weight of the product - Unit of Measure in Pounds (LBS) GTIN (14 digit item number) Information Provider GLN Net Content on Base Unit or Consumer Unit Order Sizing Factor / UOM (only for suppliers using Cube Adjusted Weight) Pallet Ti, Hi Product Descriptions Product Type (e.g. case, inner pack, each, etc.) Shelf Life from Production & UOM - Product Life Span from Production in Days Storage Temperature Min/Max Target Market Unit Indicators: Base Unit, Consumer Unit, Orderable Unit, Shipping Unit, Invoice Unit, Variable Weight Unit Pack Size Information Notes: o
Assign GTIN’s to all levels of packaging. The net content at the lowest level of the hierarchy will be the size. The number of units at the higher levels will determine the pack count.
Data Synchronization Implementation Guide Example: Consumer unit GTIN published net content is “4 ounces”. Inner pack GTIN published contains “6” units (the number of consumer unit items within one inner pack). Case GTIN published contains “2” units (the number of inner pack items within one case). In this example, the pack size is 2-6-4 OZ. If your cases contain inner packs that are not bar coded, use the following GDSN fields to send the unmarked “contents” of the GTIN: Inner Pack Quantity (No GTIN Assigned) Item in Inner Pack Quantity (No GTIN Assigned) Individual Unit Measures – Min/Max and UOM’s Example: A bulk pack item that is a 4-5lb case. Inner pack quantity published is “4”. Individual unit min/max published is “5 pounds”. Example: A case of 4 steaks where the size of the individual item is a range (12-14oz). Inner pack quantity published is “4”. Individual unit min published is “12 ounces”, and individual unit max published is “14 ounces”
o
3.2
Nutritional:
Notes: USCI is requiring all suppliers of consumable products to provide Nutrition and Allergen information. USCI requires suppliers be providing the nutrient information based off 100 grams amounts.
Data Synchronization Implementation Guide 4
ATTRIBUTE TABLE Ref #
Common Name
1WorldSync Attribute Name
Global Data Dictionary Tag
Attribute Required
1
Information Provider GLN
Brand
informationProviderOfTrad eItem nameOfInformationProvide r brandName
R
3
Information Provider GLN Information Provider GLN Brand Name
4
GTIN
GTIN
GTIN
R
5
Unit Descriptor
Product Type
tradeItemUnitDescriptor
R
6
Brand Owner Name
Brand Owner GLN Name
nameOfBrandOwner
O
7
Brand Owner GLN
Brand Owner GLN
brandOwner
O
8
Manufacturer Product Number Manufacturer Product Number Manufacturer Short Product Description
Alternate Item Identification Agency Alternate Item Identification Id Short Description / POS Desc. 1
additionalTradeItemIdentifi cationTypeCode additionalTradeItemIdentifi cationValue descriptionShort
R
11
Product Name
Product Description
tradeItemDescription
R
12
Manufacturer Expanded Product Description
Additional Description
additionalTradeItemDescri ption
R
13
Base Unit Indicator
isTradeItemABaseUnit
R
Orderable Unit
R
Dispatch Unit Indicator
isTradeItemAnOrderableUn it isTradeItemAConsumerUni t isTradeItemADespatchUnit
Invoice Unit Indicator
sTradeItemAnInvoiceUnit
R
18
Is Item the Base Unit (Lowest Packaging Level) Is Trade Item Orderable? Is Trade Item Consumer Unit? Is Trade Item Shipping Unit? Is Trade Item Invoice Unit? Gross Weight/uom
Gross Weight
grossWeight/uom
R
19
Net Weight/uom
Net Weight
netWeight/uom
R
20
Quantity of Next Lower Package Level
Qty of Next Level Item(s)
totalQuantityOfNextLow erLevelTradeItem
R
21
Net Content/uom
Net Content
netContent/uom
R
22
Catch Weight
isTradeItemAVariableUnit
R
23
Height/uom
Variable Weight Trade Item Height/UOM
height/uom
R
24
Width/uom
Width/UOM
width/uom
R
25
Depth/uom
Depth/UOM
depth/uom
R
26
Cube/uom
Volume/UOM
R
27
Pallet Ti and Pallet Hi
Pallet Hi
tradeItemMeasurements/v olume/uom quantityOfCompleteLayers ContainedInATradeItem
2
9 10
14 15 16 17
Information Provider Name
Consumer Unit Indicator
R R
R R
R R
R
Notes
Data Synchronization Implementation Guide 28
Pallet Ti and Pallet Hi
Pallet Ti
quantityOfTradeItemsCont ainedInACompleteLayer
R
29
Pallet Ti and Pallet Hi
non GTIN Pallet Ti
R
30
Pallet Ti and Pallet Hi
non GTIN Pallet Hi
quantityOfTradeItemsPerP alletLayer quantityOfLayersPerPallet
31
Shelf Life from Production
Min Product Lifespan from Production
minimumTradeItemLifespa nFromTimeOfProduction
R
32
Storage Temperature Minimum with UoM
temperatureQualifierCode minimumTemperature/uo m
R
33
Storage Temperature Maximum with UoM
temperatureQualifierCode maximumTemperature/uo m
R
34
Effective Date of Change Discontinued / Cancel Date Is Packaging marked as Returnable?
Temperature Qualifier Code = STORAGE_HANDLING Minimum Temperature/UOM Temperature Qualifier Code = STORAGE_HANDLING Maximum Temperature/UOM Effective Date
effectiveDate
R
Discontinued Date/Canceled Date Packaging Marked Returnable
discontinuedDateTime/can celledDateTime sPackagingMarkedReturna ble
C
35 36
R
R
37
Is the Item marked as recyclable?
Product Marked Recyclable
isTradeItemMarkedAsRecy clable
R
38
Item Availability Date
Start Availability Date
startAvailabilityDateTime
R
39
Target Market
Target Market
targetMarketCountryCode
R
40
Functional Name
Functional Name
functionalName
R
41
Global Product Classification (GPC)
GPC Code
classificationCategoryCode
R
42
GTIN of Next Higher Package Level
Parent GTIN
parentGTIN
C
43
GTIN of Next Lower Package Level
Child GTIN
childGTIN
C
44
Country of Origin
Country of Origin
tradeItemCountryOfOrigin
R
45
Allergen Relevant Data Provided
Allergen Relevant Data Provided
allergenRelevantDataProvi ded
C
46
Allergens
Allergen Agency
O
47
Allergens
Allergen Regulation Name
allergenSpecificationAgenc y allergenSpecificationName
48
Allergens Allergens
50
Allergens
51
Allergens
52
Allergens
allergenTypeCode (AC) & levelOfContainment allergenTypeCode(AE) & levelOfContainment allergenTypeCode(AF) & levelOfContainment allergenTypeCode(AM) & levelOfContainment allergenTypeCode(AS) & levelOfContainment
R
49
Allergen Level Of Allergen Level Of Allergen Level Of Allergen Level Of Allergen Level Of
Type Code (AC) & Containment Type Code (AE) & Containment Type Code (AF) & Containment Type Code (AM) & Containment Type Code (AS) & Containment
If provided value is Yes product passes Allergens audit ***
O
R R R R
Crustaceans and their derivates Eggs and their derivates Fish and their derivates Milk and its derivates Sesame Seeds and their derivates
Data Synchronization Implementation Guide 53
Allergens
54
Allergens
55
Allergens
56
Allergens
57
Nutrition Fact Serving Size & UOM Nutrition Fact Serving Size & UOM Serving Size Text
58 59
Allergen Type Code (AN) & Level Of Containment Allergen Type Code (UW) & Level Of Containment Allergen Type Code (AY) & Level Of Containment Allergen Type Code (AP) & Level Of Containment Serving Size
allergenTypeCode(AN) & levelOfContainment allergenTypeCode(UW) & levelOfContainment allergenTypeCode(AY) & levelOfContainment allergenTypeCode(AP) & levelOfContainmen servingSize
R
Serving Size UOM
servingSizeUoM
R
R R R R
Serving Size Description
servingSizeDescription
R
Nutrient Label contents and measures Nutrient Relevant Data Provided
Preparation State
preparationState
C
Nutrient Relevant Data Provided
nutrientRelevantDataProvi ded
R
62
Nutrient Label contents and measures Nutrient Label contents and measures
64
Nutrient Label contents and measures
65
Nutrient Label contents and measures
66
Nutrient Label contents and measures
67
Nutrient Label contents and measures
68
Nutrient Label contents and measures
69
Nutrient Label contents and measures
70
Nutrient Label contents and measures
71
Nutrient Label contents and measures
72
Nutrient Label contents and measures
nutrientTypeCode(ENER-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(ENERPF) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & percentageOfDailyValueInt ake nutrientTypeCode(FASAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FASAT) & percentageOfDailyValueInt ake nutrientTypeCode(FATRN) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHOL-) & percentageOfDailyValueInt ake nutrientTypeCode(CHOL-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(NA) & percentageOfDailyValueInt ake nutrientTypeCode(NA) & measurementPrecision & quantityContained & quantityContainedUoM
R
63
nutrientTypeCode(ENER-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(ENERPF) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & percentageOfDailyValueInt ake nutrientTypeCode(FASAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FASAT) & percentageOfDailyValueInt ake nutrientTypeCode(FATRN) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHOL-) & percentageOfDailyValueInt ake nutrientTypeCode(CHOL-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(NA) & percentageOfDailyValueInt ake nutrientTypeCode(NA) & measurementPrecision & quantityContained & quantityContainedUoM
60 61
Nuts and their derivates Wheat and its derivates Soybeans and their derivates Peanuts and their derivates
O
R
R R
R
R
R
R
R R
M if any Nutrients Stated If provided value is Yes product passes Nutrients audit ***
Data Synchronization Implementation Guide 73
Nutrient Label contents and measures
74
Nutrient Label contents and measures
75
Nutrient Label contents and measures
76
Nutrient Label contents and measures
77
Nutrient Label contents and measures
78
Nutrient Label contents and measures
79
Nutrient Label contents and measures
80
Nutrient Label contents and measures
81
Nutrient Label contents and measures
82
Nutrient Label contents and measures
83
Nutrient Label contents and measures
84
Nutrient Label contents and measures
85
Nutrient Label contents and measures Nutrient Label contents and measures
86
nutrientTypeCode(CHO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHO-) & percentageOfDailyValueInt ake nutrientTypeCode(FIBTSW) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FIBTSW) & percentageOfDailyValueInt ake nutrientTypeCode(SUGAR) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD ) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD )& percentageOfDailyValueInt ake nutrientTypeCode(PRO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(VITA-) & percentageOfDailyValueInt ake nutrientTypeCode(VITC-) & percentageOfDailyValueInt ake nutrientTypeCode(CA) & percentageOfDailyValueInt ake nutrientTypeCode(FE) & percentageOfDailyValueInt ake Ingredient Statement
nutrientTypeCode(CHO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHO-) & percentageOfDailyValueInt ake nutrientTypeCode(FIBTSW) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FIBTSW) & percentageOfDailyValueInt ake nutrientTypeCode(SUGAR) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD ) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD )& percentageOfDailyValueInt ake nutrientTypeCode(PRO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(VITA-) & percentageOfDailyValueInt ake nutrientTypeCode(VITC-) & percentageOfDailyValueInt ake nutrientTypeCode(CA) & percentageOfDailyValueInt ake nutrientTypeCode(FE) & percentageOfDailyValueInt ake ingredientStatement
R
Number Of Servings Per Package
numberOfServingsPerPack age
R
R R
R
R
R
R
R
O O R R R
Confidential & Proprietary
Data Synchronization Implementation Guide REVISION HISTORY Date
Ver #
Description of Change
Author
06/21/2016
1
Initial document
K.Danner
Data Synchronization Implementation Guide TABLE OF CONTENTS 1 2 3
USCI DATA SYNCHRONIZATION INFORMATION ....................... 4 1.1 International USCI GLN.................................................... 4 1.2 USCI Summary and Contacts............................................ 4 STEPS TO BEGIN SYNCING YOUR DATA WITH USCI ................. 5 ATTRIBUTE REQUIREMENTS ..................................................... 8 3.1 REQUIRED DATA ATTRIBUTES .......................................... 8 3.2 Nutritional: ...................................................................... 9
Data Synchronization Implementation Guide 1
USCI DATA SYNCHRONIZATION INFORMATION 1.1
USCI GLN
Production: 0073245000012 1.2
USCI Summary and Contacts Primary Program Analyst
Secondary Program Analyst
Contact:
TJ Stommes
Contact:
Diane Pafiolis
Phone:
952.830.0417
Phone:
952.830.0493
Email:
[email protected]
Email:
[email protected]
SUMMARY Company Overview: The DQ® System and Unified Supply Chain Inc. (USCI). The DQ® system is now on its 76th year with more than 6,700 locations throughout the U.S., Canada and 27 other countries. Although much has changed in the world and in the DQ® system through the years, success is as simple today as it was in 1940. Happy fans lead to successful restaurants. In 2004, Unified Supply Chain Inc. (USCI) was formed as a wholly owned subsidiary of International Dairy Queen (IDQ). It was created to streamline the supply chain operations of IDQ, allow for transparency through franchisee participation in the supply chain and to provide Dairy Queen® franchisees a competitive position against the other QSR chains. As USCI was formed, the franchisee Supply Chain Advisory Council (SCAC) was elected to advise USCI on all supply chain issues while ensuring accountability. USCI and the SCAC continue to work together, making tremendous strides in lowering costs for DQ® operators while ensuring stable and dependable supply and this is the main reason we are adopting the GS1 Standards. USCI would like to achieve more accurate data while creating efficiencies. Now that we have started the initiative with GS1 Standards we now have the opportunity to utilize the GDSN technology as well as pave the way to traceability of product to store operation. GDSN/GS1 Initiative: USCI and the SCAC are committed to protecting our brand and taking proactive measures to enhance food safety and franchisee profitability. Data accuracy and Food safety is our top priority and the GDSN (Global Data Synchronization Network) standards will allow us product traceability that we need to protect our fans and our franchisees while reducing costs and creating efficiencies. Implementing the GS1 standards and utilizing the technology of GDSN into our supply chain is a significant step forward for our supply chain and franchisee profitability.
Data Synchronization Implementation Guide 2
STEPS TO BEGIN SYNCING YOUR DATA WITH USCI
Have your accurate item data loaded into your home data pool and ensure it is ready for publication a. Contact your Data Pool for any education you might require to complete this step.
Understand USCI’s Attribute Requirements a. USCI’s attribute requirements are detailed beginning on page 7 of this document. USCI strongly recommends organizing, loading and sending these attributes via the GDSN as soon as possible. b. 1WorldSync customers please refer to the 1WorldSync Foodservice Attribute Mapping Guide located on the 1WorldSync Solution Center/Foodservice tab/Implementation folder. This guide will map all the Foodservice Common Names to a 1WorldSync attribute and location. c. All mandatory attributes are required at the case level and below. If a product is sold to USCI at a packaging level above the case, all mandatory attributes are required at that packaging level above the case down to the lowest level of packaging. d. A full list of attributes can be found in Section 3.
Complete the USCI Trading Partner Form located at http://www.1worldsync.com/web/us/international-dairy-queen
USCI will place a subscription to your company’s GLN. Please wait to see USCI’s subscription on your solution provider or data pool interface before publishing items
USCI will send email to the supplier’s primary data synchronization contact when we are ready for the first publications.
Publish items a. Publish all items as Initial Load b. Publish items only sold to USCI
USCI will provide feedback on publications using the following method a. Catalogue Item Confirmation: CICs i. RECEIVED – Product record has been received and has passed the USCI GDSN validations. This response will typically be sent within a few hours after receiving the publication. ii. REVIEW - Product does not pass USCI’s GDSN validations or product has failed USCI’s audit process and therefore has data discrepancies to be reviewed and addressed. Reason for Review status will be transmitted in CIC999. iii. SYNCHRONIZED - Product has been released by USCI to our catalog and will be updated as revisions occur. This response will be sent after all validations and audits have been successfully completed iv. REJECT - Product has been rejected by USCI. The item will be removed from USCI’s Catalog and a Rejected CIC status will be sent.
Data Synchronization Implementation Guide
Send ongoing item maintenance notifications through your GDSN Certified Data Pool to USCI. USCI utilizes GDSN product information in their new item set up process. Suppliers are required to publish and pass, all audit requirements on every item sold to USCI, to help facilitate the new item set up process and increase the speed to market on new items. The expectation of USCI is all required attributes for new item requests will be published through the GDSN within 72 hours.
Ongoing Data Synchronization After USCI’s initial data synchronization process is complete, during ongoing day-to-day operations, you may observe changes in the way USCI subscribes to your items. Additional subscriptions may be placed for specific GTINs and/or changes may be made to subscriptions at the GLN level. If these changes are visible to you via your GDSN tools, you do not need to make any changes to your existing publications. You should also continue to perform your standard process for publishing any new items to USCI. Removal of a Previous Subscription Even if you notice that USCI has removed a previous subscription to your items, USCI will continue to receive your item updates, per the standard behavior of the GDSN. Your item updates to USCI will stop only if you receive a CIC “Rejected” message. GDSN Foodservice Attributes List For most attributes, USCI follows the GS1 US Foodservice Initiative recommendations. The two exceptions to date will be supplying your current Manufacturer Product Code (MPC) to insure synchronization with legacy systems and the future requirement for 100-gram nutritional data. Providing Your Current Manufacturer Product Code (MPC) USCI requires you to provide a Manufacturer Product Code (MPC) which is used to help align your GTIN with USCI’s internal catalog items. This value is supplied for each item via two attributes: “additionalTradeItemIdentificationType” = SUPPLIER_ASSIGNED and “additionalTradeItemIdentificationValue” = {your MPC}. 100-Gram Nutritional Data In addition to nutritional data corresponding to “Serving Size”, USCI will require the new “100-Gram Product Information” variant for nutritional data. This is a best practice from the GS1 US Foodservice Initiative. Prior to requirement date, USCI will work closely with you and the various data pools to ensure all parties can test their systems adequately and comply with GS1 US best practices.
Data Synchronization Implementation Guide
Data Synchronization Implementation Guide 3
ATTRIBUTE REQUIREMENTS The following are the definitions for the GDSN Attribute quantifiers as found in the GDSN, Foodservice and USCI Required Attributes table found in the next section. MANDATORY (Required=R) - These attributes are mandatory or core attributes for the GDSN Message. A message cannot be published without these elements. DEPENDENT (Conditional =C) - Dependent attributes become GDSN Mandatory based on the population of another attribute, or based on the value populated for another attribute. These dependencies are driven either by validation rule or by invoking a class (or group) of attributes OPTIONAL (Optional Attributes to USCI)- These attributes add value to the foodservice supply chain, and consequently may be requested by foodservice data recipients. If the number of trading partners requesting these attributes increases to the point that they are needed by the majority of the industry, they may become Foodservice Best Practice (Threshold).
3.1
REQUIRED DATA ATTRIBUTES
USCI currently requires the following mandatory set of attributes: Alternate Item Number – Manufacturer’s Product Code Brand Name Country of Origin Dimensions – Height, Width, Depth and Unit of Measure in Inches Functional Name Global Product Classification Code Gross Weight (All packaging unit of measure in Pounds (LBS) - included case, dispenser, baggage ) Net Weight (Actual weight of the product - Unit of Measure in Pounds (LBS) GTIN (14 digit item number) Information Provider GLN Net Content on Base Unit or Consumer Unit Order Sizing Factor / UOM (only for suppliers using Cube Adjusted Weight) Pallet Ti, Hi Product Descriptions Product Type (e.g. case, inner pack, each, etc.) Shelf Life from Production & UOM - Product Life Span from Production in Days Storage Temperature Min/Max Target Market Unit Indicators: Base Unit, Consumer Unit, Orderable Unit, Shipping Unit, Invoice Unit, Variable Weight Unit Pack Size Information Notes: o
Assign GTIN’s to all levels of packaging. The net content at the lowest level of the hierarchy will be the size. The number of units at the higher levels will determine the pack count.
Data Synchronization Implementation Guide Example: Consumer unit GTIN published net content is “4 ounces”. Inner pack GTIN published contains “6” units (the number of consumer unit items within one inner pack). Case GTIN published contains “2” units (the number of inner pack items within one case). In this example, the pack size is 2-6-4 OZ. If your cases contain inner packs that are not bar coded, use the following GDSN fields to send the unmarked “contents” of the GTIN: Inner Pack Quantity (No GTIN Assigned) Item in Inner Pack Quantity (No GTIN Assigned) Individual Unit Measures – Min/Max and UOM’s Example: A bulk pack item that is a 4-5lb case. Inner pack quantity published is “4”. Individual unit min/max published is “5 pounds”. Example: A case of 4 steaks where the size of the individual item is a range (12-14oz). Inner pack quantity published is “4”. Individual unit min published is “12 ounces”, and individual unit max published is “14 ounces”
o
3.2
Nutritional:
Notes: USCI is requiring all suppliers of consumable products to provide Nutrition and Allergen information. USCI requires suppliers be providing the nutrient information based off 100 grams amounts.
Data Synchronization Implementation Guide 4
ATTRIBUTE TABLE Ref #
Common Name
1WorldSync Attribute Name
Global Data Dictionary Tag
Attribute Required
1
Information Provider GLN
Brand
informationProviderOfTrad eItem nameOfInformationProvide r brandName
R
3
Information Provider GLN Information Provider GLN Brand Name
4
GTIN
GTIN
GTIN
R
5
Unit Descriptor
Product Type
tradeItemUnitDescriptor
R
6
Brand Owner Name
Brand Owner GLN Name
nameOfBrandOwner
O
7
Brand Owner GLN
Brand Owner GLN
brandOwner
O
8
Manufacturer Product Number Manufacturer Product Number Manufacturer Short Product Description
Alternate Item Identification Agency Alternate Item Identification Id Short Description / POS Desc. 1
additionalTradeItemIdentifi cationTypeCode additionalTradeItemIdentifi cationValue descriptionShort
R
11
Product Name
Product Description
tradeItemDescription
R
12
Manufacturer Expanded Product Description
Additional Description
additionalTradeItemDescri ption
R
13
Base Unit Indicator
isTradeItemABaseUnit
R
Orderable Unit
R
Dispatch Unit Indicator
isTradeItemAnOrderableUn it isTradeItemAConsumerUni t isTradeItemADespatchUnit
Invoice Unit Indicator
sTradeItemAnInvoiceUnit
R
18
Is Item the Base Unit (Lowest Packaging Level) Is Trade Item Orderable? Is Trade Item Consumer Unit? Is Trade Item Shipping Unit? Is Trade Item Invoice Unit? Gross Weight/uom
Gross Weight
grossWeight/uom
R
19
Net Weight/uom
Net Weight
netWeight/uom
R
20
Quantity of Next Lower Package Level
Qty of Next Level Item(s)
totalQuantityOfNextLow erLevelTradeItem
R
21
Net Content/uom
Net Content
netContent/uom
R
22
Catch Weight
isTradeItemAVariableUnit
R
23
Height/uom
Variable Weight Trade Item Height/UOM
height/uom
R
24
Width/uom
Width/UOM
width/uom
R
25
Depth/uom
Depth/UOM
depth/uom
R
26
Cube/uom
Volume/UOM
R
27
Pallet Ti and Pallet Hi
Pallet Hi
tradeItemMeasurements/v olume/uom quantityOfCompleteLayers ContainedInATradeItem
2
9 10
14 15 16 17
Information Provider Name
Consumer Unit Indicator
R R
R R
R R
R
Notes
Data Synchronization Implementation Guide 28
Pallet Ti and Pallet Hi
Pallet Ti
quantityOfTradeItemsCont ainedInACompleteLayer
R
29
Pallet Ti and Pallet Hi
non GTIN Pallet Ti
R
30
Pallet Ti and Pallet Hi
non GTIN Pallet Hi
quantityOfTradeItemsPerP alletLayer quantityOfLayersPerPallet
31
Shelf Life from Production
Min Product Lifespan from Production
minimumTradeItemLifespa nFromTimeOfProduction
R
32
Storage Temperature Minimum with UoM
temperatureQualifierCode minimumTemperature/uo m
R
33
Storage Temperature Maximum with UoM
temperatureQualifierCode maximumTemperature/uo m
R
34
Effective Date of Change Discontinued / Cancel Date Is Packaging marked as Returnable?
Temperature Qualifier Code = STORAGE_HANDLING Minimum Temperature/UOM Temperature Qualifier Code = STORAGE_HANDLING Maximum Temperature/UOM Effective Date
effectiveDate
R
Discontinued Date/Canceled Date Packaging Marked Returnable
discontinuedDateTime/can celledDateTime sPackagingMarkedReturna ble
C
35 36
R
R
37
Is the Item marked as recyclable?
Product Marked Recyclable
isTradeItemMarkedAsRecy clable
R
38
Item Availability Date
Start Availability Date
startAvailabilityDateTime
R
39
Target Market
Target Market
targetMarketCountryCode
R
40
Functional Name
Functional Name
functionalName
R
41
Global Product Classification (GPC)
GPC Code
classificationCategoryCode
R
42
GTIN of Next Higher Package Level
Parent GTIN
parentGTIN
C
43
GTIN of Next Lower Package Level
Child GTIN
childGTIN
C
44
Country of Origin
Country of Origin
tradeItemCountryOfOrigin
R
45
Allergen Relevant Data Provided
Allergen Relevant Data Provided
allergenRelevantDataProvi ded
C
46
Allergens
Allergen Agency
O
47
Allergens
Allergen Regulation Name
allergenSpecificationAgenc y allergenSpecificationName
48
Allergens Allergens
50
Allergens
51
Allergens
52
Allergens
allergenTypeCode (AC) & levelOfContainment allergenTypeCode(AE) & levelOfContainment allergenTypeCode(AF) & levelOfContainment allergenTypeCode(AM) & levelOfContainment allergenTypeCode(AS) & levelOfContainment
R
49
Allergen Level Of Allergen Level Of Allergen Level Of Allergen Level Of Allergen Level Of
Type Code (AC) & Containment Type Code (AE) & Containment Type Code (AF) & Containment Type Code (AM) & Containment Type Code (AS) & Containment
If provided value is Yes product passes Allergens audit ***
O
R R R R
Crustaceans and their derivates Eggs and their derivates Fish and their derivates Milk and its derivates Sesame Seeds and their derivates
Data Synchronization Implementation Guide 53
Allergens
54
Allergens
55
Allergens
56
Allergens
57
Nutrition Fact Serving Size & UOM Nutrition Fact Serving Size & UOM Serving Size Text
58 59
Allergen Type Code (AN) & Level Of Containment Allergen Type Code (UW) & Level Of Containment Allergen Type Code (AY) & Level Of Containment Allergen Type Code (AP) & Level Of Containment Serving Size
allergenTypeCode(AN) & levelOfContainment allergenTypeCode(UW) & levelOfContainment allergenTypeCode(AY) & levelOfContainment allergenTypeCode(AP) & levelOfContainmen servingSize
R
Serving Size UOM
servingSizeUoM
R
R R R R
Serving Size Description
servingSizeDescription
R
Nutrient Label contents and measures Nutrient Relevant Data Provided
Preparation State
preparationState
C
Nutrient Relevant Data Provided
nutrientRelevantDataProvi ded
R
62
Nutrient Label contents and measures Nutrient Label contents and measures
64
Nutrient Label contents and measures
65
Nutrient Label contents and measures
66
Nutrient Label contents and measures
67
Nutrient Label contents and measures
68
Nutrient Label contents and measures
69
Nutrient Label contents and measures
70
Nutrient Label contents and measures
71
Nutrient Label contents and measures
72
Nutrient Label contents and measures
nutrientTypeCode(ENER-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(ENERPF) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & percentageOfDailyValueInt ake nutrientTypeCode(FASAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FASAT) & percentageOfDailyValueInt ake nutrientTypeCode(FATRN) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHOL-) & percentageOfDailyValueInt ake nutrientTypeCode(CHOL-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(NA) & percentageOfDailyValueInt ake nutrientTypeCode(NA) & measurementPrecision & quantityContained & quantityContainedUoM
R
63
nutrientTypeCode(ENER-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(ENERPF) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FAT) & percentageOfDailyValueInt ake nutrientTypeCode(FASAT) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FASAT) & percentageOfDailyValueInt ake nutrientTypeCode(FATRN) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHOL-) & percentageOfDailyValueInt ake nutrientTypeCode(CHOL-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(NA) & percentageOfDailyValueInt ake nutrientTypeCode(NA) & measurementPrecision & quantityContained & quantityContainedUoM
60 61
Nuts and their derivates Wheat and its derivates Soybeans and their derivates Peanuts and their derivates
O
R
R R
R
R
R
R
R R
M if any Nutrients Stated If provided value is Yes product passes Nutrients audit ***
Data Synchronization Implementation Guide 73
Nutrient Label contents and measures
74
Nutrient Label contents and measures
75
Nutrient Label contents and measures
76
Nutrient Label contents and measures
77
Nutrient Label contents and measures
78
Nutrient Label contents and measures
79
Nutrient Label contents and measures
80
Nutrient Label contents and measures
81
Nutrient Label contents and measures
82
Nutrient Label contents and measures
83
Nutrient Label contents and measures
84
Nutrient Label contents and measures
85
Nutrient Label contents and measures Nutrient Label contents and measures
86
nutrientTypeCode(CHO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHO-) & percentageOfDailyValueInt ake nutrientTypeCode(FIBTSW) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FIBTSW) & percentageOfDailyValueInt ake nutrientTypeCode(SUGAR) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD ) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD )& percentageOfDailyValueInt ake nutrientTypeCode(PRO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(VITA-) & percentageOfDailyValueInt ake nutrientTypeCode(VITC-) & percentageOfDailyValueInt ake nutrientTypeCode(CA) & percentageOfDailyValueInt ake nutrientTypeCode(FE) & percentageOfDailyValueInt ake Ingredient Statement
nutrientTypeCode(CHO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(CHO-) & percentageOfDailyValueInt ake nutrientTypeCode(FIBTSW) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(FIBTSW) & percentageOfDailyValueInt ake nutrientTypeCode(SUGAR) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD ) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(SUGARD )& percentageOfDailyValueInt ake nutrientTypeCode(PRO-) & measurementPrecision & quantityContained & quantityContainedUoM nutrientTypeCode(VITA-) & percentageOfDailyValueInt ake nutrientTypeCode(VITC-) & percentageOfDailyValueInt ake nutrientTypeCode(CA) & percentageOfDailyValueInt ake nutrientTypeCode(FE) & percentageOfDailyValueInt ake ingredientStatement
R
Number Of Servings Per Package
numberOfServingsPerPack age
R
R R
R
R
R
R
R
O O R R R
