StriveFormats
CSV Fixer
CSV Templates / TikTok

TikTok Catalog

Check a TikTok catalog feed before you upload it in TikTok Ads Manager: the nine required fields, sku_id, availability, prices, brand and image links.

Open with preset →Download sample CSV

What this preset checks

15 checks run on every file. Each links to a guide with examples and fixes.

Blocks the import (8)
  • Missing required column

    One of the nine fields TikTok requires for every product has no column: sku_id, title, description, availability, condition, price, link, image_link or brand.

  • Required field is blank

    A required field (sku_id, title, description, availability, condition, price, link, image_link or brand) is empty on this row.

  • Duplicate sku_id

    Two or more rows use the same sku_id.

  • Invalid link or image URL

    link, image_link or additional_image_link isn't a full web address starting with http:// or https://.

  • Image TikTok can't use

    The image is on a host TikTok can't read (Google Drive, Dropbox, Flickr, Pinterest, 500px, imgbb or SmugMug), or isn't a JPG or PNG file.

  • Invalid availability valueAuto-fix

    availability must be in stock, available for order, preorder, out of stock or discontinued.

  • Invalid priceAuto-fix

    price isn't a number with a currency code, or it is 0.

  • Invalid condition valueAuto-fix

    condition must be new, refurbished or used.

Fixed automatically (3)
  • Invalid sale price

    sale_price isn't a valid price, or isn't lower than price.

  • Invalid GTIN

    The gtin isn't 8, 12, 13 or 14 digits with a correct check digit, or a spreadsheet turned it into scientific notation.

  • Invalid gender value

    gender must be female, male or unisex.

Flagged for review (4)

Expected columns

sku_id
title
description
availability
condition
price
link
image_link
brand
additional_image_link
video_link
sale_price
sale_price_effective_date
item_group_id
google_product_category
product_type
color
size
gender
age_group
material
pattern
gtin
mpn
shipping_weight

Example row

sku_idtitledescriptionavailabilityconditionpricelinkimage_linkbrandadditional_image_linkvideo_linksale_price
TSHIRT-ORGANIC-BLUE-MOrganic Cotton T-Shirt, Blue, MediumSoft organic cotton t-shirt with a relaxed fit.in stocknew24.99 USDhttps://example.com/products/organic-cotton-tshirt?variant=blue-mhttps://example.com/images/tshirt-blue.jpgAcme Apparel

Showing 12 columns for readability. Download the sample CSV for the full header set.

About this format

TikTok catalogs power Video Shopping Ads and catalog ads. You fill one from a product file in TikTok Ads Manager: one product per row, with TikTok's field names in the header row. This preset checks each product against TikTok's catalog product parameters and keeps your column names as they are.

It catches what stops products from uploading: missing required fields, a feed that names its identifier id instead of sku_id, availability values TikTok doesn't take, products with no brand, duplicate sku_ids, and images on hosts TikTok can't read.

How it works

  1. 1
    Upload your catalog file (CSV, or a tab-delimited .txt or .tsv).
  2. 2
    Each product is checked for sku_id, title, description, availability, condition, price, link, image_link and brand.
  3. 3
    A Google- or Meta-style id column is renamed to sku_id, and values like in_stock, pre_order, "19,99 EUR" and "New" are converted to TikTok's format.
  4. 4
    Images on Google Drive, Dropbox and other hosts TikTok can't read are flagged, as are emoji and offers in titles.
  5. 5
    Download a CSV with your original columns, ready to upload in TikTok Ads Manager.

Examples of fixes

  • Rename an id column to sku_id
  • Convert availability to in stock, available for order, preorder, out of stock or discontinued
  • Write prices as 9.99 USD, with a period and a currency code
  • Convert condition to new, refurbished or used
  • Flag products with no brand
  • Flag images TikTok can't load

FAQ

Can I upload my Google or Meta feed to TikTok?
Mostly, because most field names are the same. The differences: TikTok names the identifier sku_id instead of id, and brand is required for every product. This preset renames the id column and flags products without a brand.
Which fields are required?
sku_id, title, description, availability, condition, price, link, image_link and brand, for every product.
Do prices need a currency code?
TikTok uses the currency of the catalog's country when the code is left out, but adding it, like 9.99 USD, avoids prices being read in the wrong currency.
Why are my images rejected?
TikTok needs a public link to a JPG or PNG file. Share links from Google Drive, Dropbox, Flickr or Pinterest don't work. Square images should be at least 500 × 500 pixels.

Popular CSV Guides

Step-by-step guides for the most common CSV import problems.

General
Append vs Merge vs Join: Combining CSV Files the Right Way

Understand the difference between appending rows, merging files with the same structure, and joining files with related data. Choose the right approach for your ecommerce catalog workflow.

General
CSV Basics for Ecommerce Imports

Understand headers, UTF-8 encoding, quoting, line endings, and the most common mistakes that break ecommerce CSV imports, before your first upload.

General
Fix CSV Column Mismatch Errors

How to diagnose and fix column mismatch errors in CSV imports: wrong column names, case differences, extra spaces, and column order problems across ecommerce platforms.

General
CSV Formatting Rules for Ecommerce Imports

The exact formatting rules your CSV must follow to pass ecommerce platform imports: delimiters, quoting, line endings, encoding, and header requirements.

General
CSV Import Checklist for Ecommerce Platforms

A complete pre-import checklist for Shopify, WooCommerce, Etsy, eBay, and Amazon CSV files: encoding, headers, data types, and platform-specific rules.

General
CSV Import Errors Explained

A plain-English breakdown of the most common CSV import error messages across Shopify, WooCommerce, Etsy, eBay, and Amazon, and how to fix each one.

Browse all CSV guides →