Orders and cancellations

Orders and cancellations

Schema Name - tiktok_source_data

Cancellations

Table Name: tiktok_shop_cancellations

Column Name	Data type	Description
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Display Name for the account
shop_id	String	TikTok Shop identifier (distribution key)
open_id	String	TikTok user open ID
cancel_id	String	Unique cancellation request identifier
order_id	String	Original order identifier
downloaded_date	Date	Date the data was downloaded
cancel_type	String	Cancellation type: CANCEL, RETURN, or REFUND_ONLY.
cancel_status	String	Current status of the cancellation request
role	String	Who initiated the cancellation: BUYER, SELLER, or PLATFORM.
cancel_reason	String	Cancellation reason code
cancel_reason_text	String	Cancellation reason free-text description
refund_amount_currency	String	Currency code for refund amounts
refund_amount_total	Numeric	Total refund amount
refund_amount_subtotal	Numeric	Subtotal refund
refund_amount_shipping_fee	Numeric	Refund on shipping fee
refund_amount_tax	Numeric	Refund on tax
refund_amount_retail_delivery_fee	Numeric	Refund on retail delivery fee
refund_amount_buyer_service_fee	Numeric	Refund on buyer service fee
create_time	DateTime	Timestamp when the cancellation was created
update_time	DateTime	Timestamp when the cancellation was last updated
download_time	DateTime	Timestamp when the record was ingested

Cancellation Line Items

Table Name: tiktok_shop_cancellation_line_items

Column Name	Data type	Description
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Display Name for the account
shop_id	String	TikTok Shop identifier (distribution key)
open_id	String	TikTok user open ID
cancel_id	String	Cancellation request identifier
order_id	String	Original order identifier
downloaded_date	Date	Date the data was downloaded
cancel_line_item_id	String	Unique identifier for this cancellation line item
order_line_item_id	String	Original order line item ID being cancelled
sku_id	String	SKU identifier
sku_name	String	SKU display name or variant name
product_name	String	Product name
seller_sku	String	Seller-defined SKU code
product_image_url	String	Product image URL
product_image_width	Integer	Product image width in pixels
product_image_height	Integer	Product image height in pixels
refund_amount_currency	String	Currency code for refund amounts
refund_amount_total	Numeric	Total refund amount for this line item
refund_amount_subtotal	Numeric	Subtotal refund for the product
refund_amount_shipping_fee	Numeric	Refund on shipping fee
refund_amount_tax	Numeric	Refund on tax
refund_amount_retail_delivery_fee	Numeric	Refund on retail delivery fee
refund_amount_buyer_service_fee	Numeric	Refund on buyer service fee
download_time	DateTime	Timestamp when the record was ingested

Cancellation Seller Actions

Table Name: tiktok_shop_cancellation_seller_actions

Column Name	Data type	Description
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Display Name for the account
shop_id	String	TikTok Shop identifier (distribution key)
open_id	String	TikTok user open ID
cancel_id	String	Cancellation request identifier
order_id	String	Original order identifier
downloaded_date	Date	Date the data was downloaded
action	String	Seller action available, such as APPROVE or REJECT.
deadline	DateTime	Deadline by which the seller must take this action
download_time	DateTime	Timestamp when the record was ingested

Orders

Table Name: tiktok_shop_orders

