Supplier product data template: the fields to ask every supplier for
A free CSV template with 43 columns for supplier product data: every field with format, example and the channel or law that needs it, plus a request text to copy.
On this page
In short
- The supplier product data template has 43 columns in eight groups: identity, classification, description, dimensions, packaging, media, compliance and commercial data.
- Article 19 of the EU General Product Safety Regulation requires an online offer to show the manufacturer's name, postal address and electronic address, so the template asks the supplier for all three.
- If the manufacturer is not established in the EU, the offer must also show the name, postal address and electronic address of the responsible person in the EU.
- Textile products need their fibre composition visible before purchase, also online, under Regulation (EU) No 1007/2011.
- Suppliers of products with an EU energy label must give dealers the EPREL model registration number.
- A returned file is usable when it has one row per variant, GTINs as text, every measure with its unit and one value per cell.
Download the template#
The template is one CSV file: a header row with 43 columns and two example rows, a headlamp and a rain jacket from the fictional brand Northpeak.
Download the supplier product data template (CSV)
It is UTF-8, comma separated, and opens in any spreadsheet program. Retailers know this kind of document as a new item setup form, a product information template or a product spec sheet template. It is also the product data part of a vendor onboarding checklist.
| Group | Columns | What it answers |
|---|---|---|
| Identity | 8 | Which product and which variant is this? |
| Classification | 2 | Where does it belong in a catalog? |
| Description | 4 | What is it, for whom, made of what? |
| Dimensions and weight | 4 | How big and heavy is the product? |
| Packaging | 4 | How big and heavy is the parcel? |
| Media | 4 | Which images and documents exist, and may you use them? |
| Compliance | 13 | Who made it, and what must an offer in the EU show? |
| Commercial | 4 | What does it cost, and when can it ship? |
Delete columns that never apply to your range, but keep the order of the rest. What you do with the file when it comes back is covered in product data onboarding.
Every column explained#
The examples are the values of the two rows in the file. "Google" refers to its product data specification, as of November 2026; other channels ask for the same facts under other names.
Identity#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
sku | The supplier's article number for this exact variant | NP-HL-400-BK | You, to match orders and updates. Google requires a unique id of up to 50 characters. |
gtin | The number under the barcode: digits only, as text | 9506000210049 | Google strongly recommends it where the manufacturer assigned one. See what a GTIN is. |
mpn | Manufacturer part number | HL400-BK | Google requires it when the product has no GTIN (up to 70 characters). |
brand | The brand on the product | Northpeak | Google requires it for all new products except movies, books and musical recordings. |
product_name | Name without color and size | Beam 400 Headlamp | The base for titles, which you write per channel. |
variant_group | The same value on every variant of one product | NP-RJ-01 | Channels group variants by it; Google's field is item_group_id. |
color | One plain color name | Navy | Google requires it for apparel in several countries and for products sold in different colors (up to 100 characters). |
size | Size as printed on the product or label | M | Google requires it for clothing and shoes in several countries. |
Classification#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
category | The supplier's category path, levels separated by ">" | Outdoor > Lighting > Headlamps | You, to assign your own and each channel's category. |
classification_code | Standard system and code if the supplier classifies: an ETIM class, an ECLASS code or a GPC brick | Empty in both rows | B2B catalogs and data pools. See product data sources. |
Description#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
description | Plain text, no HTML, facts before adjectives | Waterproof 2.5-layer rain jacket with taped seams... | Every channel. Google allows up to 5,000 characters. |
material | Main material | Polyester | Filters, and Google when material tells variants apart. |
gender | male, female or unisex | unisex | Google requires it for apparel in several countries. |
age_group | newborn, infant, toddler, kids or adult | adult | Google requires it for apparel in several countries. |
Dimensions and weight#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
net_weight | Number and unit, product without packaging | 85 g | Listings and comparisons. Google accepts g, kg, oz and lb for product weight. |
length, width, height | Number and unit, the same unit in all three; leave empty what does not apply | 6.2 cm, 4.1 cm, 3.8 cm | Google accepts cm and in and shows the dimensions only when all use the same unit. |
Packaging#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
package_weight | Number and unit, product in its sales packaging | 132 g | Shipping cost. Google's shipping weight accepts g, kg, oz and lb. |
package_length, package_width, package_height | Number and unit, the same unit in all three | 12 cm, 8 cm, 6 cm | Carrier rates by size. Google asks for all three shipping dimensions if you send one. |
Media#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
main_image_url | Link to the main product image, reachable without login | https://media.northpeak.example/np-hl-400-bk/front.jpg | Every channel. Google requires a main image link. |
additional_image_urls | Further image links, separated by semicolons | Side view; in use | Channels with image galleries. |
image_rights | Who owns the images and what you may do with them | "Resellers may use, crop and resize them in shops, on marketplaces and in ads for as long as they sell the product." | You. See product images from manufacturers. |
document_urls | Links to manuals, care instructions, data sheets | Manual as PDF | Customers, and you as the source of facts. |
Compliance#
These fields exist because EU law requires the information in the online offer, or because a marketplace has to collect it. This page explains the rules; it is not legal advice.
| Column | What goes in | Example | Why, with the official source |
|---|---|---|---|
manufacturer_name, manufacturer_address, manufacturer_email | Name, registered trade name or trade mark; postal address; electronic address | Northpeak Outdoor Ltd., 12 Example Road, Leeds LS1 0AA, United Kingdom, product-safety@northpeak.example | Regulation (EU) 2023/988, Article 19(a): every online offer of a consumer product must show them. |
eu_responsible_person_name, eu_responsible_person_address, eu_responsible_person_email | The responsible person in the EU, when the manufacturer is not established in the EU | Northpeak Europe GmbH, Beispielweg 12, 80331 Munich, Germany, eu-compliance@northpeak.example | Regulation (EU) 2023/988, Article 19(b). See GPSR for online sellers. |
safety_warnings | Warnings and safety information from the product, packaging or leaflet, word for word | Do not look directly into the beam. | Regulation (EU) 2023/988, Article 19(d): shown in the offer, in the language set by the Member State of sale. |
energy_class | Class on the EU energy label, for product groups that have one | Empty in both rows | Regulation (EU) 2017/1369, Article 5: dealers show the label, also online. See energy labels online. |
eprel_registration_number | The model's registration number in the EU product database | Empty in both rows | Suppliers must give dealers this number, says the Commission's dealer page, citing Implementing Regulation (EU) 2024/994. |
material_composition | Fibre names with percentages, per part | Shell: 100% polyester; Lining: 100% polyamide | Regulation (EU) No 1007/2011, Article 16: visible before purchase, also online. |
country_of_origin | Two-letter country code | CN | For food, origin is a mandatory particular where Article 26 of Regulation (EU) No 1169/2011 requires it. For other goods, keep it on record. |
battery_registration_number | The producer's number in the national battery register | DE 12345678 (placeholder) | Regulation (EU) 2023/1542, Article 62(6): online platforms must obtain it from producers who offer batteries, also batteries built into devices. |
weee_registration_number | The producer's registration number for electrical equipment | DE 87654321 (placeholder) | Germany: section 6(3) of the ElektroG obliges every producer to state the number when offering and on invoices. |
The energy fields are empty for the headlamp on purpose. Delegated Regulation (EU) 2019/2015 lists light sources in battery-operated products, such as torches, among its exemptions. Which rules apply to a category is a question for the product regulation finder.
Commercial#
| Column | What goes in | Example | Who needs it |
|---|---|---|---|
price | The supplier's price to you per unit, a number with a decimal point | 21.50 | You. Your selling price is your own decision. |
currency | ISO 4217 code | EUR | Google uses the same codes in its price attribute. |
availability | in_stock, out_of_stock, preorder or backorder | in_stock | Google's supported values; other channels map from them. |
lead_time_days | Working days from your order to dispatch | 3 | Delivery promises in your shop. |
How to send it to suppliers#
Send the file with a short request that says what you need, by when, and what happens to incomplete rows. A text you can copy:
Subject: Product data for [your shop]: please use the attached template
Hello [name],
to list your products we need their data in the attached file,
one row per variant (each color and size is its own row).
Please:
- keep the column names and their order,
- enter GTINs as text, digits only,
- write every weight and dimension with its unit (85 g, 6.2 cm),
- fill the manufacturer and, if the manufacturer is outside the EU,
the EU responsible person columns for every product,
- copy safety warnings word for word from the packaging or manual,
- leave a cell empty if it does not apply, and do not write "n/a".
Images: Please confirm in your reply that we may use, crop and
resize the images you send in our shop, on marketplaces and in
advertising for as long as we sell the products.
Please return the file as CSV (UTF-8) by [date]. Rows without GTIN,
manufacturer address or main image cannot go live; we will send
them back with a note.
Thank you,
[your name]A supplier onboarding checklist for the product data part then has six lines:
- Template and request text sent, with a return date.
- A named contact for data questions on the supplier's side.
- Image rights confirmed in writing.
- GTINs come from the brand owner, not from the supplier's own numbering.
- Compliance documents received for the categories that need them.
- First file imported and checked; open questions sent back in one list.
Rules that make a returned file usable#
- One row per variant. A jacket in three sizes is three rows with the same
variant_group. - Columns stay as they are. No renamed, merged or reordered columns; new information goes into new columns at the end.
- Identifiers are text. Microsoft states that Excel removes leading zeros and converts large numbers to scientific notation; a GTIN stored that way is lost.
- Number and unit together.
410 g, not410and not0,41. - One value per cell. Several links or parts are separated by semicolons, never by line breaks.
- Plain text. No HTML, no formatting, no text in all capitals.
- Empty means "does not apply". Words such as "n/a", "none" or "tbd" are values a system will publish.
- CSV with quotes where needed. Under RFC 4180, fields that contain commas, line breaks or double quotes are enclosed in double quotes. Spreadsheet programs do this on export.
- Full file on every update. The supplier sends the whole file again, not only changed cells, with the date in the file name.
To turn a returned Excel file into CSV, or a CSV into the format your shop imports, use the product file converter near the top of this page.
Common mistakes#
Asking for everything at once. A supplier with 20 products can fill 43 columns in an afternoon. A supplier with 20,000 may not; mark the columns that block a listing and accept the rest later.
Accepting the supplier's address as the manufacturer's. A distributor is not the manufacturer. The offer must show who made the product and, where needed, the responsible person in the EU.
Taking images without a statement of rights. A file full of image links says nothing about what you may do with them.
Where Central helps#
A template gets you what the supplier knows. Central researches the product data a listing still needs from your own data, the open web and verified databases (for example EPREL and the EU Safety Gate), and backs every value with sources you can check. What the sources do not support is held back. Central then writes titles, descriptions and attributes within each channel's limits.
Questions
What should a supplier product data template contain?
At least the identifiers (SKU, GTIN, MPN, brand), the variant values (color, size), a description, dimensions and weights with units, image links with the right to use them, the manufacturer's contact details and the compliance fields of the category, and price, currency and availability.
Is this the same as a new item setup form?
It covers the same ground. Retailers call the document a new item setup form, a product information template or a product spec sheet template; all of them ask a supplier for one structured record per item. This template has one row per variant.
Do I need the manufacturer's address for every product?
For consumer products offered online in the EU, yes. Article 19 of Regulation (EU) 2023/988 requires the offer to show the manufacturer's name, registered trade name or trade mark and its postal and electronic address.
May I use the images a supplier sends with the file?
Only as far as the supplier allows. The template has a column for the image rights, and the request text asks the supplier to confirm in writing that you may use the images to sell the products.
Excel or CSV: which should suppliers return?
CSV in UTF-8 keeps the file readable by any system. If a supplier works in Excel, ask for identifier columns formatted as text, because Excel removes leading zeros and shows large numbers in scientific notation.
Sources
- Product data specificationGoogle Merchant Center Helpchecked 20 November 2026
- Regulation (EU) 2023/988 on general product safetyEUR-Lexchecked 20 November 2026
- Regulation (EU) No 1007/2011 on textile fibre names and labellingEUR-Lexchecked 20 November 2026
- Regulation (EU) 2017/1369 setting a framework for energy labellingEUR-Lexchecked 20 November 2026
- What do dealers need to know?European Commissionchecked 20 November 2026
- Delegated Regulation (EU) 2019/2015 on energy labelling of light sourcesEUR-Lexchecked 20 November 2026
- Regulation (EU) 2023/1542 concerning batteries and waste batteriesEUR-Lexchecked 20 November 2026
- Elektro- und Elektronikgerätegesetz (ElektroG)Gesetze im Internetchecked 20 November 2026
- Regulation (EU) No 1169/2011 on food information to consumersEUR-Lexchecked 20 November 2026
- RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) FilesRFC Editorchecked 20 November 2026
- Keeping leading zeros and large numbersMicrosoft Supportchecked 20 November 2026