TikTok Shop Connector Reference

369 metrics208 dimensions

Fields Options

The TikTok Shop connector exposes 577 fields (369 metrics, 208 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available options

currency Currency

Which currency to use for shop performance results.

Possible values (2)

LOCALdefaultUSD

TikTok Shop Fields

TikTok Shop Order fields

The Order report of the TikTok Shop connector includes 117 fields.

TikTok Shop Order fields (order_auto_combine_group_id to order_id)

ID	Type	Name	Description
order_auto_combine_group_id	TEXT	Order Auto Combine Group ID	An identifier assigned to orders from the same customer during a LIVE session to facilitate combined order shipping when "auto-combination" is activated in Seller Center.
order_buyer_email	TEXT	Order Buyer Email	The anonymized email address of the buyer. It is not recommended to send messages directly to this email address. If you need to contact the buyer, please go to the TikTok Shop Seller Center - Buyer Messages page.
order_buyer_message	TEXT	Order Buyer Message	The note from the buyer.
order_cancel_datetime	TIMESTAMP	Order Cancel Datetime	The time an order's status was updated to CANCELLED. ISO 8601 datetime format (UTC).
order_cancel_reason	TEXT	Order Cancel Reason	The cancellation reason.
order_cancel_sla_datetime	TIMESTAMP	Order Cancel SLA Datetime	The automatic cancellation time for orders specified by the platform. ISO 8601 datetime format (UTC).
order_cancel_sla_time	TIMESTAMP	Order Cancel SLA Time	The automatic cancellation time for orders specified by the platform. Unix timestamp.
order_cancel_time	TIMESTAMP	Order Cancel Time	The time an order's status was updated to CANCELLED. Unix timestamp.
order_cancellation_initiator	TEXT	Order Cancellation Initiator	Cancellation request initiator. Available values: SELLER, BUYER, SYSTEM.
order_collection_datetime	TIMESTAMP	Order Collection Datetime	The time an order's status has been updated to IN_TRANSIT. ISO 8601 datetime format (UTC).
order_collection_due_datetime	TIMESTAMP	Order Collection Due Datetime	If the order hasn't updated its status to IN_TRANSIT before this time, the order will be canceled by TikTok Shop. ISO 8601 datetime format (UTC).
order_collection_due_time	TIMESTAMP	Order Collection Due Time	If the order hasn't updated its status to IN_TRANSIT before this time, the order will be canceled by TikTok Shop. Unix timestamp.
order_collection_time	TIMESTAMP	Order Collection Time	The time an order's status has been updated to IN_TRANSIT. Unix timestamp.
order_commerce_platform	TEXT	Order Commerce Platform	The platform where the order was placed. TIKTOK_SHOP or TOKOPEDIA. Note: Available only in the Indonesia market.
order_consultation_id	TEXT	Order Consultation ID	An ID to identify the corresponding ePharmacy consultation. Applicable only if an ePharmacy consultation was initiated. Not applicable if the prescription was provided by the customer through an image upload.
order_cpf	TEXT	Order CPF	CPF (invoice number), used to issue an invoice. Note: Only available in the Brazil market.
order_cpf_name	TEXT	Order CPF Name	Name belonging to the CPF number for the Brazil market.
order_create_datetime	TIMESTAMP	Order Create Datetime	The date and time that the order was created. ISO 8601 datetime format (UTC).
order_create_time	TIMESTAMP	Order Create Time	The date and time that the order was created. Unix timestamp.
order_delivery_datetime	TIMESTAMP	Order Delivery Datetime	The time an order's status changed to DELIVERED. ISO 8601 datetime format (UTC).
order_delivery_due_datetime	TIMESTAMP	Order Delivery Due Datetime	If the order hasn't updated its status to DELIVERED before this time, the order will be automatically canceled by TikTok Shop. ISO 8601 datetime format (UTC).
order_delivery_due_time	TIMESTAMP	Order Delivery Due Time	If the order hasn't updated its status to DELIVERED before this time, the order will be automatically canceled by TikTok Shop. Unix timestamp.
order_delivery_option_id	TEXT	Order Delivery Option ID	Delivery option ID is mapped to seller configured logistics templates ID.
order_delivery_option_name	TEXT	Order Delivery Option Name	Delivery option name. For display purposes only. Economy Shipping, Standard Shipping, or Express Shipping.
order_delivery_option_required_delivery_datetime	TIMESTAMP	Order Delivery Option Required Delivery Datetime	Order should be delivered before this time. ISO 8601 datetime format (UTC).
order_delivery_option_required_delivery_time	TIMESTAMP	Order Delivery Option Required Delivery Time	Order should be delivered before this time. Unix timestamp.
order_delivery_sla_datetime	TIMESTAMP	Order Delivery SLA Datetime	Order should arrive by this date to be considered on-time and to avoid late delivery penalties. ISO 8601 datetime format (UTC).
order_delivery_sla_time	TIMESTAMP	Order Delivery SLA Time	Order should arrive by this date to be considered on-time and to avoid late delivery penalties.
order_delivery_time	TIMESTAMP	Order Delivery Time	The time an order's status changed to DELIVERED. Unix timestamp.
order_delivery_type	TEXT	Order Delivery Type	Indicates whether it is a Pick-Up Drop-Off (PUDO) location. The PUDO location is selected by the buyer when placing orders.
order_exchange_source_order_id	TEXT	Order Exchange Source Order ID	If the order is an exchange order, this field returns the original order's order ID, from which the exchange order was generated. Returned only if is_exchange_order = true. Note: Only available in US and UK.
order_fast_delivery_program	TEXT	Order Fast Delivery Program	A badge presented on the merchandise to tell the buyer that the seller participates in the fast delivery program, such that the order should arrive in a promised time period. Not returned if order did not meet fast delivery program requirements. Note: Applicable only for the US market.
order_fast_dispatch_sla_datetime	TIMESTAMP	Order Fast Dispatch SLA Datetime	The latest collection time to gain incentives of NDD (Next Day Delivery) project. ISO 8601 datetime format (UTC). Note: Only available in Thailand and the Philippines.
order_fast_dispatch_sla_time	TIMESTAMP	Order Fast Dispatch SLA Time	The latest collection time to gain incentives of NDD (Next Day Delivery) project. Unix timestamp. Note: Only available in Thailand and the Philippines.
order_fulfillment_priority_level	NUMERIC	Order Fulfillment Priority Level	Fulfillment priority value that can be used to prioritize shipping (only available in SEA).
order_fulfillment_type	TEXT	Order Fulfillment Type	Fulfillment type. Only orders with fulfillment type can be shipped by sellers.
order_handling_duration_days	NUMERIC	Order Handling Duration Days	The duration for the seller to process the order and hand it over to a shipping carrier after the order is placed. Applicable only if the order_type is MADE_TO_ORDER or BACK_ORDER.
order_handling_duration_type	TEXT	Order Handling Duration Type	Indicates if the duration is calculated in calendar days or business days. CALENDAR_DAY or BUSINESS_DAY.
order_has_updated_recipient_address	BOOLEAN	Order Has Updated Recipient Address	Whether the recipient address has been updated or changed.
order_id	TEXT	Order ID	TikTok Shop order ID.

TikTok Shop Order fields (order_is_buyer_request_cancel to order_recipient_address_line4)

ID	Type	Name	Description
order_is_buyer_request_cancel	BOOLEAN	Order is Buyer Request Cancel	Whether the buyer has a pending cancellation request.
order_is_cod	BOOLEAN	Order is COD	This option is for sellers that accept cash payment on delivery (COD). Buyers will pay in cash upon receiving the package. Only applicable to countries where COD is supported.
order_is_exchange_order	BOOLEAN	Order is Exchange Order	When TRUE, this is an exchange order. Note: Only available in US and UK.
order_is_on_hold	BOOLEAN	Order is on Hold	Indicates whether the order has been changed to or will be updated to ON_HOLD status.
order_is_replacement_order	BOOLEAN	Order is Replacement Order	Whether this is a replacement order.
order_is_sample_order	BOOLEAN	Order is Sample Order	Use this field to determine whether the order is a sample order.
order_line_items_product_name	TEXT	Order Line Item Product Name	The name of the product for this order line item.
order_line_items_sku_id	TEXT	Order Line Item SKU ID	The SKU ID generated by TikTok Shop for this order line item.
order_line_items_sku_name	TEXT	Order Line Item SKU Name	The SKU display name for this order line item.
order_need_upload_invoice	TEXT	Order Need Upload Invoice	Whether an invoice needs to be uploaded and uploaded status (only for Brazil market).
order_paid_datetime	TIMESTAMP	Order Paid Datetime	The date and time that the order was paid. ISO 8601 datetime format (UTC).
order_paid_time	TIMESTAMP	Order Paid Time	The date and time that the order was paid. Unix timestamp.
order_payment_buyer_service_fee	NUMERIC	Order Payment Buyer Service Fee	A service fee is charged on every transaction made. The charge is applied from the fifth order onwards and collected directly from customers during checkout. Only available in the Indonesia market.
order_payment_currency	TEXT	Order Payment Currency	Currency for payment.
order_payment_handling_fee	NUMERIC	Order Payment Handling Fee	A fee charged to the buyer to cover the additional processing, handling, and/or installment costs associated with the chosen payment method.
order_payment_item_insurance_fee	NUMERIC	Order Payment Item Insurance Fee	The cost incurred by the buyers for coverage against defects or damage to the product after purchase. Note: Only available in the US and Indonesia markets.
order_payment_method_name	TEXT	Order Payment Method Name	Payment method name, for display purposes.
order_payment_original_shipping_fee	NUMERIC	Order Payment Original Shipping Fee	Shipping fee before discount.
order_payment_original_total_product_price	NUMERIC	Order Payment Original Total Product Price	Total original price of the products (VAT included for cross-border shops). For the US market, this is pre-tax total amount.
order_payment_platform_discount	NUMERIC	Order Platform Discount	Product discount by platform.
order_payment_product_tax	NUMERIC	Order Payment Product Tax	The tax on the total item price.
order_payment_retail_delivery_fee	NUMERIC	Order Payment Retail Delivery Fee	Retail delivery fee (RDF). Note: Only available in the US market.
order_payment_seller_discount	NUMERIC	Order Seller Discount	Product discount by seller.
order_payment_shipping_fee	NUMERIC	Order Payment Shipping Fee	Buyer paid shipping fee. shipping_fee = original_shipping_fee - shipping_fee_seller_discount - shipping_fee_platform_discount. For the US market, this is pre-tax total amount.
order_payment_shipping_fee_cofunded_discount	NUMERIC	Order Payment Shipping Fee Cofunded Discount	Shipping fee discount provided by seller, eligible for co-funded reimbursement upon order delivery, based on Co-Funded Free Shipping program terms. Note: This will be 0 for orders that did not meet minimum order value for co-funded reimbursement. In this case, refer to shipping_fee_seller_discount for the shipping discount the buyer received.
order_payment_shipping_fee_platform_discount	NUMERIC	Order Payment Shipping Fee Platform Discount	Shipping fee discount provided by platform.
order_payment_shipping_fee_seller_discount	NUMERIC	Order Payment Shipping Fee Seller Discount	Shipping fee discount provided by seller for an order that will not qualify for co-funded reimbursement. Note: If an order meets the minimum order value for co-funded reimbursement, this will be 0. In this case, refer to shipping_fee_cofunded_discount for the shipping discount the buyer received.
order_payment_shipping_fee_tax	NUMERIC	Order Payment Shipping Fee Tax	The tax on the shipping price.
order_payment_shipping_insurance_fee	NUMERIC	Order Payment Shipping Insurance Fee	The cost incurred by the buyer for coverage against loss or damage to goods during transit. Note: Only available in the Indonesia market.
order_payment_small_order_fee	NUMERIC	Order Payment Small Order Fee	Small order fee for TH (Thailand market only). Small order fee means that the platform will set a minimum order spending amount. When the order amount is lower than the minimum order spending amount, the user needs to pay a small order fee to meet the platform minimum spending amount. e.g. Minimum order spending amount is 100, order amount is 80. So the small order fee will be 20.
order_payment_sub_total	NUMERIC	Order Payment Sub-Total	Buyer paid sub-total of all the SKUs in the order. sub_total = original_total_product_price - seller_discount - platform_discount. For the US market, this is pre-tax total amount.
order_payment_tax	NUMERIC	Order Payment Tax	Buyer paid total taxes for the order. Applicable to both cross-border shops and the US market.
order_payment_total_amount	NUMERIC	Order Payment Total Amount	Buyer paid total payment. total_amount = sub_total + shipping_fee + taxes + retail_delivery_fee.
order_pick_up_cut_off_datetime	TIMESTAMP	Order Pick Up Cut Off Datetime	To avoid LDR, you must ensure the package is picked up by this time. Only applicable in South East Asia regions. ISO 8601 datetime format (UTC).
order_pick_up_cut_off_time	TIMESTAMP	Order Pick Up Cut Off Time	To avoid LDR, you must ensure the package is picked up by this time. Only applicable in South East Asia regions.
order_recipient_address_detail	TEXT	Order Recipient Address Detail	Full recipient detailed address.
order_recipient_address_line1	TEXT	Order Recipient Address Line 1	The first line of the street address.
order_recipient_address_line2	TEXT	Order Recipient Address Line 2	The second line of the street address.
order_recipient_address_line3	TEXT	Order Recipient Address Line 3	The third line of the street address. Usually only for the Brazilian market.
order_recipient_address_line4	TEXT	Order Recipient Address Line 4	The fourth line of the street address. Usually only for the Brazilian market.

TikTok Shop Order fields (order_recipient_drop_off_location to order_warehouse_id)

ID	Type	Name	Description
order_recipient_drop_off_location	TEXT	Order Recipient Drop Off Locatiion	Drop-off location selected by the recipient. Currently, only available in the US market.
order_recipient_first_name	TEXT	Order Recipient First Name	Recipient first name. If the recipient first and last names are not provided separately, this parameter will have the same value as the name parameter. Note: Applicable only for the US, UK, and JP markets.
order_recipient_first_name_local_script	TEXT	Order Recipient First Name Local Script	Recipient first name in katakana. Note: Applicable only for the JP market.
order_recipient_full_address	TEXT	Order Recipient Full Address	Complete recipient address information.
order_recipient_last_name	TEXT	Order Recipient Last Name	Recipient last name. If the recipient first and last names are not provided separately, this parameter will be empty. Note: Applicable only for the US, UK, and JP markets.
order_recipient_last_name_local_script	TEXT	Order Recipient Last Name Local Script	Recipient last name in katakana. Note: Applicable only for the JP market.
order_recipient_name	TEXT	Order Recipient Name	Recipient name. Note: If this order uses platform logistics, the recipient name will be desensitized.
order_recipient_phone_number	TEXT	Order Recipient Phone Number	Recipient telephone number. Note: If this order uses platform logistics, the phone number will be desensitized.
order_recipient_post_town	CITY	Order Recipient Post Town	Post town of the address. Note: Available only in UK market.
order_recipient_postal_code	TEXT	Order Recipient Postal Code	The postal code that can be used by seller for shipping. For the US market, this refers to the ZIP Code.
order_recipient_region_code	REGION	Order Recipient Region Code	Region code.
order_recommended_shipping_datetime	TIMESTAMP	Order Recommended Shipping Datetime	Recommended time to ship based on the each LSP service type (only available in SEA). ISO 8601 datetime format (UTC).
order_recommended_shipping_time	TIMESTAMP	Order Recommended Shipping Time	Recommended time to ship based on the each LSP service type (only available in SEA).
order_release_date	DATE	Order Release Date	The date on which order handling starts and the status of the order changes to AWAITING_SHIPMENT. Applicable only if the order_type is PRE_ORDER.
order_replacement_order_id	TEXT	Order Replacement Order ID	The order Id for the order that is being replaced. Returned only if is_replacement_order = true.
order_request_cancel_datetime	TIMESTAMP	Order Request Cancel Datetime	Buyer request cancellation time. ISO 8601 datetime format (UTC).
order_request_cancel_time	TIMESTAMP	Order Request Cancel Time	Buyer request cancellation time. Unix timestamp.
order_rts_datetime	TIMESTAMP	Order RTS Datetime	The time sellers shipped the order (called Ship Package API successfully). ISO 8601 datetime format (UTC).
order_rts_sla_datetime	TIMESTAMP	Order RTS SLA Datetime	The latest shipping time specified by the platform. ISO 8601 datetime format (UTC).
order_rts_sla_time	TIMESTAMP	Order RTS SLA Time	The latest shipping time specified by the platform. Unix timestamp.
order_rts_time	TIMESTAMP	Order RTS Time	The time sellers shipped the order (called Ship Package API successfully). Unix timestamp.
order_seller_note	TEXT	Order Seller Note	The seller note from TikTok Shop Seller Center.
order_shipping_due_datetime	TIMESTAMP	Order Shipping Due Datetime	If the order hasn't updated its status to AWAITING_COLLECTION before this time, the order will be automatically canceled by TikTok Shop. ISO 8601 datetime format (UTC).
order_shipping_due_time	TIMESTAMP	Order Shipping Due Time	If the order hasn't updated its status to AWAITING_COLLECTION before this time, the order will be automatically canceled by TikTok Shop. Unix timestamp.
order_shipping_provider	TEXT	Order Shipping Provider	The name of the current shipping provider.
order_shipping_provider_id	TEXT	Order Shipping Provider ID	The ID of the current shipping provider.
order_shipping_type	TEXT	Order Shipping Type	Delivery method. TIKTOK or SELLER.
order_split_or_combine_tag	TEXT	Order Split or Combine Tag	Indicates whether the order is combined or split: COMBINED or SPLIT.
order_status	TEXT	Order Status	Specific order status.
order_tracking_number	TEXT	Order Tracking Number	Tracking number. Available after the package has been shipped.
order_tts_sla_datetime	TIMESTAMP	Order TTS SLA Datetime	The latest collection time specified by the platform. ISO 8601 datetime format (UTC).
order_tts_sla_time	TIMESTAMP	Order TTS SLA Time	The latest collection time specified by the platform. Unix timestamp.
order_type	TEXT	Order Type	The order type.
order_update_datetime	TIMESTAMP	Order Update Datetime	Time of order status change. ISO 8601 datetime format (UTC).
order_update_time	TIMESTAMP	Order Update Time	Time of order status change. Unix timestamp.
order_user_id	TEXT	Order User ID	Buyer user ID.
order_warehouse_id	TEXT	Order Warehouse ID	Seller warehouse ID.

TikTok Shop Payment fields

The Payment report of the TikTok Shop connector includes 16 fields.

ID	Type	Name	Description
payment_amount_before_exchange_currency	TEXT	Payment Amount Before Exchange Currency	Original currency before exchange (ISO 4217).
payment_amount_before_exchange_value	NUMERIC	Payment Amount Before Exchange Value	Payment amount before currency exchange was applied.
payment_amount_currency	TEXT	Payment Amount Currency	Currency of the payment amount (ISO 4217).
payment_amount_value	NUMERIC	Payment Amount Value	The original payment amount, before any platform reserves.
payment_bank_account	TEXT	Payment Bank Account	Masked bank account that received the payment.
payment_create_datetime	TIMESTAMP	Payment Create Datetime	The time when the payment was created. ISO 8601 datetime format (UTC).
payment_create_time	TIMESTAMP	Payment Create Time	The time when the payment was created. Unix timestamp.
payment_exchange_rate	NUMERIC	Payment Exchange Rate	Exchange rate applied when converting to the settlement currency.
payment_id	TEXT	Payment ID	The unique identifier of the payment.
payment_paid_datetime	TIMESTAMP	Payment Paid Datetime	The time when the payment was paid out to the seller. ISO 8601 datetime format (UTC).
payment_paid_time	TIMESTAMP	Payment Paid Time	The time when the payment was paid out to the seller. Unix timestamp.
payment_reserve_amount_currency	TEXT	Payment Reserve Amount Currency	Currency of the reserved amount (ISO 4217).
payment_reserve_amount_value	NUMERIC	Payment Reserve Amount Value	Amount withheld by the platform from this payment as a reserve.
payment_settlement_amount_currency	TEXT	Payment Settlement Amount Currency	Currency of the settlement amount (ISO 4217).
payment_settlement_amount_value	NUMERIC	Payment Settlement Amount Value	Final amount paid out to the seller after platform reserves.
payment_status	TEXT	Payment Status	The status of the payment, e.g. PAID.

TikTok Shop Product fields

The Product report of the TikTok Shop connector includes 19 fields.

ID	Type	Name	Description
product_create_datetime	TIMESTAMP	Product Create Datetime	The time when the product was created. ISO 8601 datetime format (UTC).
product_create_time	TIMESTAMP	Product Create Time	The time when the product was created. Unix timestamp.
product_has_draft	BOOLEAN	Product Has Draft	A flag indicating whether the product has a draft.
product_id	TEXT	Product ID	The TikTok Shop product ID.
product_is_not_for_sale	BOOLEAN	Product is Not For Sale	A flag indicating whether the product is not for sale.
product_listing_quality_tier	TEXT	Product Listing Quality Tier	The quality tier of the product listing. Possible values: POOR, FAIR, GOOD. Available only for the US market.
product_sku_id	TEXT	Product SKU ID	The SKU ID generated by TikTok Shop.
product_sku_inventory_backorder_quantity	NUMERIC	Product SKU Inventory Backorder Quantity	The backorder quantity that will be converted to available quantity once in-stock inventory is sold out.
product_sku_inventory_handling_time	NUMERIC	Product SKU Inventory Handling Time	The estimated number of working days needed for a backorder to be shipped.
product_sku_inventory_quantity	NUMERIC	Product SKU Inventory Quantity	The total SKU quantity available in the warehouse. This refers to in-stock inventory that can be shipped immediately.
product_sku_inventory_warehouse_id	TEXT	Product SKU Inventory Warehouse ID	The ID of the warehouse where the SKU is stored.
product_sku_price_currency	TEXT	Product SKU Price Currency	The currency of the SKU price.
product_sku_price_sale_price	NUMERIC	Product SKU Sale Price	The sale price of the SKU.
product_sku_price_tax_exclusive_price	NUMERIC	Product SKU Tax Exclusive Price	The tax-exclusive price of the SKU.
product_sku_seller_sku	TEXT	Product SKU Seller SKU	An internal code/name for managing SKUs, not visible to buyers.
product_status	TEXT	Product Status	The product status in TikTok Shop. Possible values: DRAFT, PENDING, FAILED, ACTIVATE, SELLER_DEACTIVATED, PLATFORM_DEACTIVATED, FREEZE, DELETED.
product_title	TEXT	Product Title	The product title.
product_update_datetime	TIMESTAMP	Product Update Datetime	The time when the product was last updated. ISO 8601 datetime format (UTC).
product_update_time	TIMESTAMP	Product Update Time	The time when the product was last updated. Unix timestamp.

TikTok Shop Shop fields

The Shop report of the TikTok Shop connector includes 5 fields.

ID	Type	Name	Description
shop_code	TEXT	Shop Code	The TikTok Shop code, which is also displayed on Seller Center.
shop_id	TEXT	Shop ID	An internal identifier for the TikTok Shop.
shop_name	TEXT	Shop Name	The TikTok Shop name.
shop_region	REGION	Shop Region	The region of the shop.
shop_seller_type	TEXT	Shop Seller Type	The type of seller. Possible values: CROSS_BORDER: Cross border sellers with multiple shops in different countries. LOCAL: Local sellers with only 1 shop.

TikTok Shop Shop Performance fields

The Shop Performance report of the TikTok Shop connector includes 53 fields.

TikTok Shop Shop Performance fields (shop_performance_avg_order_value_amount to shop_performance_product_name)

ID	Type	Name	Description
shop_performance_avg_order_value_amount	NUMERIC	Shop Performance Average Order Value Amount	Average value of an order for the shop. (US shops)
shop_performance_avg_order_value_currency	TEXT	Shop Performance Average Order Value Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_avg_product_page_visitors	NUMERIC	Shop Performance Average Product Page Visitors	Average number of unique visitors per day for the shop. (US shops)
shop_performance_avg_product_page_visitors_breakdowns_live_amount	NUMERIC	Shop Performance Average Product Page Visitors Breakdowns Live Amount	Average number of unique visitors per day for the corresponding type (live). (US shops)
shop_performance_avg_product_page_visitors_breakdowns_product_card_amount	NUMERIC	Shop Performance Average Product Page Visitors Breakdowns Product Card Amount	Average number of unique visitors per day for the corresponding type (product card). (US shops)
shop_performance_avg_product_page_visitors_breakdowns_video_amount	NUMERIC	Shop Performance Average Product Page Visitors Breakdowns Video Amount	Average number of unique visitors per day for the corresponding type (video). (US shops)
shop_performance_buyer_breakdowns_live_amount	NUMERIC	Shop Performance Buyers Breakdowns Live Amount	Number of unique buyers for the corresponding type (live). (US shops)
shop_performance_buyer_breakdowns_product_card_amount	NUMERIC	Shop Performance Buyers Breakdowns Product Card Amount	Number of unique buyers for the corresponding type (product card). (US shops)
shop_performance_buyer_breakdowns_video_amount	NUMERIC	Shop Performance Buyers Breakdowns Video Amount	Number of unique buyers for the corresponding type (video). (US shops)
shop_performance_buyers	NUMERIC	Shop Performance Buyers	Number of unique buyers for the shop. (US shops)
shop_performance_cancellations_and_returns	NUMERIC	Shop Performance Cancellations and Returns	Total number of items that were canceled or returned for the shop. (US shops)
shop_performance_cost_per_live_view	NUMERIC	Shop Performance Cost Per Live View	Average cost per live stream view.
shop_performance_cost_per_order	NUMERIC	Shop Performance Cost Per Order	Average cost per order.
shop_performance_gmv_amount	NUMERIC	Shop Performance GMV Amount	Overall Gross Merchandise Value (GMV) for the shop. (US shops)
shop_performance_gmv_breakdowns_live_amount	NUMERIC	Shop Performance GMV Breakdowns Live Amount	GMV breakdowns for the shop (live). (US shops)
shop_performance_gmv_breakdowns_live_currency	TEXT	Shop Performance GMV Breakdowns Live Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_gmv_breakdowns_product_card_amount	NUMERIC	Shop Performance GMV Breakdowns Product Card Amount	GMV breakdowns for the shop (product card). (US shops)
shop_performance_gmv_breakdowns_product_card_currency	TEXT	Shop Performance GMV Breakdowns Product Card Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_gmv_breakdowns_video_amount	NUMERIC	Shop Performance GMV Breakdowns Video Amount	GMV breakdowns for the shop (video). (US shops)
shop_performance_gmv_breakdowns_video_currency	TEXT	Shop Performance GMV Breakdowns Video Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_gmv_currency	TEXT	Shop Performance GMV Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_gross_revenue	NUMERIC	Shop Performance Gross Revenue	Total gross revenue.
shop_performance_live_duration	NUMERIC	Shop Performance Live Duration	Duration of the live stream in seconds.
shop_performance_live_follows	NUMERIC	Shop Performance Live Follows	Number of follows gained from live streams.
shop_performance_live_launched_datetime	TIMESTAMP	Shop Performance Live Launched Datetime	Timestamp when live stream was launched. ISO 8601 datetime format (UTC).
shop_performance_live_launched_time	TIMESTAMP	Shop Performance Live Launched Time	Timestamp when live stream was launched.
shop_performance_live_name	TEXT	Shop Performance Live Name	Name of the live stream session.
shop_performance_live_views	NUMERIC	Shop Performance Live Views	Number of live stream views.
shop_performance_max_delivery_budget	NUMERIC	Shop Performance Max Delivery Budget	Maximum delivery budget for GMV Max campaigns.
shop_performance_net_cost	NUMERIC	Shop Performance Net Cost	Net cost after deductions.
shop_performance_operation_status	TEXT	Shop Performance Operation Status	GMV Max campaign operation status.
shop_performance_orders	NUMERIC	Shop Performance Orders	Total (sum of all) orders for a shop. (US shops)
shop_performance_product_click_rate	NUMERIC	Shop Performance Product Click Rate	Click-through rate for products (clicks/impressions).
shop_performance_product_clicks	NUMERIC	Shop Performance Product Clicks	Number of clicks on product listings.
shop_performance_product_image_url	IMAGE_URL	Shop Performance Product Image URL	URL of the product image.
shop_performance_product_impression_breakdowns_live_amount	NUMERIC	Shop Performance Product Impression Breakdowns Live Amount	Total product impressions for the corresponding type (live). (US shops)
shop_performance_product_impression_breakdowns_product_card_amount	NUMERIC	Shop Performance Product Impression Breakdowns Product Card Amount	Total product impressions for the corresponding type (product card). (US shops)
shop_performance_product_impression_breakdowns_video_amount	NUMERIC	Shop Performance Product Impression Breakdowns Video Amount	Total product impressions for the corresponding type (video). (US shops)
shop_performance_product_impressions	NUMERIC	Shop Performance Product Impressions	Total product impressions for the shop. (US shops)
shop_performance_product_name	TEXT	Shop Performance Product Name	Name of the product.

TikTok Shop Shop Performance fields (shop_performance_product_page_view_breakdowns_live_amount to shop_performance_units_sold)

ID	Type	Name	Description
shop_performance_product_page_view_breakdowns_live_amount	NUMERIC	Shop Performance Product Page Views Breakdowns Live Amount	Total product page views for the corresponding type (live). (US shops)
shop_performance_product_page_view_breakdowns_product_card_amount	NUMERIC	Shop Performance Product Page Views Breakdowns Product Card Amount	Total product page views for the corresponding type (product card). (US shops)
shop_performance_product_page_view_breakdowns_video_amount	NUMERIC	Shop Performance Product Page Views Breakdowns Video Amount	Total product page views for the corresponding type (video). (US shops)
shop_performance_product_page_views	NUMERIC	Shop Performance Product Page Views	Total product detail page views for the shop. (US shops)
shop_performance_refunds_amount	NUMERIC	Shop Performance Refunds Amount	Total value of refunds for the shop. (US shops)
shop_performance_refunds_currency	TEXT	Shop Performance Refunds Currency	GMV currency code (ISO 4217 standard). (US shops)
shop_performance_roas_bid	NUMERIC	Shop Performance ROAS Bid	ROAS bid value for GMV Max campaigns.
shop_performance_roi	NUMERIC	Shop Performance ROI	Return on investment percentage.
shop_performance_sku_orders	NUMERIC	Shop Performance SKU Orders	Number of Stock Keeping Units (SKUs) in orders placed. (US shops)
shop_performance_target_roi_budget	NUMERIC	Shop Performance Target ROI Budget	Target ROI budget setting for GMV Max.
shop_performance_title	TEXT	Shop Performance Title	Title of the content or product.
shop_performance_tt_account_profile_image_url	IMAGE_URL	Shop Performance TikTok Account Profile Image URL	TikTok account profile image URL.
shop_performance_units_sold	NUMERIC	Shop Performance Units Sold	Number of units sold for the shop. (US shops)

TikTok Shop Statement fields

The Statement report of the TikTok Shop connector includes 255 fields.

TikTok Shop Statement fields (statement_adjustment_amount to statement_transaction_fee_fee_per_item_sold_amount)

ID	Type	Name	Description
statement_adjustment_amount	NUMERIC	Statement Adjustment Amount	Total adjustments applied in the statement.
statement_currency	TEXT	Statement Currency	Currency of the statement amounts (ISO 4217).
statement_fee_amount	NUMERIC	Statement Fee Amount	Total fees charged in the statement.
statement_id	TEXT	Statement ID	The unique identifier of the statement.
statement_net_sales_amount	NUMERIC	Statement Net Sales Amount	Net sales recognised in the statement.
statement_payment_datetime	TIMESTAMP	Statement Payment Datetime	Time the statement was paid out. ISO 8601 datetime format (UTC).
statement_payment_id	TEXT	Statement Payment ID	Identifier of the payment associated with the statement.
statement_payment_status	TEXT	Statement Payment Status	Status of the payment associated with the statement, e.g. PAID.
statement_payment_time	TIMESTAMP	Statement Payment Time	Time the statement was paid out. Unix timestamp.
statement_revenue_amount	NUMERIC	Statement Revenue Amount	Total revenue contribution included in the statement.
statement_settlement_amount	NUMERIC	Statement Settlement Amount	The total amount settled to the seller in this statement.
statement_shipping_cost_amount	NUMERIC	Statement Shipping Cost Amount	Total shipping cost component of the statement.
statement_statement_datetime	TIMESTAMP	Statement Datetime	The time the statement was generated. ISO 8601 datetime format (UTC).
statement_statement_time	TIMESTAMP	Statement Time	The time the statement was generated. Unix timestamp.
statement_transaction_adjustment_amount	NUMERIC	Statement Transaction Adjustment Amount	Adjustment amount applied to the transaction.
statement_transaction_adjustment_id	TEXT	Statement Transaction Adjustment ID	Identifier of the adjustment associated with the transaction.
statement_transaction_adjustment_order_id	TEXT	Statement Transaction Adjustment Order ID	Order identifier the adjustment refers to.
statement_transaction_associated_order_id	TEXT	Statement Transaction Associated Order ID	Order identifier the reserve is associated with.
statement_transaction_estimated_release_datetime	TIMESTAMP	Statement Transaction Estimated Release Datetime	Estimated release time for the reserve. ISO 8601 datetime format (UTC).
statement_transaction_estimated_release_time	TIMESTAMP	Statement Transaction Estimated Release Time	Estimated release time for the reserve. Unix timestamp.
statement_transaction_fee_affiliate_ads_commission_amount	NUMERIC	Statement Transaction Fee Affiliate Ads Commission	Affiliate commission attributed to ads.
statement_transaction_fee_affiliate_commission_amount	NUMERIC	Statement Transaction Fee Affiliate Commission	Affiliate commission paid for the transaction.
statement_transaction_fee_affiliate_commission_amount_before_pit	NUMERIC	Statement Transaction Fee Affiliate Commission Before PIT	Affiliate commission before personal income tax withholding.
statement_transaction_fee_affiliate_commission_deposit	NUMERIC	Statement Transaction Fee Affiliate Commission Deposit	Deposit held for affiliate commission.
statement_transaction_fee_affiliate_commission_release	NUMERIC	Statement Transaction Fee Affiliate Commission Release	Released portion of the affiliate commission deposit.
statement_transaction_fee_affiliate_partner_commission_amount	NUMERIC	Statement Transaction Fee Affiliate Partner Commission	Commission paid to affiliate partners.
statement_transaction_fee_bonus_cashback_service_fee_amount	NUMERIC	Statement Transaction Fee Bonus Cashback Service Fee	Bonus cashback service fee.
statement_transaction_fee_campaign_period_fee_cfp_amount	NUMERIC	Statement Transaction Fee Campaign Period Fee CFP	Campaign-period commission flat-price fee.
statement_transaction_fee_campaign_period_fee_cfp_tax_amount	NUMERIC	Statement Transaction Fee Campaign Period Fee CFP Tax	Tax portion of the campaign-period commission flat-price fee.
statement_transaction_fee_campaign_period_fee_sp_amount	NUMERIC	Statement Transaction Fee Campaign Period Fee SP	Campaign-period seller-pays fee.
statement_transaction_fee_campaign_period_fee_sp_tax_amount	NUMERIC	Statement Transaction Fee Campaign Period Fee SP Tax	Tax portion of the campaign-period seller-pays fee.
statement_transaction_fee_campaign_resource_fee	NUMERIC	Statement Transaction Fee Campaign Resource Fee	Campaign resource fee.
statement_transaction_fee_cofunded_creator_bonus_amount	NUMERIC	Statement Transaction Fee Cofunded Creator Bonus	Co-funded creator bonus.
statement_transaction_fee_cofunded_promotion_service_fee_amount	NUMERIC	Statement Transaction Fee Cofunded Promotion Service Fee	Co-funded promotion service fee.
statement_transaction_fee_credit_card_handling_fee_amount	NUMERIC	Statement Transaction Fee Credit Card Handling Fee	Credit card handling fee.
statement_transaction_fee_dt_handling_fee_amount	NUMERIC	Statement Transaction Fee DT Handling Fee	Direct-to-consumer handling fee.
statement_transaction_fee_dynamic_commission_amount	NUMERIC	Statement Transaction Fee Dynamic Commission	Dynamic commission applied to the transaction.
statement_transaction_fee_epr_pob_service_fee_amount	NUMERIC	Statement Transaction Fee EPR POB Service Fee	Extended producer responsibility / proof-of-buy service fee.
statement_transaction_fee_external_affiliate_marketing_fee_amount	NUMERIC	Statement Transaction Fee External Affiliate Marketing Fee	Fee for external affiliate marketing.
statement_transaction_fee_fee_per_item_sold_amount	NUMERIC	Statement Transaction Fee Per Item Sold	Per-item sold fee.

TikTok Shop Statement fields (statement_transaction_fee_flash_sales_service_fee_amount to statement_transaction_order_transaction_sku_transactions_fee_affiliate_commission_release)

ID	Type	Name	Description
statement_transaction_fee_flash_sales_service_fee_amount	NUMERIC	Statement Transaction Fee Flash Sales Service Fee	Flash sales service fee.
statement_transaction_fee_gmv_max_ad_fee_amount	NUMERIC	Statement Transaction Fee GMV Max Ad Fee	GMV Max ad fee.
statement_transaction_fee_installation_service_fee	NUMERIC	Statement Transaction Fee Installation Service Fee	Installation service fee.
statement_transaction_fee_live_specials_fee_amount	NUMERIC	Statement Transaction Fee Live Specials Fee	Live specials promotional fee.
statement_transaction_fee_mall_service_fee_amount	NUMERIC	Statement Transaction Fee Mall Service Fee	Mall service fee.
statement_transaction_fee_platform_commission_amount	NUMERIC	Statement Transaction Fee Platform Commission	Platform commission charged on the transaction.
statement_transaction_fee_platform_semi_managed_commission_fee	NUMERIC	Statement Transaction Fee Platform Semi-Managed Commission Fee	Commission fee for platform semi-managed shops.
statement_transaction_fee_platform_semi_managed_commission_fee_tax	NUMERIC	Statement Transaction Fee Platform Semi-Managed Commission Fee Tax	Tax portion of the platform semi-managed commission fee.
statement_transaction_fee_platform_special_service_fee_amount	NUMERIC	Statement Transaction Fee Platform Special Service Fee	Platform special service fee.
statement_transaction_fee_pre_order_service_fee_amount	NUMERIC	Statement Transaction Fee Pre Order Service Fee	Pre-order service fee.
statement_transaction_fee_referral_fee_amount	NUMERIC	Statement Transaction Fee Referral Fee	Referral fee charged on the transaction.
statement_transaction_fee_refund_administration_fee_amount	NUMERIC	Statement Transaction Fee Refund Administration Fee	Administration fee charged for refunds.
statement_transaction_fee_seller_growth_fee_amount	NUMERIC	Statement Transaction Fee Seller Growth Fee	Seller growth program fee.
statement_transaction_fee_seller_paylater_handling_fee_amount	NUMERIC	Statement Transaction Fee Seller Paylater Handling Fee	Seller pay-later handling fee.
statement_transaction_fee_sfp_service_fee_amount	NUMERIC	Statement Transaction Fee SFP Service Fee	Shipped-from-platform service fee.
statement_transaction_fee_shipping_fee_guarantee_service_fee	NUMERIC	Statement Transaction Fee Shipping Fee Guarantee Service Fee	Service fee for the shipping fee guarantee program.
statement_transaction_fee_smart_promotion_fee_amount	NUMERIC	Statement Transaction Fee Smart Promotion Fee	Smart promotion fee.
statement_transaction_fee_tap_shop_ads_commission	NUMERIC	Statement Transaction Fee Tap Shop Ads Commission	Tap shop ads commission.
statement_transaction_fee_tax_amount	NUMERIC	Statement Transaction Fee and Tax Amount	Total of fees and taxes for the transaction.
statement_transaction_fee_transaction_fee_amount	NUMERIC	Statement Transaction Fee Transaction Fee	Per-transaction fee.
statement_transaction_fee_tsp_commission_amount	NUMERIC	Statement Transaction Fee TSP Commission	TikTok shop partner (TSP) commission.
statement_transaction_fee_vn_fix_infrastructure_fee	NUMERIC	Statement Transaction Fee VN Fix Infrastructure Fee	Vietnam fixed infrastructure fee.
statement_transaction_fee_voucher_xtra_service_fee_amount	NUMERIC	Statement Transaction Fee Voucher Xtra Service Fee	Voucher Xtra promotional service fee.
statement_transaction_id	TEXT	Statement Transaction ID	The unique identifier of the statement transaction.
statement_transaction_order_create_datetime	TIMESTAMP	Statement Transaction Order Create Datetime	Time the underlying order was created. ISO 8601 datetime format (UTC).
statement_transaction_order_create_time	TIMESTAMP	Statement Transaction Order Create Time	Time the underlying order was created. Unix timestamp.
statement_transaction_order_id	TEXT	Statement Transaction Order ID	Identifier of the order the transaction is for.
statement_transaction_order_transaction_currency	TEXT	Statement Order Transaction Currency	Currency of the order transaction amounts (ISO 4217).
statement_transaction_order_transaction_fee_and_tax_amount	NUMERIC	Statement Order Transaction Fee and Tax Amount	Total fees and taxes for the order.
statement_transaction_order_transaction_order_create_datetime	TIMESTAMP	Statement Order Transaction Order Create Datetime	Time the underlying order was created. ISO 8601 datetime format (UTC).
statement_transaction_order_transaction_order_create_time	TIMESTAMP	Statement Order Transaction Order Create Time	Time the underlying order was created. Unix timestamp.
statement_transaction_order_transaction_order_id	TEXT	Statement Order Transaction Order ID	Identifier of the underlying order.
statement_transaction_order_transaction_revenue_amount	NUMERIC	Statement Order Transaction Revenue Amount	Total revenue contribution of the order.
statement_transaction_order_transaction_settlement_amount	NUMERIC	Statement Order Transaction Settlement Amount	Total settlement amount for the order.
statement_transaction_order_transaction_shipping_cost_amount	NUMERIC	Statement Order Transaction Shipping Cost Amount	Total shipping cost for the order.
statement_transaction_order_transaction_sku_transactions_fee_affiliate_ads_commission_amount	NUMERIC	Statement Order Transaction SKU Fee Affiliate Ads Commission	Affiliate commission attributed to ads.
statement_transaction_order_transaction_sku_transactions_fee_affiliate_commission_amount	NUMERIC	Statement Order Transaction SKU Fee Affiliate Commission	Affiliate commission paid for the SKU.
statement_transaction_order_transaction_sku_transactions_fee_affiliate_commission_amount_before_pit	NUMERIC	Statement Order Transaction SKU Fee Affiliate Commission Before PIT	Affiliate commission before personal income tax withholding.
statement_transaction_order_transaction_sku_transactions_fee_affiliate_commission_deposit	NUMERIC	Statement Order Transaction SKU Fee Affiliate Commission Deposit	Deposit held for affiliate commission.
statement_transaction_order_transaction_sku_transactions_fee_affiliate_commission_release	NUMERIC	Statement Order Transaction SKU Fee Affiliate Commission Release	Released portion of the affiliate commission deposit.

TikTok Shop Statement fields (statement_transaction_order_transaction_sku_transactions_fee_affiliate_partner_commission_amount to statement_transaction_order_transaction_sku_transactions_quantity)

ID	Type	Name	Description
statement_transaction_order_transaction_sku_transactions_fee_affiliate_partner_commission_amount	NUMERIC	Statement Order Transaction SKU Fee Affiliate Partner Commission	Commission paid to affiliate partners.
statement_transaction_order_transaction_sku_transactions_fee_bonus_cashback_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Bonus Cashback Service Fee	Bonus cashback service fee.
statement_transaction_order_transaction_sku_transactions_fee_campaign_period_fee_cfp_amount	NUMERIC	Statement Order Transaction SKU Fee Campaign Period Fee CFP	Campaign-period commission flat-price fee.
statement_transaction_order_transaction_sku_transactions_fee_campaign_period_fee_cfp_tax_amount	NUMERIC	Statement Order Transaction SKU Fee Campaign Period Fee CFP Tax	Tax portion of the campaign-period commission flat-price fee.
statement_transaction_order_transaction_sku_transactions_fee_campaign_period_fee_sp_amount	NUMERIC	Statement Order Transaction SKU Fee Campaign Period Fee SP	Campaign-period seller-pays fee.
statement_transaction_order_transaction_sku_transactions_fee_campaign_period_fee_sp_tax_amount	NUMERIC	Statement Order Transaction SKU Fee Campaign Period Fee SP Tax	Tax portion of the campaign-period seller-pays fee.
statement_transaction_order_transaction_sku_transactions_fee_campaign_resource_fee	NUMERIC	Statement Order Transaction SKU Fee Campaign Resource Fee	Campaign resource fee.
statement_transaction_order_transaction_sku_transactions_fee_cofunded_creator_bonus_amount	NUMERIC	Statement Order Transaction SKU Fee Cofunded Creator Bonus	Co-funded creator bonus.
statement_transaction_order_transaction_sku_transactions_fee_cofunded_promotion_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Cofunded Promotion Service Fee	Co-funded promotion service fee.
statement_transaction_order_transaction_sku_transactions_fee_credit_card_handling_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Credit Card Handling Fee	Credit card handling fee.
statement_transaction_order_transaction_sku_transactions_fee_dt_handling_fee_amount	NUMERIC	Statement Order Transaction SKU Fee DT Handling Fee	Direct-to-consumer handling fee.
statement_transaction_order_transaction_sku_transactions_fee_dynamic_commission_amount	NUMERIC	Statement Order Transaction SKU Fee Dynamic Commission	Dynamic commission applied to the SKU.
statement_transaction_order_transaction_sku_transactions_fee_epr_pob_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee EPR POB Service Fee	Extended producer responsibility / proof-of-buy service fee.
statement_transaction_order_transaction_sku_transactions_fee_external_affiliate_marketing_fee_amount	NUMERIC	Statement Order Transaction SKU Fee External Affiliate Marketing Fee	Fee for external affiliate marketing.
statement_transaction_order_transaction_sku_transactions_fee_fee_per_item_sold_amount	NUMERIC	Statement Order Transaction SKU Fee Per Item Sold	Per-item sold fee.
statement_transaction_order_transaction_sku_transactions_fee_flash_sales_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Flash Sales Service Fee	Flash sales service fee.
statement_transaction_order_transaction_sku_transactions_fee_gmv_max_ad_fee_amount	NUMERIC	Statement Order Transaction SKU Fee GMV Max Ad Fee	GMV Max ad fee.
statement_transaction_order_transaction_sku_transactions_fee_installation_service_fee	NUMERIC	Statement Order Transaction SKU Fee Installation Service Fee	Installation service fee.
statement_transaction_order_transaction_sku_transactions_fee_live_specials_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Live Specials Fee	Live specials promotional fee.
statement_transaction_order_transaction_sku_transactions_fee_mall_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Mall Service Fee	Mall service fee.
statement_transaction_order_transaction_sku_transactions_fee_platform_commission_amount	NUMERIC	Statement Order Transaction SKU Fee Platform Commission	Platform commission charged on the SKU.
statement_transaction_order_transaction_sku_transactions_fee_platform_semi_managed_commission_fee	NUMERIC	Statement Order Transaction SKU Fee Platform Semi-Managed Commission Fee	Commission fee for platform semi-managed shops.
statement_transaction_order_transaction_sku_transactions_fee_platform_semi_managed_commission_fee_tax	NUMERIC	Statement Order Transaction SKU Fee Platform Semi-Managed Commission Fee Tax	Tax portion of the platform semi-managed commission fee.
statement_transaction_order_transaction_sku_transactions_fee_platform_special_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Platform Special Service Fee	Platform special service fee.
statement_transaction_order_transaction_sku_transactions_fee_pre_order_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Pre Order Service Fee	Pre-order service fee.
statement_transaction_order_transaction_sku_transactions_fee_referral_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Referral Fee	Referral fee charged on the SKU.
statement_transaction_order_transaction_sku_transactions_fee_refund_administration_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Refund Administration Fee	Administration fee charged for SKU refunds.
statement_transaction_order_transaction_sku_transactions_fee_seller_growth_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Seller Growth Fee	Seller growth program fee.
statement_transaction_order_transaction_sku_transactions_fee_seller_paylater_handling_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Seller Paylater Handling Fee	Seller pay-later handling fee.
statement_transaction_order_transaction_sku_transactions_fee_sfp_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee SFP Service Fee	Shipped-from-platform service fee.
statement_transaction_order_transaction_sku_transactions_fee_shipping_fee_guarantee_service_fee	NUMERIC	Statement Order Transaction SKU Fee Shipping Fee Guarantee Service Fee	Service fee for the shipping fee guarantee program.
statement_transaction_order_transaction_sku_transactions_fee_smart_promotion_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Smart Promotion Fee	Smart promotion fee.
statement_transaction_order_transaction_sku_transactions_fee_tap_shop_ads_commission	NUMERIC	Statement Order Transaction SKU Fee Tap Shop Ads Commission	Tap shop ads commission.
statement_transaction_order_transaction_sku_transactions_fee_tax_amount	NUMERIC	Statement Order Transaction SKU Fee and Tax Amount	Fees and taxes attributable to this SKU.
statement_transaction_order_transaction_sku_transactions_fee_transaction_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Transaction Fee	Per-transaction fee for the SKU.
statement_transaction_order_transaction_sku_transactions_fee_tsp_commission_amount	NUMERIC	Statement Order Transaction SKU Fee TSP Commission	TikTok shop partner (TSP) commission.
statement_transaction_order_transaction_sku_transactions_fee_vn_fix_infrastructure_fee	NUMERIC	Statement Order Transaction SKU Fee VN Fix Infrastructure Fee	Vietnam fixed infrastructure fee.
statement_transaction_order_transaction_sku_transactions_fee_voucher_xtra_service_fee_amount	NUMERIC	Statement Order Transaction SKU Fee Voucher Xtra Service Fee	Voucher Xtra promotional service fee.
statement_transaction_order_transaction_sku_transactions_product_name	TEXT	Statement Order Transaction SKU Product Name	Display name of the product the SKU belongs to.
statement_transaction_order_transaction_sku_transactions_quantity	NUMERIC	Statement Order Transaction SKU Quantity	Quantity of the SKU in the transaction.

TikTok Shop Statement fields (statement_transaction_order_transaction_sku_transactions_revenue_amount to statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_seller_shipping_fee_discount_amount)

ID	Type	Name	Description
statement_transaction_order_transaction_sku_transactions_revenue_amount	NUMERIC	Statement Order Transaction SKU Revenue Amount	Revenue contribution attributable to this SKU.
statement_transaction_order_transaction_sku_transactions_revenue_cod_service_fee_amount	NUMERIC	Statement Order Transaction SKU Revenue COD Service Fee	COD service fee included in the SKU revenue.
statement_transaction_order_transaction_sku_transactions_revenue_distant_item_fee_amount	NUMERIC	Statement Order Transaction SKU Revenue Distant Item Fee	Distant-item fee included in the SKU revenue.
statement_transaction_order_transaction_sku_transactions_revenue_refund_cod_service_fee_amount	NUMERIC	Statement Order Transaction SKU Revenue Refund COD Service Fee	Refunded portion of the COD service fee.
statement_transaction_order_transaction_sku_transactions_revenue_refund_subtotal_before_discount_amount	NUMERIC	Statement Order Transaction SKU Revenue Refund Subtotal Before Discount	Refunded subtotal portion of the SKU revenue before discounts.
statement_transaction_order_transaction_sku_transactions_revenue_seller_discount_amount	NUMERIC	Statement Order Transaction SKU Revenue Seller Discount	Discount provided by the seller against the SKU revenue.
statement_transaction_order_transaction_sku_transactions_revenue_seller_discount_refund_amount	NUMERIC	Statement Order Transaction SKU Revenue Seller Discount Refund	Refunded portion of the seller's discount on the SKU.
statement_transaction_order_transaction_sku_transactions_revenue_subtotal_before_discount_amount	NUMERIC	Statement Order Transaction SKU Revenue Subtotal Before Discount	Subtotal of the SKU revenue before any discounts.
statement_transaction_order_transaction_sku_transactions_settlement_amount	NUMERIC	Statement Order Transaction SKU Settlement Amount	Settlement amount attributable to this SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_actual_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Actual Shipping Fee	Actual shipping fee charged for the SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_amount	NUMERIC	Statement Order Transaction SKU Shipping Cost Amount	Shipping cost attributable to this SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_customer_paid_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Customer Paid Shipping Fee	Shipping fee paid by the customer.
statement_transaction_order_transaction_sku_transactions_shipping_cost_distant_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Distant Shipping Fee	Distant-shipping fee for the SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_exchange_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Exchange Shipping Fee	Shipping fee for an exchange SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_failed_delivery_subsidy_amount	NUMERIC	Statement Order Transaction SKU Shipping Failed Delivery Subsidy	Subsidy granted for failed delivery attempts.
statement_transaction_order_transaction_sku_transactions_shipping_cost_fbt_free_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping FBT Free Shipping Fee	Fulfilled-by-TikTok free shipping fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_fbt_fulfillment_fee_reimbursement_amount	NUMERIC	Statement Order Transaction SKU Shipping FBT Fulfillment Fee Reimbursement	Reimbursement of the fulfilled-by-TikTok fulfillment fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_fbt_key_merchant_subsidy	NUMERIC	Statement Order Transaction SKU Shipping FBT Key Merchant Subsidy	Fulfilled-by-TikTok key merchant subsidy.
statement_transaction_order_transaction_sku_transactions_shipping_cost_fbt_overall_merchant_subsidy	NUMERIC	Statement Order Transaction SKU Shipping FBT Overall Merchant Subsidy	Fulfilled-by-TikTok overall merchant subsidy.
statement_transaction_order_transaction_sku_transactions_shipping_cost_free_return_subsidy_amount	NUMERIC	Statement Order Transaction SKU Shipping Free Return Subsidy	Subsidy for free returns.
statement_transaction_order_transaction_sku_transactions_shipping_cost_logistics_service_fee	NUMERIC	Statement Order Transaction SKU Shipping Logistics Service Fee	Logistics service fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_replacement_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Replacement Shipping Fee	Shipping fee for a replacement SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_return_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Return Shipping Fee	Shipping fee for a returned SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_return_shipping_fee_paid_buyer_amount	NUMERIC	Statement Order Transaction SKU Shipping Return Shipping Fee Paid By Buyer	Return shipping fee paid by the buyer.
statement_transaction_order_transaction_sku_transactions_shipping_cost_return_shipping_label_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Return Shipping Label Fee	Return shipping label fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_seller_self_shipping_service_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Seller Self Shipping Service Fee	Service fee charged when the seller ships independently.
statement_transaction_order_transaction_sku_transactions_shipping_cost_shipping_app_service_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping App Service Fee	Shipping app service fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_shipping_fee_discount_amount	NUMERIC	Statement Order Transaction SKU Shipping Fee Discount	Discount applied to the SKU shipping fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_shipping_insurance_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Insurance Fee	Shipping insurance fee for the SKU.
statement_transaction_order_transaction_sku_transactions_shipping_cost_signature_confirmation_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Signature Confirmation Fee	Signature-confirmation fee component of shipping.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_customer_shipping_fee_offset_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Customer Shipping Fee Offset	Supplementary offset against the customer-paid shipping fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_fbm_shipping_cost_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary FBM Shipping Cost	Fulfilled-by-merchant supplementary shipping cost.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_fbt_fulfillment_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary FBT Fulfillment Fee	Fulfilled-by-TikTok supplementary fulfillment fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_fbt_fulfillment_fee_reimbursement_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary FBT Fulfillment Fee Reimbursement	Supplementary reimbursement of the FBT fulfillment fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_fbt_shipping_cost_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary FBT Shipping Cost	Fulfilled-by-TikTok supplementary shipping cost.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_platform_shipping_fee_discount_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Platform Shipping Fee Discount	Platform-funded supplementary shipping fee discount.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_promo_shipping_incentive_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Promo Shipping Incentive	Supplementary promotional shipping incentive amount.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_refunded_customer_shipping_fee_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Refunded Customer Shipping Fee	Refunded portion of the customer-paid shipping fee.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_return_refund_subsidy_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Return Refund Subsidy	Subsidy for return refunds.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_seller_shipping_fee_discount_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Seller Shipping Fee Discount	Seller-funded supplementary shipping fee discount.

TikTok Shop Statement fields (statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_shipping_fee_guarantee_reimbursement to statement_transaction_shipping_cost_fbt_key_merchant_subsidy)

ID	Type	Name	Description
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_shipping_fee_guarantee_reimbursement	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Fee Guarantee Reimbursement	Reimbursement under the shipping fee guarantee program.
statement_transaction_order_transaction_sku_transactions_shipping_cost_supplementary_shipping_fee_subsidy_amount	NUMERIC	Statement Order Transaction SKU Shipping Supplementary Shipping Fee Subsidy	Supplementary shipping fee subsidy amount.
statement_transaction_order_transaction_sku_transactions_sku_id	TEXT	Statement Order Transaction SKU ID	TikTok Shop SKU identifier.
statement_transaction_order_transaction_sku_transactions_sku_name	TEXT	Statement Order Transaction SKU Name	SKU display name.
statement_transaction_order_transaction_sku_transactions_statement_id	TEXT	Statement Order Transaction SKU Statement ID	Identifier of the statement the SKU transaction belongs to.
statement_transaction_order_transaction_sku_transactions_tax_anti_dumping_duty_amount	NUMERIC	Statement Order Transaction SKU Tax Anti-Dumping Duty	Anti-dumping duty applied to the SKU.
statement_transaction_order_transaction_sku_transactions_tax_cedular_tax	NUMERIC	Statement Order Transaction SKU Tax Cedular Tax	Cedular tax (Philippines).
statement_transaction_order_transaction_sku_transactions_tax_customs_clearance_amount	NUMERIC	Statement Order Transaction SKU Tax Customs Clearance	Customs clearance fee applied to the SKU.
statement_transaction_order_transaction_sku_transactions_tax_customs_duty_amount	NUMERIC	Statement Order Transaction SKU Tax Customs Duty	Customs duty applied to the SKU.
statement_transaction_order_transaction_sku_transactions_tax_gst_amount	NUMERIC	Statement Order Transaction SKU Tax GST	Goods and services tax.
statement_transaction_order_transaction_sku_transactions_tax_import_vat_amount	NUMERIC	Statement Order Transaction SKU Tax Import VAT	Import VAT due on the SKU.
statement_transaction_order_transaction_sku_transactions_tax_isr_amount	NUMERIC	Statement Order Transaction SKU Tax ISR	Impuesto sobre la renta (ISR).
statement_transaction_order_transaction_sku_transactions_tax_iva_amount	NUMERIC	Statement Order Transaction SKU Tax IVA	Impuesto al valor agregado (IVA).
statement_transaction_order_transaction_sku_transactions_tax_local_vat_amount	NUMERIC	Statement Order Transaction SKU Tax Local VAT	Local VAT applied to the SKU.
statement_transaction_order_transaction_sku_transactions_tax_pit_amount	NUMERIC	Statement Order Transaction SKU Tax PIT	Personal income tax withheld.
statement_transaction_order_transaction_sku_transactions_tax_sales_tax_referral_fee_amount	NUMERIC	Statement Order Transaction SKU Tax Sales Tax Referral Fee	Sales tax portion of the referral fee.
statement_transaction_order_transaction_sku_transactions_tax_smart_promotion_fee_tax_amount	NUMERIC	Statement Order Transaction SKU Tax Smart Promotion Fee Tax	Tax portion of the smart promotion fee.
statement_transaction_order_transaction_sku_transactions_tax_sst_amount	NUMERIC	Statement Order Transaction SKU Tax SST	Sales and service tax (Malaysia).
statement_transaction_order_transaction_sku_transactions_tax_vat_amount	NUMERIC	Statement Order Transaction SKU Tax VAT	Value-added tax due on the SKU.
statement_transaction_reserve_amount	NUMERIC	Statement Transaction Reserve Amount	Amount held in reserve against the transaction.
statement_transaction_reserve_id	TEXT	Statement Transaction Reserve ID	Identifier of the reserve held against the transaction.
statement_transaction_reserve_status	TEXT	Statement Transaction Reserve Status	Status of the reserve, e.g. Collected.
statement_transaction_revenue_amount	NUMERIC	Statement Transaction Revenue Amount	Revenue contribution of this transaction.
statement_transaction_revenue_cod_service_fee_amount	NUMERIC	Statement Transaction Revenue COD Service Fee	Cash-on-delivery service fee included in the revenue.
statement_transaction_revenue_distant_item_fee_amount	NUMERIC	Statement Transaction Revenue Distant Item Fee	Distant-item fee included in the revenue.
statement_transaction_revenue_refund_cod_service_fee_amount	NUMERIC	Statement Transaction Revenue Refund COD Service Fee	Refunded portion of the COD service fee.
statement_transaction_revenue_refund_subtotal_before_discount_amount	NUMERIC	Statement Transaction Revenue Refund Subtotal Before Discount	Refunded subtotal portion before discounts.
statement_transaction_revenue_seller_discount_amount	NUMERIC	Statement Transaction Revenue Seller Discount	Discount provided by the seller against the revenue.
statement_transaction_revenue_seller_discount_refund_amount	NUMERIC	Statement Transaction Revenue Seller Discount Refund	Refunded portion of the seller's discount.
statement_transaction_revenue_subtotal_before_discount_amount	NUMERIC	Statement Transaction Revenue Subtotal Before Discount	Subtotal of the order revenue before any discounts.
statement_transaction_settlement_amount	NUMERIC	Statement Transaction Settlement Amount	Amount settled to the seller for this transaction.
statement_transaction_shipping_cost_actual_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Actual Shipping Fee	Actual shipping fee charged for the order.
statement_transaction_shipping_cost_amount	NUMERIC	Statement Transaction Shipping Cost Amount	Total shipping cost component of the transaction.
statement_transaction_shipping_cost_customer_paid_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Customer Paid Shipping Fee	Shipping fee paid by the customer.
statement_transaction_shipping_cost_distant_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Distant Shipping Fee	Distant-shipping fee for the order.
statement_transaction_shipping_cost_exchange_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Exchange Shipping Fee	Shipping fee for an exchange order.
statement_transaction_shipping_cost_failed_delivery_subsidy_amount	NUMERIC	Statement Transaction Shipping Failed Delivery Subsidy	Subsidy granted for failed delivery attempts.
statement_transaction_shipping_cost_fbt_free_shipping_fee_amount	NUMERIC	Statement Transaction Shipping FBT Free Shipping Fee	Fulfilled-by-TikTok free shipping fee.
statement_transaction_shipping_cost_fbt_fulfillment_fee_reimbursement_amount	NUMERIC	Statement Transaction Shipping FBT Fulfillment Fee Reimbursement	Reimbursement of the fulfilled-by-TikTok fulfillment fee.
statement_transaction_shipping_cost_fbt_key_merchant_subsidy	NUMERIC	Statement Transaction Shipping FBT Key Merchant Subsidy	Fulfilled-by-TikTok key merchant subsidy.

TikTok Shop Statement fields (statement_transaction_shipping_cost_fbt_overall_merchant_subsidy to statement_transaction_supplementary_seller_cofunded_discount_refund_amount)

ID	Type	Name	Description
statement_transaction_shipping_cost_fbt_overall_merchant_subsidy	NUMERIC	Statement Transaction Shipping FBT Overall Merchant Subsidy	Fulfilled-by-TikTok overall merchant subsidy.
statement_transaction_shipping_cost_free_return_subsidy_amount	NUMERIC	Statement Transaction Shipping Free Return Subsidy	Subsidy for free returns.
statement_transaction_shipping_cost_logistics_service_fee	NUMERIC	Statement Transaction Shipping Logistics Service Fee	Logistics service fee.
statement_transaction_shipping_cost_replacement_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Replacement Shipping Fee	Shipping fee for a replacement order.
statement_transaction_shipping_cost_return_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Return Shipping Fee	Shipping fee for a returned order.
statement_transaction_shipping_cost_return_shipping_fee_paid_buyer_amount	NUMERIC	Statement Transaction Shipping Return Shipping Fee Paid By Buyer	Return shipping fee that was paid by the buyer.
statement_transaction_shipping_cost_return_shipping_label_fee_amount	NUMERIC	Statement Transaction Shipping Return Shipping Label Fee	Return shipping label fee.
statement_transaction_shipping_cost_seller_self_shipping_service_fee_amount	NUMERIC	Statement Transaction Shipping Seller Self Shipping Service Fee	Service fee charged when the seller ships independently.
statement_transaction_shipping_cost_shipping_app_service_fee_amount	NUMERIC	Statement Transaction Shipping App Service Fee	Shipping app service fee.
statement_transaction_shipping_cost_shipping_fee_discount_amount	NUMERIC	Statement Transaction Shipping Fee Discount	Discount applied to the shipping fee.
statement_transaction_shipping_cost_shipping_fee_guarantee_reimbursement	NUMERIC	Statement Transaction Shipping Fee Guarantee Reimbursement	Reimbursement under the shipping fee guarantee program.
statement_transaction_shipping_cost_shipping_insurance_fee_amount	NUMERIC	Statement Transaction Shipping Insurance Fee	Shipping insurance fee for the order.
statement_transaction_shipping_cost_signature_confirmation_fee_amount	NUMERIC	Statement Transaction Shipping Signature Confirmation Fee	Signature-confirmation fee component of shipping.
statement_transaction_shipping_cost_supplementary_customer_shipping_fee	NUMERIC	Statement Transaction Shipping Supplementary Customer Shipping Fee	Supplementary customer shipping fee.
statement_transaction_shipping_cost_supplementary_customer_shipping_fee_offset_amount	NUMERIC	Statement Transaction Shipping Supplementary Customer Shipping Fee Offset	Supplementary offset applied against the customer-paid shipping fee.
statement_transaction_shipping_cost_supplementary_fbm_shipping_cost_amount	NUMERIC	Statement Transaction Shipping Supplementary FBM Shipping Cost	Fulfilled-by-merchant supplementary shipping cost.
statement_transaction_shipping_cost_supplementary_fbt_fulfillment_fee_amount	NUMERIC	Statement Transaction Shipping Supplementary FBT Fulfillment Fee	Fulfilled-by-TikTok supplementary fulfillment fee.
statement_transaction_shipping_cost_supplementary_fbt_fulfillment_fee_reimbursement_amount	NUMERIC	Statement Transaction Shipping Supplementary FBT Fulfillment Fee Reimbursement	Supplementary reimbursement of the FBT fulfillment fee.
statement_transaction_shipping_cost_supplementary_fbt_shipping_cost_amount	NUMERIC	Statement Transaction Shipping Supplementary FBT Shipping Cost	Fulfilled-by-TikTok supplementary shipping cost.
statement_transaction_shipping_cost_supplementary_platform_shipping_fee_discount_amount	NUMERIC	Statement Transaction Shipping Supplementary Platform Shipping Fee Discount	Platform-funded supplementary shipping fee discount.
statement_transaction_shipping_cost_supplementary_promo_shipping_incentive_amount	NUMERIC	Statement Transaction Shipping Supplementary Promo Shipping Incentive	Supplementary promotional shipping incentive amount.
statement_transaction_shipping_cost_supplementary_refund_customer_shipping_fee	NUMERIC	Statement Transaction Shipping Supplementary Refund Customer Shipping Fee	Refund of the supplementary customer shipping fee.
statement_transaction_shipping_cost_supplementary_refunded_customer_shipping_fee_amount	NUMERIC	Statement Transaction Shipping Supplementary Refunded Customer Shipping Fee	Refunded portion of the customer-paid shipping fee.
statement_transaction_shipping_cost_supplementary_return_refund_subsidy_amount	NUMERIC	Statement Transaction Shipping Supplementary Return Refund Subsidy	Subsidy for return refunds.
statement_transaction_shipping_cost_supplementary_seller_shipping_fee_discount_amount	NUMERIC	Statement Transaction Shipping Supplementary Seller Shipping Fee Discount	Seller-funded supplementary shipping fee discount.
statement_transaction_shipping_cost_supplementary_shipping_fee_subsidy_amount	NUMERIC	Statement Transaction Shipping Supplementary Shipping Fee Subsidy	Supplementary shipping fee subsidy amount.
statement_transaction_supplementary_customer_payment_amount	NUMERIC	Statement Transaction Supplementary Customer Payment	Customer payment captured for the transaction.
statement_transaction_supplementary_customer_refund_amount	NUMERIC	Statement Transaction Supplementary Customer Refund	Customer refund issued for the transaction.
statement_transaction_supplementary_platform_cofunded_discount_amount	NUMERIC	Statement Transaction Supplementary Platform Cofunded Discount	Platform-cofunded discount applied to the transaction.
statement_transaction_supplementary_platform_cofunded_discount_refund_amount	NUMERIC	Statement Transaction Supplementary Platform Cofunded Discount Refund	Refunded portion of the platform-cofunded discount.
statement_transaction_supplementary_platform_discount_amount	NUMERIC	Statement Transaction Supplementary Platform Discount	Platform discount applied to the transaction.
statement_transaction_supplementary_platform_discount_refund_amount	NUMERIC	Statement Transaction Supplementary Platform Discount Refund	Refunded portion of the platform discount.
statement_transaction_supplementary_retail_delivery_fee_amount	NUMERIC	Statement Transaction Supplementary Retail Delivery Fee	Retail delivery fee applied to the transaction.
statement_transaction_supplementary_retail_delivery_fee_payment_amount	NUMERIC	Statement Transaction Supplementary Retail Delivery Fee Payment	Retail delivery fee payment portion.
statement_transaction_supplementary_retail_delivery_fee_refund_amount	NUMERIC	Statement Transaction Supplementary Retail Delivery Fee Refund	Refunded retail delivery fee.
statement_transaction_supplementary_sales_tax_amount	NUMERIC	Statement Transaction Supplementary Sales Tax	Sales tax due on the transaction.
statement_transaction_supplementary_sales_tax_payment_amount	NUMERIC	Statement Transaction Supplementary Sales Tax Payment	Sales tax payment portion.
statement_transaction_supplementary_sales_tax_refund_amount	NUMERIC	Statement Transaction Supplementary Sales Tax Refund	Refunded sales tax portion.
statement_transaction_supplementary_seller_cofunded_discount_amount	NUMERIC	Statement Transaction Supplementary Seller Cofunded Discount	Seller-cofunded discount applied to the transaction.
statement_transaction_supplementary_seller_cofunded_discount_refund_amount	NUMERIC	Statement Transaction Supplementary Seller Cofunded Discount Refund	Refunded portion of the seller-cofunded discount.

TikTok Shop Statement fields (statement_transaction_tax_anti_dumping_duty_amount to statement_transaction_type)

ID	Type	Name	Description
statement_transaction_tax_anti_dumping_duty_amount	NUMERIC	Statement Transaction Tax Anti-Dumping Duty	Anti-dumping duty applied to the transaction.
statement_transaction_tax_cedular_tax	NUMERIC	Statement Transaction Tax Cedular Tax	Cedular tax (Philippines).
statement_transaction_tax_customs_clearance_amount	NUMERIC	Statement Transaction Tax Customs Clearance	Customs clearance fee applied to the transaction.
statement_transaction_tax_customs_duty_amount	NUMERIC	Statement Transaction Tax Customs Duty	Customs duty applied to the transaction.
statement_transaction_tax_gst_amount	NUMERIC	Statement Transaction Tax GST	Goods and services tax.
statement_transaction_tax_import_vat_amount	NUMERIC	Statement Transaction Tax Import VAT	Import VAT due on the transaction.
statement_transaction_tax_isr_amount	NUMERIC	Statement Transaction Tax ISR	Impuesto sobre la renta (ISR).
statement_transaction_tax_iva_amount	NUMERIC	Statement Transaction Tax IVA	Impuesto al valor agregado (IVA).
statement_transaction_tax_local_vat_amount	NUMERIC	Statement Transaction Tax Local VAT	Local VAT applied to the transaction.
statement_transaction_tax_pit_amount	NUMERIC	Statement Transaction Tax PIT	Personal income tax withheld.
statement_transaction_tax_sales_tax_referral_fee_amount	NUMERIC	Statement Transaction Tax Sales Tax Referral Fee	Sales tax portion of the referral fee.
statement_transaction_tax_smart_promotion_fee_tax_amount	NUMERIC	Statement Transaction Tax Smart Promotion Fee Tax	Tax portion of the smart promotion fee.
statement_transaction_tax_sst_amount	NUMERIC	Statement Transaction Tax SST	Sales and service tax (Malaysia).
statement_transaction_tax_vat_amount	NUMERIC	Statement Transaction Tax VAT	Value-added tax due on the transaction.
statement_transaction_type	TEXT	Statement Transaction Type	Type of the transaction, e.g. ORDER.

TikTok Shop Unsettled Transaction fields

The Unsettled Transaction report of the TikTok Shop connector includes 84 fields.

TikTok Shop Unsettled Transaction fields (unsettled_transaction_adjustment_id to unsettled_transaction_order_delivery_time)

ID	Type	Name	Description
unsettled_transaction_adjustment_id	TEXT	Unsettled Transaction Adjustment ID	Identifier of the adjustment associated with the transaction.
unsettled_transaction_adjustment_order_id	TEXT	Unsettled Transaction Adjustment Order ID	Order identifier the adjustment refers to.
unsettled_transaction_currency	TEXT	Unsettled Transaction Currency	Currency of the transaction amounts (ISO 4217).
unsettled_transaction_est_adjustment_amount	NUMERIC	Unsettled Transaction Estimated Adjustment Amount	Estimated adjustment amount for the transaction.
unsettled_transaction_est_fee_tax_amount	NUMERIC	Unsettled Transaction Estimated Fee and Tax Amount	Estimated total of fees and taxes for the transaction.
unsettled_transaction_est_revenue_amount	NUMERIC	Unsettled Transaction Estimated Revenue Amount	Estimated revenue contribution of the transaction.
unsettled_transaction_est_settlement_amount	NUMERIC	Unsettled Transaction Estimated Settlement Amount	Estimated amount that will be settled to the seller.
unsettled_transaction_est_shipping_cost_amount	NUMERIC	Unsettled Transaction Estimated Shipping Cost Amount	Estimated shipping cost component of the transaction.
unsettled_transaction_estimated_settlement	TEXT	Unsettled Transaction Estimated Settlement	Estimated settlement timing for the transaction as a human-readable description, e.g. 'Delivered + 5 days'.
unsettled_transaction_fee_affiliate_ads_commission_amount	NUMERIC	Unsettled Transaction Fee Affiliate Ads Commission	Affiliate commission attributed to ads.
unsettled_transaction_fee_affiliate_commission_amount	NUMERIC	Unsettled Transaction Fee Affiliate Commission	Affiliate commission paid for the transaction.
unsettled_transaction_fee_affiliate_commission_before_pit_amount	NUMERIC	Unsettled Transaction Fee Affiliate Commission Before PIT	Affiliate commission before personal income tax withholding.
unsettled_transaction_fee_affiliate_partner_commission_amount	NUMERIC	Unsettled Transaction Fee Affiliate Partner Commission	Commission paid to affiliate partners.
unsettled_transaction_fee_bonus_cashback_service_fee_amount	NUMERIC	Unsettled Transaction Fee Bonus Cashback Service Fee	Bonus cashback service fee.
unsettled_transaction_fee_campaign_period_fee_cfp_amount	NUMERIC	Unsettled Transaction Fee Campaign Period Fee CFP	Campaign-period commission flat-price fee.
unsettled_transaction_fee_campaign_period_fee_cfp_tax_amount	NUMERIC	Unsettled Transaction Fee Campaign Period Fee CFP Tax	Tax portion of the campaign-period commission flat-price fee.
unsettled_transaction_fee_campaign_period_fee_sp_amount	NUMERIC	Unsettled Transaction Fee Campaign Period Fee SP	Campaign-period seller-pays fee.
unsettled_transaction_fee_campaign_period_fee_sp_tax_amount	NUMERIC	Unsettled Transaction Fee Campaign Period Fee SP Tax	Tax portion of the campaign-period seller-pays fee.
unsettled_transaction_fee_credit_card_handling_fee_amount	NUMERIC	Unsettled Transaction Fee Credit Card Handling Fee	Credit card handling fee.
unsettled_transaction_fee_dynamic_commission_amount	NUMERIC	Unsettled Transaction Fee Dynamic Commission	Dynamic commission applied to the transaction.
unsettled_transaction_fee_live_specials_fee_amount	NUMERIC	Unsettled Transaction Fee Live Specials Fee	Live specials promotional fee.
unsettled_transaction_fee_mall_service_fee_amount	NUMERIC	Unsettled Transaction Fee Mall Service Fee	Mall service fee.
unsettled_transaction_fee_pit_withheld_from_ads_commission_amount	NUMERIC	Unsettled Transaction Fee PIT Withheld From Ads Commission	Personal income tax withheld from the ads commission.
unsettled_transaction_fee_platform_commission_amount	NUMERIC	Unsettled Transaction Fee Platform Commission	Platform commission charged on the transaction.
unsettled_transaction_fee_platform_special_service_fee_amount	NUMERIC	Unsettled Transaction Fee Platform Special Service Fee	Platform special service fee.
unsettled_transaction_fee_referral_fee_amount	NUMERIC	Unsettled Transaction Fee Referral Fee	Referral fee charged on the transaction.
unsettled_transaction_fee_refund_administration_fee_amount	NUMERIC	Unsettled Transaction Fee Refund Administration Fee	Administration fee charged for refunds.
unsettled_transaction_fee_retail_delivery_fee_amount	NUMERIC	Unsettled Transaction Fee Retail Delivery Fee	Retail delivery fee.
unsettled_transaction_fee_retail_delivery_fee_payment_amount	NUMERIC	Unsettled Transaction Fee Retail Delivery Fee Payment	Retail delivery fee payment portion.
unsettled_transaction_fee_retail_delivery_fee_refund_amount	NUMERIC	Unsettled Transaction Fee Retail Delivery Fee Refund	Refunded retail delivery fee.
unsettled_transaction_fee_seller_growth_fee_amount	NUMERIC	Unsettled Transaction Fee Seller Growth Fee	Seller growth program fee.
unsettled_transaction_fee_sfp_service_fee_amount	NUMERIC	Unsettled Transaction Fee SFP Service Fee	Shipped-from-platform service fee.
unsettled_transaction_fee_smart_promotion_fee_amount	NUMERIC	Unsettled Transaction Fee Smart Promotion Fee	Smart promotion fee.
unsettled_transaction_fee_transaction_fee_amount	NUMERIC	Unsettled Transaction Fee Transaction Fee	Per-transaction fee.
unsettled_transaction_fee_vn_fix_infrastructure_fee	NUMERIC	Unsettled Transaction Fee VN Fix Infrastructure Fee	Vietnam fixed infrastructure fee.
unsettled_transaction_id	TEXT	Unsettled Transaction ID	The unique identifier of the unsettled transaction.
unsettled_transaction_order_create_datetime	TIMESTAMP	Unsettled Transaction Order Create Datetime	Time the underlying order was created. ISO 8601 datetime format (UTC).
unsettled_transaction_order_create_time	TIMESTAMP	Unsettled Transaction Order Create Time	Time the underlying order was created. Unix timestamp.
unsettled_transaction_order_delivery_datetime	TIMESTAMP	Unsettled Transaction Order Delivery Datetime	Time the underlying order was delivered. ISO 8601 datetime format (UTC).
unsettled_transaction_order_delivery_time	TIMESTAMP	Unsettled Transaction Order Delivery Time	Time the underlying order was delivered. Unix timestamp.

TikTok Shop Unsettled Transaction fields (unsettled_transaction_order_id to unsettled_transaction_tax_smart_promotion_fee_tax_amount)

ID	Type	Name	Description
unsettled_transaction_order_id	TEXT	Unsettled Transaction Order ID	Identifier of the underlying order.
unsettled_transaction_revenue_cod_service_fee_amount	NUMERIC	Unsettled Transaction Revenue COD Service Fee	Cash-on-delivery service fee included in the revenue.
unsettled_transaction_revenue_distant_item_fee_amount	NUMERIC	Unsettled Transaction Revenue Distant Item Fee	Distant-item fee included in the revenue.
unsettled_transaction_revenue_refund_cod_service_fee_amount	NUMERIC	Unsettled Transaction Revenue Refund COD Service Fee	Refunded portion of the COD service fee.
unsettled_transaction_revenue_refund_subtotal_before_discount_amount	NUMERIC	Unsettled Transaction Revenue Refund Subtotal Before Discount	Refunded subtotal portion of the revenue before discounts.
unsettled_transaction_revenue_seller_discount_amount	NUMERIC	Unsettled Transaction Revenue Seller Discount	Discount provided by the seller against the revenue.
unsettled_transaction_revenue_seller_discount_refund_amount	NUMERIC	Unsettled Transaction Revenue Seller Discount Refund	Refunded portion of the seller's discount.
unsettled_transaction_revenue_subtotal_before_discount_amount	NUMERIC	Unsettled Transaction Revenue Subtotal Before Discount	Subtotal of the order revenue before any discounts.
unsettled_transaction_shipping_cost_actual_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Actual Shipping Fee	Actual shipping fee charged for the order.
unsettled_transaction_shipping_cost_customer_paid_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Customer Paid Shipping Fee	Shipping fee paid by the customer.
unsettled_transaction_shipping_cost_distant_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Distant Shipping Fee	Distant-shipping fee for the order.
unsettled_transaction_shipping_cost_exchange_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Exchange Shipping Fee	Shipping fee for an exchange order.
unsettled_transaction_shipping_cost_fbt_key_merchant_subsidy	NUMERIC	Unsettled Transaction Shipping FBT Key Merchant Subsidy	Fulfilled-by-TikTok key merchant subsidy.
unsettled_transaction_shipping_cost_fbt_overall_merchant_subsidy	NUMERIC	Unsettled Transaction Shipping FBT Overall Merchant Subsidy	Fulfilled-by-TikTok overall merchant subsidy.
unsettled_transaction_shipping_cost_logistics_service_fee	NUMERIC	Unsettled Transaction Shipping Logistics Service Fee	Logistics service fee.
unsettled_transaction_shipping_cost_replacement_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Replacement Shipping Fee	Shipping fee for a replacement order.
unsettled_transaction_shipping_cost_return_shipping_fee_amount	NUMERIC	Unsettled Transaction Shipping Return Shipping Fee	Shipping fee for a returned order.
unsettled_transaction_shipping_cost_shipping_app_service_fee_amount	NUMERIC	Unsettled Transaction Shipping App Service Fee	Shipping app service fee.
unsettled_transaction_shipping_cost_shipping_fee_discount_amount	NUMERIC	Unsettled Transaction Shipping Fee Discount	Discount applied to the shipping fee.
unsettled_transaction_shipping_cost_shipping_insurance_fee_amount	NUMERIC	Unsettled Transaction Shipping Insurance Fee	Shipping insurance fee for the order.
unsettled_transaction_shipping_cost_signature_confirmation_fee_amount	NUMERIC	Unsettled Transaction Shipping Signature Confirmation Fee	Signature-confirmation fee component of shipping.
unsettled_transaction_shipping_cost_supplementary_customer_shipping_fee_offset_amount	NUMERIC	Unsettled Transaction Shipping Supplementary Customer Shipping Fee Offset	Supplementary offset applied against the customer-paid shipping fee.
unsettled_transaction_shipping_cost_supplementary_fbm_shipping_cost_amount	NUMERIC	Unsettled Transaction Shipping Supplementary FBM Shipping Cost	Fulfilled-by-merchant supplementary shipping cost.
unsettled_transaction_shipping_cost_supplementary_fbt_fulfillment_fee_amount	NUMERIC	Unsettled Transaction Shipping Supplementary FBT Fulfillment Fee	Fulfilled-by-TikTok supplementary fulfillment fee.
unsettled_transaction_shipping_cost_supplementary_fbt_shipping_cost_amount	NUMERIC	Unsettled Transaction Shipping Supplementary FBT Shipping Cost	Fulfilled-by-TikTok supplementary shipping cost.
unsettled_transaction_shipping_cost_supplementary_platform_shipping_fee_discount_amount	NUMERIC	Unsettled Transaction Shipping Supplementary Platform Shipping Fee Discount	Platform-funded supplementary shipping fee discount.
unsettled_transaction_shipping_cost_supplementary_promo_shipping_incentive_amount	NUMERIC	Unsettled Transaction Shipping Supplementary Promo Shipping Incentive	Supplementary promotional shipping incentive amount.
unsettled_transaction_shipping_cost_supplementary_seller_shipping_fee_discount_amount	NUMERIC	Unsettled Transaction Shipping Supplementary Seller Shipping Fee Discount	Seller-funded supplementary shipping fee discount.
unsettled_transaction_shipping_cost_supplementary_shipping_fee_subsidy_amount	NUMERIC	Unsettled Transaction Shipping Supplementary Shipping Fee Subsidy	Supplementary shipping fee subsidy amount.
unsettled_transaction_status	TEXT	Unsettled Transaction Status	The status of the transaction, e.g. UNSETTLED.
unsettled_transaction_tax_cedular_tax	NUMERIC	Unsettled Transaction Tax Cedular Tax	Cedular tax (Philippines).
unsettled_transaction_tax_customs_clearance_amount	NUMERIC	Unsettled Transaction Tax Customs Clearance	Customs clearance fee applied to the transaction.
unsettled_transaction_tax_customs_duty_amount	NUMERIC	Unsettled Transaction Tax Customs Duty	Customs duty applied to the transaction.
unsettled_transaction_tax_gst_amount	NUMERIC	Unsettled Transaction Tax GST	Goods and services tax.
unsettled_transaction_tax_import_vat_amount	NUMERIC	Unsettled Transaction Tax Import VAT	Import VAT due on the transaction.
unsettled_transaction_tax_sales_tax_amount	NUMERIC	Unsettled Transaction Tax Sales Tax	Sales tax due on the transaction.
unsettled_transaction_tax_sales_tax_payment_amount	NUMERIC	Unsettled Transaction Tax Sales Tax Payment	Sales tax payment portion.
unsettled_transaction_tax_sales_tax_referral_fee_amount	NUMERIC	Unsettled Transaction Tax Sales Tax Referral Fee	Sales tax portion of the referral fee.
unsettled_transaction_tax_sales_tax_refund_amount	NUMERIC	Unsettled Transaction Tax Sales Tax Refund	Refunded sales tax portion.
unsettled_transaction_tax_smart_promotion_fee_tax_amount	NUMERIC	Unsettled Transaction Tax Smart Promotion Fee Tax	Tax portion of the smart promotion fee.

TikTok Shop Unsettled Transaction fields (unsettled_transaction_tax_sst_amount to unsettled_transaction_unsettled_reason)

ID	Type	Name	Description
unsettled_transaction_tax_sst_amount	NUMERIC	Unsettled Transaction Tax SST	Sales and service tax (Malaysia).
unsettled_transaction_tax_vat_amount	NUMERIC	Unsettled Transaction Tax VAT	Value-added tax due on the transaction.
unsettled_transaction_type	TEXT	Unsettled Transaction Type	The type of the unsettled transaction, e.g. ORDER.
unsettled_transaction_unsettled_reason	TEXT	Unsettled Transaction Unsettled Reason	Reason the transaction is still unsettled.

TikTok Shop Withdrawal fields

The Withdrawal report of the TikTok Shop connector includes 7 fields.

ID	Type	Name	Description
withdrawal_amount	NUMERIC	Withdrawal Amount	The withdrawal amount.
withdrawal_create_datetime	TIMESTAMP	Withdrawal Create Datetime	The time when the withdrawal was created. ISO 8601 datetime format (UTC).
withdrawal_create_time	TIMESTAMP	Withdrawal Create Time	The time when the withdrawal was created. Unix timestamp.
withdrawal_currency	TEXT	Withdrawal Currency	Currency of the withdrawal amount (ISO 4217).
withdrawal_id	TEXT	Withdrawal ID	The unique identifier of the withdrawal.
withdrawal_status	TEXT	Withdrawal Status	The status of the withdrawal, e.g. PROCESSING.
withdrawal_type	TEXT	Withdrawal Type	The type of the withdrawal. Possible values: WITHDRAW, SETTLE, TRANSFER, REVERSE.

TikTok Shop other fields

The TikTok Shop connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The TikTok Shop account ID.
account_name	TEXT	Account Name	The TikTok Shop account name.
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The Date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors