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
订单利润明细
第 201–225 条，共 6,384 条
点击订单号查看 sheet 完整字段
| 店铺 | 订单号 | 下单时间 | 订单状态 | 结算金额 | 净 GMV | 预计收入 | 平台费用 | 产品成本 | 尾程扣减 | 毛利润 | 毛利率 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jollychefus | 07/16 01:28 | DELIVERED | $17.68 | $23.27 | - | -$5.59 | $7.17 | $11.37 | -$2.00 | -8.6% | |
| Jollychefus | 07/16 01:25 | DELIVERED | - | - | - | - | $4.13 | - | - | - | |
| Jollychefus | 07/16 00:50 | IN_TRANSIT | - | - | $25.99 | -$5.46 | $4.93 | - | $4.54 | 17.5% | |
| Jollychefus | 07/16 00:31 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.29 | $9.16 | $6.06 | 25.3% | |
| Jollychefus | 07/16 00:05 | DELIVERED | $9.75 | $19.99 | - | -$10.24 | $3.79 | $0.00 | $4.16 | 20.8% | |
| Jollychefus | 07/16 00:04 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.33 | $11.98 | $3.15 | 13.1% | |
| Jollychefus | 07/16 00:02 | DELIVERED | $7.59 | $19.99 | - | -$12.40 | $3.79 | $0.00 | $2.00 | 10.0% | |
| Jollychefus | 07/15 23:32 | IN_TRANSIT | - | - | $26.99 | -$7.69 | $5.51 | - | $3.54 | 13.1% | |
| Jollychefus | 07/15 23:15 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.29 | $9.16 | $5.87 | 24.5% | |
| Jollychefus | 07/15 23:08 | DELIVERED | - | - | $19.99 | -$1.20 | $3.95 | - | $3.86 | 19.3% | |
| Jollychefus | 07/15 22:51 | DELIVERED | $39.25 | $41.98 | - | -$2.73 | $8.58 | $13.26 | $14.80 | 35.3% | |
| Jollychefus | 07/15 22:43 | IN_TRANSIT | - | - | $19.99 | -$5.40 | $3.95 | - | -$0.34 | -1.7% | |
| Jollychefus | 07/15 20:55 | DELIVERED | - | - | $27.99 | -$1.96 | $6.01 | - | $18.06 | 64.5% | |
| Jollychefus | 07/15 20:47 | DELIVERED | - | - | $19.99 | -$1.49 | $3.95 | - | $3.57 | 17.9% | |
| Jollychefus | 07/15 20:44 | DELIVERED | $11.47 | $19.99 | - | -$8.52 | $3.89 | $0.00 | $5.71 | 28.6% | |
| Jollychefus | 07/15 20:21 | DELIVERED | $19.51 | $27.99 | - | -$8.48 | $5.98 | $0.00 | $10.62 | 37.9% | |
| Jollychefus | 07/15 19:58 | DELIVERED | $15.54 | $25.99 | - | -$10.45 | $4.54 | $0.00 | $9.13 | 35.1% | |
| Jollychefus | 07/15 19:55 | IN_TRANSIT | - | - | $19.99 | -$4.20 | $3.95 | - | $1.70 | 8.5% | |
| Jollychefus | 07/15 19:18 | DELIVERED | $11.13 | $25.99 | - | -$14.86 | $4.54 | $0.00 | $4.72 | 18.2% | |
| Jollychefus | 07/15 16:31 | DELIVERED | $21.19 | $29.99 | - | -$8.80 | $8.44 | $0.00 | $11.48 | 38.3% | |
| Jollychefus | 07/15 16:05 | DELIVERED | $15.72 | $25.99 | - | -$10.27 | $4.93 | $0.00 | $8.77 | 33.7% | |
| Jollychefus | 07/15 15:56 | IN_TRANSIT | - | - | $69.99 | -$17.50 | $27.74 | - | $21.59 | 30.8% | |
| Jollychefus | 07/15 15:11 | DELIVERED | $8.98 | $19.99 | - | -$11.01 | $3.89 | $0.00 | $3.22 | 16.1% | |
| Jollychefus | 07/15 14:50 | DELIVERED | $30.39 | $39.99 | - | -$9.60 | $12.64 | $16.84 | -$0.79 | -2.0% | |
| Jollychefus | 07/15 13:59 | IN_TRANSIT | - | - | $26.99 | -$5.67 | $5.51 | - | $4.72 | 17.5% |
最近刷新记录
每日定时任务和页面手动任务共用运行历史。
| 状态 | 触发方式 | 店铺 | 数据区间 | 开始时间 | 耗时 | 写入订单 | 错误 |
|---|---|---|---|---|---|---|---|
| 失败 | 计划任务 | 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. |