StriveFormats
eBayvariantImport blocker

Variation specifics mismatch

VariationSpecificsName and VariationSpecificsValue must both be provided or both be empty.

What is this issue?

VariationSpecificsName and VariationSpecificsValue must both be provided or both be empty.

Affected field:Variation specifics mismatch
Import blocker: your file will fail to import until this is resolved.

Why eBay rejects this

eBay requires matched name/value pairs to build variation attributes. A mismatch prevents the variation from being created.

Examples

Bad valueGood valueNote
Option2 filled but Option1 blankOption1 filled first, then Option2
Variant row appears before its parent rowParent row appears directly above variant rows

Fix in StriveFormats

StriveFormats detects variant structure issues and highlights the rows that are misaligned or missing required option values.

Open CSV FixerView templateeBay Fixer guideeBay ecommerce guide

Fix in Excel

  1. 1In Excel, sort your rows by the parent identifier column (Handle for Shopify, parent SKU for WooCommerce).
  2. 2Verify the parent row appears before all its variant rows in the sorted result.
  3. 3For WooCommerce: parent rows should have Type = 'variable'. Variation rows should have Type = 'variation' and the Parent column set to the parent's SKU.
  4. 4For Shopify: all rows in a product group must share the same Handle. Check that Option1 Name is filled before Option2 Name.
  5. 5Save as CSV (Comma delimited).

Fix in Google Sheets

  1. 1In Google Sheets, go to Data > Sort range and sort by the parent identifier column (Handle or Parent SKU).
  2. 2Verify parent rows appear directly before their variant rows.
  3. 3For WooCommerce: parent rows need Type = 'variable'. Variation rows need Type = 'variation' and Parent = the parent SKU.
  4. 4For Shopify: all variant rows in a product group must share the same Handle.
  5. 5Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

  • --Always keep parent product rows directly above all their variant rows.
  • --For Shopify: use the same Handle value for all rows in one product group.
  • --For WooCommerce: parent rows have Type = variable; child rows have Type = variation with Parent = parent SKU.
  • --Test with a single product (one parent, two to three variants) before importing your full catalog.

How StriveFormats detects this

StriveFormats groups rows by their parent identifier (Handle for eBay) and checks that the structure matches the platform's variant model. Orphaned variation rows, missing parent rows, and duplicate option combinations are each flagged separately.

►Technical detail
eBay requires parent product rows to appear before their child/variation rows, with a specific column value linking child rows to their parent. Rows that reference a parent that does not exist in the file will be treated as orphans and either skipped or imported incorrectly.