API接口目录

自营业务

退厂API
厂送API
厂送退换货API
品牌串码API
采购订单API
供应商收发货API
售后服务API
供应商财务API
主数据API
自营合同API
自营商品API
自营财务API
采购计划API
收发货API
订单API
易道报表API
不良品API
自营促销API
异常码自查工具
suning.selfmarket.saleorder.query 批量获取销售订单
¥免费

通过此接口可批量获取销售订单

公共参数
请求参数
名称 类型 是否必须 示例值 描述
endTimeStringY2013-11-30 23:06:10交易创建结束时间。查询交易创建结束时间。格式: yyyy-MM-dd HH:mm:ss
pageNoStringN1页码。当前页码,1到99999之间,当前页码或者每页数量其中一个不填则当前页码默认1,每页数量默认为10
pageSizeStringN10每页条数。每页数量,1到100之间,当前页码或者每页数量其中一个不填则当前页码默认1,每页数量默认为10
startTimeStringY2013-11-29 23:06:10交易创建起始时间。查询交易创建开始时间。格式: yyyy-MM-dd HH:mm:ss
stateStringN20订单状态。订单待发货10、订单不能满足20、订单延迟发货30、厂家已发货40、厂家确认顾客已收货45、顾客已收货50、单证已寄票60、顾客已收票70
supplierCodeStringY10000020供应商编码。
响应参数
名称 类型 示例值 描述
addressString南京市江宁区经济开发平安路8号顾客送货地址。市、县/区、镇/街道、详细地址
customerNameString张三顾客姓名。
memberOrgNameString江苏苏宁软件技术有限公司会员单位名称
mobilePhoneString13957582227移动电话。
orderIdString11111B2C订单号。
orderItemIdString00000208117601订单行号。
platformStringA平台来源。苏宁:A ,天猫:B, 抖音:C, 拼多多:D, 快手:E, 淘特:F ,视频号:G ,百度小店:BD, 小红书:H,
posIdString11111POS单号。
priceString50.20销售价。最后交易价
productCodeString101030069商品编码。
productNameString保健品王商品名称。
refundFeeString2.00退款金额
remarkString顾客的销售订单备注订单备注
remarkcolorflagString1:红色,2:黄色,3:绿色,4:蓝色,5:紫色;商家备注旗帜
saleQtyString20销售数量。
saleTimeString2013-11-29 23:06:10订单销售日期时间。年月日小时分钟。
shipConditionString01装运条件。
statusString30订单状态。支付关闭0、未支付5、订单待发货10、订单不能满足20、订单延迟发货30、厂家已发货40、厂家确认顾客已收货45、顾客已收货50、单证已寄票60、顾客已收票70、订单已关闭75
supplierCmmdtyCodeString123456789商家商品编码
supplierCodeString100024789供应商编码。
supplierremarkString轻拿轻放商家备注内容
telephoneString13957582227电话。
wareCodeStringZ01供应商填写的仓库编码
returnorderflagString1退货标识 0:非退货; 1:退货
returnStatusString80退货状态
exchangeGoodsFlagString1换货标识:无换货(0),换货中(1),换货完成(2)
returnFlagString1退货标识 0:非退货; 1:退货
gyaoBatchNumString18010221国药批次号
gyaoSpecificatString10粒*6板/盒国药规格
gyaoManufactString上海东海制药股份有限公司国药厂商
gyaoTermValidityString2020/12国药有效期
storeCodeString0001门店代码
isShowPriceString1是否展示价格,0-不展示,1-展示
factoryIWDFlagString1苏宁仓配:1-是 0-否
pickDateString2020-11-18 12:00:00承诺发货日期
purchasePriceString13采购价
isOtherDeliveryString1其他商家发货标识0否1是
distributorNameStringxxx分销商名称
oldChangeNewFlagString10-以旧换新家电两步式订单且旧机已回收完成,1代表以旧换新家电两步式订单且旧机未回收完成。为空表示非以旧换新家电两步式订单
sidStringBBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...address+customerName+mobilePhone+telephone加密字段,解密后格式为:{address:南京市江宁区经济开发平安路8号,customerName:张哈哈,mobilePhone:15805190183,telephone:66996699}
userNameString123123@163.com买家账号
detailAddressString苏宁大道1号详细地址
serialNumFlagString1是否回传序列号标识:0否,1 SN码 2 IMEI码
serialNumString969670000000000序列号
hwgPackageOrderIdString4863317887330092865合并订单号
hwgPayOrderIdString18741998合并支付单号
hwgPayerNameString张三支付人姓名
hwgPayerDocumentTypeString01支付人证件类型,默认01
hwgPayerDocumentNumberString110110200001010002支付人证件号码
hwgDistTypeString03发货方式,01直邮 02商家自有保税区 03苏宁保税区
hwgCustomsModeString01通关模式:01保税仓 02海外直邮 03个人申报 04邮关
hwgRtotalAmountString82.78行成交总价
hwgRpayAmountString88.0行支付金额
hwgRpayTaxAmountString1行支付税款
hwgRfreightString2行支付运费
hwgRcouponTotalMoneyString3行优惠金额
hwgCountryCodeString中国产销国
hwgStatusString1事件状态:抖音海外购事件当前状态,同步成功后状态更新,同步失败不更新
virtualNumMarkStringY是,N否虚拟号标识
actSettlementPriceString12活动结算价.该字段积分商城订单才有值,非积分商城订单无值
referencePriceString1供应商维护的销售价
cscPriceString1直降、大聚惠的购物车结算价格
hwgDeclareFlagString未申报,申报成功申报状态
hwgMergePayNoString1合并支付单号(申报后)
hwgOrderTotalAmountString1合单维度:订单总金额
hwgTotalCountString1合单维度:总件数
hwgPayAmountString1合单维度:支付金额
hwgPayTaxAmountString1合单维度:支付税款
hwgFreightString1合单维度:支付运费
hwgCouponTotalMoneyString1合单维度:优惠金额
isCardOrderString11:号卡订单,号卡收货人姓名与号卡收货人证件号需要解密sid字段,获取consignee与idNumber
cardExamineString00表示待审核,1表示审核通过,2表示审核不通过,号卡订单必须审核通过的情况下才能进行发货
consigneeString张**号卡收货人名称,需要解密sid字段获取
idNumberString34****************号卡收货人身份证信息,需要解密sid字段
provinceNameString江苏省收件人地址(省)中文
cityNameString南京市收件人地址(市)中文
districtNameString玄武区收件人地址(区)中文
townNameString鼓楼区街道镇
zpOrderFlagString00-支票支付订单且支票已到账,1支票支付订单且支票未到账,为空表示非支票支付订单(非0情况下不可发货)
outCodeString200111111111外部订单号
outItemCodeString20011111111101外部订单行号
yjhOrderFlagString0云交惠订单是否可发货标识:0-门店已开单,1门店暂未开单,暂时无需发货(非0情况下不可发货)
deliverMemoString请发顺丰顾客送货备注
orderTypeMultiStringXA005,XA006XA006:苏宁有货S2B模式,XA005:零售云订单苏宁有货S2B2C模式中的S2B订单,XA004:苏宁有货API渠道销售,XA024:零售云订单,XA030:江苏消费补贴,XA031:北京消费补贴
encryptInfoString
encryptCustomerNameStringABCDE加密的收货人名称
encryptDetailAddressStringABCDE加密的详细地址
encryptMobilePhoneStringABCDE加密的手机号码
请求示例
  • XML示例
  • JSON示例
