iWMS菜鸟面单区分淘系非淘系订单支持说明

菜鸟对下单应用AppKey进行了订单所属平台统计，要求iWMS相关客户进行数据准确性维护
iWMS应用涉及AppKey：24602748（胜境iWMS）和23090920（百胜iWMS）
iWMS订单来自上游，不同的上游对订单渠道编号可能不同导致和菜鸟对平台的定义也可能不一致
正在使用菜鸟面单匹配的客户按照此文档依次执行

1.执行语句A

select ParmValue FROM dbo.TSysParm WHERE ParmId = 'WD0927'

2.执行语句B

select OrigSystem,SoType from TSyn_order_info where pay_time>'2020-01-01'group by OrigSystem,SoType order by SoType

1）语句A值为0
语句B SoType为TB&TM 且没有纯数字 不包括1688 执行语句C

2）语句A值为1
语句B SoType为纯数字且上游为E3 执行语句D

3）语句A值为1
语句B SoType为TB&TM 且没有纯数字 更新语句A值为0 执行语句C

3.执行语句C

  1. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  2. Values('', '0', 'TB', '淘宝', 'TB', '', '', '', '', '', '', '', '', '', '', '1')
  4. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  5. Values('', '0', 'TM', '天猫', 'TM', '', '', '', '', '', '', '', '', '', '', '1')
  7. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  8. Values('', '0', 'JD', '京东', 'JD', '', '', '', '', '', '', '', '', '', '', '1')
  10. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  11. Values('', '0', '1688', '1688', '1688', '', '', '', '', '', '', '', '', '', '', '1')
  13. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  14. Values('', '0', 'WPH', '唯品会', 'WPH', '', '', '', '', '', '', '', '', '', '', '1')
  16. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  17. Values('', '0', 'PDD', '拼多多', 'PIN_DUO_DUO', '', '', '', '', '', '', '', '', '', '', '1')
  19. Insert Into TDefShippingSalePlatRef( TnId, Product, PlatCode, Explain, CnyzCode, CnyzName, JdCode, JdName, Ex1Code, Ex1Name, Ex2Code, Ex2Name, Ex1, Ex2, Memo, Status)
  20. Values('', '0', 'SN', '苏宁', 'SN', '', '', '', '', '', '', '', '', '', '', '1')

执行完毕后 重启客户端 打开FD进行抓包验证

