Invalid age group value
age_group must be newborn, infant, toddler, kids or adult.
What is this issue?
age_group must be newborn, infant, toddler, kids or adult.
age_groupWhat it looks like in your file
| sku_id | age_group | |
|---|---|---|
| 2 | MUG-01 | Teens |
| 3 | TOTE-01 | children |
| sku_id | age_group | |
|---|---|---|
| 2 | MUG-01 | adult |
| 3 | TOTE-01 | kids |
Upload your CSV to check for this issue and export a clean file.
Fix nowWhy TikTok rejects this
TikTok uses the age group for audience targeting. It has no teen or all ages group.
TikTok-specific note
TikTok's age groups are newborn (0-3 months), infant (3-12 months), toddler (1-5 years), kids (5-13 years) and adult (13 or older). There's no teen or all ages group: use adult for teens, and leave age_group blank for products meant for everyone.
Valid values / expected format
- ✓newborn
- ✓infant
- ✓toddler
- ✓kids
- ✓adult
Fix in StriveFormats
Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.
Fix in Excel
- 1In Excel, click the column letter for the age_group column.
- 2Press Ctrl+H. Type the invalid value in 'Find what' and the correct value in 'Replace with', then click Replace All.
- 3The accepted values are: newborn, infant, toddler, kids.
- 4To prevent future errors, add a dropdown: select the column, go to Data > Data Validation, choose 'List', and enter the valid options separated by commas.
- 5Save as CSV UTF-8 (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, select the age_group column.
- 2Press Ctrl+H, find the invalid value and replace it with the correct one, then click Replace All.
- 3Accepted values: newborn, infant, toddler, kids.
- 4To add a validation dropdown: select the column, go to Data > Data Validation, choose 'Dropdown (from a list)', and enter the valid options.
- 5Go to File > Download > Comma Separated Values (.csv).
Prevent it next time
- ✓Copy-paste allowed values directly from the official template to avoid typos.
- ✓Use Excel Data Validation or Google Sheets Data Validation to restrict the column to a dropdown of allowed values.
- ✓Check the platform's official documentation for the current list of allowed values, as they can change.
How StriveFormats detects this
StriveFormats checks the age_group column against the exact list of accepted values for TikTok. The comparison is case-sensitive, so any difference in capitalization or spelling is flagged as an invalid value.