Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
Order ID TikTok Shop order ID. |
| ||||||
Buyer Message The note from the buyer. |
| ||||||
Cancellation Initiator Cancellation request initiator. Available values: SELLER, BUYER, SYSTEM. |
| ||||||
Shipping Provider ID The ID of the current shipping provider. |
| ||||||
Create Time The date and time that the order was created. Unix timestamp. |
| ||||||
Shipping Provider The name of the current shipping provider. |
| ||||||
Payment Currency Currency for payment. |
| ||||||
Payment Sub Total Buyer paid sub-total of all the SKUs in the order. For the US market, pre-tax total amount. |
| ||||||
Payment Shipping Fee Buyer paid shipping fee. For the US market, pre-tax total amount. |
| ||||||
Payment Seller Discount Product discount by seller. |
| ||||||
Payment Platform Discount Product discount by platform. |
| ||||||
Payment Total Amount Buyer paid total payment. |
| ||||||
Payment Original Total Product Price Total original price of the products (VAT included for cross-border shops). US: pre-tax. |
| ||||||
Payment Original Shipping Fee Shipping fee before discount. |
| ||||||
Payment Shipping Fee Seller Discount Shipping fee discount provided by seller not co-funded. |
| ||||||
Payment Shipping Fee Platform Discount Shipping fee discount provided by platform. |
| ||||||
Payment Shipping Fee Cofunded Discount Seller shipping fee discount eligible for co-funded reimbursement. |
| ||||||
Payment Tax Buyer paid total taxes for the order. |
| ||||||
Payment Small Order Fee Small order fee (TH market only). |
| ||||||
Payment Shipping Fee Tax The tax on the shipping price. |
| ||||||
Payment Product Tax The tax on the total item price. |
| ||||||
Payment Retail Delivery Fee Retail delivery fee (RDF). US only. |
| ||||||
Payment Buyer Service Fee Service fee applied from the fifth order onwards. Indonesia only. |
| ||||||
Payment Handling Fee Fee to cover additional processing/handling costs. Indonesia only. |
| ||||||
Payment Shipping Insurance Fee Insurance cost against loss or damage during transit. Indonesia only. |
| ||||||
Payment Item Insurance Fee Post-purchase product insurance cost. US and Indonesia. |
| ||||||
Recipient Full Address Complete recipient address information. |
| ||||||
Recipient Phone Number Recipient telephone number (may be desensitized with platform logistics). |
| ||||||
Recipient Name Recipient name (may be desensitized with platform logistics). |
| ||||||
Recipient First Name Recipient first name (US, UK, JP only). |
| ||||||
Recipient Last Name Recipient last name (US, UK, JP only). |
| ||||||
Recipient First Name (Local Script) Recipient first name in katakana (JP only). |
| ||||||
Recipient Last Name (Local Script) Recipient last name in katakana (JP only). |
| ||||||
Recipient Address Detail Full recipient detailed address. |
| ||||||
Recipient Address Line 1 The first line of the street address. |
| ||||||
Recipient Address Line 2 The second line of the street address. |
| ||||||
Recipient Address Line 3 The third line of the street address (usually BR). |
| ||||||
Recipient Address Line 4 The fourth line of the street address (usually BR). |
| ||||||
Delivery Prefs Drop-off Location Drop-off location selected by the recipient (US only). |
| ||||||
Postal Code Postal/ZIP code for shipping. |
| ||||||
Region Code Region code. |
| ||||||
Post Town Post town of the address (UK only). |
| ||||||
Status Specific order status. |
| ||||||
Fulfillment Type Fulfillment type for the order. |
| ||||||
Delivery Type Indicates PUDO vs home delivery. |
| ||||||
Paid Time The date and time that the order was paid. Unix timestamp. |
| ||||||
RTS SLA Time Latest shipping time specified by the platform. Unix timestamp. |
| ||||||
TTS SLA Time Latest collection time specified by the platform. Unix timestamp. |
| ||||||
Cancel Reason Cancellation reason. |
| ||||||
Update Time Time of order status change. Unix timestamp. |
| ||||||
Payment Method Name Payment method name for display. |
| ||||||
RTS Time Time seller shipped the order. Unix timestamp. |
| ||||||
Tracking Number Tracking number. Available after shipment. |
| ||||||
Split/Combine Tag Indicates whether the order is combined or split. |
| ||||||
Has Updated Recipient Address Whether the recipient address has been updated. |
| ||||||
Cancel Order SLA Time Automatic cancellation time set by the platform. Unix timestamp. |
| ||||||
Warehouse ID Seller warehouse ID. |
| ||||||
Request Cancel Time Buyer request cancellation time. Unix timestamp. |
| ||||||
Shipping Type Delivery method: TIKTOK or SELLER. |
| ||||||
Buyer User ID Buyer user ID. |
| ||||||
Seller Note Seller note from Seller Center. |
| ||||||
Delivery SLA Time Order should arrive by this date to be on-time. Unix timestamp. |
| ||||||
Is COD Whether the order is Cash on Delivery. |
| ||||||
Delivery Option ID Mapped to seller logistics template ID. |
| ||||||
Cancel Time Time status updated to CANCELLED. Unix timestamp. |
| ||||||
Need Upload Invoice Whether an invoice needs to be uploaded and status (BR only). |
| ||||||
Delivery Option Name Delivery option name for display. |
| ||||||
CPF Invoice number used to issue an invoice (BR only). |
| ||||||
Buyer Email Anonymized buyer email. |
| ||||||
Delivery Due Time Auto-cancel if not DELIVERED by this time. Unix timestamp. |
| ||||||
Is Sample Order Whether the order is a sample order. |
| ||||||
Shipping Due Time Auto-cancel if not AWAITING_COLLECTION by this time. Unix timestamp. |
| ||||||
Collection Due Time Auto-cancel if not IN_TRANSIT by this time. Unix timestamp. |
| ||||||
Required Delivery Time Order should be delivered before this time. Unix timestamp. |
| ||||||
Is On-Hold Order Whether the order is or will be ON_HOLD. |
| ||||||
Delivery Time Time status changed to DELIVERED. Unix timestamp. |
| ||||||
Is Replacement Order Whether this is a replacement order. |
| ||||||
Collection Time Time status updated to IN_TRANSIT. Unix timestamp. |
| ||||||
Replaced Order ID Order ID that is being replaced (if applicable). |
| ||||||
Buyer Requested Cancel Whether the buyer has a pending cancellation request. |
| ||||||
Pick-up Cut-off Time Latest pick-up time to avoid LDR (SEA regions). Unix timestamp. |
| ||||||
Fast Dispatch SLA Time Latest collection time to gain NDD incentives (TH, PH). Unix timestamp. |
| ||||||
Commerce Platform Platform where the order was placed (e.g., TIKTOK_SHOP, TOKOPEDIA). |
| ||||||
Order Type Order type (e.g., ZERO_LOTTERY, PRE_ORDER, MADE_TO_ORDER, BACK_ORDER). |
| ||||||
Release Date Date handling starts (PRE_ORDER). Unix timestamp. |
| ||||||
Handling Duration Days Number of days for handling (MADE_TO_ORDER/BACK_ORDER). |
| ||||||
Handling Duration Type CALENDAR_DAY or BUSINESS_DAY. Default BUSINESS_DAY. |
| ||||||
Auto Combine Group ID Identifier to combine orders from the same customer during LIVE. |
| ||||||
CPF Name Name belonging to the CPF number (BR market). |
| ||||||
Is Exchange Order TRUE if this is an exchange order (US/UK). |
| ||||||
Exchange Source Order ID Original order ID for the exchange order (US/UK). |
| ||||||
Consultation ID ID for corresponding ePharmacy consultation, if initiated. |
| ||||||
Fast Delivery Program Badge indicating fast delivery program (e.g., 3_DAY_DELIVERY). US only. |
| ||||||
Fulfillment Priority Level Priority value to prioritize shipping (SEA). |
| ||||||
Recommended Shipping Time Recommended time to ship based on LSP service type (SEA). Unix timestamp. |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|
.svg){kind=logo}