LinkyFlow — agents autonomes et données métier live dans Excel ou sur le webLinkyFlow
ConnexionCommencer
Connexion TikTok Shop pour LinkyFlow

Connexion TikTok Shop pour LinkyFlow

LinkyFlow connecte Excel a TikTok Shop pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

31

Requetes de lecture

21

Actions ecriture

12

Champs documentes

223

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

After-sales

Approve Cancellation

Accepts the buyer’s cancellation: the order is cancelled and the buyer refunded.

Creation

Approve Cancellation

Approve Cancellation

Route: POST /mutation/cancellationApprove

Entrees configurables
NameTypeRequiredDescription
cancel_ididYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Approve Return

Accepts the buyer’s request: a refund, a return of the item, the item received, or a replacement.

Creation

Approve Return

Approve Return

Route: POST /mutation/returnApprove

Entrees configurables
NameTypeRequiredDescription
buyer_keep_itembooleanNo-
decisionenumYesValues: APPROVE_REFUND, APPROVE_RETURN, APPROVE_RECEIVED_PACKAGE, APPROVE_REPLACEMENT
return_ididYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Cancellations

The cancellations of a shop’s orders, asked by the buyer or made by the seller, and what each refunds.

Lecture

Cancellations

The cancellations of a shop’s orders, asked by the buyer or made by the seller, and what each refunds.

Route: GET /cancellations

Formule Excel: =LF.tiktokshop.cancellations("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
cancel_statusenumNoOnly the cancellations in this status. Values: CANCELLATION_REQUEST_PENDING, CANCELLATION_REQUEST_SUCCESS, CANCELLATION_REQUEST_CANCEL, CANCELLATION_REQUEST_COMPLETE
order_ididNoOnly this order’s.
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 50). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

order_id
default

id

→ orders

-

cancel_status
default

string

—

-

cancel_type
default

string

—

-

cancel_reason_text
default

string

—

-

refund_total
default

string

—

-

update_time
default

date

—

-

Reject Cancellation

Refuses the buyer’s cancellation, with a reason TikTok Shop accepts: the order goes on.

Creation

Reject Cancellation

Reject Cancellation

Route: POST /mutation/cancellationReject

Entrees configurables
NameTypeRequiredDescription
cancel_ididYes-
commentstringNo-
reject_reasonstringYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reject Reasons

The reasons TikTok Shop accepts for refusing one cancellation or return: the keys a rejection names.

Lecture

Reject Reasons

The reasons TikTok Shop accepts for refusing one cancellation or return: the keys a rejection names.

Route: GET /rejectReasons

