What is a Supply Chain

GS1 US Data Hub Help Center

Import Products and Assign Available GTINs

Follow these steps to import products and have GS1 US Data Hub assign available GTINs to these products. These steps are for products with the "Each" packaging level and NOT shipping/receiving items. 

Note: Importing products with GTINs already assigned? Read this Import article.

This link is displayed on the far right of the main Products screen.

You can download one of three templates. To have GS1 US Data Hub assign available GTINs to the products you're creating, you will be using the Download an Assigned GTINs Template.

The number of available GTINs is displayed in parentheses next to the prefix.

This number determines how many available GTINs will display in the template.

The template is saved to your "Downloads" folder.

When you open the template, you'll see that data has been pre-populated in several columns. Use the drop-down for certain columns to select valid values.

Note: Are you pasting information from another spreadsheet? Select "Paste as Values"  to preserve the formatting of this template.

These columns require data:

Action: "Create" are pre-populated.

GS1CompanyPrefix: The GS1 Company Prefix is pre-populated.

GTIN: GTINs are pre-populated, based on the number you entered in the "How many products do you want to create?" field. GTINs are displayed in 14 digits, with two leading zeroes.

PackagingLevel: Select "Each" to indicate these are individual trade items purchased by consumers. Learn more about the other Packaging Level Definitions. To learn how to import higher level packaging, view the Product Import: Higher Level Packaging module.

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), and net contents. For example, “Tasty Harvest Jam Raspberry 20 oz.” There is a 200-character limit. Avoid the use of special characters, such as the pipe "|" and line breaks "CR/LF".

Desc1Language: "en" is displayed for English, which is the default selection.

BrandName: Enter the brand name you want to convey to consumers. 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: "en" is displayed for English, which is the default selection.

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. After you finalize the data, and you're ready to share with the marketplace, you can change the status of these items to In Use.


Industry:
"CPG" indicates Consumer Packaged Goods; General indicates "General Merchandise."


IsVariable:
 "N" is displayed, meaning products are not variable measure trade items.

IsPurchasable: "Y" is displayed, meaning products can be purchased by consumers.

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 file and view the errors in Column B of this spreadsheet (referred to as the "results file" in Help materials).

The Product Import User Guide, Appendix B, contains a list of error messages and corrective actions you can take. Make the corrections back in the original template you saved on your computer. Remove all the rows for products that were successfully imported, save the file, then upload this file again.

Yes. Select the GS1 Company Prefix under the Download an Assigned GTINs Template. The number of available GTINs is ​displayed in parentheses next to each​ GS1 Company Prefix.​

Type the "Available" number in the How many products do you want to create? field, and click the Download Template button. The template will provide a list of all available GTINs that can be assigned, based on the quantity you entered.

Watch or Download:

Import  Products & Assign GTINs Module:

Product Import User Guide (PDF):

Related Articles: