When creating Higher Levels of Packaging, such as an innerpack, case, display shipper or pallet, you can use the Import feature within GS1 US Data Hub®.
Note: You must create your GTIN-14s outside of the GS1 US Data Hub tool prior to filling out this spreadsheet. View the Introduction to the GTIN for guidance.
This link is displayed on the top left of the main Products screen.
You'll be presented with two different options.
If your higher levels of packaging contain a quantity of a SINGLE item, it is recommended you use the "Download a Blank Template".
If your configuration is a Mixed Case/Pallet (multiple products within the case/pallet), you can use the "Assigned GTINs Template".
The import template fields and their required actions are listed below. Green headers indicate required fields. Several columns contain drop-down values; click the drop-down arrow to select a valid value.
Note: Are you pasting information from another spreadsheet? Select "Paste as Values" 
to preserve the formatting of this template.
Action: Select "Create".
GS1CompanyPrefix: Enter the GS1 Company Prefix, as noted on your certificate.
GTIN: Enter the GTIN-14 you've created for these higher-levels of packaging.
PackagingLevel: Select the proper packaging level to identify the product you're create, ex: innerpack. case, or pallet. Learn more about the other Packaging Level Definitions.
Description: Enter the product description for your trading partners (as opposed to consumers). A best practice is to include: brand name, type of product, variation (color, flavor, scent, etc), net contents and quantity. For example, “Tasty Harvest Jam Raspberry 20 oz. Case of 24” There is a 200-character limit. Avoid the use of special characters, such as the pipe "|" and line breaks "CR/LF".
Desc1Language: Select "en" for English.
BrandName: Enter the brand name you have used for the "Each" level item. The Brand Name must be consistent across products, and is case sensitive. It cannot have multiple spellings. This field is limited to 70 characters.
Brand1Language: Select "en" for English.
Status: If you are sharing the product with consumers and trading partners, select In Use from the drop-down. If product details are still being finalized, and the products are not ready to be viewed by the marketplace, select PreMarket. At a later date, after you have finalized date and you're ready to share with the marketplace, you can change the status of these items to In Use. Note: The "Each" level item must be In-Use in order to input the higher level packaging(s) In Use.
Industry: "CPG" indicates Consumer Packaged Goods; General indicates "General Merchandise".
IsVariable: Select "N", meaning this product is not a variable measure trade item.
IsPurchasable: Select "Y," meaning this product can be purchased by consumers.
List the lowest level packaging first, such as “Inner Pack,” then “Case,” and so on. This ensures that all packaging levels in the "hierarchy" are created properly based of their "ChildGTINs".
Enter the GTIN contained in this item. In the Quantity column, enter the quantity of this item.
Note: If the item contain quantities of two or more GTINs (such as a Mixed Case), in the ChildGTINs column, enter the Child GTINs, and separate each Child GTIN with a ~ (tilde key, to the left of the “1” key). Then separate each Child GTIN quantity with the tilde (~) and list these quantities in the same order as the corresponding Child GTIN.
First, save the file to your local drive. Then click the Import/Modify Products tab. You can drag and drop the file into the gray upload box or click Browse Files. Locate the updated file on your computer and click “Open.” The file name displays in the File Input field. Click the Import Products button.
At the bottom of the Import screen, "Complete" will display in the Status column when the file has been processed. Click the Refresh Table button every minute or so after you submit the file to update the Status.
The # Processed column displays the number of records that were processed. The # Successful column displays the number of records that were imported.
The # Errors displays any records that had errors and were not processed.
If a number other than zero (0) displays in the # Errors column, click the File Name column to open the "results" file and view the errors in Column B of the spreadsheet.
The Product Import User Guide, Appendix B, contains a list of error messages and corrective actions you can take. You should make the correction back in the original template you saved on your computer. Remove all the rows for the products that were successfully imported, save the update file to your computer, then submit the file again.
Note: If the message ”File Format error. Please use the current Data Hub Import Template” displays, make sure you used the most recent template and haven’t changed a column name, deleted a column, or added a column.
Product Import User Guide (PDF):
