Upload Products via CSV
Preparation for CSV Product Listing
Confirm Whether Category Qualifications Are Required for Products to Be Uploaded
- If you have a small number of categories, you can check whether the corresponding category requires category qualification through Add new product > Selecting the category. Click to submit the relevant qualification application. If the category of your product does not require qualifications, please skip to Section Entry of this document.
- If you have a large number of product categories, please check How do I apply for Category Qualification? to view all categories requiring application and apply for them one by one. If the category of your product does not require qualifications, please skip to Section 2.1 of this document.
- How to Check the Status of Category Qualification Applications:
Tips:
- Category qualification review takes 2-5 days.
- For detailed qualification requirements of each category, please refer to: Restricted Products
If the Product to Be Uploaded Is a Branded Product
Please first confirm whether the brand requires you to submit a brand authorization. For a step-by-step guide, please refer to: Branded Products - Brand Qualification Application GuidePrepare Product Images to Be Uploaded
You can obtain the image URL in two ways:- [Recommended] For online images:
- Right-click on the image
- Select Copy image address/URL/location in your browser
- Paste the URL where needed such as the Image fields in template
- For images stored on your computer:
To learn more, please visit our guide on the Product Media Center. Using Product Media Center to upload images faster
Steps for CSV Product Listing
Entry
Products > Manage Products > Bulk action > Bulk listing.
Usage Process
Download the CSV Template
Download the CSV TemplateIf you cannot access the download page, click "Step 1, Download Template" to redownload the new CSV template.
As the GIF below shows: Select category > Select brand > Click Download.
- Selecting a category:
- Method 1 - Search for the category name by entering relevant keywords to find the closest match.
- Method 2 - View all categories and select from the list.
- Please note that you need to choose the corresponding category in the template. Additionally, the template you download will not include categories for which you have not obtained qualifications. If you need to list products in such categories, please apply for qualification first. (For a detailed guide, please refer to Section 1.1).
- Selecting a brand:
- Method 1 - Search/select from the existing brand list and add it.
- Method 2 - Add a new brand.
If a brand name is grayed out and unselectable, it means you have not obtained the right to sell products of this brand. You need to submit brand authorization and pass the review in advance. For brand authorization submission guidelines, please refer to Branded Products - Brand Authorisation Application GuideIf the case (uppercase/lowercase) of the new brand name changes after input, it is because the brand already exists in TikTok Shop's brand library, and TikTok Shop automatically corrects the case. If the "automatically corrected brand name" does not meet the brand's expression requirements, please submit a Ticket here.
- TIP: Please note that your template is strongly associated with the selected categories and brands and will change as your warehouses increase. If there are new adjustments, be sure to redownload the template.
- Download location: After clicking Download, please find the xlsx file starting with "Tiktoksellercenter_batchupload" in your browser's download directory.
Enter and Save Information in the CSV Template
Please note: Each row in the CSV represents one SKU. If you need a product link to include multiple Variation SKUs, see the multi-SKU section below.It is recommended to try uploading a small number of products first, then upload in batches. For batch uploads, it is recommended not to exceed 1,000 rows per batch.To improve efficiency, pay attention to the following information before filling in the CSV:
- In the CSV template, rows 1-6 contain key template information. Please read the content of rows 3-6 carefully before filling in and do not delete them. The content of each row is as follows:
- Rows 1-2 are hidden rows recording key template information. Modifying or deleting them may cause errors.
- Row 3: Field names
- Row 4: Describes whether the field is "Required," "Optional," or "Required under certain conditions." If a field in row 4 displays a red border during filling, it is a required field.
- Row 5: Descriptions of each field
- Row 6: Examples for each field
Tips:
- Do not merge any cells.
- Do not worry about cell borders, text formatting, or full-width/half-width characters.
- Hyperlinks do not need to be processed.
Single SKU and Multi-SKU Product Instructions
Single SKU Products- For a single SKU product, all filled fields represent the product, and information about "variation" does not need to be filled in.
- For products with multiple SKUs, we support "Primary variation" and "Secondary variation," and their combinations result in different multi-SKUs. For details, see the descriptions below.
Example: A dress is available in colors [White], [Black] and sizes [S], [M], [L]. These two variations need to be entered in the CSV template according to SKUs, as shown below.
- Ensure that product names are completely consistent; otherwise, they will be identified as different products.
- Do not use "/" in the "Primary variation" column, as it will cause reading errors.
- Note that images for different SKUs only support the "Primary variation" dimension. Please insert them in the "Primary variation image 1" column.
Variation 1 column is mandatory
Column Variation 1 is mandatory for multiple product variations. You must enter the names of different variants in a new row (e.g. if your variation is color, list your colors "white", "black", "grey", etc.).Column Variation 2 is only required if you need two tiers of variations, such as colors and sizes. In this instance, your Variation 1 column will be regarded as color and the Variation 2 column as size by default
The same product's variation values must be different.
Each SKU has its own row
For example, if the product comes in 3 different colors, there will be 3 SKUs, with each SKU in a separate row. If the product comes in 3 different colors and 2 different sizes, there will be a total of 6 SKUs (3 colours multiplied by 2 sizes), with each SKU in a separate row.Product information should be kept the same
Make sure the product information is the same, with the exception of variant information, retail price, quantity, and seller SKU. If product information differs, TikTok Shop cannot consider those items as different variants of the same product.
Upload the CSV Template
Go to Products > Product Management > Bulk Listing > Step 2 > Upload spreadsheet.
Once uploaded, confirm the read status
- Successful status: The number of successfully uploaded products and SKUs will be displayed below. Click "Import n error-free products" to complete the bulk listing.
- Error status: If any of your uploaded 1 or more SKUs have errors to be read, the online editor for those errors will automatically pop up.
Symbol | Meaning | Required Action |
 | Whether to show SKUs that are successfully uploaded. | This page shows columns with errors only by default.If you would like to check all the uploaded SKUs, you may click this button to turn off this default mode. |
 | Errors detected in this row need correction. | Hover the mouse over the symbol for a brief description of what needs adjustment. |
 | Content format is correct, ready to be imported. | No action is needed, and this row can be imported directly. |