复制全部代码
                                
<sn_request>
  <sn_body>
    <querySaleOrder>
      <pageNo>1</pageNo>
      <pageSize>10</pageSize>
      <startTime>2013-11-29 23:06:10</startTime>
      <endTime>2013-11-30 23:06:10</endTime>
      <state>20</state>
      <supplierCode>10000020</supplierCode>
    </querySaleOrder>
  </sn_body>
</sn_request>

			
                                
                                
{
  "sn_request": {
    "sn_body": {
      "querySaleOrder": {
        "pageNo": "1",
        "pageSize": "10",
        "startTime": "2013-11-29 23:06:10",
        "endTime": "2013-11-30 23:06:10",
        "state": "20",
        "supplierCode": "10000020"
      }
    }
  }
}
			
                                
响应示例
  • XML示例
  • JSON示例
复制全部代码
                              
<sn_responseContent>
  <sn_head>
    <totalSize>1</totalSize>
    <pageTotal>1</pageTotal>
    <pageNo>1</pageNo>
    <returnMessage>biz.handler.data-get:success</returnMessage>
  </sn_head>
  <sn_body>
    <querySaleOrder>
      <refundFee>2.00</refundFee>
      <hwgPayerDocumentNumber>110110200001010002</hwgPayerDocumentNumber>
      <orderId>11111</orderId>
      <hwgStatus>1</hwgStatus>
      <returnStatus>80</returnStatus>
      <hwgCouponTotalMoney>1</hwgCouponTotalMoney>
      <pickDate>2020-11-18 12:00:00</pickDate>
      <hwgRtotalAmount>82.78</hwgRtotalAmount>
      <factoryIWDFlag>1</factoryIWDFlag>
      <purchasePrice>13</purchasePrice>
      <productName>保健品王</productName>
      <hwgTotalCount>1</hwgTotalCount>
      <hwgFreight>1</hwgFreight>
      <returnFlag>1</returnFlag>
      <hwgCountryCode>中国</hwgCountryCode>
      <deliverMemo>请发顺丰</deliverMemo>
      <price>50.20</price>
      <gyaoSpecificat>10粒*6板/盒</gyaoSpecificat>
      <hwgPayerDocumentType>01</hwgPayerDocumentType>
      <cscPrice>1</cscPrice>
      <memberOrgName>江苏苏宁软件技术有限公司</memberOrgName>
      <cardExamine>0</cardExamine>
      <supplierCmmdtyCode>123456789</supplierCmmdtyCode>
      <townName>鼓楼区</townName>
      <exchangeGoodsFlag>1</exchangeGoodsFlag>
      <serialNum>969670000000000</serialNum>
      <consignee>张**</consignee>
      <outCode>200111111111</outCode>
      <telephone>13957582227</telephone>
      <wareCode>Z01</wareCode>
      <isCardOrder>1</isCardOrder>
      <customerName>张三</customerName>
      <shipCondition>01</shipCondition>
      <outItemCode>20011111111101</outItemCode>
      <yjhOrderFlag>0</yjhOrderFlag>
      <orderTypeMulti>XA005,XA006</orderTypeMulti>
      <supplierremark>轻拿轻放</supplierremark>
      <isShowPrice>1</isShowPrice>
      <mobilePhone>13957582227</mobilePhone>
      <hwgMergePayNo>1</hwgMergePayNo>
      <serialNumFlag>1</serialNumFlag>
      <provinceName>江苏省</provinceName>
      <remarkcolorflag>1:红色,2:黄色,3:绿色,4:蓝色,5:紫色;</remarkcolorflag>
      <hwgDeclareFlag>未申报,申报成功</hwgDeclareFlag>
      <status>30</status>
      <storeCode>0001</storeCode>
      <gyaoTermValidity>2020/12</gyaoTermValidity>
      <isOtherDelivery>1</isOtherDelivery>
      <hwgDistType>03</hwgDistType>
      <remark>顾客的销售订单备注</remark>
      <hwgRpayAmount>88.0</hwgRpayAmount>
      <supplierCode>100024789</supplierCode>
      <virtualNumMark>Y是,N否</virtualNumMark>
      <idNumber>34****************</idNumber>
      <platform>A</platform>
      <sid>BBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...</sid>
      <encryptInfo>
        <encryptCustomerName>ABCDE</encryptCustomerName>
        <encryptMobilePhone>ABCDE</encryptMobilePhone>
        <encryptDetailAddress>ABCDE</encryptDetailAddress>
      </encryptInfo>
      <hwgRfreight>2</hwgRfreight>
      <distributorName>xxx</distributorName>
      <posId>11111</posId>
      <saleTime>2013-11-29 23:06:10</saleTime>
      <referencePrice>1</referencePrice>
      <actSettlementPrice>12</actSettlementPrice>
      <cityName>南京市</cityName>
      <hwgPayTaxAmount>1</hwgPayTaxAmount>
      <returnorderflag>1</returnorderflag>
      <gyaoManufact>上海东海制药股份有限公司</gyaoManufact>
      <oldChangeNewFlag>1</oldChangeNewFlag>
      <gyaoBatchNum>18010221</gyaoBatchNum>
      <address>南京市江宁区经济开发平安路8号</address>
      <hwgPayAmount>1</hwgPayAmount>
      <districtName>玄武区</districtName>
      <orderItemId>00000208117601</orderItemId>
      <hwgOrderTotalAmount>1</hwgOrderTotalAmount>
      <hwgRcouponTotalMoney>3</hwgRcouponTotalMoney>
      <hwgRpayTaxAmount>1</hwgRpayTaxAmount>
      <userName>123123@163.com</userName>
      <productCode>101030069</productCode>
      <hwgPackageOrderId>4863317887330092865</hwgPackageOrderId>
      <hwgCustomsMode>01</hwgCustomsMode>
      <zpOrderFlag>0</zpOrderFlag>
      <detailAddress>苏宁大道1号</detailAddress>
      <hwgPayerName>张三</hwgPayerName>
      <saleQty>20</saleQty>
      <hwgPayOrderId>18741998</hwgPayOrderId>
    </querySaleOrder>
  </sn_body>
