1. Report Module API
API URL
post {HTTP(S) address}/api/{version}/report
1.1. Shopee Transaction Details Query Interface
1.1.1. SERVICE_TYPE
QUERY_SHOPEE_TRANSACTION_DETAIL_LIST
1.1.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| type | Y | Integer | 1 | Bill type: Bill details (1) or Cross-border store adjustment fee (2) |
| adjustmentLevel | N | String | ORDER | Adjustment dimension, required when type=2, ORDER or SHOP |
| payoutTimeFrom | N | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | N | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| onlineOrderId | N | String | 2011asd | Platform online order number |
| onlineOrderIdList | N | List |
["2011asd"] | Platform online order number list |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.1.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See ShopeeReportDTO for details |
ShopeeReportDTO (Shopee Transaction Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop ID |
| onlineShopId | Y | String | 123456 | Online shop ID |
| shopName | Y | String | Shop A | Shop name |
| ordersn | Y | String | 2011asd | Order number |
| payoutTime | Y | Long | 1735697410000 | Order payout time |
| payoutTimeFormatted | Y | String | "2025-01-01 10:10:10" | Order payout time |
| currency | Y | String | PHP | Currency Currency Unit |
| adjustmentLevel | N | String | ORDER | Adjustment dimension |
| orderStatus | N | String | COMPLETED | Order status |
| returnsn | N | String | Return order number | |
| refundsn | N | String | Refund order number | |
| escrowAmount | N | BigDecimal | Escrow amount | |
| originalPrice | N | BigDecimal | Original price (after refund) | |
| orderSellingPrice | N | BigDecimal | Selling price (after refund) | |
| sellerDiscount | N | BigDecimal | Seller discount (after refund) | |
| productSaleAmount | N | BigDecimal | Discounted product amount | |
| originalPriceBeforeRefund | N | BigDecimal | Original price (before refund) | |
| sellingPriceBeforeRefund | N | BigDecimal | Selling price (before refund) | |
| sellerDiscountBeforeRefund | N | BigDecimal | Seller discount (before refund) | |
| refundAmount | N | BigDecimal | Refund amount | |
| shopeeDiscount | N | BigDecimal | Shopee discount amount | |
| voucherFromSeller | N | BigDecimal | Seller coupon amount | |
| sellerCoinCashBack | N | BigDecimal | Seller's Shopee coin cashback | |
| buyerPaidShippingFee | N | BigDecimal | Shipping fee paid by buyer | |
| shopeeShippingRebate | N | BigDecimal | Shopee shipping rebate | |
| actualShippingFee | N | BigDecimal | Actual shipping fee | |
| reverseShippingFee | N | BigDecimal | Reverse shipping fee | |
| commissionFee | N | BigDecimal | Commission fee | |
| serviceFee | N | BigDecimal | Service fee | |
| rsfSellerProtectionFeeClaimAmount | N | BigDecimal | Reverse shipping fee insurance | |
| rsfSellerProtectionFeePremiumAmount | N | BigDecimal | Reverse shipping fee reduction | |
| shippingSellerProtectionFeeAmount | N | BigDecimal | Change of Mind Returns Program Fee | |
| orderAmsCommissionFee | N | BigDecimal | AMS commission | |
| deliverySellerProtectionFeePremiumAmount | N | BigDecimal | 3PL buyer shipping fee insurance | |
| sellerTransactionFee | N | BigDecimal | Transaction fee | |
| escrowTax | N | BigDecimal | Customs duty | |
| sellerLostCompensation | N | BigDecimal | Loss compensation | |
| sellerShippingDiscount | N | BigDecimal | Seller's shipping promotion | |
| buyerTotalAmount | N | BigDecimal | Amount actually paid by buyer | |
| coins | N | BigDecimal | Shopee coins | |
| voucherFromShopee | N | BigDecimal | Shopee coupon amount | |
| shippingFeeSst | N | BigDecimal | Shipping Fee SST | |
| reverseShippingFeeSst | N | BigDecimal | Reverse Shipping Fee SST | |
| finalEscrowProductGst | N | BigDecimal | Product Goods and Service Tax | |
| finalEscrowShippingGst | N | BigDecimal | Shipping Goods and Service Tax | |
| campaignFee | N | BigDecimal | Shopee Campaign Fee | |
| shopeeCoinsRedeemed | N | BigDecimal | Shopee Coins Redeemed | |
| withholdingTax | N | BigDecimal | Withholding tax | |
| salesTaxOnLvg | N | BigDecimal | Sales tax on LVG | |
| vatOnImportedGoods | N | BigDecimal | Imported Goods Vat | |
| fsfSellerProtectionFeeClaimAmount | N | BigDecimal | Shipping Fee Claim Amount | |
| overseasReturnServiceFee | N | BigDecimal | Overseas Return Service Fee | |
| crossBorderTax | N | BigDecimal | Cross-border tax | |
| paymentPromotion | N | BigDecimal | Payment promotion | |
| estimatedShippingFee | N | BigDecimal | Estimated shipping fee | |
| finalShippingFee | N | BigDecimal | Final shipping fee | |
| shippingFeeDiscountFrom3pl | N | BigDecimal | 3PL shipping fee discount | |
| sellerVoucherCode | N | String | Seller coupon code | |
| offlineAdjustment | N | BigDecimal | Adjustment fee | |
| module | N | String | Fee type (only available when querying cross-border store adjustment fee) | |
| scenario | N | String | Adjustment scenario (only available when querying cross-border store adjustment fee) | |
| adjustmentAmount | N | BigDecimal | Adjustment amount (only available when querying cross-border store adjustment fee) | |
| remark | N | String | Remarks (only available when querying cross-border store adjustment fee) | |
| updateTime | N | Long | 1735697410000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
| udf1 | N | BigDecimal | Seller Order Processing Fee | |
| udf2 | N | BigDecimal | Seller PIT | |
| udf3 | N | BigDecimal | Seller VAT | |
| udf4 | N | BigDecimal | Trade in Bonus by Seller | |
| udf5 | N | BigDecimal | FBS Fee | |
| udf6 | N | BigDecimal | Final Return To Seller Shipping Fee | |
| udf7 | N | BigDecimal | Ads Escrow Top Up Fee/Technical Support Fee | |
| udf8 | N | BigDecimal | Import Duty | |
| udf9 | N | BigDecimal | Reserved field, currently unused | |
| udf10 | N | BigDecimal | Reserved field, currently unused | |
| udf11 | N | BigDecimal | Reserved field, currently unused | |
| udf12 | N | BigDecimal | Reserved field, currently unused | |
| udf13 | N | BigDecimal | Reserved field, currently unused | |
| udf14 | N | BigDecimal | Reserved field, currently unused | |
| udf15 | N | BigDecimal | Reserved field, currently unused |
1.2. Lazada Transaction Details Query Interface
1.2.1. SERVICE_TYPE
QUERY_LAZADA_TRANSACTION_DETAIL_LIST
1.2.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | N | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | N | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| onlineOrderId | N | String | 2011asd | Order number |
| onlineOrderIdList | N | List |
["2011asd"] | Order number list |
| feeName | N | String | Fee name | |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.2.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See LazadaReportDTO for details |
LazadaReportDTO (Lazada Transaction Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop ID |
| onlineShopId | Y | String | 123456 | Online shop ID |
| shopName | Y | String | Shop A | Shop name |
| transactionDate | Y | String | "2025-01-01" | Date |
| transactionTimestamp | Y | Long | 1735660800000 | Date |
| transactionNumber | Y | String | Transaction number | |
| transactionType | Y | String | Transaction type | |
| orderNo | Y | String | 2011asd | Order number |
| feeName | N | String | Fee name | |
| currency | N | String | PHP | Currency Currency Unit |
| amount | N | String | Total transaction amount | |
| details | N | String | Details | |
| sellerSku | N | String | Seller SKU | |
| vatInAmount | N | String | VAT | |
| whtAmount | N | String | WHT | |
| comment | N | String | Remarks | |
| updateTime | N | Date | 1735660800000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
1.3. TikTok Transaction Details Query Interface
1.3.1. SERVICE_TYPE
QUERY_TIKTOK_TRANSACTION_DETAIL_LIST
1.3.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | Y | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | Y | Date | 2022-09-05 | Payout end time |
| onlineOrderId | N | String | 2011asd | Order number |
| onlineOrderIdList | N | List |
["2011asd"] | Order number list |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.3.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See TiktokReportDTO for details |
TiktokReportDTO (TikTok Transaction Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop Id |
| shopName | Y | String | Shop A | Shop name |
| currency | Y | String | PHP | Currency Currency Unit |
| orderId | Y | String | 2011asd | Order number |
| adjustmentId | Y | String | Adjustment order number | |
| relatedOrderId | Y | String | Related order number | |
| settlementTime | N | Long | 1735660800000 | Settlement time |
| settlementTimeFormatted | N | String | "2025-01-01" | Settlement time |
| skuId | N | String | SKU ID | |
| skuName | N | String | SKU name | |
| productName | N | String | Product name | |
| userPay | N | BigDecimal | Payment by buyer | |
| platformPromotion | N | BigDecimal | Platform promotion | |
| shippingFeeSubsidy | N | BigDecimal | Shipping fee subsidy | |
| refund | N | BigDecimal | Refund | |
| paymentFee | N | BigDecimal | Transaction fee | |
| platformCommission | N | BigDecimal | Platform commission | |
| flatFee | N | BigDecimal | Flat fee | |
| salesFee | N | BigDecimal | Sales fee | |
| affiliateCommission | N | BigDecimal | Affiliate commission | |
| vat | N | BigDecimal | VAT | |
| shippingFee | N | BigDecimal | Platform shipping fee | |
| smallOrderFee | N | BigDecimal | Small order fee | |
| affiliatePartnerCommission | N | BigDecimal | Affiliate partner commission | |
| sellerReasonFundDeduction | N | BigDecimal | Compensation for loss | |
| shippingFeeAdjustment | N | BigDecimal | Shipping fee adjustment | |
| chargeBack | N | BigDecimal | Difference amount | |
| customerServiceCompensation | N | BigDecimal | After-sales compensation | |
| promotionAdjustment | N | BigDecimal | Promotion adjustment fee | |
| otherAdjustment | N | BigDecimal | Other adjustment fee | |
| settlementAmount | N | BigDecimal | Settlement amount | |
| transactionFee | N | BigDecimal | Transaction fee | |
| subtotalAfterSellerDiscounts | N | BigDecimal | Discounted product sales amount | |
| refundSubtotalAfterSellerDiscounts | N | BigDecimal | Discounted product refund amount | |
| gst | N | BigDecimal | GST (Singapore) | |
| sfpServiceFee | N | BigDecimal | SFP service fee | |
| transactionFeeRefund | N | BigDecimal | Transaction Fee Refund | |
| wht | N | BigDecimal | Withholding Tax | |
| logisticsReimbursement | N | BigDecimal | Logistics Reimbursement | |
| tokLogisticsReimbursement | N | BigDecimal | Tok Logistics Reimbursement | |
| satisfactionSubsidy | N | BigDecimal | Satisfaction Subsidy | |
| bonusCashbackServiceFee | N | BigDecimal | Bonus Cashback ServiceFee | |
| referralFee | N | BigDecimal | Referral fee | |
| affiliateCommissionBeforePit | N | BigDecimal | Affiliate Commission before Pit | |
| pitAmount | N | BigDecimal | Pit Amount | |
| creditCardInstallmentHandlingFee | N | BigDecimal | Creditcard Installment HandlingFee | |
| mallServiceFee | N | BigDecimal | Mall service fee | |
| affiliateAdsCommission | N | BigDecimal | Affiliate Ads Commission | |
| affiliateAdsCommissionBeforePit | N | BigDecimal | AffiliateAds Commission before Pit | |
| updateTime | N | Long | 1735660800000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
1.4. Shopee Payout Record Query Interface
1.4.1. SERVICE_TYPE
QUERY_SHOPEE_PAYOUT_DETAIL_LIST
1.4.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | Y | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | Y | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| type | N | String | Type | |
| payoutStatus | N | String | Transaction Status | |
| transactionType | N | String | Transaction type | |
| onlineOrderId | N | String | 2011asd | Order number |
| onlineOrderIdList | N | List |
["2011asd"] | Order number list |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.4.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See ShoppeePayoutReportDTO for details |
ShoppeePayoutReportDTO (Shopee Payout Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop ID |
| onlineShopId | Y | String | 123456 | Online shop ID |
| shopName | Y | String | Shop A | Shop name |
| platform | Y | String | Shopee | Platform |
| siteCode | Y | String | PH | Site |
| currency | Y | String | PHP | Currency Currency Unit |
| type | N | String | Type | |
| payType | N | String | Payment method | |
| transactionId | N | String | Transaction ID | |
| payoutStatus | N | String | Transaction status | |
| transactionType | N | String | Transaction type | |
| amount | N | BigDecimal | Amount | |
| currentBalance | N | BigDecimal | Current balance | |
| transactionTime | N | Long | 1735697410000 | Transaction time |
| transactionTimeFormatted | N | String | "2025-01-01 10:10:10" | Transaction time |
| updateTime | N | Long | 1735697410000 | Update time |
| orderSn | N | String | 2011asd | Order number |
| refundSn | N | String | Refund order number | |
| withdrawalType | N | String | withdrawal type | |
| transactionFee | N | BigDecimal | Transaction fee | |
| description | N | String | Description | |
| buyerName | N | String | Buyer name | |
| withdrawId | N | String | withdrawal id | |
| reason | N | String | Explanations related to transactions or withdrawals | |
| rootWithdrawalId | N | String | root withdrawal id | |
| payoutExchangeCurrency | N | String | Actual amount currency | |
| payoutExchangeAmount | N | BigDecimal | Actual amount | |
| payoutExchangeRate | N | String | Exchange rate | |
| payoutPayeeId | N | String | seller's collection account | |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
1.5. Lazada My Balance Query Interface
1.5.1. SERVICE_TYPE
QUERY_LAZADA_ACCOUNT_TRANSACTION_LIST
1.5.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | Y | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | Y | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| transactionNumberList | N | List |
["T123"] | Transaction number list |
| typeList | N | List |
["Type A"] | Type List |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.5.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See LazadaAccountTransactionReportDTO for details |
LazadaAccountTransactionReportDTO (Lazada Account Transaction Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| customerId | N | Long | 1001 | Customer ID |
| shopId | N | Long | 1001 | Shop ID |
| onlineShopId | N | String | 123456 | Online shop ID |
| siteCode | N | String | PH | Site |
| transactionNumber | N | String | T123 | Transaction number |
| transactionTime | N | Long | 1735697410000 | Transaction time |
| transactionTimeFormatted | N | String | "2025-01-01 10:10:10" | Transaction time |
| type | N | String | Type A | Type |
| subType | N | String | Subtype A | Subtype |
| amount | N | BigDecimal | Amount | |
| currency | N | String | PHP | Currency Currency Unit |
| remarks | N | String | Remarks | |
| payeeAccount | N | String | Account | |
| payeeDescription | N | String | Description | |
| payeeJson | N | String | Account information | |
| trackingListJson | N | String | Transaction process tracking record | |
| shopName | N | String | Shop A | Shop name |
| platform | N | String | Lazada | Platform name |
| updateTime | N | Long | 1735697410000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
1.6. TikTok V2 Transaction Details Query Interface
1.6.1. SERVICE_TYPE
QUERY_TIKTOK_V2_TRANSACTION_DETAIL_LIST
1.6.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | N | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | N | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| onlineOrderId | N | String | 2011asd | Order number |
| onlineOrderIdList | N | List |
["2011asd"] | Order number list |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.6.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See TiktokV2025SettlementReportDTO for details |
TiktokV2025SettlementReportDTO (TikTok V2 Transaction Details)
commercePlatform notes
The Toko / TikTok identifier comes from the source tag written after the order is pulled into ERP; it is NULL if the order has not been synced to ERP.
- Values:
TIKTOK,TOKOPEDIA. NULL if the order has not been synced to ERP. - When
typeCode=ORDER,orderIdis non-empty, and the order has already been pulled into ERP.
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop ID |
| onlineShopId | Y | String | 123456 | Online shop ID |
| currency | Y | String | PHP | Currency Currency Unit |
| platform | Y | String | TikTok | Platform information |
| shopName | Y | String | Shop A | Shop name |
| typeCode | N | String | Type | |
| orderId | N | String | 2011asd | Order number |
| commercePlatform | N | String | TIKTOK | TIKTOK, TOKOPEDIA, or empty. See notes above. |
| orderCreateTime | N | Long | Order creation time | |
| settlementTime | N | Long | 1735660800000 | Settlement transaction time |
| settlementTimeFormatted | N | String | "2025-01-01" | Settlement transaction time |
| adjustmentId | N | String | Adjustment order | |
| adjustmentOrderId | N | String | Adjustment related order | |
| adjustmentAmount | N | BigDecimal | Adjustment fee | |
| settlementAmount | N | BigDecimal | Settlement fee | |
| revenueAmount | N | BigDecimal | Revenue | |
| shippingCostAmount | N | BigDecimal | Shipping fee | |
| shippingCostBreakDown | N | TiktokV2025SettlementShippingCostBreakDownVO | Shipping Cost Breakdown | |
| feeTaxAmount | N | BigDecimal | Take fee_tax_breakdown total value | |
| totalFees | N | BigDecimal | Total fees take fee_tax | |
| subtotalAfterDiscountAmount | N | BigDecimal | Calculated discounted product amount | |
| refundSubtotalAfterDiscountAmount | N | BigDecimal | Discounted product amount (refund) | |
| subtotalBeforeDiscountAmount | N | BigDecimal | Product amount before discount | |
| sellerDiscountAmount | N | BigDecimal | Seller discount | |
| refundSubtotalBeforeDiscountAmount | N | BigDecimal | Product amount before discount refund | |
| sellerDiscountRefundAmount | N | BigDecimal | Seller discount amount refund | |
| codServiceFeeAmount | N | BigDecimal | COD service fee | |
| refundCodServiceFeeAmount | N | BigDecimal | COD refund service fee | |
| feePlatformCommissionAmount | N | BigDecimal | Platform commission | |
| feeReferralFeeAmount | N | BigDecimal | Referral fee | |
| feeRefundAdministrationFeeAmount | N | BigDecimal | Refund administration fee | |
| feeTransactionFeeAmount | N | BigDecimal | Transaction fee | |
| feeCreditCardHandlingFeeAmount | N | BigDecimal | Credit card handling fee | |
| feeAffiliateCommissionAmount | N | BigDecimal | Affiliate commission | |
| feeAffiliateCommissionAmountBeforePit | N | BigDecimal | Pre-tax affiliate commission | |
| feeAffiliatePartnerCommissionAmount | N | BigDecimal | Affiliate partner commission | |
| feeAffiliateAdsCommissionAmount | N | BigDecimal | Affiliate advertising commission | |
| feeSfpServiceFeeAmount | N | BigDecimal | SFP service fee | |
| feeLiveSpecialsFeeAmount | N | BigDecimal | LIVE service fee | |
| feeBonusCashbackServiceFeeAmount | N | BigDecimal | Bonus cashback service fee | |
| feeMallServiceFeeAmount | N | BigDecimal | Platform mall service fee | |
| taxVatAmount | N | BigDecimal | VAT (cross-border store) | |
| taxImportVatAmount | N | BigDecimal | Import VAT | |
| taxCustomsDutyAmount | N | BigDecimal | Customs duty (cross-border store) | |
| taxCustomsClearanceAmount | N | BigDecimal | Customs clearance tax (cross-border store) | |
| taxSstAmount | N | BigDecimal | SST service tax | |
| taxGstAmount | N | BigDecimal | GST service tax | |
| udf1 | N | BigDecimal | Xtra plan service fee | |
| udf2 | N | BigDecimal | Flash sales service fee | |
| udf3 | N | BigDecimal | Joint promotion service fee | |
| udf4 | N | BigDecimal | Pre-purchase service fee | |
| udf5 | N | BigDecimal | TSP commission | |
| udf6 | N | BigDecimal | Ditayani Tokopedia service charge | |
| udf7 | N | BigDecimal | Paylater service charge | |
| udf8 | N | BigDecimal | Platform dynamic commission | |
| udf9 | N | BigDecimal | Fixed infrastructure fee | |
| udf10 | N | BigDecimal | PRO Service Fee Amount | |
| udf11 | N | BigDecimal | Per Item Sold Fee Amount | |
| udf12 | N | BigDecimal | Cofunded Promotion Service Fee Amount | |
| udf13 | N | BigDecimal | EAMSP Service Fee Amount | |
| udf14 | N | BigDecimal | Affiliate Commission Fee After Order Paid | |
| udf15 | N | BigDecimal | Affiliate Commission Fee After Order Settlement | |
| udf16 | N | BigDecimal | Return shipping fee (paid by customers) | |
| udf17 | N | BigDecimal | Return shipping fee reimbursement | |
| udf18 | N | BigDecimal | Affiliate Partner shop ads commission | |
| udf19 | N | BigDecimal | Campaign resource fee | |
| udf20 | N | BigDecimal | Installation service fee | |
| udf21 | N | BigDecimal | Platform Special Service Fee | |
| udf22 | N | BigDecimal | ISR | |
| udf23 | N | BigDecimal | IVA | |
| udf24 | N | BigDecimal | Anti Dumping Duty Amount | |
| udf25 | N | BigDecimal | PIT | |
| udf26 | N | BigDecimal | Smart Promotion Fee | |
| udf27 | N | BigDecimal | GMV Max Ad Fee | |
| udf28 | N | BigDecimal | Platform Semi Managed Commission Fee | |
| udf29 | N | BigDecimal | Campaign Period Fee CFP Amount | |
| udf30 | N | BigDecimal | Campaign Period Fee SP Amount | |
| udf31 | N | BigDecimal | Seller Growth Fee Amount | |
| udf32 | N | BigDecimal | Sales Tax Referral Fee Amount | |
| udf33 | N | BigDecimal | Smart Promotion Fee Tax Amount | |
| udf34 | N | BigDecimal | Cedular Tax | |
| udf35 | N | BigDecimal | Reserved field | |
| udf40 | N | BigDecimal | GMV Max Coupon Payment | |
| updateTime | N | Long | 1735660800000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
TiktokV2025SettlementShippingCostBreakDownVO (Shipping Cost Breakdown)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| actualShippingFeeAmount | N | BigDecimal | Actual shipping cost | |
| shippingFeeDiscountAmount | N | BigDecimal | Platform shipping subsidy | |
| customerPaidShippingFeeAmount | N | BigDecimal | Shipping paid by customer | |
| returnShippingFeeAmount | N | BigDecimal | Return shipping cost | |
| replacementShippingFeeAmount | N | BigDecimal | Replacement cost | |
| exchangeShippingFeeAmount | N | BigDecimal | Goods delivery (Indonesia) | |
| signatureConfirmationFeeAmount | N | BigDecimal | Signature package service | |
| shippingInsuranceFeeAmount | N | BigDecimal | Shipping insurance | |
| shippingCostSupplementaryComponent | N | TiktokV2025SettlementShippingCostBreakDownOtherInfoVO | Other shipping cost details |
TiktokV2025SettlementShippingCostBreakDownOtherInfoVO (Other Shipping Cost Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| platformShippingFeeDiscountAmount | N | BigDecimal | Platform shipping discount | |
| promoShippingIncentiveAmount | N | BigDecimal | Free shipping incentive | |
| shippingFeeSubsidyAmount | N | BigDecimal | Platform shipping subsidy | |
| sellerShippingFeeDiscountAmount | N | BigDecimal | Seller shipping discount | |
| customerShippingFeeOffsetAmount | N | BigDecimal | Customer shipping cost after discount (US only) | |
| fbmShippingCostAmount | N | BigDecimal | TikTok Shipping cost for sellers | |
| fbtShippingCostAmount | N | BigDecimal | FBT shipping cost for sellers (except US) | |
| fbtFulfillmentFeeAmount | N | BigDecimal | Platform shipping discount | |
| platformShippingFeeDiscountAmount | N | BigDecimal | Platform shipping discount |
1.7. TikTok Payout Record Query Interface
1.7.1. SERVICE_TYPE
QUERY_TIKTOK_WITHDRAWALS_DETAIL_LIST
1.7.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopIdList | N | List |
[1001] | Shop ID list (max: 100). Must provide one of shopIdList or shopNameList; if both are provided, this field takes precedence. |
| shopNameList | N | List |
["Shop A"] | Shop name list (max: 100). Must provide one of shopIdList or shopNameList. |
| payoutTimeFrom | Y | Date | 2022-09-05 | Payout start time |
| payoutTimeTo | Y | Date | 2022-09-05 | Payout end time |
| updateTimeFrom | N | Date | 2022-09-05 00:00:00 | Update start time |
| updateTimeTo | N | Date | 2022-09-05 10:00:00 | Update end time |
| typeList | N | List |
["Type A"] | Transaction Type List |
| page | Y | Integer | 1 | Page number, default 1 |
| pageSize | Y | Integer | 100 | Number of entries per page, no more than 200, default 100 |
1.7.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total count |
| result | Y | List |
See TiktokWithdrawalsWebReportDTO for details |
TiktokWithdrawalsWebReportDTO (TikTok Withdrawal Details)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| shopId | Y | Long | 1001 | Shop ID |
| onlineShopId | Y | String | 123456 | Online shop ID |
| withdrawalsId | N | String | ID | |
| type | N | String | Type A | Transaction Type |
| amount | N | BigDecimal | Amount | |
| currency | N | String | PHP | Currency Currency Unit |
| status | N | String | Status | |
| withdrawalsCreateTime | N | Long | 1735697410000 | Withdrawal creation time |
| withdrawalsCreateTimestamp | N | Long | 1735697410000 | Withdrawal creation timestamp |
| withdrawalsCreateTimeFormatted | N | String | "2025-01-01 10:10:10" | Withdrawal creation time |
| shopName | N | String | Shop A | Shop name |
| siteCode | N | String | PH | Site |
| updateTime | N | Long | 1735697410000 | Update time |
| shopTimeZone | N | String | "Asia/Shanghai" | Shop Time Zone |
| publicId | N | String | "550318454795" | Public Id |
1.8. Inventory Daily Statement Query Interface
1.8.1. SERVICE_TYPE
QUERY_INVENTORY_DAILY_REPORT
1.8.2. Request Parameters
| Parameter | Required | Type | Example | Remarks |
|---|---|---|---|---|
| skuParam | N | String | Goods | Input box for commodity code / commodity name / UPC |
| spuKeywords | N | String | Goods | SPU / style name (fuzzy) |
| spuKeywordList | N | List |
["SPU-A"] | SPU / style name exact batch search |
| warehouse | N | String | Warehouse1 | Warehouse name. At least one of warehouse / warehouses is required; values are merged and de-duplicated. Must be an authorized warehouse |
| warehouses | N | List |
["Warehouse1","Warehouse2"] | Warehouse name list. At least one of warehouse / warehouses is required. Must be authorized warehouses |
| dateFrom | Y | String | 2025-01-18 | Snapshot start time (warehouse time zone). Max time span within 1 month (yyyy-MM-dd) |
| dateTo | Y | String | 2025-02-18 | Snapshot end time (warehouse time zone). Max time span within 1 month (yyyy-MM-dd) |
| enable | N | Integer | 1 | System SKU status: 1 enabled, 0 disabled |
| warehouseSkuEnable | N | String | ON | Warehouse SKU status: ON / OFF, 1 / 0 also accepted |
| categorySelectList | N | List |
[{"categoryLevel1":11}] | Category multi-select. See CategorySelect |
| page | Y | Integer | 1 | Page number, default value: 1 |
| pageSize | Y | Integer | 100 | Records per page, maximum 200, default value: 100 |
CategorySelect (category)
| Parameter | Required | Type | Example | Remarks |
|---|---|---|---|---|
| categoryLevel1 | N | Long | 11 | Level-1 category ID |
| categoryLevel2 | N | Long | 22 | Level-2 category ID |
| categoryLevel3 | N | Long | 33 | Level-3 category ID |
Warehouse group filter is not supported. Amounts use account currency; currency cannot be switched.
1.8.3. Response Parameters
| Parameter | Required | Type | Example | Remarks |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total record count |
| result | Y | List |
Refer to OpenApiInventoryDailyReportDTO |
1.8.4. OpenApiInventoryDailyReportDTO (Inventory Flow Data)
Amount fields are numbers without a currency prefix. Use currency / currencySymbol for display. Volume = corresponding qty × SKU length × width × height; missing dimensions yield 0. Cost split fields are flattened; nested costDetail, logList and statistics are not returned.
| Parameter | Required | Type | Example | Remarks |
|---|---|---|---|---|
| picUrl | N | String | Product image URL | |
| sku | N | String | 1001 | Commodity SKU code |
| skuName | N | String | 123456 | Commodity name |
| category | N | String | Commodity category | |
| spu | N | String | SPU code | |
| spuTitle | N | String | Style name | |
| warehouseName | N | String | PHP | Warehouse name |
| warehouseId | N | Long | 1001 | ERP warehouse primary key |
| color | N | String | RED | Color, from system SKU |
| size | N | String | M | Size, from system SKU |
| itemPackage | N | Long | 1 | Package, from system SKU |
| barcode | N | String | Barcode, from system SKU | |
| upc | N | String | UPC, from system SKU | |
| customProp1 | N | String | Custom property 1, from system SKU | |
| customProp2 | N | String | Custom property 2, from system SKU | |
| totalBefore | N | Long | 10 | Opening inventory |
| totalCostBefore | N | BigDecimal | 40.0000 | Opening cost |
| volumeBefore | N | BigDecimal | 1.2000 | Opening volume |
| goodTotalBefore | N | Long | 8 | Opening inventory (good) |
| goodTotalCostBefore | N | BigDecimal | 32.0000 | Opening cost (good) |
| goodVolumeBefore | N | BigDecimal | 0.9600 | Opening volume (good) |
| defectiveTotalBefore | N | Long | 2 | Opening inventory (defective) |
| defectiveTotalCostBefore | N | BigDecimal | 8.0000 | Opening cost (defective) |
| defectiveVolumeBefore | N | BigDecimal | 0.2400 | Opening volume (defective) |
| costDetailBeforePurchaseFee | N | BigDecimal | 20.0000 | Opening purchase fee |
| costDetailBeforeFirstLegFee | N | BigDecimal | 10.0000 | Opening first-leg fee |
| costDetailBeforeTransferFee | N | BigDecimal | 10.0000 | Opening transfer fee |
| shippingQuantityBefore | N | Long | 50 | Opening in-transit quantity |
| shippingCostBefore | N | BigDecimal | 40.0000 | Opening in-transit cost |
| shippingVolumeBefore | N | BigDecimal | 6.0000 | Opening in-transit volume |
| inboundQuantity | N | Long | 20 | Inbound quantity |
| inboundCost | N | BigDecimal | 40.0000 | Inbound cost |
| inboundVolume | N | BigDecimal | 2.4000 | Inbound volume |
| inboundCostDetailPurchaseFee | N | BigDecimal | 20.0000 | Inbound purchase fee |
| inboundCostDetailFirstLegFee | N | BigDecimal | 10.0000 | Inbound first-leg fee |
| inboundCostDetailTransferFee | N | BigDecimal | 10.0000 | Inbound transfer fee |
| outboundQuantity | N | Long | 30 | Outbound quantity |
| outboundCost | N | BigDecimal | 40.0000 | Outbound cost |
| outboundVolume | N | BigDecimal | 3.6000 | Outbound volume |
| outboundCostDetailPurchaseFee | N | BigDecimal | 20.0000 | Outbound purchase fee |
| outboundCostDetailFirstLegFee | N | BigDecimal | 10.0000 | Outbound first-leg fee |
| outboundCostDetailTransferFee | N | BigDecimal | 10.0000 | Outbound transfer fee |
| totalAfter | N | Long | 40 | Closing inventory |
| totalCostAfter | N | BigDecimal | 40.0000 | Closing cost |
| volumeAfter | N | BigDecimal | 4.8000 | Closing volume |
| goodTotalAfter | N | Long | 36 | Closing inventory (good) |
| goodTotalCostAfter | N | BigDecimal | 36.0000 | Closing cost (good) |
| goodVolumeAfter | N | BigDecimal | 4.3200 | Closing volume (good) |
| defectiveTotalAfter | N | Long | 4 | Closing inventory (defective) |
| defectiveTotalCostAfter | N | BigDecimal | 4.0000 | Closing cost (defective) |
| defectiveVolumeAfter | N | BigDecimal | 0.4800 | Closing volume (defective) |
| costDetailAfterPurchaseFee | N | BigDecimal | 20.0000 | Closing purchase fee |
| costDetailAfterFirstLegFee | N | BigDecimal | 10.0000 | Closing first-leg fee |
| costDetailAfterTransferFee | N | BigDecimal | 10.0000 | Closing transfer fee |
| shippingQuantityAfter | N | Long | 60 | Closing in-transit quantity |
| shippingCostAfter | N | BigDecimal | 40.0000 | Closing in-transit cost |
| shippingVolumeAfter | N | BigDecimal | 7.2000 | Closing in-transit volume |
| shippingPurchaseFeeAfter | N | BigDecimal | 12.0000 | Closing in-transit purchase fee |
| iorder | N | Long | 1 | Order inbound |
| ireturn | N | Long | 1 | Return inbound |
| imanual | N | Long | 1 | Manual inbound |
| ipurchase | N | Long | 1 | Purchase inbound |
| ifirstLeg | N | Long | 1 | First-leg inbound |
| ifirstLegWithdrawShipped | N | Long | 1 | First-leg withdraw inbound |
| iplan | N | Long | 1 | Planned transfer inbound |
| iavailable | N | Long | 1 | Available transfer inbound |
| iassembly | N | Long | 1 | Assembly inbound |
| irestore | N | Long | 1 | Split inbound |
| adjustmentManual | N | Long | 1 | Manual adjustment inbound |
| adjustmentAuto | N | Long | 1 | Auto adjustment inbound |
| istorageLocation | N | Long | 1 | Location transfer inbound |
| countExtra | N | Long | 1 | Cycle-count surplus |
| iimportInbound | N | Long | 1 | Inventory import inbound |
| oorder | N | Long | 1 | Order outbound |
| omanualOdo | N | Long | 1 | Manual outbound |
| opurchaseReturn | N | Long | 1 | Purchase return outbound |
| ofirstLeg | N | Long | 1 | First-leg outbound |
| oplan | N | Long | 1 | Planned transfer outbound |
| oavailable | N | Long | 1 | Available transfer outbound |
| adjustmentManualOut | N | Long | 1 | Manual adjustment outbound |
| adjustmentAutoOut | N | Long | 1 | Auto adjustment outbound |
| oassembly | N | Long | 1 | Assembly outbound |
| orestore | N | Long | 1 | Split outbound |
| ostorageLocation | N | Long | 1 | Location transfer outbound |
| countMissing | N | Long | 1 | Cycle-count shortage |
| currency | N | String | CNY | Account currency code |
| currencySymbol | N | String | ¥ | Account currency symbol |
1.9. Inventory Age Report Query Interface
1.9.1. SERVICE_TYPE
QUERY_INVENTORY_AGE
Data is scoped to warehouses authorized for the open application. SKU scope follows the tenant main account SKU permission
1.9.2. Request Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| warehouse | N | String | Warehouse1 | Warehouse name. If omitted, all warehouses authorized for the app are queried. Must match an authorized warehouse name when provided. |
| skuParam | N | String | SKU-001 | SKU code, product title, or UPC (fuzzy). |
| spuKeywords | N | String | Style A | SPU code or style name (fuzzy). |
| sellerUsername | N | String | John | Salesperson display name |
| developerUserName | N | String | Jane | Developer display name |
| enable | N | Integer | 1 | System SKU status: 1 enabled, 0 disabled. |
| warehouseSkuEnable | N | String | ON | Warehouse SKU status: ON / OFF; 1 / 0 also accepted. |
| showEmpty | N | Integer | 0 | Whether to include zero-inventory rows: 1 yes, 0 no. Default 0. |
| page | Y | Integer | 1 | Page number, default 1. |
| pageSize | Y | Integer | 100 | Page size, maximum 200, default 100. Values greater than 200 return a parameter error. |
Cost amounts use the account base currency
1.9.3. Response Parameters
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| errorCode | Y | String | Error Code | |
| errorMsg | Y | String | Business error message | |
| state | Y | String | Request Result | |
| total | Y | Integer | 100 | Total record count |
| result | Y | List |
See InventoryAgeVO |
InventoryAgeVO (inventory age row)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| sku | N | String | SKU-001 | SKU code |
| skuName | N | String | Product A | Product title |
| picUrl | N | String | Product image URL | |
| color | N | String | RED | Color |
| size | N | String | M | Size |
| warehouseName | N | String | Warehouse1 | Warehouse name |
| category | N | String | Cat1/Cat2 | Category path (level names joined by /) |
| categoryLevel1 | N | Long | 11 | Level-1 category ID |
| categoryName1 | N | String | Level-1 category name | |
| categoryLevel2 | N | Long | 22 | Level-2 category ID |
| categoryName2 | N | String | Level-2 category name | |
| categoryLevel3 | N | Long | 33 | Level-3 category ID |
| categoryName3 | N | String | Level-3 category name | |
| spu | N | String | SPU-001 | SPU code |
| spuTitle | N | String | Style A | Style name |
| sellerUsername | N | String | John | Salesperson name(s), comma-separated if multiple |
| developerUserName | N | String | Jane | Developer name(s), comma-separated if multiple |
| total | N | InventoryAgeItem | Overview: quantity and cost for all age buckets combined | |
| sectionOne | N | InventoryAgeItem | Age bucket 0–30 days | |
| sectionTwo | N | InventoryAgeItem | Age bucket 30–60 days | |
| sectionThree | N | InventoryAgeItem | Age bucket 60–90 days | |
| sectionFour | N | InventoryAgeItem | Age bucket 90–180 days | |
| sectionFive | N | InventoryAgeItem | Age bucket over 180 days |
InventoryAgeItem (quantity and cost per bucket)
| Parameter | Required | Type | Example | Description |
|---|---|---|---|---|
| total | N | Long | 10 | Total quantity |
| cost | N | BigDecimal | 120.00 | Total cost (account currency) |
| goodTotal | N | Long | 8 | Good quantity |
| goodCost | N | BigDecimal | 96.00 | Good cost |
| defectiveTotal | N | Long | 2 | Defective quantity |
| defectiveCost | N | BigDecimal | 24.00 | Defective cost |