StriveFormats
CSV Fixer
ShopifyListing rules

Gift card in CSV

A row is marked as a gift card.

What is this issue?

A row is marked as a gift card.

Affected field:Gift card in CSV

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

Fix now

Why Shopify rejects this

Shopify cannot create gift card products from a CSV import.

Fix in StriveFormats

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

Open CSV FixerView templateShopify Fixer guide

Fix in Excel

  1. 1Review the Gift card in CSV column for incorrect values.
  2. 2Fix any cells that do not match the expected format.
  3. 3Save as CSV (Comma delimited).

Fix in Google Sheets

  1. 1Review the Gift card in CSV column for incorrect values.
  2. 2Correct any cells that do not match the expected format.
  3. 3Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

  1. ✓Start from the official platform template to avoid structural issues.
  2. ✓Run your file through StriveFormats before every import.
  3. ✓Test with a small sample file first to catch errors before they affect your full catalog.

How StriveFormats detects this

StriveFormats parses every row of your CSV and applies Shopify-specific validation rules to the Gift card in CSV field. Any row that violates the rule is flagged with the row number and the specific value that caused the issue.

►Technical detail
Shopify's importer validates the Gift card in CSV field against its official import specification. Values that do not meet the expected format are flagged to prevent silent data corruption -- an invalid value that slips through import might appear as a blank field, a zero, or incorrect text in your storefront without any error message after the fact.