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

订单利润明细

326350 条,共 6,384

点击订单号查看 sheet 完整字段

店铺订单号下单时间订单状态结算金额净 GMV预计收入平台费用产品成本尾程扣减毛利润毛利率
Jollychefus07/14 03:27DELIVERED$23.49$24.99--$1.50$5.55$12.61$4.2216.9%
Jollychefus07/14 03:25IN_TRANSIT--$66.99-$9.38$27.74-$16.8425.1%
Jollychefus07/14 03:25DELIVERED$11.76$27.99--$16.23$5.98$0.00$2.8710.3%
Jollychefus07/14 03:24DELIVERED$22.55$23.99--$1.44$4.29$11.98$4.9720.7%
Jollychefus07/14 03:22DELIVERED$20.01$23.27--$3.26$7.17$11.37$0.301.3%
Jollychefus07/14 03:10DELIVERED$22.55$23.99--$1.44$4.29$11.98$5.0921.2%
Jollychefus07/14 03:09DELIVERED$25.79$29.99--$4.20$7.20$11.37$6.2220.7%
Jollychefus07/14 03:05DELIVERED$20.63$23.99--$3.36$3.83$11.98$3.5014.6%
Jollychefus07/14 03:00DELIVERED$14.51$26.99--$12.48$5.51$0.00$6.9525.8%
Jollychefus07/14 02:48DELIVERED$22.66$29.99--$7.33$7.20$11.37$3.0910.3%
Jollychefus07/14 02:41DELIVERED$11.98$19.99--$8.01$3.89$0.00$6.2231.1%
Jollychefus07/14 02:20DELIVERED$31.81$36.99--$5.18$12.64$16.84$0.521.4%
Jollychefus07/14 02:08DELIVERED$17.68$23.27--$5.59$7.17$11.37-$1.96-8.4%
Jollychefus07/14 01:20DELIVERED$7.28$23.99--$16.71$4.29$11.98-$10.30-42.9%
Jollychefus07/14 00:54DELIVERED$17.76$23.99--$6.23$4.29$11.98$0.180.8%
Jollychefus07/14 00:40DELIVERED$18.23$23.99--$5.76$4.29$11.98$0.773.2%
Jollychefus07/14 00:08DELIVERED$20.63$23.99--$3.36$4.29$11.98$3.1713.2%
Jollychefus07/13 23:20DELIVERED$25.24$36.98--$11.74$7.58$0.00$14.0538.0%
Jollychefus07/13 23:02DELIVERED$22.55$23.99--$1.44$4.29$11.98$5.0921.2%
Jollychefus07/13 22:41DELIVERED$18.23$23.99--$5.76$4.29$11.98$0.652.7%
Jollychefus07/13 22:05DELIVERED$22.49$23.99--$1.50$4.29$11.98$4.9120.5%
Jollychefus07/13 21:43DELIVERED$22.55$23.99--$1.44$4.29$11.98$5.1721.6%
Jollychefus07/13 21:42DELIVERED$68.81$92.99--$24.18$23.67$0.00$43.4946.8%
Jollychefus07/13 21:02DELIVERED$20.63$23.99--$3.36$4.29$11.98$3.0512.7%
Jollychefus07/13 17:01DELIVERED$20.01$23.27--$3.26$7.17$11.37$0.301.3%
14 / 256

最近刷新记录

每日定时任务和页面手动任务共用运行历史。

状态触发方式店铺数据区间开始时间耗时写入订单错误
失败计划任务Jollychefus2026-04-252026-07-232026/07/23 03:30:004 分 34 秒0CalledProcessError: 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.
失败计划任务Jollychefus2026-04-242026-07-222026/07/22 03:30:004 分 28 秒0CalledProcessError: 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.
成功计划任务Jollychefus2026-04-232026-07-212026/07/21 03:30:008 分 17 秒6,304-
成功计划任务Jollychefus2026-04-222026-07-202026/07/20 03:30:008 分 7 秒6,298-
成功计划任务Jollychefus2026-04-212026-07-192026/07/19 03:30:007 分 49 秒6,285-
失败计划任务Jollychefus2026-04-202026-07-182026/07/18 03:30:0011 秒0CalledProcessError: 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.