Clothing without color, size, gender or age group
The product is in a clothing or shoes category, but color, size, gender or age_group is blank.
What is this issue?
The product is in a clothing or shoes category, but color, size, gender or age_group is blank.
color / size / gender / age_groupWhat it looks like in your file
| id | color | gender | age_group | |
|---|---|---|---|---|
| 2 | TEE-M | (empty) | (empty) | (empty) |
| id | color | gender | age_group | |
|---|---|---|---|---|
| 2 | TEE-M | Blue | unisex | adult |
Upload your CSV to check for this issue and export a clean file.
Fix nowWhy Google Merchant Center rejects this
Google requires these four attributes for clothing in many countries, including the US, UK, Germany, France, Japan and Brazil. Without them, products can be limited or disapproved.
Fix in StriveFormats
StriveFormats detects variant structure issues and highlights the rows that are misaligned or missing required option values.
Fix in Excel
- 1In Excel, sort your rows by the parent identifier column (Handle for Shopify, parent SKU for WooCommerce).
- 2Verify the parent row appears before all its variant rows in the sorted result.
- 3For WooCommerce: parent rows should have Type = 'variable'. Variation rows should have Type = 'variation' and the Parent column set to the parent's SKU.
- 4For Shopify: all rows in a product group must share the same Handle. Check that Option1 Name is filled before Option2 Name.
- 5Save as Text (Tab delimited) (*.txt).
Fix in Google Sheets
- 1In Google Sheets, go to Data > Sort range and sort by the parent identifier column (Handle or Parent SKU).
- 2Verify parent rows appear directly before their variant rows.
- 3For WooCommerce: parent rows need Type = 'variable'. Variation rows need Type = 'variation' and Parent = the parent SKU.
- 4For Shopify: all variant rows in a product group must share the same Handle.
- 5Go to File > Download > Tab Separated Values (.tsv), then rename the file to end in .txt.
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 Google Merchant Center) 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.