How do I fix "Missing required column"?

Add the missing required column header (even if values are blank).

ShopifystructureImport blockerAuto-fixable

Missing required column

Your CSV is missing a required Shopify column header.

What is this issue?

Your CSV is missing a required Shopify column header.

Affected field:the header row

Import blocker: your file will fail to import until this is resolved.

Why Shopify rejects this

Shopify validates column headers during import. Missing required headers can prevent Shopify from creating or updating products.

Valid values / expected format

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

Examples

Bad value	Good value	Note
`Column absent from row 1`	`Column added to header row (can have blank values)`	Header must exist even if data is blank

Fix in StriveFormats

Auto-fix adds all missing required column headers in one click. The added columns will be blank -- add your data into them.

Auto-fixable: this issue is corrected automatically when you click Fix Issues.

Open CSV Fixer View template Shopify Fixer guide Shopify ecommerce guide

Fix in Excel

1Download the official Shopify template from the Templates section of StriveFormats.
2Open both your CSV and the downloaded template in Excel.
3Look at row 1 in both files -- this is the header row.
4Identify column names that appear in the template but are missing from your file.
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).
6Leave the new column's cells blank if you have no data -- the column just needs to exist.
7Repeat for each missing column, then save as CSV (Comma delimited).

Fix in Google Sheets

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

Prevent it next time

--Always start from the official platform template, never a blank spreadsheet.
--After building your file, compare your header row to the template side-by-side before exporting.
--Keep a saved copy of the correct header row as a reference for future files.
--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 Shopify format. Any column name from the required list that is absent triggers this issue.

►Technical detail

Shopify's importer parses the first row of the CSV as the header row before processing any data. If a required column name is absent from that row, the importer has no column to write data into -- it cannot infer missing columns from content. Column names are matched exactly (case-sensitive on most platforms), so "variant price" will not satisfy a requirement for "Variant Price".