Column Name	Data type	Description
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Display Name for the account
shop_id	String	TikTok Shop identifier (distribution key)
open_id	String	TikTok user open ID
order_id	String	Unique order identifier
downloaded_date	Date	Date the data was downloaded
status	String	Current order status, such as UNPAID, SHIPPED, DELIVERED, or CANCELLED.
order_type	String	Order type: NORMAL, REPLACEMENT, or EXCHANGE.
fulfillment_type	String	Fulfillment type: TIKTOK or SELLER.
delivery_type	String	Delivery type
shipping_type	String	Shipping type
create_time	DateTime	Timestamp when the order was created
update_time	DateTime	Timestamp when the order was last updated
paid_time	DateTime	Timestamp when the order was paid
cancel_time	DateTime	Timestamp when the order was cancelled
delivery_time	DateTime	Timestamp when the order was delivered
rts_time	DateTime	Ready-to-ship timestamp
collection_time	DateTime	Timestamp when the carrier collected the order
request_cancel_time	DateTime	Timestamp when cancellation was requested
rts_sla_time	DateTime	SLA deadline for ready-to-ship
tts_sla_time	DateTime	Time-to-ship SLA deadline
delivery_sla_time	DateTime	Delivery SLA deadline
cancel_order_sla_time	DateTime	Cancellation SLA deadline
shipping_due_time	DateTime	Shipping due time
collection_due_time	DateTime	Collection due time
delivery_due_time	DateTime	Delivery due time
delivery_option_required_delivery_time	DateTime	Required delivery time for the selected delivery option
pick_up_cut_off_time	DateTime	Pick-up cut-off time
fast_dispatch_sla_time	DateTime	Fast dispatch SLA deadline
release_date	DateTime	Order release date
recommended_shipping_time	DateTime	Recommended shipping time
buyer_user_id	String	Buyer's TikTok user ID
buyer_email	String	Buyer email address
buyer_message	String	Message from buyer to seller
seller_note	String	Internal note from seller
is_cod	Boolean	Whether this is a cash-on-delivery order
is_sample_order	Boolean	Whether this is a sample order
is_replacement_order	Boolean	Whether this is a replacement order
replaced_order_id	String	Original order ID that this order replaces
is_exchange_order	Boolean	Whether this is an exchange order
exchange_source_order_id	String	Source order ID for exchange orders
is_on_hold_order	Boolean	Whether the order is on hold
is_buyer_request_cancel	Boolean	Whether the buyer requested cancellation
has_updated_recipient_address	Boolean	Whether the recipient address was updated
tracking_number	String	Shipment tracking number
shipping_provider	String	Shipping provider or carrier name
shipping_provider_id	String	Shipping provider or carrier ID
warehouse_id	String	Warehouse ID used for fulfillment
delivery_option_id	String	Selected delivery option ID
delivery_option_name	String	Selected delivery option name
cancel_reason	String	Cancellation reason code
cancellation_initiator	String	Who initiated the cancellation
split_or_combine_tag	String	Tag indicating a split or combined order
auto_combine_group_id	String	Auto-combine group identifier
commerce_platform	String	Commerce platform source
need_upload_invoice	String	Whether invoice upload is needed
cpf	String	Brazilian CPF tax document number
cpf_name	String	Name associated with the CPF number
consultation_id	String	Consultation or chat session identifier
fast_delivery_program	String	Fast delivery program type
fulfillment_priority_level	Integer	Priority level for fulfillment
handling_duration_days	Integer	Handling duration in days
handling_duration_type	String	Handling duration type
payment_currency	String	Currency code for payment amounts
payment_total_amount	Numeric	Total order payment amount
payment_sub_total	Numeric	Order subtotal before shipping and fees
payment_shipping_fee	Numeric	Shipping fee paid by buyer
payment_original_total_product_price	Numeric	Original total product price before discounts
payment_original_shipping_fee	Numeric	Original shipping fee before discounts
payment_seller_discount	Numeric	Total seller-funded discount
payment_platform_discount	Numeric	Total platform-funded discount
payment_shipping_fee_seller_discount	Numeric	Seller-funded shipping discount
payment_shipping_fee_platform_discount	Numeric	Platform-funded shipping discount
payment_shipping_fee_cofunded_discount	Numeric	Co-funded shipping discount
payment_tax	Numeric	Total tax collected
payment_product_tax	Numeric	Tax on products
payment_shipping_fee_tax	Numeric	Tax on shipping fee
payment_retail_delivery_fee	Numeric	Retail delivery fee
payment_small_order_fee	Numeric	Small order fee
payment_buyer_service_fee	Numeric	Buyer service fee
payment_handling_fee	Numeric	Handling fee
payment_shipping_insurance_fee	Numeric	Shipping insurance fee
payment_item_insurance_fee	Numeric	Item insurance fee
payment_item_insurance_tax	Numeric	Tax on item insurance
payment_method_name	String	Payment method used, such as credit card or PayPal
recipient_name	String	Recipient full name
recipient_first_name	String	Recipient first name
recipient_last_name	String	Recipient last name
recipient_first_name_local_script	String	Recipient first name in local script
recipient_last_name_local_script	String	Recipient last name in local script
recipient_phone_number	String	Recipient phone number
recipient_full_address	String	Full shipping address
recipient_address_detail	String	Detailed address information
recipient_address_line1	String	Address line 1
recipient_address_line2	String	Address line 2
recipient_address_line3	String	Address line 3
recipient_address_line4	String	Address line 4
recipient_postal_code	String	Recipient postal or ZIP code
recipient_region_code	String	Recipient country or region code
recipient_post_town	String	Recipient post town
delivery_preferences_drop_off_location	String	Preferred delivery drop-off location
download_time	DateTime	Timestamp when the record was ingested

Order Line Items

Table Name: tiktok_shop_order_line_items

Column Name	Data type	Description
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Display Name for the account
shop_id	String	TikTok Shop identifier (distribution key)
open_id	String	TikTok user open ID
order_id	String	Order identifier
line_item_id	String	Unique order line item identifier
downloaded_date	Date	Date the data was downloaded
sku_id	String	SKU identifier
product_id	String	Product identifier
product_name	String	Product display name
sku_name	String	SKU variant name
seller_sku	String	Seller-defined SKU code
sku_image	String	SKU image URL
sku_type	String	SKU type: NORMAL or COMBINED.
order_type	String	Order type: NORMAL, REPLACEMENT, or EXCHANGE.
original_price	Numeric	Original listed price of the SKU
sale_price	Numeric	Actual sale price after discounts
seller_discount	Numeric	Discount amount applied by the seller
platform_discount	Numeric	Discount amount applied by TikTok
pfand_fee	Numeric	Deposit fee for applicable products
retail_delivery_fee	Numeric	Retail delivery fee for this line item
buyer_service_fee	Numeric	Buyer service fee
small_order_fee	Numeric	Small order fee
gift_retail_price	Numeric	Retail price when this is a gift item
package_id	String	Package that shipped this line item
package_status	String	Shipping package status
display_status	String	Display status shown to the buyer
tracking_number	String	Shipment tracking number
shipping_provider_id	String	Shipping provider or carrier identifier
shipping_provider_name	String	Shipping provider or carrier name
cancel_reason	String	Cancellation reason when this item was cancelled
cancel_user	String	Who cancelled the item: BUYER, SELLER, or PLATFORM.
rts_time	DateTime	Ready-to-ship timestamp for this line item
handling_duration_days	Integer	Handling duration in days
handling_duration_type	String	Handling duration type: WORKING_DAYS or CALENDAR_DAYS.
is_gift	Boolean	Whether this line item is a gift
is_dangerous_good	Boolean	Whether this item is classified as dangerous goods
needs_prescription	Boolean	Whether a prescription is required
currency	String	Currency code for all monetary amounts
download_time	DateTime	Timestamp when the record was ingested