Skip to main content

Add TikTok Shop exports

Send your product and order data to TikTok Shop and import order data from TikTok into Productsup.

Introduction

TikTok Shop provides a new, native checkout experience for TikTok users and lets them shop, order, and pay without leaving the TikTok app. This leads to a smoother shopping experience, higher conversion rates, and more transparent ad performance, which yields a higher return on ad spend. Additional incentives for selling products on TikTok Shop are:

  • TikTok has been the most downloaded app for the past two years, and its core user base is Generation Z, the most converting audience.

  • TikTok offers low commission fees compared with other large social commerce players.

Note

TikTok Shop is currently available in Indonesia, Malaysia, the Philippines, Singapore, Thailand, the United Kingdom, and Vietnam. It is in beta testing in the US.

Currently, Productsup can support you in selling your products on TikTok Shop only in the UK and the US.

To let you sell your products on TikTok Shop, Productsup has built an ecosystem that sends product and order data to TikTok Shop and imports order data from TikTok Shop into Productsup:

  1. TikTok Shop Product Export API Main (US)

    This export creates, updates, and deletes products on TikTok Shop via API for the US market and contains the attributes relevant to products of all categories. When setting up this export, you also use multiple category-specific exports that contain category-specific attributes to let you send products of relevant categories to TikTok Shop. This main product export is a delta-based export that sends only the new, changed, or deleted products to TikTok Shop instead of exporting the entire product catalog during every site run.

  2. TikTok Shop Product Export API Main (UK)

    This export creates, updates, and deletes products on TikTok Shop via API for the UK market and contains the attributes relevant to products of all categories. When setting up this export, you also use multiple category-specific exports that contain category-specific attributes to let you send products of relevant categories to TikTok Shop. This main product export is a delta-based export that sends only the new, changed, or deleted products to TikTok Shop instead of exporting the entire product catalog during every site run.

  3. TikTok Shop Order Import

    This API-based data source imports orders from TikTok Shop into Productsup to let you send the order data to your order management system.

  4. TikTok Shop - Shipment Notifications

    This export sends shipping updates to TikTok Shop via API to let you send tracking information to TikTok and inform customers on TikTok that you shipped their orders. This is a delta-based export that sends only new shipment data to TikTok Shop instead of sending the entire catalog during every site run.

Prerequisites

To set up the TikTok Shop ecosystem in Productsup, you need:

  1. Product variants in your product data.

    Your product data should support product variants, which means multiple rows in your data source can represent one main product with slight variations in such data as size, color, model, etc.

    All products in your feed must have product_id and parent_id. The product_id attribute uniquely identifies product variants, and the parent_id attribute links all product variants to their main product.

    If a product doesn't have variants, it still must have the parent_id attribute. It can just have the same value as the product_id attribute.

    See Mind product variants and their attributes for more information.

    Caution

    If your product data doesn't support product variants and doesn't have the needed main product and variant IDs, you need to optimize your data in Productsup to make sure it meets the TikTok Shop requirements.

  2. A project in your Productsup organization where you are going to create three (3) sites pushing and pulling data from TikTok Shop. In this separate project, you need to create a separate site for each TikTok Shop export and data source.

    Note

    This is a recommended option. If a separate TikTok Shop project doesn't fit your overall organization structure, you can ignore this advice.

  3. A TikTok seller account and a shop set up on TikTok Shop. See Set Up TikTok Shop Using TikTok Seller Center for more information.

  4. A list of all TikTok categories you want to sell products in.

    Note

    This integration has category-specific channels. Productsup supports only some categories by default. But we can add missing categories on request. It may take around two weeks to add support for your request. To request the necessary categories or countries for this integration, contact your Customer Success Manager or support@productsup.com and provide the following information:

    • List of categories. See Product Categorisation for more information on choosing the right TikTok Shop product categories.

    • List of countries. Now, we only support UK and US.

  5. An approval from TikTok to sell products of specific categories and brands. Some brands and categories on TikTok Shop are invite-only, so you need to reach out to TikTok to get their approval to work with the categories and brands that aren't publicly available.

  6. A TikTok Shop authentication created on the project or organization level to use it across all TikTok Shop sites. See Add OAuth authentication to external systems for more information.

    Add this authentication as follows:

    1. Go to Authentication from your organization's or project's menu and select ADD AUTHENTICATION.

    2. In Type, select the needed authentication type based on your country of interest, give it a custom name as desired, and select Next:

      • Select TikTok Shop US Authentication if you want to sell products on the US market.

      • Select TikTok Shop Non-US Authentication if you want to sell products on the UK market.

    3. Select Connect for Productsup to redirect you to a TikTok account page where you can give Productsup access to your account. Follow the instructions on TikTok to connect the systems.

      Add the TikTok Shop US Authentication
      Add the TikTok Shop Non-US Authentication
    4. Once ready, TikTok redirects you back to Productsup to finish the authentication process. Close the confirmation window in Productsup to proceed.

Send products to TikTok Shop

To send your products to TikTok Shop in the US or the UK, you first need to add and set up the export TikTok Shop Product Export API Main (US) or TikTok Shop Product Export API Main (UK) and create a Partner Taxonomy Mapping list for your category attribute.

Your next steps depend on what attributes you want to send to TikTok Shop. If you plan to send any of the following attribute types, you need to take additional steps to set them up:

  • The brand attribute

  • Attributes that require predefined values

  • Multi-value attributes

  • Product variant attributes

See the following sections for information on setting up the export itself and working with each attribute type listed above.

Tip

To see what data in your feed doesn't meet the export channel requirements, you can use the Analyzer feature. See Analyze your data in Data View for more information on identifying the data that needs optimization.Analyze your data in Data View

See TikTok Shop Partner Center API Documents for reference on TikTok Shop's requirements for each attribute.

Add and set up your TikTok Shop product export

In the site dedicated to the main TikTok Shop product export, add and set up the main product export as follows:

  1. Go to Exports from your site's main menu and select ADD EXPORT.

  2. Search for the needed export based on your country of interest, hover over it, and select Add:

    • Search for and add TikTok Shop Product Export API Main (US) if you want to sell products on the US market.

      Add the export TikTok Shop Product Export API Main (US)
    • Search for and add TikTok Shop Product Export API Main (UK) if you want to sell products on the UK market.

      Add the export ​​TikTok Shop Product Export API Main​​ (UK)
  3. On the Exports page, select the name of the added export to set it up.

  4. Select Add Destination, choose TikTok Shop Export Products from the drop-down list, give it a name as desired, and then select Save.

    Add the destination TikTok Shop Export Products
  5. In Authentication, select the TikTok Shop authentication you have added to your Productsup organization or project.

  6. To let the platform create a file and log all calls to the TikTok Shop API, toggle the Log API calls button to On. You can also toggle Log headers of API calls to On to let the logs feature request and response headers.

    Tip

    You can use these settings to troubleshoot your export setup on demand, but you shouldn't use them permanently because they slow down the export process.

  7. Toggle the Enable Feedback File button to Off if you don't want the platform to receive feedback files from TikTok.

    This feature is active by default to let Productsup receive a feedback file from the TikTok Shop API in case of export errors. This helps to troubleshoot the setup.

  8. Toggle the Active button to On to activate the destination.

  9. Select Save.

  10. Go to Lists from your site's main menu and select ADD LIST.

  11. Choose Partner Taxonomy Mapping and select Continue.

  12. Give the list a desired name, select the needed taxonomy in Taxonomy, and choose Import in Stage:

    • Search for and add the taxonomy Tiktok US categories with ids if you want to sell products on the US market.

    • Search for and add the taxonomy Tiktok UK categories with ids if you want to sell products on the UK market.

    tiktok_US_categories_with_ids.png
    tiktok_UK_categories_with_ids.png
  13. Select the Attribute field to choose the attribute in your import stage that contains your products' category data. Then, select Add at the bottom of the page to add the list.

  14. Go through all the values of your category attribute in the column on the left and select the corresponding TikTok Shop categories in the Replace term column.

    select the corresponding values in the Replace terms column

    Note

    You must create and set up a new Partner Taxonomy Mapping list every time you modify the chosen category attribute in your data source and import its new values into your site. Otherwise, the already existing list can't upload your new values, and you can't map them to the corresponding TikTok Shop categories. Once you create a new Classification Mapping list, you need to choose it in the related rule box.

  15. Go to Dataflow and select the added export from the drop-down menu on the left.

  16. Map all the needed attributes from import to export. The attributes you see in the export stage are relevant for products of all your TikTok categories.

    Tip

    Map your import-stage category attribute to both category_id and category_path in the intermediate stage to add the needed rule boxes and apply the Partner Taxonomy Mapping list.

  17. Select category_id in the intermediate stage and open the Select an Option drop-down menu on the right to find and add the rule boxes:

    1. Search for and select Taxonomy Mapping. Choose your category list in List.

    2. Search for and select Split String. Enter | in Splitter, 0 in From, and 1 in Items. Select Save.

      This way, the category_id attribute contains only the ID of the needed category.

  18. Select category_path in the intermediate stage and open the Select an Option drop-down menu on the right to find and add the rule boxes:

    1. Search for and select Taxonomy Mapping. Choose your category list in List.

    2. Search for and select Split String. Enter | in Splitter, 1 in From, and 1 in Items. Select Save.

      This way, the category_path attribute contains only the path of the needed category.

  19. To let the site display your category-specific attributes in Dataflow, select Run in the top-right corner of your view.

    Warning

    This run will fail because you haven't yet mapped all the mandatory attributes, so no data export occurs at this stage. The aim of the run is to import the needed categories and attributes in Dataflow.

  20. Once the site run finishes, the Classifications drop-down menu appears in the upper ribbon in Dataflow. Select each category in this drop-down menu to let Dataflow display the relevant category-specific attributes in the export stage. Map all the needed attributes from import to export.

    The Classifications drop-down menu appears in the upper ribbon in Dataflow

    Tip

    If you can't see the Classifications drop-down menu when the site run finishes, try refreshing your page.

