TK 订单利润
TikTok 订单利润
每日重算最近 90 天并覆盖同店铺同订单；更早的历史订单继续保留。已结算毛利率使用 TK 结算单净 GMV。
订单数
6,384
6,188 条已结算
结算单净 GMV
$183,674.97
TK结算单净GMVUSD
未结算预计收入
$7,846.14
预计收入口径
毛利润
$12,038.91
当前筛选订单合计
综合毛利率
6.3%
毛利润 /（净 GMV + 预计收入）
最新任务
失败2026/07/23 03:30:00
数据区间
2026-04-23 至 2026-07-21
来源脚本
build… · cf7f37745bb8
自动刷新
每日 03:30 · Asia/Shanghai
订单利润明细
第 226–250 条，共 6,384 条
点击订单号查看 sheet 完整字段
| 店铺 | 订单号 | 下单时间 | 订单状态 | 结算金额 | 净 GMV | 预计收入 | 平台费用 | 产品成本 | 尾程扣减 | 毛利润 | 毛利率 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jollychefus | 07/15 13:21 | DELIVERED | $60.39 | $75.97 | - | -$15.58 | $19.29 | $24.41 | $11.46 | 15.1% | |
| Jollychefus | 07/15 13:19 | DELIVERED | $12.05 | $23.99 | - | -$11.94 | $4.58 | $0.00 | $5.48 | 22.8% | |
| Jollychefus | 07/15 12:52 | IN_TRANSIT | - | - | $136.98 | -$9.59 | $55.47 | - | $49.41 | 36.1% | |
| Jollychefus | 07/15 12:50 | AWAITING_COLLECTION | - | - | $33.99 | -$8.16 | $10.59 | - | $13.94 | 41.0% | |
| Jollychefus | 07/15 12:46 | CANCELLED | -$0.24 | $0.00 | - | -$0.24 | $3.79 | $7.44 | -$13.27 | - | |
| Jollychefus | 07/15 11:34 | DELIVERED | $17.68 | $23.27 | - | -$5.59 | $7.17 | $11.37 | -$2.03 | -8.7% | |
| Jollychefus | 07/15 11:13 | IN_TRANSIT | - | - | $23.99 | -$2.95 | $4.13 | - | $15.71 | 65.5% | |
| Jollychefus | 07/15 10:52 | DELIVERED | $16.23 | $25.99 | - | -$9.76 | $4.54 | $0.00 | $9.82 | 37.8% | |
| Jollychefus | 07/15 10:29 | DELIVERED | $25.87 | $36.99 | - | -$11.12 | $13.65 | $16.84 | -$6.15 | -16.6% | |
| Jollychefus | 07/15 10:22 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $2.85 | $14.09 | $4.30 | 17.9% | |
| Jollychefus | 07/15 10:08 | DELIVERED | $22.17 | $29.99 | - | -$7.82 | $7.20 | $11.37 | $2.49 | 8.3% | |
| Jollychefus | 07/15 10:05 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.33 | $11.98 | $0.75 | 3.1% | |
| Jollychefus | 07/15 09:56 | DELIVERED | $24.96 | $33.99 | - | -$9.03 | $12.64 | $16.84 | -$6.55 | -19.3% | |
| Jollychefus | 07/15 09:54 | DELIVERED | $24.43 | $25.99 | - | -$1.56 | $4.01 | $11.05 | $5.88 | 22.6% | |
| Jollychefus | 07/15 09:43 | DELIVERED | - | - | $19.99 | -$4.20 | $3.95 | - | $1.70 | 8.5% | |
| Jollychefus | 07/15 09:21 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $4.79 | $13.22 | $3.18 | 13.3% | |
| Jollychefus | 07/15 08:21 | IN_TRANSIT | - | - | $59.99 | -$20.34 | $21.06 | - | $8.02 | 13.4% | |
| Jollychefus | 07/15 08:18 | DELIVERED | $13.58 | $27.99 | - | -$14.41 | $5.98 | $0.00 | $4.21 | 15.0% | |
| Jollychefus | 07/15 08:01 | IN_TRANSIT | - | - | $35.99 | -$2.16 | $6.42 | - | $17.28 | 48.0% | |
| Jollychefus | 07/15 07:44 | DELIVERED | - | - | $19.99 | -$4.20 | $3.95 | - | $9.90 | 49.5% | |
| Jollychefus | 07/15 07:42 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.30 | 1.3% | |
| Jollychefus | 07/15 07:41 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.30 | 1.3% | |
| Jollychefus | 07/15 07:31 | IN_TRANSIT | - | - | $19.99 | -$2.80 | $3.95 | - | $3.10 | 15.5% | |
| Jollychefus | 07/15 07:27 | DELIVERED | $10.59 | $19.99 | - | -$9.40 | $3.79 | $0.00 | $5.00 | 25.0% | |
| Jollychefus | 07/15 07:25 | IN_TRANSIT | - | - | $35.99 | -$5.23 | $6.42 | - | $15.60 | 43.3% |
最近刷新记录
每日定时任务和页面手动任务共用运行历史。
| 状态 | 触发方式 | 店铺 | 数据区间 | 开始时间 | 耗时 | 写入订单 | 错误 |
|---|---|---|---|---|---|---|---|
| 失败 | 计划任务 | Jollychefus | 2026-04-25 至 2026-07-23 | 2026/07/23 03:30:00 | 4 分 34 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-25', '--end-date', '2026-07-23', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.summary.json', '--max-pages', '100']' returned non-zero exit status 1. Traceback (most recent call last): File "/app/tiktok_order_profit_worker/main.py", line 614, in run_once paths, output_shop_slug = execute_pipeline(start, end, output_directory) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tiktok_order_profit_worker/main.py", line 261, in execute_pipeline run_command( File "/app/tiktok_order_profit_worker/main.py", line 170, in run_command subprocess.run(command, cwd=cwd, check=True) File "/usr/local/lib/python3.12/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-25', '--end-date', '2026-07-23', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.summary.json', '--max-pages', '100']' returned non-zero exit status 1. |
| 失败 | 计划任务 | Jollychefus | 2026-04-24 至 2026-07-22 | 2026/07/22 03:30:00 | 4 分 28 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-24', '--end-date', '2026-07-22', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.summary.json', '--max-pages', '100']' returned non-zero exit status 1. Traceback (most recent call last): File "/app/tiktok_order_profit_worker/main.py", line 614, in run_once paths, output_shop_slug = execute_pipeline(start, end, output_directory) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tiktok_order_profit_worker/main.py", line 261, in execute_pipeline run_command( File "/app/tiktok_order_profit_worker/main.py", line 170, in run_command subprocess.run(command, cwd=cwd, check=True) File "/usr/local/lib/python3.12/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-24', '--end-date', '2026-07-22', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.summary.json', '--max-pages', '100']' returned non-zero exit status 1. |
| 成功 | 计划任务 | Jollychefus | 2026-04-23 至 2026-07-21 | 2026/07/21 03:30:00 | 8 分 17 秒 | 6,304 | - |
| 成功 | 计划任务 | Jollychefus | 2026-04-22 至 2026-07-20 | 2026/07/20 03:30:00 | 8 分 7 秒 | 6,298 | - |
| 成功 | 计划任务 | Jollychefus | 2026-04-21 至 2026-07-19 | 2026/07/19 03:30:00 | 7 分 49 秒 | 6,285 | - |
| 失败 | 计划任务 | Jollychefus | 2026-04-20 至 2026-07-18 | 2026/07/18 03:30:00 | 11 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/sync_tiktok_shop_orders.py', '--config', '/runtime/config.local.json', '--site', 'jollychef', '--start-date', '2026-04-20', '--end-date', '2026-07-18', '--timezone', 'America/Los_Angeles', '--output-dir', '/app/artifacts/tiktok_order_profit/2026-07-18_44a50e3f-d47a-4334-95d0-0730c5b30c45']' returned non-zero exit status 1. Traceback (most recent call last): File "/app/tiktok_order_profit_worker/main.py", line 614, in run_once paths, output_shop_slug = execute_pipeline(start, end, output_directory) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tiktok_order_profit_worker/main.py", line 231, in execute_pipeline run_command( File "/app/tiktok_order_profit_worker/main.py", line 170, in run_command subprocess.run(command, cwd=cwd, check=True) File "/usr/local/lib/python3.12/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['python', '/app/upstream/tools/sync_tiktok_shop_orders.py', '--config', '/runtime/config.local.json', '--site', 'jollychef', '--start-date', '2026-04-20', '--end-date', '2026-07-18', '--timezone', 'America/Los_Angeles', '--output-dir', '/app/artifacts/tiktok_order_profit/2026-07-18_44a50e3f-d47a-4334-95d0-0730c5b30c45']' returned non-zero exit status 1. |