Required field is blank
A required field (sku_id, title, description, availability, condition, price, link, image_link or brand) is empty on this row.
What is this issue?
A required field (sku_id, title, description, availability, condition, price, link, image_link or brand) is empty on this row.
sku_id / title / brandWhat it looks like in your file
| sku_id | brand | |
|---|---|---|
| 2 | MUG-01 | (empty) |
| sku_id | brand | |
|---|---|---|
| 2 | MUG-01 | Acme |
Upload your CSV to check for this issue and export a clean file.
Fix nowWhy TikTok rejects this
TikTok can't upload a product with a required field missing.
TikTok-specific note
TikTok requires brand on every product, unlike Google and Meta, which accept a GTIN or MPN instead. For products you make yourself, use your store's name.
Common causes
- 1Products you make yourself have no brand in the store, so the brand column is empty for them.
- 2New products were added after the feed was set up and some fields were never filled in.
- 3A spreadsheet formula that builds a column returned an empty cell for some rows.
Fix in StriveFormats
StriveFormats flags every row where this required field is blank, so you can find and fill them quickly.
Fix in Excel
- 1In Excel, click the header letter of the sku_id / title / brand column to select it.
- 2Press Ctrl+G (Go To), then choose Special → Blanks → OK. Excel selects all empty cells in that column.
- 3Type the required value and press Ctrl+Enter to fill all selected blank cells at once.
- 4If different rows need different values: use Data > Filter on the column, filter for '(Blanks)', and fill each row manually.
- 5Save as CSV UTF-8 (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, click the header of the sku_id / title / brand column.
- 2Go to Data > Create a filter.
- 3Click the filter icon on the column header, clear all checkboxes, then check '(Blanks)'. This shows only empty rows.
- 4Fill in the required value for each blank cell shown.
- 5Remove the filter: Data > Remove filter.
- 6Go to File > Download > Comma Separated Values (.csv).
Prevent it next time
- ✓Start from the official platform template so you know which fields are required from the start.
- ✓Before exporting, run a quick filter on each required column and check for blanks.
- ✓Test with a small 5-row sample CSV before uploading your full catalog.
- ✓If a field is only required for certain product types, still include the column and leave the other rows blank.
How StriveFormats detects this
StriveFormats scans every row for blank or whitespace-only cells in the sku_id / title / brand column. Rows where this field is empty are flagged because TikTok requires a value on every row.