顺丰快递时效标识
WMS本地的快递编码ExpressType
菜鸟顺丰 时效标识 SFLYBIZTYPE
京东无界顺丰 时效标识 SFLY#JDWJ_ExpressType
拼多多顺丰 时效标识 SFLY#PDD_TIMED-DELIVERY
抖音顺丰 时效标识 SFLY#DY_productType
快手顺丰 时效标识 SFLY#KS_expressProductCode
小红书顺丰 时效标识 shunfeng-SF_ProductCode 直接复制
爱库存顺丰 时效标识 SF#AKC_productType
菜鸟有品牌之后,附加服务(以顺丰为例)配置参考:
–payMethod ⽀付⽅式:
/*
普通⽉结: ⽆需传⼊PayMethod
现结: 暂不⽀持,顺丰对接适配中。
到付:payMethod = 2
第三⽅付:payMethod = 3
/
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘CNYZ’ And ParmKey = ‘[SF#CNYZ]PayMethod’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
Values(‘CNYZ’, ‘[SF#CNYZ]PayMethod’, ‘顺丰,支付方式payMethod’, ‘’, ‘‘, ‘*|店铺’)
End
GO
–附加服务开关;
if not exists(select 1 from TDefShippingMethodsDet where ShippingCode = ‘CNYZ’ and ParmKey=’SF_AddSrv’)
begin
INSERT TDefShippingMethodsDet(ShippingCode,ParmAssign,ParmKey,ParmName,ParmValue,Ex1, Ex2,Status)
Select ‘CNYZ’,’‘,’SF_AddSrv’,’顺丰附加服务(空值(默认)|SF:顺丰)’,’’,’|店铺’,’0’,’1’
End
–品牌:SF, 特殊配置
–INSURE 0(默认)-不保价|1-保价(保价取TBillKdRel.Insured字段值)
if not exists(select 1 from TDefShippingMethodsDet where ShippingCode = ‘CNYZ’ and ParmKey=’SF-SF_INSURE’)
begin
INSERT TDefShippingMethodsDet(ShippingCode,ParmAssign,ParmKey,ParmName,ParmValue,Ex1, Ex2,Status)
Select ‘CNYZ’,’‘,’SF-SF_INSURE’,’顺丰保价;0(默认)-不保价|1-保价(取TBillKdRel.Insured字段值)’,’’,’|店铺’,’0’,’1’
End
/* 菜鸟顺丰寄 隐私物品,配置则替换默认值,其他可不配置
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘CNYZ’ And ParmKey = ‘[SF#CNYZ]GoodsDesc’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
Values(‘CNYZ’, ‘[SF#CNYZ]GoodsDesc’, ‘货物描述’, ‘物品描述’, ‘‘, ‘|店铺’)
End
GO
*/