顺丰快递无法在菜鸟中使用，直连需要客户找快递公司提供以下字段：

热敏服务器地址，客户号，校验码/密码，月结卡号，业务类型：标准还是顺丰特惠、电商客户。

此外，wms上的配置如下图

以上，配置完成后，即可获取顺丰的快递面单，剩下在配置快递模板即可。

配置快递模板如下：

顺丰产品类别表

https://qiao.sf-express.com/pages/developDoc/index.html?level2=689001

最后附脚本：

``````sql
— select * from TDefShippingMethodsDet where ShippingCode = ‘SF’

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘ServerAddr’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘ServerAddr’, ‘热敏服务器地址’, ‘’)
End
GO
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘Account’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘Account’, ‘客户号’, ‘’)
End
GO
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘Password’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘Password’, ‘校验码/密码’, ‘’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘MonthlyAccount’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘MonthlyAccount’, ‘月结卡号’, ‘’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘BizType’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘BizType’, ‘业务类型：1标准快递，2顺丰特惠，3电商特惠’, ‘’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘ShowDetailCount’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘ShowDetailCount’, ‘商品明细显示行数’, ‘2’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘RowEllipsisHint’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘RowEllipsisHint’, ‘商品内详标识’, ‘超行商品未打印’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘OrderThreadNum’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘OrderThreadNum’, ‘上传线程数;<=0单线程’, ‘10’)
End
GO

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘UrgentService’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘UrgentService’, ‘加急服务：0不加急(默认)，1加急’, ‘0’)
End
Go

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘InsureService’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘InsureService’, ‘保价服务：0不保价(默认)，1保价’, ‘0’)
End
Go

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘InsureAvgPrice’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘InsureAvgPrice’, ‘均价保价起点’, ‘600’)
End
Go

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘ClusterParcel’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘ClusterParcel’, ‘启用子母件(0|1);默认0’, ‘0’)
End
Go

If Not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘ParcelBySL’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘ParcelBySL’, ‘按数量分包(1|2|…|6|…);默认0’, ‘0’)
End
Go

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘OnlyLastPrint’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue)
Values(‘SF’, ‘OnlyLastPrint’, ‘仅最后一包打印(0|1);默认0’, ‘0’)
End
Go

—添加快递费付款方式：1:寄方付(默认）2:收方付 3:第三方付
If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = ‘SF’ And ParmKey = ‘PayType’)
Begin
Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, Ex1)
Values(‘SF’, ‘PayType’, ‘1:寄方付(默认）2:收方付 3:第三方付’, ‘1’, ‘*|仓库’)
End
Go