The goal of this guide is cover how Pipe17 breaks down TikTok Shop's order financial information.
TikTok Shop Order Details
{
"payment":{
"currency":"USD",
"original_shipping_fee":"7.99",
"original_total_product_price":"115.94",
"platform_discount":"0",
"product_tax":"8.79",
"seller_discount":"9.45",
"shipping_fee":"0",
"shipping_fee_platform_discount":"7.99",
"shipping_fee_seller_discount":"0",
"shipping_fee_tax":"0",
"sub_total":"106.49",
"tax":"8.79",
"total_amount":"115.28"
}
}
|
payment
|
|
Payment info about this order - this is the payment made by the buyer
|
|
currency
|
USD
|
Currency for payment.
|
|
sub_total
|
5000
|
Buyer paid sub total of all the SKUs in the order. For the US market, this is pre-tax total amount.
sub_total = original_total_product_price - seller_discount - platform_discount |
|
shipping_fee
|
5000
|
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. |
|
seller_discount
|
5000
|
Product discount by seller.
|
|
platform_discount
|
5000
|
Product discount by platform (TikTok).
|
|
total_amount
|
5000
|
Buyer paid total payment.
Total_amount=sub_total+shipping_fee+taxes+retail_delivery_fee. |
|
original_total_product_price
|
5000
|
Total original price of products. (VAT included for crossborder shop).
For the US market, this is pre-tax total amount. |
|
original_shipping_fee
|
5000
|
Shipping fee before discount.
|
|
shipping_fee_seller_discount
|
5000
|
Shipping fee discount by seller.
|
|
shipping_fee_platform_discount
|
5000
|
Shipping fee discount by platform (TikTok).
|
|
tax
|
5000
|
Buyer paid total taxes of the order. Applicable to crossborder shops and the US market.
|
|
small_order_fee
|
3000
|
Small order fee for TH.
Small order fee is for Thailand 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 small order fee to meet the platform minimum spending amount. e.g. Minmum order spending amount is 100, order amount is 80. So the small order fee will be 20. |
|
shipping_fee_tax
|
11
|
The tax on the shipping price.
|
|
product_tax
|
21.3
|
The tax on the total item price.
|
|
retail_delivery_fee
|
1.28
|
RDF(Retail delivery fee). Available only in the US market.
|
|
buyer_service_fee
|
1000
|
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 Indonesia market.
|
How payments get mapped into Pipe17
Pipe17 has the following fields
orderTax
shippingPrice
subTotalPrice
totalPrice
orderDiscount
Order Tax
(() => parseFloat(sourcedoc.payment.product_tax || 0) + parseFloat(sourcedoc.payment.shipping_fee_tax || 0))()
orderTax = product_tax + shipping_fee_tax
Shipping Price
(() => Math.round((parseFloat(sourcedoc.payment.original_shipping_fee || 0) - parseFloat(sourcedoc.payment.shipping_fee_seller_discount || 0)) * 100) / 100)()
shippingPrice = original_shipping_fee - shipping_fee_seller_discount
Sub Total Price
(() => Math.round(((parseFloat(sourcedoc.payment.sub_total) || 0) + (parseFloat(sourcedoc.payment.shipping_fee_platform_discount) || 0) + (parseFloat(sourcedoc.payment.platform_discount) || 0)) * 100) / 100)()
Order Sub Total = sub_total + platform_discount
Total Price
(() => Math.round(((parseFloat(sourcedoc.payment.total_amount || 0)) + parseFloat(sourcedoc.payment.shipping_fee_platform_discount || 0) + parseFloat((sourcedoc.payment.platform_discount) || 0)) * 100) / 100)()
totalPrice = total_amount + shipping_fee_platform_discount + platform_discount
Order Discounts
(() => parseFloat(sourcedoc.payment.seller_discount) || 0)()
Comments
0 comments