Identifying GTIN In Outbound EDI 5010 maps
Identifying GTIN in Kroger EDI outbound 5010 maps (for transactions 810, 812, 830, 832, 850, 867, 875, 880) vendors have the possibility of case items being sent as UPCs (UA qualifier) or GTINs (UK qualifier). The MFG id (which is made up of the package level indicator, the country code and a 6 digit prefix) is used to determine if the case items have been converted to GTINs or not. Kroger treats an entire MFG id as either being converted or not.
Identifying GTIN MFG id – identified in one of the following ways:
- UPC MFG id = ‘0’ (package level indicator) + first 7 digits (country code + 6 digit prefix) of the UPC
Example – UPC 001234577777 the MFG id would be 00012345 (0 + 0012345)
- GTIN MFG id = replace the 1st digit (package level indicator) with ‘0’ + the next 7 digits (country code + 6 digit prefix) of the GTIN
Example – GTIN 10034567888889 the MFG id would be 00034567 (0 + 0034567)
GTINs will be sent out for case items in the 5010 EDI maps for:
- Any MFG id that is identified at Kroger as converted to GTIN
- Private label items (any of the MFG ids listed below)
- KPCs (MFG id with a ‘4’ in the 3rd position / 1st position of the 6 digit prefix)
- EANs (MFG id with a digit other than zero in the 2nd position / country code)
- Converted MFG ids
If a MFG id is identified as having been converted at Kroger, all items under that MFG id will be sent as GTINs. This would happen when Kroger has gone thru the GTIN conversion process with the owner of the MFG id. (Note: if you own just a few items under a MFG id, the MFG id may have been converted even though your items have not been)
- Private Label MFG ids: 0 (package level indicator) + 0 (country code) + certain 6 digit prefixes
00001000 00001110 00002000 00003000 00004000 00011110
00011240 00041175 00041226 00041260 00041573 00341226
- KPCs (any MFG id in the following format):
004xxxxx where 0 (package level indicator) + 0 (country code) + any 6 digit prefix beginning with ‘4’
- EANs (any MFG id that has a country code other than 0):
0#xxxxxx where # (the country code) is any number > 0 and xxxxxx are any 6 digit prefix
Example of a partner upgrading from version 4010 to 5010
Vendors currently receive the following items as UPCs in version 4010:
PO1**63*CA*13.6**UA*004126034060*PI*0520213~
PO1**252*CA*19.1**UA*001111097274*PI*07534~
PO1**45*CA*18**UA*007161703111*PI*0754523~
PO1**60*CA*77**UA*040108000135*PI*0254078~
PO1**40*CA*48**UA*341776102000*PI*0307504~
When vendors upgrade to version 5010, they would receive these same items as the following:
PO1**63*CA*13.6**UA*004126034060*PI*0520213~
004126034060 è MFG id = 0 + 0041260 MFG id not converted UPC sent
PO1**252*CA*19.1**UK*0001111097274*PI*07534~
001111097274 è MFG id = 0 + 0011110 MFG id is a private label GTIN sent (MFG id is in the list of private label MFG ids)
PO1**45*CA*18**UA*007161703111*PI*0754523~
007161703111 è MFGid = 0 + 0071617 MFG id not converted UPC sent
PO1**60*CA*77**UK*0040108000135*PI*0254078~
040108000135 è MFG id = 0 + 0401080 MFG id is a KPC GTIN sent (MFG id has a ‘4’ in the 3rd position)
PO1**40*CA*48**UK*0341776102000*PI*0307504~
341776102000 è MFG id = 0 + 3417761 MFG id is an EAN GTIN sent (MFG id has a non-zero in the 2nd position)
Additional situations where a UPC with a MFG id that is not a private label, not a KPC and not an EAN that will cause a GTIN to be transmitted:
- Your company has just an item or 2 under a MFG id owned by another vendor who has already converted the MFG id to GTIN
- Your company has acquired a MFG id from another vendor who has already converted the MFG id to GTIN.