Follow these steps to import products that meet the "Each" packaging level requirements, so that GS1 US Data Hub can assign available GTINs to these products. In other words, when you import these products, they have NOT had GTINs assigned to them - but after they are imported successfully, they will have the GTINs assigned. Typically, items with the "Each" packaging level are individual products that can be purchased by consumers and are the lowest level of the packaging hierarchy.
For more details, view the GS1 US Data Hub Working with Product Import Templates User Guide.
- From the menu bar, click Product, then Import.
- 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.
- 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.
- 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 more details, view Packaging Level Definitions. 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.
- Click "Browse" on the main Product Import page and select the update file you just saved, then click "Submit."
- 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.
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.