Console / Settings
设置
本地数据库路径、Google Sheets 镜像目标与发布状态。
Sources
Google Sheets 镜像目标
sheet · 2026-arcteryxUS
1zSa8SApS0d7K4bgp1mmir44MF8Bp69lE-PfQZRMVVbs
sheet · 2026-arcteryxCA
1zSa8SApS0d7K4bgp1mmir44MF8Bp69lE-PfQZRMVVbs
以上 US / CA 原表沿用原商品／包裹展示与首次采集日期分组；arc_v1_* 底表继续作为内部发布数据保留。明确归属的商品与财务源字段持续同步，原表人工金额、自由文本状态及公式保留；无法无损映射的具体变更会报告异常。发布与队列状态反映内部同步，原表异常会显示在发布错误中。
Connection
接入凭据
Spreadsheet ID
1zSa8SApS0d7K4bgp1mmir44MF8Bp69lE-PfQZRMVVbs
Service Account File
/Volumes/wykk/projects/arc-order-system/credentials.json
✓ 凭据已找到
Storage
本地持久化
本地订单
461
本地 SKU
30
覆写记录
49
操作日志
319
Database Path
/Volumes/wykk/projects/arc-order-system/data/wykk-local.sqlite
Mirror Queue
镜像队列
积压（pending+failed）
19
失败
1
最老积压
8小时前
镜像发布 · flat
最近已接受发布：12badf0a-a6c1-4564-ac39-17d4b9f05a07
461 订单 · 905 明细 · 467 包裹 · 661 分配
待确认发布：ea254f37-fb09-4657-99e7-7f12b1ed63e6
发布错误：recovery_mismatch
历史 Google 导入时间不代表当前镜像的更新时间；请结合发布与队列状态查看。
Last mirror error
flat publication not verified
8小时前
Pipeline Rules
阶段推断规则
异常关键词
退货 / 取消 / 丢件 / 退款 → 异常
财务字段命中
到手 / 利润 / 结算 → 已结算
销售/运费命中
售卖 / 运费 → 国内仓处理中
包裹预报
当前绑定账号的全部现有包裹均有成功账本或到库证据 → 已预报
包裹到库
全部现有包裹均已到库 → 转运仓处理中；混合包裹取较早阶段，未发货余量单独显示
历史 Google 导入记录 · 非当前镜像更新时间
导入 303 条订单与 23 条 SKU 目录。
Product Rules
品类与颜色规则
规则按顺序匹配标题：命中的第一条生效；颜色按“斜杠首段 → 各段 → 整个值，先完整键再首词”的既有顺序翻译。 保存不会改写已存明细的颜色，也不会重跑旧邮件或重发已预报包裹；已排队载荷在新规则下哈希变化时由既有冲突保护拦截，需要人工重新确认。 未初始化时页面与解析都使用代码内置默认规则（15 条品类 / 31 条颜色）。
品类规则（按顺序匹配）
| # | 正则（source） | flags | 品类 | 启用 | 顺序 |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 | |||||
| 11 | |||||
| 12 | |||||
| 13 | |||||
| 14 | |||||
| 15 | |||||
| 16 |
颜色规则（键 → 中文）
| # | 键（key） | 翻译值 | 启用 | 移除 |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 | ||||
| 10 | ||||
| 11 | ||||
| 12 | ||||
| 13 | ||||
| 14 | ||||
| 15 | ||||
| 16 | ||||
| 17 | ||||
| 18 | ||||
| 19 | ||||
| 20 | ||||
| 21 | ||||
| 22 | ||||
| 23 | ||||
| 24 | ||||
| 25 | ||||
| 26 | ||||
| 27 | ||||
| 28 | ||||
| 29 | ||||
| 30 | ||||
| 31 |
匹配预览
使用当前草稿（含未保存编辑）与线上同一套匹配逻辑预览，不会写入任何数据。
最近变更（修改前后与时间）
- 2026/10/22 23:55品类 · 修改[{"pattern":"\\bbird\\s+word\\s+toque\\b","flags":"i","category":"帽子","enabled":true},{"pattern":"\\bkonseal\\s*15\\s*backpack\\b","flags":"i","category":"背包","enabled":true},{"pattern":"\\bkragg\\s+sl\\s+cotton\\s+shirt\\s+ss\\b","flags":"i","category":"短袖","enabled":true},{"pattern":"\\brho\\s+lt\\s+(?:crew\\s+neck|zip\\s+neck)\\s+men'?s\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:backpack|daypack|rucksack|pack)\\b","flags":"i","category":"背包","enabled":true},{"pattern":"\\b(?:toque|beanie|cap|hat|trucker)\\b","flags":"i","category":"帽子","enabled":true},{"pattern":"\\b(?:short\\s+sleeve|ss|tee|t\\s+shirt|tank|polo)\\b","flags":"i","category":"短袖","enabled":true},{"pattern":"\\b(?:overshirt|cardigan)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:parka|coat|anorak)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:shirt|crew(?:\\s+neck)?|zip\\s+neck|jacket|hoody|hoodie|sweater|pullover|vest)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:pants?|shorts?(?!\\s+sleeve)|trousers?|leggings?|bottoms?)\\b","flags":"i","category":"裤子","enabled":true},{"pattern":"\\bgloves?\\b","flags":"i","category":"手套","enabled":true},{"pattern":"\\bsocks?\\b","flags":"i","category":"袜子","enabled":true},{"pattern":"\\b(?:shoe|shoes|boot|boots)\\b","flags":"i","category":"鞋子","enabled":true},{"pattern":"\\b(?:bags?|sling|tote|duffel|duffle|pouch|satchel)\\b","flags":"i","category":"包","enabled":true}] → [{"pattern":"\\bbird\\s+word\\s+toque\\b","flags":"i","category":"帽子","enabled":true},{"pattern":"\\bkonseal\\s*15\\s*backpack\\b","flags":"i","category":"背包","enabled":true},{"pattern":"\\bkragg\\s+sl\\s+cotton\\s+shirt\\s+ss\\b","flags":"i","category":"短袖","enabled":true},{"pattern":"\\brho\\s+lt\\s+(?:crew\\s+neck|zip\\s+neck)\\s+men'?s\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:backpack|daypack|rucksack|pack)\\b","flags":"i","category":"背包","enabled":true},{"pattern":"\\b(?:toque|beanie|cap|hat|trucker)\\b","flags":"i","category":"帽子","enabled":true},{"pattern":"\\b(?:short\\s+sleeve|ss|tee|t\\s+shirt|tank|polo)\\b","flags":"i","category":"短袖","enabled":true},{"pattern":"\\b(?:overshirt|cardigan)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:parka|coat|anorak)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:shirt|crew(?:\\s+neck)?|zip\\s+neck|jacket|hoody|hoodie|sweater|pullover|vest)\\b","flags":"i","category":"上衣","enabled":true},{"pattern":"\\b(?:pants?|shorts?(?!\\s+sleeve)|trousers?|leggings?|bottoms?)\\b","flags":"i","category":"裤子","enabled":true},{"pattern":"\\bgloves?\\b","flags":"i","category":"手套","enabled":true},{"pattern":"\\bsocks?\\b","flags":"i","category":"袜子","enabled":true},{"pattern":"\\b(?:shoe|shoes|boot|boots)\\b","flags":"i","category":"鞋子","enabled":true},{"pattern":"\\b(?:bags?|sling|tote|duffel|duffle|pouch|satchel)\\b","flags":"i","category":"包","enabled":true},{"pattern":"^rho lt圆领衫$","flags":"i","category":"上衣","enabled":true}]local_ui
- 2026/10/7 12:24配置 · 初始化— → defaultslocal_ui