Set up the brand attribute

When receiving brand information about a product, TikTok Shop requires the ID of that brand. To satisfy this requirement, you need to create a Partner Taxonomy Mapping list in your site and map your current brand attribute with the brand IDs expected by TikTok:

  1. Go to Lists from your site's main menu and select ADD LIST.

  2. Choose Partner Taxonomy Mapping and select Continue.

  3. Give the list a desired name, select Tiktok brands with ids in Taxonomy, and choose Import in Stage.

    tiktok_brands_with_ids.png
  4. Select the Attribute field to choose the attribute in your import stage that contains your products' brand data. Then, select Add at the bottom of the page to add the list.

  5. Go through all the values of your brand attribute in the column on the left and select the corresponding TikTok-recognized brands and brand IDs in the Replace term column.

    replace_terms_for_tiktok_brands.png

    Note

    You must create and set up a new Partner Taxonomy Mapping list every time you modify the chosen brand attribute in your data source and import its new values into your site. Otherwise, the already existing list can't upload your new values, and you can't map them to the corresponding brands and brand IDs recognized by TikTok Shop.

  6. Go to Dataflow and select TikTok Shop Product Export API Main from the drop-down menu on the left.

  7. To apply the brand-mapping list to your attributes and extract the needed data from it, select brand_id in the export stage and open the Select an Option drop-down menu on the right to find and add the rule boxes:

    1. Search for and select Taxonomy Mapping. Choose your brand-mapping list in List.

    2. Search for and select Split String. Enter | in Splitter, 0 in From, and 1 in Items. Select Save.

      This way, the brand_id attribute contains only the IDs of the needed brands, as required by TikTok Shop.

Set up attributes that require predefined values

For some attributes, TikTok Shop accepts predefined values only and requires receiving the IDs of those values together with the values themselves. For example, TikTok Shop accepts only the values Foldable and Non-Foldable for the attribute product_attribute.Foldable Furniture#100887 and also expects to receive those values' IDs 1002263 and 1002263 in this attribute. You thus need to send the values as follows: Foldable:::::1002263 and Non-Foldable:::::1004668.

