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" is 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.
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.