{"mode":"mock_preview","objects":["ProductImportTemplateField","ProductSourceMappingDraft"],"automationPolicy":{"changeDetection":"飞书记录新增、编辑、删除事件触发增量同步；定时巡检用于兜底对账。","deletePolicy":"记录删除不直接删除 Shopify 商品，先将对应库存设为 0 并把映射标记为 source_deleted。","normalPath":"库存和价格字段变更后自动更新 Shopify，不进入人工确认。","quarantinePolicy":"字段缺失、价格异常、库存异常或 Shopify userErrors 只隔离当前 SKU，不阻塞其他 SKU。","shopifyWritePolicy":"已映射 variant 走价格/库存更新；未映射记录自动创建 Product / Variant / Mapping。"},"productSourceMapping":{"id":"product_source_mapping_draft_3c_v0","mappingName":"飞书货源自动同步映射","sourceState":"真实货源表已确认","sourceOfTruth":"ADkabWtH...FId3nbd / Brand new + Asis + Asis+ + CPO","blockedReason":"商品源表已确认；Shopify 写入前还缺 app 权限、location/publication、订单回流和异常通知配置。","nextAction":"实现 Feishu 变更事件、自动 SKU 派生、Shopify 映射写入、库存价格更新和同步日志。"},"hardStops":["稳定 SKU 无法派生时隔离该记录。","库存、USD价格或 HKD价格不是合法数字时隔离该记录。","Shopify 写入失败超过重试上限时隔离该 SKU，并写同步日志。"],"mappingRows":[{"id":"template_sku","sourceColumn":"栏目 + 机型 + Version + 容量 + 卡槽规格 + 状态 + 颜色/货号","sourceFieldKey":"栏目/机型/Version/容量/卡槽规格/状态/颜色/货号","sourceStatus":"自动派生","targetField":"ProductVariant.sku","targetObject":"ProductVariant","targetObjectLabel":"商品规格","requirement":"required","requirementLabel":"必填","mappingRule":"按稳定键规则自动 slug 化，每行对应一个 Shopify variant 映射。","validation":"由栏目、机型、Version、容量、卡槽规格、状态和颜色/货号自动派生，每行必须稳定唯一。"},{"id":"template_product_title","sourceColumn":"品牌 + 机型 + 栏目","sourceFieldKey":"品牌/机型/栏目","sourceStatus":"已确认","targetField":"Product.title","targetObject":"Product","targetObjectLabel":"商品主档","requirement":"required","requirementLabel":"必填","mappingRule":"品牌 + 机型 + 栏目生成商品标题。","validation":"由品牌、机型和栏目自动生成，用于平台商品和 Shopify 商品标题。"},{"id":"template_variant_title","sourceColumn":"Version + 容量 + 卡槽规格 + 状态 + 颜色/货号","sourceFieldKey":"Version/容量/卡槽规格/状态/颜色/货号","sourceStatus":"已确认","targetField":"ProductVariant.title","targetObject":"ProductVariant","targetObjectLabel":"商品规格","requirement":"required","requirementLabel":"必填","mappingRule":"Version + 容量 + 卡槽规格 + 状态 + 颜色/货号生成规格标题。","validation":"由 Version、容量、卡槽规格、状态和颜色/货号自动生成，承载手机行业规格差异。"},{"id":"template_category","sourceColumn":"派生：手机","sourceFieldKey":"derived_category","sourceStatus":"自动派生","targetField":"Product.category","targetObject":"Product","targetObjectLabel":"商品主档","requirement":"required","requirementLabel":"必填","mappingRule":"当前 Base 固定映射为 3C 手机行业包。","validation":"当前新货源 Base 固定进入 3C 手机行业包，后续其他行业仍要有品类字段。"},{"id":"template_base_price","sourceColumn":"USD价格","sourceFieldKey":"USD价格","sourceStatus":"已确认","targetField":"ProductVariant.basePrice","targetObject":"ProductVariant","targetObjectLabel":"商品规格","requirement":"required","requirementLabel":"必填","mappingRule":"读取 USD价格；数值异常或波动超过阈值时隔离该 SKU。","validation":"优先使用 USD价格作为国际报价基础价；必须为数字，异常波动进入隔离。"},{"id":"template_currency","sourceColumn":"派生：USD","sourceFieldKey":"derived_currency","sourceStatus":"自动派生","targetField":"ProductVariant.currency","targetObject":"ProductVariant","targetObjectLabel":"商品规格","requirement":"required","requirementLabel":"必填","mappingRule":"由 USD价格字段派生为 USD；HKD价格保留采购参考。","validation":"由 USD价格字段派生为 USD；HKD价格保留为采购参考价。"},{"id":"template_moq","sourceColumn":"派生：默认 MOQ","sourceFieldKey":"derived_moq","sourceStatus":"自动派生","targetField":"ProductVariant.moq","targetObject":"ProductVariant","targetObjectLabel":"商品规格","requirement":"required","requirementLabel":"必填","mappingRule":"当前表无 MOQ，自动同步先默认 1；后续有 MOQ 字段再覆盖。","validation":"当前货源表缺 MOQ，自动同步先采用默认 1；后续如供应商提供 MOQ 字段再覆盖。"},{"id":"template_quantity_available","sourceColumn":"库存","sourceFieldKey":"库存","sourceStatus":"已确认","targetField":"InventorySnapshot.quantityAvailable","targetObject":"InventorySnapshot","targetObjectLabel":"库存快照","requirement":"required","requirementLabel":"必填","mappingRule":"读取库存；非负整数才进入 Shopify inventorySetQuantities。","validation":"来自库存字段，必须为非负整数；变化后自动同步 Shopify 库存。"},{"id":"template_warehouse","sourceColumn":"派生：香港","sourceFieldKey":"derived_warehouse","sourceStatus":"自动派生","targetField":"InventorySnapshot.warehouse","targetObject":"InventorySnapshot","targetObjectLabel":"库存快照","requirement":"recommended","requirementLabel":"建议","mappingRule":"当前按供应商货源口径默认香港，后续可接真实仓库字段。","validation":"当前由供应商货源口径默认派生，后续可拆成真实仓库或发货地字段。"},{"id":"template_target_country","sourceColumn":"派生：global","sourceFieldKey":"derived_target_country","sourceStatus":"自动派生","targetField":"PriceRule.targetCountry","targetObject":"PriceRule","targetObjectLabel":"价格规则","requirement":"recommended","requirementLabel":"建议","mappingRule":"当前使用 global 通用价格；国家价格规则后续叠加。","validation":"当前货源表提供通用 USD/HKD 价格，不按国家分价；国家价格规则后续单独叠加。"},{"id":"template_shopify_handle","sourceColumn":"派生：Shopify handle","sourceFieldKey":"derived_shopify_handle","sourceStatus":"自动派生","targetField":"ShopifyProductMapping.shopifyHandle","targetObject":"ShopifyProductMapping","targetObjectLabel":"结账映射","requirement":"optional","requirementLabel":"可选","mappingRule":"按 Shopify Product 拆分规则自动 slug 化，不写回原货源表。","validation":"由商品拆分规则自动派生；映射 ID 存在独立映射层，不写回原货源表。"},{"id":"template_review_note","sourceColumn":"派生：sync_exception_reason","sourceFieldKey":"derived_exception_reason","sourceStatus":"自动派生","targetField":"PriceRule.reviewNote","targetObject":"PriceRule","targetObjectLabel":"价格规则","requirement":"optional","requirementLabel":"可选","mappingRule":"由自动同步异常生成，例如错价、缺字段、库存异常或 API 失败。","validation":"用于记录自动隔离原因，如错价、缺字段、库存异常或 Shopify API 失败。"}],"sampleRowPreview":[{"fieldKey":"sku","id":"template_sku","label":"SKU","sampleValue":"brand-new-iphone-17e-a3634-b-a-256gb-1sim-esim-not-activate-rv4","targetField":"ProductVariant.sku"},{"fieldKey":"product_title","id":"template_product_title","label":"商品名称","sampleValue":"Apple iPhone 17e Brand new","targetField":"Product.title"},{"fieldKey":"variant_title","id":"template_variant_title","label":"规格名称","sampleValue":"A3634-B/A / 256GB / 1 Sim+E Sim / Not Activate / Black-黑色-RV4","targetField":"ProductVariant.title"},{"fieldKey":"category","id":"template_category","label":"品类","sampleValue":"手机","targetField":"Product.category"},{"fieldKey":"base_price","id":"template_base_price","label":"基础价格","sampleValue":"632","targetField":"ProductVariant.basePrice"},{"fieldKey":"currency","id":"template_currency","label":"币种","sampleValue":"USD","targetField":"ProductVariant.currency"},{"fieldKey":"moq","id":"template_moq","label":"起订量","sampleValue":"1","targetField":"ProductVariant.moq"},{"fieldKey":"quantity_available","id":"template_quantity_available","label":"可售库存","sampleValue":"1","targetField":"InventorySnapshot.quantityAvailable"},{"fieldKey":"warehouse","id":"template_warehouse","label":"仓库/发货地","sampleValue":"香港","targetField":"InventorySnapshot.warehouse"},{"fieldKey":"target_country","id":"template_target_country","label":"目标国家","sampleValue":"global","targetField":"PriceRule.targetCountry"},{"fieldKey":"shopify_handle","id":"template_shopify_handle","label":"Shopify 商品句柄","sampleValue":"apple-iphone-17e-brand-new-a3634-b-a-256gb-1sim-esim-not-activate","targetField":"ShopifyProductMapping.shopifyHandle"},{"fieldKey":"review_note","id":"template_review_note","label":"审核备注","sampleValue":"price_spike_gt_20_percent","targetField":"PriceRule.reviewNote"}],"sourceProfile":{"baseLabel":"ADkabWtH...FId3nbd","productSplitRule":"栏目 + 机型 + Version + 容量 + 卡槽规格 + 状态 = Shopify Product；颜色/货号 = Shopify Variant","sourceState":"真实货源表已确认","sourceTables":[{"rowCount":193,"statusField":"Not Activate","stockTotal":3821,"tableId":"tblX2UPIYbSaGyqw","tableName":"Brand new"},{"rowCount":484,"statusField":"Active","stockTotal":48207,"tableId":"tblEyp9We57hyD3p","tableName":"Asis"},{"rowCount":69,"statusField":"Not Activate","stockTotal":4832,"tableId":"tbl7QbYg9lFUMNM9","tableName":"Asis+"},{"rowCount":290,"statusField":"Not Activate","stockTotal":26515,"tableId":"tblsxtChwV4O3T7H","tableName":"CPO"}],"sourceTotalRows":1036,"sourceTotalStock":83375,"stableKeyRule":"栏目 + 机型 + Version + 容量 + 卡槽规格 + 状态 + 颜色/货号","triggerFields":["库存","USD价格","HKD价格","状态","机型","Version","容量","卡槽规格","颜色/货号"]},"targetGroups":[{"fields":5,"label":"商品规格","targetObject":"ProductVariant"},{"fields":2,"label":"商品主档","targetObject":"Product"},{"fields":2,"label":"库存快照","targetObject":"InventorySnapshot"},{"fields":2,"label":"价格规则","targetObject":"PriceRule"},{"fields":1,"label":"结账映射","targetObject":"ShopifyProductMapping"}],"totals":{"rows":12,"required":8,"recommended":2,"optional":2,"targetObjects":5,"sourceRows":1036,"sourceStock":83375}}