ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBC
1
Order IDOrder Status
Order Substatus
Cancelation/Return Type
Normal or Pre-order
SKU IDSeller SKUProduct NameVariationQuantity
Sku Quantity of return
SKU Unit Original Price
SKU Subtotal Before Discount
SKU Platform Discount
SKU Seller Discount
SKU Subtotal After Discount
Shipping Fee After Discount
Original Shipping Fee
Shipping Fee Seller Discount
Shipping Fee Platform Discount
Payment platform discountTaxes
Small Order Fee
Order Amount
Order Refund Amount
Created TimePaid TimeRTS TimeShipped Time
Delivered Time
Cancelled Time
Cancel By
Cancel Reason
Fulfillment Type
Warehouse Name
Tracking ID
Delivery Option
Shipping Provider Name
Buyer Message
Buyer Username
RecipientPhone #ZipcodeCountryProvinceDistrict
Detail Address
Additional address information
Payment Method
Weight(kg)
Product Category
Package IDSeller Note
Checked Status
Checked Marked by
2
Platform unique order ID.
Current order status.
The filed to explain the order is in cancellation or in return/refund.
Platform SKU ID.
Seller sku input by the seller in the product system.
Platform product name.Platform SKU variation
SKU sold quantity in the order.
SKU returned quantity in the order.
1 SKU original price.
It equals to SKU Unit Original Price * Sku Quantity.
Total platform discount in this SKU ID.
Total seller discount in this SKU ID.
It equals SKU Subtotal Before Discount - SKU Platform Discount - SKU Seller Discount.
It equals to Original Shipping Fee - Shipping Fee Seller Discount - Shipping Fee Platform Discount.
The order's original shipping fee.
The order's shipping fee discount from the seller.
The order's shipping fee discount from the platform.
The discount provided by a third-party payment platform, which the buyer used to place the order.
Small order fee is a service fee charged by TikTok Shop for processing small value orders
Order total amount paid by the buyer.
Order total refund amount of all returned SKUs.
Order created time.
Order paid time.
The time when the seller clicks 'arrange shipment'.
The time when the order status changes to In Transit.
The time when the order status changes to Delivered.
The time when the order status changes to Cancelled.
The order is cancelled by whom.
The order cancel reason.
The order's tracking number.
The order's delivery option.
The order's shipping provider name.
The order's payment method.
SKU's product category.
The order's Package ID
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100