GS1 US Data Hub® Help Center
Welcome to GS1 US Data Hub Help Center

Use the categories on the left hand side to focus on a specific topic. Or type keywords in the search box. Or get answers to basic questions using the "How Do I..."  category. 

Product Import Instructional Modules

21 February 2020

Product Import Instructional Modules

GS1 US Data Hub: Product Import

To learn how to add products in bulk, click one of the links below to view the Product Import instructional module in the GS1 US University Learning Management System:

Download All Available GTINs (Duration: 6:36) - this module explains how to assign GTINs to your products and import them into GS1 US Data Hub. The module shows how to enter product data in the columns, save the template, then submit it to GS1 US Data Hub for processing. The GTINs will then be assigned to these products. You can also use this template to view a list of ALL available GTINs for this prefix. The "GTIN Capacity - Available" number for each prefix is displayed on the main page of Data Hub.

Download Import Template (Duration: 5:03) - this module explains how to import products that already have assigned GTINs (perhaps from another system).

Correcting Errors (Duration: 8:56) - this module explains common errors that members sometime receive when importing products.

Higher Level Packaging (Duration: 9:15) - this module explains how to import higher level packaging items (inner packs, cases, mixed cases, pallets, etc.) into GS1 US Data Hub using the Download Import Template.

How to View All GS1 US Data Hub Modules:

Visit the GS1 US University Learning Management System (sign in required). Under Categories menu on the left, click "GS1 US Data Hub & User Portal," then "Help Resources". All available modules will display on the right, as shown here:

Learn More:

For step-by-step product import instructions in the GS1 US Data Hub Working with Product Import Templates User Guide, click here >

 



Import Products and Assign Available GTINs

21 February 2020

Import Products and Assign Available GTINs

Follow these steps to import multiple products with the "each" packaging level, and have GS1 US Data Hub assign available GTINs to these products. Generally, "each" items are products that can be purchased by consumers and are the lowest level of the packaging hierarchy (to learn how to import higher level packaging items, such as cases, view an instructional module in GS1 US University - sign in is required).

For more details, view the GS1 US Data Hub Working with Product Import Templates User Guide.

  1. From the menu bar, click Product, then Import.



  2. On the main Import page, select the industry for the products you are going to import. This will determine the industry that is applied to each of the product detail records.



  3. Click the "Download All Available GTINs" link. Confirm the industry, then enter the quantity of available GTINs you want to be listed in this template, so you can assign products to these and import them. Then save the template to your computer. Data is pre-populated in several columns, such as "Create" in the "Action" column, the Company Prefix, and GTIN information, among others. Headings that are green-colored are required. Use the drop-down for certain columns to select valid values for that column.



  4. Enter your information into this template (referred to as the "update file" in Help materials), based on the column values as noted in the Product Import user guide.
    If you are pasting information from another spreadsheet, select "Paste as Values"  to preserve the formatting of this template. When you're done, save this file to your computer. These columns require data:

    Action: "Create" will be pre-populated.
    GS1CompanyPrefix: The GS1 Company Prefix will be pre-populated, as noted on your certificate.
    GTIN: The GTINs will be pre-populated, based on the quantity that you specified on the Download All Available GTINs window.
    PackagingLevel: Select "Each" to indicate these are individual trade items sold to consumers. For definitions of other packaging types, view Packaging Level Definitions in this Help Center. Want to learn how to import inner packs, cases, etc.? View the Product Import: Higher Level Packaging module in GS1 US University (sign in is required).
    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, “Edible 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 share with consumers; this field is limited to 70 characters.
    Brand1Language: "en" is displayed for English, which is the default selection.
    Status: If the product is already being shared 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 share with the marketplace, select PreMarket. At a later date, you can change the status of these items to In Use when you're ready to share them with the marketplace. 
    IsVariable: "N" is displayed, meaning this product is not a variable measure trade item.
    IsPurchasable: "Y" is displayed, meaning this product can be purchased by consumers.



  5. Click "Browse" on the main Product Import page and select the update file you just saved, then click "Submit."

  6. GS1 US Data Hub begins to process the file. When "Complete" displays in the Status column, the file has been processed, and you will see the number of records that were processed, the number of successful records and the number of records that had errors (if any).

    If you do see a number other than zero (0) in the # Errors column, click the File Name column to open the file and view the errors in Column B of the 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. You should make the correction back in your original spreadsheet or update file. Remove all the rows for the products that were successfully imported, save the update file to your computer, then submit the file again. 

Q. How do I get a list of GTINs that are available to be assigned?

A. Click "Download All Available GTINs" to view a list of ALL available GTINs for a company prefix: first, identify the available GTINs for this prefix on the home page of GS1 US Data Hub. Then click Product, then click Import, and click the Download All Available GTINs link. Specify this "Available" number in the Quantity field, and click "Continue." A spreadsheet will be generated, listing all GTINs that are still available to be assigned.


Learn More:

View these modules on the GS1 US University Learning Management System (sign in required). Click the GS1 US Data Hub & User Portal category, click "Help Resources," then scroll down to the modules listed below, and click "Launch." Or click the links below to view the module directly:

Download All Available GTINs (Duration: 6:17) - if you need to import new products and assign available GTINs to these products, view this module to learn how to enter product data in the columns, save the template, then submit it for processing. The GTINs will then be assigned to these products.

Download Import Template (Duration: 5:03) - if you want to import products that already have been assigned GTINs (perhaps from another system), or you enter the GTINs manually to your products and assign them when you import the file, view this module.

Product Import, Correcting Errors (Duration: 8:56) - if you received errors when you submitted your file, view this module to review several common errors that are generated and how to correct these errors. 

Product Import, Higher Level Packaging (Duration: 9:21) - learn how to import inner packs, cases, mixed cases, pallets, etc.



GS1 US Data Hub Working with Product Import Templates User Guide

22 February 2019

GS1 US Data Hub Working with Product Import Templates User Guide

To view the GS1 US Data Hub Working with Product Import Templates User Guide, click here >

Product Import Instructional Modules:

In addition, view these Product Import instructional modules in the GS1 US University Learning Management System (sign in is required):

  • Product Import, Download All Available GTINs
  • Product Import, Download Import Template
  • Product Import, Correcting Errors
  • Product Import, Higher Level Packaging

To access, click the "GS1 US Data Hub & User Portal" button under Categories on the main page, then click "Help Resources." Scroll down to the Product Import module you want to view and click "Launch."