Formule Excel: =LF.tiktokshop.rejectReasons("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
return_or_cancel_ididYesThe return or the cancellation to refuse.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
localestringNoThe language of the reasons (fr-FR).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

text
default

string

—

-

Reject Return

Refuses the buyer’s request, with a reason TikTok Shop accepts: the buyer may ask TikTok Shop to arbitrate.

Creation

Reject Return

Reject Return

Route: POST /mutation/returnReject

Entrees configurables
NameTypeRequiredDescription
commentstringNo-
decisionenumYesValues: REJECT_REFUND, REJECT_RETURN, REJECT_RECEIVED_PACKAGE, REJECT_REPLACEMENT
reject_reasonstringYes-
return_ididYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Returns

The returns and refunds the shop’s buyers asked for: their status, reason, tracking and what each refunds.

Lecture

Returns

The returns and refunds the shop’s buyers asked for: their status, reason, tracking and what each refunds.

Route: GET /returns

Formule Excel: =LF.tiktokshop.returns("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
return_statusenumNoOnly the returns in this status. Values: RETURN_OR_REFUND_REQUEST_PENDING, REFUND_OR_RETURN_REQUEST_REJECT, AWAITING_BUYER_SHIP, BUYER_SHIPPED_ITEM, REJECT_RECEIVE_PACKAGE
return_typeenumNoValues: REFUND, RETURN_AND_REFUND, REPLACEMENT, EXCHANGE
order_ididNoOnly this order’s.
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 50). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

order_id
default

id

→ orders

-

return_type
default

string

—

-

return_status
default

string

—

-

return_reason_text
default

string

—

-

refund_total
default

string

—

-

update_time
default

date

—

-

Analytics

Product Performance

How each product sold over a period of days: its sales, orders and views, in all and by channel.

Lecture

Product Performance

How each product sold over a period of days: its sales, orders and views, in all and by channel.

Route: GET /productPerformance

Formule Excel: =LF.tiktokshop.productPerformance("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
start_date_gestringYesThe first day, in the shop’s time zone (2026-01-31).
end_date_ltstringYesThe day after the last one, in the shop’s time zone (2026-02-28).
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
product_status_filterenumNoValues: LIVE, INACTIVE, ALL
sort_fieldstringNoThe metric products are sorted on (gmv, the default).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

total_performance
default

string

—

-

seller_live_performance

string

—

-

seller_video_performance

string

—

-

seller_product_card_performance

string

—

-

affiliate_total_performance

string

—

-

shop_tab_performance

string

—

-

Catalog

Activate Product

Puts this product deactivated by the seller back on sale on TikTok Shop.

Creation

Activate Product

Activate Product

Route: POST /mutation/productActivate

Entrees configurables
NameTypeRequiredDescription
productIdidYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Brands

The brands a shop may name on a product, and whether it is authorized to sell each.

Lecture

Brands

The brands a shop may name on a product, and whether it is authorized to sell each.

Route: GET /brands

Formule Excel: =LF.tiktokshop.brands("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
brand_namestringNoOnly the brands whose name begins so.
category_ididNo-
is_authorizedbooleanNoOnly the authorized ones, or not.
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

authorized_status
default

string

—

-

brand_status

string

—

-

is_t1_brand

boolean

—

-

Categories

TikTok Shop’s product categories, as the shop sees them: their tree and whether the shop may list in each.

Utilise comme filtre par

Brands · category_id
Lecture

Categories

TikTok Shop’s product categories, as the shop sees them: their tree and whether the shop may list in each.

Route: GET /categories

Formule Excel: =LF.tiktokshop.categories("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
keywordstringNoOnly the categories whose name holds it.
category_versionenumNov2 (7 levels) in the US, v1 (3 levels) elsewhere. Values: v1, v2
localestringNoThe language of the names (fr-FR).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

local_name
default

string

—

-

parent_id
default

string

→ categories

-

is_leaf
default

boolean

—

-

permission_statuses

string

—

-

Deactivate Product

Takes this product off sale on TikTok Shop: buyers no longer see it.

Creation

Deactivate Product

Deactivate Product

Route: POST /mutation/productDeactivate

Entrees configurables
NameTypeRequiredDescription
productIdidYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Products

The products of a shop: title, status, audit, the SKUs each holds with its price and its stock by warehouse.

Utilise comme filtre par

Stock Commitments · product_id
Lecture

Products

The products of a shop: title, status, audit, the SKUs each holds with its price and its stock by warehouse.

Route: GET /products

Formule Excel: =LF.tiktokshop.products("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
statusenumNoOnly the products in this status. Empty: every status. Values: DRAFT, PENDING, FAILED, ACTIVATE, SELLER_DEACTIVATED
seller_skustringNoOnly the products holding one of these seller SKUs, comma-separated (up to 10), as the seller spelled them.
sku_ididNoOnly the products holding one of these SKU IDs, comma-separated (up to 10).
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

title
default

string

—

-

status
default

string

—

-

audit

string

—

-

status
default

string

—

-

skus

string

—

-

sales_regions

string

—

-

is_not_for_sale

boolean

—

-

has_draft

boolean

—

-

listing_quality_tier

string

—

-

create_time

date

—

-

update_time
default

date

—

-

can_activate

boolean

—

-

can_deactivate

boolean

—

-

SKUs

Every SKU of the shop’s products, one row each: its seller SKU, its price and its product. Its stock is in Stock.

Utilise comme filtre par

Stock Commitments · sku_id
Lecture

SKUs

Every SKU of the shop’s products, one row each: its seller SKU, its price and its product. Its stock is in Stock.

Route: GET /skus

Formule Excel: =LF.tiktokshop.skus("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
statusenumNoOnly the products in this status. Empty: every status. Values: DRAFT, PENDING, FAILED, ACTIVATE, SELLER_DEACTIVATED
seller_skustringNoOnly the products holding one of these seller SKUs, comma-separated (up to 10), as the seller spelled them.
sku_ididNoOnly the products holding one of these SKU IDs, comma-separated (up to 10).
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

seller_sku
default

string

—

-

product_title
default

string

—

-

product_id
default

id

→ products

-

currency
default

string

—

-

tax_exclusive_price
default

string

—

-

update_time
default

date

—

-

Modification

Set Price

Set Price

Route: PATCH /mutation/skus

Entrees configurables
NameTypeRequiredDescription
ididYes-
price.amountstringNo-
price.currencystringNo-
price.sale_pricestringNo-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Stock

The stock of each SKU in each warehouse: the quantity TikTok Shop can ship at once. A SKU is read here as the seller spells it.

Lecture

Stock

The stock of each SKU in each warehouse: the quantity TikTok Shop can ship at once. A SKU is read here as the seller spells it.

Route: GET /inventoryLevels

Formule Excel: =LF.tiktokshop.inventoryLevels("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
warehouse_ididNoOnly the stock of this warehouse.
statusenumNoOnly the products in this status. Empty: every status. Values: DRAFT, PENDING, FAILED, ACTIVATE, SELLER_DEACTIVATED
seller_skustringNoOnly the products holding one of these seller SKUs, comma-separated (up to 10), as the seller spelled them.
sku_ididNoOnly the products holding one of these SKU IDs, comma-separated (up to 10).
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

seller_sku
default

string

—

-

product_title
default

string

—

-

warehouse_id
default

id

→ warehouses

-

quantity
default

number

—

-

update_time
default

date

—

-

Modification

Set Stock

Set Stock

Route: PATCH /mutation/inventoryLevels

Entrees configurables
NameTypeRequiredDescription
ididYes-
quantitynumberYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Stock Commitments

What each SKU has available and what open orders hold of it, in all and by warehouse: read for named products or SKUs.

Lecture

Stock Commitments

What each SKU has available and what open orders hold of it, in all and by warehouse: read for named products or SKUs.

Route: GET /inventory

Formule Excel: =LF.tiktokshop.inventory("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
product_ididNoThe products whose SKUs are read, comma-separated. This or SKU ID is required.
sku_ididNoThe SKUs read, comma-separated. This or Product is required.
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

seller_sku
default

string

—

-

product_id
default

id

→ products

-

total_available_quantity
default

number

—

-

total_committed_quantity
default

number

—

-

warehouse_inventory

string

—

-

Finance

Balance Movements

Every movement of the seller’s TikTok Shop balance: settlements, withdrawals, transfers, reversals.

Lecture

Balance Movements

Every movement of the seller’s TikTok Shop balance: settlements, withdrawals, transfers, reversals.

Route: GET /withdrawals

Formule Excel: =LF.tiktokshop.withdrawals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
typesstringNoThe movements read, comma-separated: WITHDRAW, SETTLE, TRANSFER, REVERSE, PAYMENT, REFUND. Default: WITHDRAW,SETTLE,TRANSFER,REVERSE
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

type
default

string

—

-

amount
default

string

—

-

currency
default

string

—

-

status
default

string

—

-

create_time
default

date

—

-

Order Settlement

How one order was settled, SKU by SKU: its revenue, TikTok Shop’s fees and taxes, shipping, what is paid.

Lecture

Order Settlement

How one order was settled, SKU by SKU: its revenue, TikTok Shop’s fees and taxes, shipping, what is paid.

Route: GET /orderTransactions

Formule Excel: =LF.tiktokshop.orderTransactions("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
order_ididYesThe order whose settlement is read.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

order_id
default

id

→ orders

-

sku_id
default

string

—

-

product_name
default

string

—

-

quantity
default

string

—

-

settlement_amount
default

string

—

-

revenue_amount
default

string

—

-

fee_tax_amount
default

string

—

-

Payments

What TikTok Shop paid out to the seller’s bank account: amount, exchange, status and when.

Lecture

Payments

What TikTok Shop paid out to the seller’s bank account: amount, exchange, status and when.

Route: GET /payments

Formule Excel: =LF.tiktokshop.payments("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

status
default

string

—

-

amount

string

—

-

value
default

string

—

-

currency
default

string

—

-

settlement_amount

string

—

-

value

string

—

-

currency

string

—

-

exchange_rate

string

—

-

bank_account

string

—

-

create_time
default

date

—

-

paid_time

date

—

-

Statement Transactions

What one statement settles, one transaction each: an order’s revenue, fees and shipping, a reserve, an adjustment.

Lecture

Statement Transactions

What one statement settles, one transaction each: an order’s revenue, fees and shipping, a reserve, an adjustment.

Route: GET /statementTransactions

Formule Excel: =LF.tiktokshop.statementTransactions("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
statement_ididYesThe statement whose transactions are read.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

statement_id
default

id

→ statements

-

type
default

string

—

-

order_id
default

id

→ orders

-

settlement_amount
default

string

—

-

revenue_amount
default

string

—

-

fee_tax_amount
default

string

—

-

Statements

The statements TikTok Shop settles a shop by: revenue, fees, shipping, adjustments and what it pays.

Lecture

Statements

The statements TikTok Shop settles a shop by: revenue, fees, shipping, adjustments and what it pays.

Route: GET /statements

Formule Excel: =LF.tiktokshop.statements("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
statement_fromstringNoStatements generated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
statement_tostringNoStatements generated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
payment_statusenumNoOnly the statements in this payment status. Values: PAID, FAILED, PROCESSING
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

statement_time
default

date

—

-

currency
default

string

—

-

settlement_amount
default

string

—

-

revenue_amount
default

string

—

-

fee_amount
default

string

—

-

payment_status
default

string

—

-

Marketing

Deactivate Promotion

Ends this promotion now: its products go back to their usual price.

Creation

Deactivate Promotion

Deactivate Promotion

Route: POST /mutation/promotionDeactivate

Entrees configurables
NameTypeRequiredDescription
activity_ididYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Promotions

The promotion activities of a shop: flash sales, discounts, shipping discounts, their dates and status.

Lecture

Promotions

The promotion activities of a shop: flash sales, discounts, shipping discounts, their dates and status.

Route: GET /promotions

Formule Excel: =LF.tiktokshop.promotions("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
statusenumNoOnly the activities in this status. Values: NOT_START, ONGOING, EXPIRED, DEACTIVATED
activity_typeenumNoValues: FIXED_PRICE, DIRECT_DISCOUNT, FLASHSALE, SHIPPING_DISCOUNT, BUY_MORE_SAVE_MORE
activity_titlestringNoOnly the activities whose title holds these words.
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

title
default

string

—

-

activity_type
default

string

—

-

status
default

string

—

-

begin_time
default

date

—

-

end_time
default

date

—

-

Sales

Aftersale Eligibility

What the seller may still do on an order’s lines — cancel, refund, return — and the reasons TikTok Shop accepts for each.

Lecture

Aftersale Eligibility

What the seller may still do on an order’s lines — cancel, refund, return — and the reasons TikTok Shop accepts for each.

Route: GET /orderEligibility

Formule Excel: =LF.tiktokshop.orderEligibility("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
orderIdidYesThe order whose records are read.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
request_typesenumNoOnly this kind of request. Empty: every kind. Values: CANCEL, REFUND, RETURN_AND_REFUND
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

orderId
default

id

→ orders

-

sku_id
default

string

—

-

request_type
default

string

—

-

eligible
default

boolean

—

-

available_reason_names
default

string

—

-

Cancel Order

Cancels this order, or the lines named, as the seller: TikTok Shop refunds what the buyer paid. Its reasons: Aftersale Eligibility.

Creation

Cancel Order

Cancel Order

Route: POST /mutation/orderCancel

Entrees configurables
NameTypeRequiredDescription
cancel_reasonstringYes-
order_line_item_idsstringNo-
orderIdidYes-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Mark Shipped

Records a shipment the seller made by itself, with its tracking number: the order’s lines named, or every line.

Creation

Mark Shipped

Mark Shipped

Route: POST /mutation/orderMarkShipped

Entrees configurables
NameTypeRequiredDescription
order_line_item_idsstringNo-
orderIdidYes-
shipping_provider_idstringYes-
shop_ididNo-
tracking_numberstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Orders

The orders of a shop: status, payment, fulfillment, the buyer’s note and their lines — one line per unit sold.

Lecture

Orders

The orders of a shop: status, payment, fulfillment, the buyer’s note and their lines — one line per unit sold.

Route: GET /orders

Formule Excel: =LF.tiktokshop.orders("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
order_statusenumNoOnly the orders in this status. Values: UNPAID, ON_HOLD, AWAITING_SHIPMENT, PARTIALLY_SHIPPING, AWAITING_COLLECTION
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
sort_fieldenumNoThe moment the orders are sorted on: creation (the default) or last change. Values: create_time, update_time
sort_orderenumNoOldest first, or latest first (the default). Values: ASC, DESC
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

status
default

string

—

-

currency
default

string

—

-

total_amount
default

string

—

-

fulfillment_type
default

string

—

-

create_time
default

date

—

-

update_time
default

date

—

-

Packages

The packages of a shop’s orders: their status, tracking number and carrier, and the lines each holds.

Lecture

Packages

The packages of a shop’s orders: their status, tracking number and carrier, and the lines each holds.

Route: GET /packages

Formule Excel: =LF.tiktokshop.packages("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record. An unknown id is TikTok Shop’s refusal.
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
package_statusenumNoValues: TO_FULFILL, PROCESSING, FULFILLING, COMPLETED, CANCELLED
updated_fromstringNoUpdated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
updated_tostringNoUpdated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_fromstringNoCreated at or after this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
created_tostringNoCreated before this moment (ISO 8601, 2026-01-31T00:00:00Z, or a Unix time in seconds).
sort_orderenumNoOldest first, or latest first. Values: ASC, DESC
page_sizenumberNoRows per page (max 50). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

status
default

string

—

-

tracking_number
default

string

—

-

shipping_provider_name
default

string

—

-

shipping_provider_id

string

—

-

orders

string

—

-

order_line_item_ids

string

—

-

create_time

date

—

-

update_time
default

date

—

-

can_ship

boolean

—

-

Ship Package

Arranges this package’s shipment: TikTok Shop’s carrier picks it up or it is dropped off — or, shipped by the seller, its tracking.

Creation

Ship Package

Ship Package

Route: POST /mutation/packageShip

Entrees configurables
NameTypeRequiredDescription
handover_methodenumNoValues: PICKUP, DROP_OFF
package_ididYes-
self_shipment.shipping_provider_idstringNo-
self_shipment.tracking_numberstringNo-
shop_ididNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Shop

Shops

The shops the seller authorized LinkyFlow on: a local seller has one, a cross-border seller one per market.

Lecture

Shops

The shops the seller authorized LinkyFlow on: a local seller has one, a cross-border seller one per market.

Route: GET /shops

Formule Excel: =LF.tiktokshop.shops("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

region
default

string

—

-

seller_type
default

string

—

-

code

string

—

-

Warehouses

The warehouses of a shop: where its stock is held, and whether it sells from each.

Utilise comme filtre par

Stock · warehouse_id
Lecture

Warehouses

The warehouses of a shop: where its stock is held, and whether it sells from each.

Route: GET /warehouses

Formule Excel: =LF.tiktokshop.warehouses("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
shop_ididNoThe shop to read or write, among those the seller authorized. Empty: the connection’s first shop.
page_sizenumberNoRows per page (max 100). Default: 50
page_tokenstringNoThe token the previous page answered (next_page_token): empty for the first page.
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

effect_status
default

string

—

-

type
default

string

—

-

sub_type

string

—

-

is_default
default

boolean

—

-

address

string

—

-

region_code

string

—

-

city

string

—

-

postal_code

string

—

-

← PrécédentStock et commandes TikTok ShopSuivant →LinkyFlow pour les partenaires Shopify