How to Bulk Upload Products to TikTok Shop
TikTok Shop bulk upload lets you add many products at once from a CSV file. This guide covers preparing the template, fixing common errors, and saving time in Seller Center.
I have run TikTok Shops every day since April 2023, and I use TikTok Shop bulk upload whenever I add more than a few products. Bulk upload adds many products from one CSV file instead of one at a time. You download a template in Seller Center, fill it in, upload it, and fix any rows that fail.
How do I bulk upload products on TikTok Shop?
The process is download the template, fill it, upload it, and fix errors. Here are the steps I follow.
- Open Seller Center and go to the Products area. Look for Bulk upload, or Add products and then Bulk upload. If the menu has moved, search in Seller Center or check TikTok Shop Seller University.
- Download the product template. TikTok Shop has one for your region, so pick the right file.
- Open the file in a spreadsheet program like Google Sheets or Excel. Do not change the header row.
- Fill one row per product. Use the same product name, category, price, stock, and image links you would use in the single product form.
- Save the file as CSV (UTF-8) so it uploads cleanly.
- Back in Seller Center, upload the file. The system checks each row and shows a report of failed rows.
- Fix the rows the report points to. You can usually edit them and upload again.
- Wait for review. Bulk uploaded products still go through TikTok Shop's product review before they appear live.
Each step is straightforward, but the template is the part sellers skip. If you download the wrong template, every row will fail. I always download a fresh template from Seller Center instead of reusing an old file, because TikTok Shop updates it.
How do I prepare a CSV for TikTok Shop bulk upload?
The CSV template already has the correct column headers, so you only need to fill the rows. Here are the columns I pay most attention to.
| Column | What to enter | Common mistake |
|---|---|---|
| Product name | Brand, product, key feature, size or count | Leaving out the size or count |
| Category | The leaf category that fits the product | Choosing a broad category |
| Price | The price buyers pay | Copying a price from another marketplace without checking TikTok Shop fees |
| Stock | Units ready to ship | Entering more stock than you have |
| Images | Publicly accessible image URLs | Broken or private links |
| Description and details | Clear facts, no claims that need proof | Unsupported claims like best or cure |
| SKU or product ID | Your internal code for the product, if the template asks for it | Leaving it blank when required |
| Variant info | Sizes, colors, or other options | Forgetting to list every variant |
| Shipping weight and dimensions | Packed box weight and size, not product size | Using product size instead of packed size |
I keep a master spreadsheet with one tab per category and reuse it. Before upload, I run my titles through the free AI product title and description writer so they have the words shoppers search for. For image links, I use a public image host or my own storage. The link must end in a common image format like .jpg or .png and open without a login.
Save the file as CSV UTF-8. Some spreadsheet programs save with a hidden BOM or change commas to semicolons depending on your region. If uploads keep failing, open the file in a plain text editor and check that the first row exactly matches the template.
Why did my TikTok Shop bulk upload fail?
Most failures come from a wrong category, a missing required field, or a claim that TikTok Shop does not allow. These are the errors I see most often.
- Wrong or missing category: pick the leaf category from the dropdown in the template.
- Product name too long or missing key info: follow the same naming pattern you use for single products.
- Image URLs are broken or private: use publicly accessible links and test one first.
- Price or stock left blank: each row needs both, even if you plan to change them later.
- Unsupported claims in the name or description: words like best, cure, or guaranteed often get flagged; keep the copy factual.
- Invalid characters or encoding: save the CSV as UTF-8 and avoid extra commas inside cells.
My honest take is that most bulk upload failures are not the CSV format, they are the same listing mistakes you would make one by one. Fix the template first, then upload, and you save a full day of clicking.
How do I fix failed rows after upload?
The report after upload lists each failed row with a reason. I fix only the failed rows, not the whole file, and upload again.
- Download the fail report or open the online editor if TikTok Shop offers one.
- For each row, change only the column the report points to.
- If the reason is unclear, search Seller University for the exact error text.
- Upload the corrected file. Repeat until all rows pass.
- Do not resubmit rows that already passed, or you may create duplicates.
When should I use bulk upload instead of adding products one by one?
Use bulk upload when you have more than about five products ready to list, or when you are moving a catalog from another marketplace. If you have one or two products, the single product form is simpler and shows you all required fields. If you need to change many existing products, that is bulk edit, not bulk upload. If you upload products every week, you can later automate parts of this. I wrote a guide on what to automate in a TikTok Shop first that covers listings.
What should I check before I upload?
This is the checklist I run before every bulk upload.
- My CSV has the exact header row from TikTok Shop's template.
- Each row has a unique SKU or product ID if the template asks for one.
- Prices and stock match what I can actually fulfill.
- Image links open to the right product photo.
- Categories are leaf-level, not broad.
- I read the current rules on TikTok Shop Seller University.
After the upload succeeds, I wait for product review. I check the next day in Manage products under Reviewing. If a product fails review, I fix the same things I would fix on a single product. Bulk upload does not change TikTok Shop's rules.
If you have a question about your own bulk upload, ask it in the chat on this site. It is free. Tell me your situation, what your shop sells, and what you already tried, and I will point you to the step that matters.
Frequently asked questions
- What is TikTok Shop bulk upload?
- TikTok Shop bulk upload is a Seller Center tool that lets you add many products from one CSV file instead of one at a time. You download a template, fill one row per product, and upload the file back to TikTok Shop.
- How do I download the TikTok Shop bulk upload template?
- Open Seller Center, go to the Products area, and choose Bulk upload or Add products then Bulk upload. The page has a button to download the current template for your region.
- Why does my TikTok Shop bulk upload keep failing?
- Most failures come from a wrong category, missing required fields, broken image links, or claims that TikTok Shop does not allow. Download the fail report, fix only those rows, and upload again.
- Can I bulk upload products with variations?
- Yes, if the template supports variants. Each variant, like a size or color, goes in its own row or follows the template's grouped format. Check the template notes in Seller Center.
- Is bulk upload faster than adding products one by one?
- Yes for more than a few products. Bulk upload saves time because you work in a spreadsheet, not separate product forms. For one or two products, the single product form is simpler.