4.执行语句D

  1. update TDefShippingSalePlatRef set CnyzCode='OTHERS' where PlatCode='0' and Product='1'
  3. update TDefShippingSalePlatRef set CnyzCode='TB' where PlatCode='1' and Product='1'
  5. update TDefShippingSalePlatRef set CnyzCode='PP' where PlatCode='2' and Product='1'
  7. update TDefShippingSalePlatRef set CnyzCode='JD' where PlatCode='5' and Product='1'
  9. update TDefShippingSalePlatRef set CnyzCode='AMAZON' where PlatCode='11' and Product='1'
  11. update TDefShippingSalePlatRef set CnyzCode='YHD' where PlatCode='13' and Product='1'
  13. update TDefShippingSalePlatRef set CnyzCode='EBAY' where PlatCode='21' and Product='1'
  15. update TDefShippingSalePlatRef set CnyzCode='DD' where PlatCode='22' and Product='1'
  17. update TDefShippingSalePlatRef set CnyzCode='YG' where PlatCode='26' and Product='1'
  19. update TDefShippingSalePlatRef set CnyzCode='LF' where PlatCode='28' and Product='1'
  21. update TDefShippingSalePlatRef set CnyzCode='WPH' where PlatCode='29' and Product='1'
  23. update TDefShippingSalePlatRef set CnyzCode='JM' where PlatCode='30' and Product='1'
  25. update TDefShippingSalePlatRef set CnyzCode='SN' where PlatCode='32' and Product='1'
  27. update TDefShippingSalePlatRef set CnyzCode='YOU_ZAN' where PlatCode='38' and Product='1'
  29. update TDefShippingSalePlatRef set CnyzCode='YT' where PlatCode='27' and Product='1'
  31. update TDefShippingSalePlatRef set CnyzCode='SN' where PlatCode='42' and Product='1'
  33. update TDefShippingSalePlatRef set CnyzCode='JD' where PlatCode='43' and Product='1'
  35. update TDefShippingSalePlatRef set CnyzCode='WEI_MENG' where PlatCode='44' and Product='1'
  37. update TDefShippingSalePlatRef set CnyzCode='CHU_CHU_JIE' where PlatCode='52' and Product='1'
  39. update TDefShippingSalePlatRef set CnyzCode='GM' where PlatCode='50' and Product='1'
  41. update TDefShippingSalePlatRef set CnyzCode='MI_YA' where PlatCode='61' and Product='1'
  43. update TDefShippingSalePlatRef set CnyzCode='BEI_BEI' where PlatCode='62' and Product='1'
  45. update TDefShippingSalePlatRef set CnyzCode='MGJ' where PlatCode='63' and Product='1'
  47. update TDefShippingSalePlatRef set CnyzCode='1688' where PlatCode='70' and Product='1'
  49. update TDefShippingSalePlatRef set CnyzCode='JUAN_PI' where PlatCode='83' and Product='1'
  51. update TDefShippingSalePlatRef set CnyzCode='MENG_DIAN' where PlatCode='84' and Product='1'
  53. update TDefShippingSalePlatRef set CnyzCode='MGJ' where PlatCode='86' and Product='1'
  55. update TDefShippingSalePlatRef set CnyzCode='PIN_DUO_DUO' where PlatCode='92' and Product='1'
  57. update TDefShippingSalePlatRef set CnyzCode='KAO_LA' where PlatCode='93' and Product='1'
  59. update TDefShippingSalePlatRef set CnyzCode='ZHE_800' where PlatCode='94' and Product='1'
  61. update TDefShippingSalePlatRef set CnyzCode='YUN_JI' where PlatCode='99' and Product='1'
  63. update TDefShippingSalePlatRef set CnyzCode='PX' where PlatCode='72' and Product='1'
  65. update TDefShippingSalePlatRef set CnyzCode='MEI_LI_SHUO' where PlatCode='78' and Product='1'
  67. update TDefShippingSalePlatRef set CnyzCode='YL' where PlatCode='82' and Product='1'
  69. update TDefShippingSalePlatRef set CnyzCode='SN' where PlatCode='105' and Product='1'
  71. update TDefShippingSalePlatRef set CnyzCode='WPH' where PlatCode='107' and Product='1'
  73. update TDefShippingSalePlatRef set CnyzCode='XIAO_HONG_SHU' where PlatCode='113' and Product='1'
  75. update TDefShippingSalePlatRef set CnyzCode='SN' where PlatCode='118' and Product='1'
  77. update TDefShippingSalePlatRef set CnyzCode='JD' where PlatCode='120' and Product='1'
  79. update TDefShippingSalePlatRef set CnyzCode='JD' where PlatCode='127' and Product='1'
  81. update TDefShippingSalePlatRef set CnyzCode='WPH' where PlatCode='130' and Product='1'
  83. update TDefShippingSalePlatRef set CnyzCode='YUN_JI' where PlatCode='137' and Product='1'
  85. update TDefShippingSalePlatRef set CnyzCode='JIU_XIAN_WANG' where PlatCode='139' and Product='1'
  87. update TDefShippingSalePlatRef set CnyzCode='KAO_LA' where PlatCode='141' and Product='1'
  89. update TDefShippingSalePlatRef set CnyzCode='WEI_MENG' where PlatCode='142' and Product='1'
  91. update TDefShippingSalePlatRef set CnyzCode='DOU_YIN' where PlatCode='145' and Product='1'

4.抓包验证


如图 如果值为TM或者TB即为成功

文档更新时间: 2024-06-26 15:56   作者：Gaychou