StriveFormats
CSV Fixer
Google Merchant CenterStructureImport blocker

Missing required column

One of the attributes Google requires for every product has no column: id, title, description, link, image_link, availability or price.

What is this issue?

One of the attributes Google requires for every product has no column: id, title, description, link, image_link, availability or price.

Affected field:the header row
Import blocker: your file will fail to import until this is resolved.

What it looks like in your file

In your file
id
2MUG-01
After the fix
idavailability
2MUG-01in_stock

Upload your CSV to check for this issue and export a clean file.

Fix now

Why Google Merchant Center rejects this

Merchant Center can't show a product without these attributes, so every product in the file is disapproved.

Google Merchant Center-specific note

Merchant Center reads Google's attribute names, such as image_link, in English whatever language the feed is in. Names are not case-sensitive, and a g: prefix is ignored, but the spelling and underscores must match.

Valid values / expected format

  1. ✓All required column headers must appear in row 1 of the file
  2. ✓Column names are case-sensitive on most platforms
  3. ✓Missing columns must be added even if their values are blank
  4. ✓Use the official platform template as your starting point

Fix in StriveFormats

Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.

Open CSV FixerView templateGoogle Merchant Center Fixer guide

Fix in Excel

  1. 1Download the official Google Merchant Center template from the Templates section of StriveFormats.
  2. 2Open both your CSV and the downloaded template in Excel.
  3. 3Look at row 1 in both files. This is the header row.
  4. 4Identify column names that appear in the template but are missing from your file.
  5. 5In your CSV, click the header of an empty column and type the missing column name exactly as it appears in the template (case-sensitive).
  6. 6Leave the new column's cells blank if you have no data. The column just needs to exist.
  7. 7Repeat for each missing column, then save as Text (Tab delimited) (*.txt).

Fix in Google Sheets

  1. 1Download the official Google Merchant Center template from the Templates section of StriveFormats.
  2. 2Open both files in Google Sheets (drag and drop onto drive.google.com, or File > Import in an existing sheet).
  3. 3Compare row 1 in both files. Note any column names present in the template but absent in your file.
  4. 4Add the missing column names to row 1 of your file, exactly as they appear in the template (case-sensitive).
  5. 5Leave the new column's cells blank if you have no data. Only the header has to exist.
  6. 6Go to File > Download > Tab Separated Values (.tsv), then rename the file to end in .txt.

Prevent it next time

  1. ✓Always start from the official platform template, never a blank spreadsheet.
  2. ✓After building your file, compare your header row to the template side-by-side before exporting.
  3. ✓Keep a saved copy of the correct header row as a reference for future files.
  4. ✓Run every new file through StriveFormats to verify headers match the platform's requirements.

How StriveFormats detects this

StriveFormats compares your file's header row (row 1) against the full set of required columns for the Google Merchant Center format. Any column name from the required list that is absent triggers this issue.

►Technical detail
Google Merchant Center's importer reads the first row of the CSV as the header row before processing any data. If a required column name is missing from that row, the importer has nowhere to put that data, and it can't guess missing columns from the content. Column names are matched exactly (case-sensitive on most platforms), so "variant price" won't count as "Variant Price".