</sn_responseContent>

			
                              
                              
{
  "sn_responseContent": {
    "sn_head": {
      "totalSize": "1",
      "pageTotal": "1",
      "pageNo": "1",
      "returnMessage": "biz.handler.data-get:success"
    },
    "sn_body": {
      "querySaleOrder": [
        {
          "refundFee": "2.00",
          "hwgPayerDocumentNumber": "110110200001010002",
          "orderId": "11111",
          "hwgStatus": "1",
          "returnStatus": "80",
          "hwgCouponTotalMoney": "1",
          "pickDate": "2020-11-18 12:00:00",
          "hwgRtotalAmount": "82.78",
          "factoryIWDFlag": "1",
          "purchasePrice": "13",
          "productName": "保健品王",
          "hwgTotalCount": "1",
          "hwgFreight": "1",
          "returnFlag": "1",
          "hwgCountryCode": "中国",
          "deliverMemo": "请发顺丰",
          "price": "50.20",
          "gyaoSpecificat": "10粒*6板/盒",
          "hwgPayerDocumentType": "01",
          "cscPrice": "1",
          "memberOrgName": "江苏苏宁软件技术有限公司",
          "cardExamine": "0",
          "supplierCmmdtyCode": "123456789",
          "townName": "鼓楼区",
          "exchangeGoodsFlag": "1",
          "serialNum": "969670000000000",
          "consignee": "张**",
          "outCode": "200111111111",
          "telephone": "13957582227",
          "wareCode": "Z01",
          "isCardOrder": "1",
          "customerName": "张三",
          "shipCondition": "01",
          "outItemCode": "20011111111101",
          "yjhOrderFlag": "0",
          "orderTypeMulti": "XA005,XA006",
          "supplierremark": "轻拿轻放",
          "isShowPrice": "1",
          "mobilePhone": "13957582227",
          "hwgMergePayNo": "1",
          "serialNumFlag": "1",
          "provinceName": "江苏省",
          "remarkcolorflag": "1:红色,2:黄色,3:绿色,4:蓝色,5:紫色;",
          "hwgDeclareFlag": "未申报,申报成功",
          "status": "30",
          "storeCode": "0001",
          "gyaoTermValidity": "2020/12",
          "isOtherDelivery": "1",
          "hwgDistType": "03",
          "remark": "顾客的销售订单备注",
          "hwgRpayAmount": "88.0",
          "supplierCode": "100024789",
          "virtualNumMark": "Y是,N否",
          "idNumber": "34****************",
          "platform": "A",
          "sid": "BBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...",
          "encryptInfo": {
            "encryptCustomerName": "ABCDE",
            "encryptMobilePhone": "ABCDE",
            "encryptDetailAddress": "ABCDE"
          },
          "hwgRfreight": "2",
          "distributorName": "xxx",
          "posId": "11111",
          "saleTime": "2013-11-29 23:06:10",
          "referencePrice": "1",
          "actSettlementPrice": "12",
          "cityName": "南京市",
          "hwgPayTaxAmount": "1",
          "returnorderflag": "1",
          "gyaoManufact": "上海东海制药股份有限公司",
          "oldChangeNewFlag": "1",
          "gyaoBatchNum": "18010221",
          "address": "南京市江宁区经济开发平安路8号",
          "hwgPayAmount": "1",
          "districtName": "玄武区",
          "orderItemId": "00000208117601",
          "hwgOrderTotalAmount": "1",
          "hwgRcouponTotalMoney": "3",
          "hwgRpayTaxAmount": "1",
          "userName": "123123@163.com",
          "productCode": "101030069",
          "hwgPackageOrderId": "4863317887330092865",
          "hwgCustomsMode": "01",
          "zpOrderFlag": "0",
          "detailAddress": "苏宁大道1号",
          "hwgPayerName": "张三",
          "saleQty": "20",
          "hwgPayOrderId": "18741998"
        }
      ]
    }
  }
}
			
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.selfmarket.querysaleorder.missing-parameter:* 参数必填 请检查此参数的值,*号表示参数字段名
biz.selfmarket.querysaleorder.format-error:* 参数格式错误 请检查此参数的值,*号表示参数字段名
biz.selfmarket.querysaleorder.enumeration-error:* 参数的可选值错误 请检查此参数的值,*号表示参数字段名
biz.handler.data-get:no-result 查询没结果 请检查查询参数
isp.sys.service.unavailable.somp 服务不可用 请联系苏宁技术人员
biz.selfmarket.querysaleorder.invalid-biz:100 供应商编码不合法 请输入供应商编码
biz.selfmarket.querysaleorder.invalid-biz:101 开始时间不能为空 请输入开始时间
biz.selfmarket.querysaleorder.invalid-biz:102 截止时间不能为空 请输入截止时间
biz.selfmarket.querysaleorder.invalid-biz:103 退货状态不合法 退货待处理80、厂家待鉴定100、同意退货110、不同意退货120、同意退款130、拒绝退款135、同意退款票140、厂家已寄票160
biz.selfmarket.querysaleorder.invalid-biz:104 订单状态输入有误 订单状态。订单待发货10、订单不能满足20、订单延迟发货30、厂家已发货40、厂家确认顾客已收货45、顾客已收货50、单证已寄票60、顾客已收票70
biz.selfmarket.querysaleorder.invalid-biz:105 时间格式不正确 正确格式:yyyy-MM-dd HH:mm:ss
biz.selfmarket.querysaleorder.invalid-biz:106 开始时间不能晚于结束时间 开始时间要早于截止时间
biz.selfmarket.querysaleorder.invalid-biz:107 时间间隔不能大于31天 开始时间结束时间间隔小于等于31天
公共异常码
API工具
FAQ

Q:批量获取销售订单接口如何使用?

A:通过此接口可批量获取销售订单