In the online editor, make corrections for each error of your products. Once all errors for a product (or SKU) are correct, the red 'X' on the left will become a green checkmark. You can click 'Import' once this interface has at least 1 green checkmark.
Note: You must correct all the errors associated with at least one product before you can begin importing.
View Successfully Imported Products
- After uploading successfully, you can find the newly listed products in Products > Product Management.
- In Product Management, you can check the status of each product.
FAQs
Upload images
Q: What is the sorting order of URLs when copying images from the Media Center?
A: The order follows the sequence in which images were clicked and selected, as shown below.
Q: How to quickly paste multiple images into the CSV?
A: After copying, paste by clicking (not double-clicking) the cell.
Online editor- How to check the cause of the error message
Error Reasons
Q: Why can't I see specific error reasons in the online editor?Note: Any product or SKU that contains at least one error will be shown in online editor. The errors are highlighted in red boxes and contain brief instructions below the box on how the error can be corrected. Additionally, hovering over the red 'X' on the left side will provide you with a summary of all the errors associated with each product. Click [Show columns with errors only] to view other error-free SKUs.
How to Re-enter the Online Editor?
Tip：After uploading, re-enter the upload step to view the previous file's feedback. Click [Correct Now] to enter the online editor for error viewing and modification; click [Download Fail Reasons] to export error reasons.To view more upload records, click [View Import History] in the top right corner.
Template Download/Errors
- Refer to the detailed instructions in To improve efficiency, pay attention to the following information before filling in the CSV.
- TIP: The template is strongly associated with your selected categories and brands and will change as warehouses are added. Re-download the template for any new adjustments.
- Start filling from row 7; do not delete rows 1-6.
- Do not merge any cells.
- Do not use "/" in the "Primary variation" column, as it causes reading errors.
- Categories and brands must be selected from the table's drop-down lists (copy-pasting is allowed but must be within the list range).
No Permission to Select Categories in the List
If you lack category permissions, obtain category qualifications before uploading products. Incorrect category selection will result in review rejection.Upload Quantity Limit
- Test with a small number of products first, then upload in batches. Batch uploads are recommended to not exceed 1,000 rows per batch.
Why Did My Multi-SKU Upload Become Multiple Products?
- Ensure product names are completely consistent; otherwise, they will be identified as different products.
- Do not use "/" in the "Primary variation" column, as it causes errors.
- Note that images for different SKUs only support the "Primary variation" dimension; enter them in the "Primary variation image 1" column.