To check which attributes in your feed require predefined values with value IDs:

  1. Go to Dataflow and select TikTok Shop Product Export API Main from the drop-down menu on the left.

    Tip

    For category-specific values, open the Classification drop-down menu and select the needed category.

  2. In the Overview drop-down, select Readiness.

  3. The platform highlights problematic attributes in orange or red. Select the readiness percentage under the name of each problematic attribute. If the attribute supports only predefined values, you will see a similar pie chart in the Tests section and a list of the supported values for this attribute.

    predefined_values_and_value_ids.png

    See Analyze your data in Data View for more information on the Analyzer and channel readiness scores.Analyze your data in Data View

To provide the right values and the relevant value IDs in the attributes that support only predefined values, do the following for each of these attributes:

  1. Go to Lists from your site's main menu and select ADD LIST.

  2. Choose Partner Taxonomy Mapping and select Continue.

  3. Give the list a desired name, select Tiktok non-customized with ids in Taxonomy, and choose Import in Stage.

    tiktok_non-customized_with_ids.png
  4. Select the Attribute field to choose the attribute in your import stage that should contain predefined values. Then, select Add at the bottom of the page to add the list.

  5. Go through all the values of your chosen attribute in the column on the left and select the corresponding values supported by TikTok Shop in the Replace term column.

    replace_terms_non-customized.png

    Note

    You must create and set up a new Partner Taxonomy Mapping list every time you modify the chosen attribute in your data source and import its new values into your site. Otherwise, the already existing list can't upload your new values, and you can't map them to the corresponding predefined TikTok Shop values with IDs.

  6. Go to Dataflow and select TikTok Shop Product Export API Main from the drop-down menu on the left.

  7. To apply the list to the chosen attribute and extract the needed data from it, select the relevant attribute in the export stage and open the Select an Option drop-down menu on the right to find and add the rule boxes:

    1. Search for and select Taxonomy Mapping. Choose your list in List.

    2. Search for and select Split String. Enter | in Splitter, 1 in From, and 1 in Items. Select Save.

Set up multi-value attributes

TikTok Shop allows some attributes to contain multiple values. Here are some of these attributes:

  • Images

  • Material

  • Delivery service IDs

To see if an attribute can send multiple values to TikTok Shop, you can use the Analyzer feature. If an attribute doesn't have analyzer tests at the export stage in the Analyzer, the attribute is likely to support multiple values. See Analyze your data in Data View for more information on the Analyzer feature.Analyze your data in Data View

Tip

You can also see which attributes support multiple values in your TikTok account.

Most multi-value attributes are category-specific.

For all the attributes that should send multiple values to your TikTok Shop account, do the following:

  1. Go to Dataflow and select TikTok Shop Product Export API Main from the drop-down menu on the left.

  2. Map an attribute from the import stage to the corresponding multi-value attribute in the intermediate stage.

  3. Select the attribute in the intermediate stage and open the Select an Option drop-down menu on the right to find and add the rule boxes.

  4. Search for and select Append/Prepend Column.

    append_prepend_column.png
  5. In Column, choose another attribute that should add its value to the multi-value attribute. Then, select append in Mode.

  6. In the text field, enter # to separate the value of the added attribute from the current value.

  7. Open the Select an Option drop-down menu to search for and select Text Replace.

    text_replace.png
  8. Enter # in Search for and # in Replace by.

    Note

    With the suggested settings, the Append/Prepend Column rule box adds the value of your chosen attribute to the current value in your edited multi-value attribute by using the number sign (#) and a space before it as a delimiter.

    Don't forget to enter the space before # in Search for to let the Text Replace rule box remove the space.

  9. Select Save.

    Tip

    If you want to add more than one (1) attribute to a multi-value attribute in the intermediate stage, you need to add as many Append/Prepend Column rule boxes as necessary to append all the desired values.

    Mind that the order of the rule boxes matters. The higher a rule box is in the list of added rule boxes, the earlier a site processes and applies it to the data. So the order of the Append/Prepend Column rule boxes from top to bottom should be the same as your desired order of values in the attribute.

    You should add the Text Replace rule box only once, and it should be at the bottom of the rule box list.

Mind product variants and their attributes

The TikTok Shop product data scheme uses main products and product variants. All products in your feed must have product_id and parent_id. The product_id attribute uniquely identifies product variants, and the parent_id attribute links all product variants to their main product. The platform considers the first product variant with a new parent_id as both a product variant and the main product.

All product variants have the same values as their main products in such attributes as parent_id, product_name, images, category_id, description, etc. However, there are attributes that can contain values individual to each product variant. The names of these varying attributes start with sku., expect for product_id.

When modifying the data in your feed, you shouldn't let product variants with the same parent_id have different values in the shared attributes. But the values in product_id and the sku. attributes can differ per product variant.

Import orders from TikTok Shop

To let Productsup import your orders from TikTok Shop, do the following in the site dedicated to the TikTok Shop data source:

Note

TikTok users can cancel orders within one (1) hour after placing an order. You can import orders created within the last hour, but you shouldn't ship them right away.

  1. Go to Data Sources from your site's main menu and select ADD DATA SOURCE.

  2. Search for TikTok Shop Order Import v1, select Add, give it a name as desired, and then choose Continue.

    Add the data source TikTok Shop Order Import
  3. In the Order Status Filter area, select the statuses that orders should have for Productsup to import them. If you don't select any order statuses, the platform imports orders of all statuses.

    Tip

    Hold the Ctrl or Cmd key to select multiple order statuses. Shift helps to select a range of statuses.

    See Fulfillment Process Integration Design for more information on the TikTok Shop order status flow.

  4. If you want to import orders created within a specific timeframe only, enter the needed number of days in Earliest Order Creation Time or Earliest Order Update Time. The expected input format is a digit in both fields.

    For example, if you enter 7 in Earliest Order Creation Time, the platform imports only the orders created within the last seven (7) days. To import orders updated within the past three (3) days, enter 3 in Earliest Order Update Time.

  5. In Authentication selection, select the TikTok Shop authentication you have added to your Productsup organization or project.

  6. Specify the desired name of the data source in Description (optional).

  7. Select Save.

  8. Go to Exports from your site's main menu and select ADD EXPORT.

  9. Find your order management system, add it as an export, set it up, and map the needed attributes in Dataflow.

  10. Choose Run in the top-right corner of the page to let the site import your order data and send it to your order management system.

Send shipment updates to TikTok Shop

There are two (2) types of shipping methods available on TikTok Shop:

  1. Self-shipping, which you manage yourself.

  2. Shipping managed by TikTok.

Note

  • Currently, Productsup supports only self-shipping and doesn't allow splitting and batching packages.

  • TikTok users can cancel orders within one (1) hour after placing an order. You shouldn't ship orders created within the last hour because there is a cancellation risk.

To send shipment updates to TikTok Shop and notify your customers of the shipment process, do the following in the site dedicated to the TikTok Shop shipment export:

  1. Go to Exports from your site's main menu and select ADD EXPORT.

  2. Search for TikTok Shop - Shipment Notifications, hover over it, and select Add.

    Add the export TikTok Shop - Shipment Notifications
  3. On the Exports page, select the name of the added export to set it up.

  4. Select Add Destination, choose TikTok Shop Shipment Notification Export from the drop-down list, give it a name as desired, and then select Save.

    shipment_destination.png
  5. In Authentication selection, select the TikTok Shop authentication you have added to your Productsup organization or project.

  6. Toggle the Feedback Import button to Off if you don't want the platform to receive feedback files from TikTok.

    This feature is active by default to let Productsup receive a feedback file from the TikTok Shop API in case of export errors. This helps to troubleshoot the setup.

  7. Toggle the Active button to On to activate the destination.

  8. Select Save.

  9. Go to Dataflow and select TikTok Shop - Shipment Notifications from the drop-down menu on the left.

  10. Map all the needed attributes from import to export.

  11. Once all the settings are ready, you can send your shipment updates to TikTok Shop. Select Run in the top-right corner of your view to send the data.