API接口目录

自营业务

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

通过此接口根据订单修改时间批量获取订单。
1.一次请求只能查询时间跨度为一天的增量交易记录,即查询修结束时间-查询修改开始时间<=1天,通过此接口可以查询到时间范围在当前时间往前三个月的时间内。
2.返回的数据结果是以订单修改时间降序排列的,通过从后往前翻页的方式可以避免漏单问题。
3.页码和每页条数默认返回第1页、10条内容,通过请求参数的页码可以定位到具体第几页,每页条数控制每页返回的条数。
4.返回省、市、区代码及中文详细地址,省、市、区代码与详细中文地址省、市、区对应。 
5.请求参数中订单状态指当前订单行项目状态,有订单状态。订单待发货10、订单不能满足20、订单延迟发货30、厂家已发货40、厂家确认顾客已收货45、顾客已收货50、单证已寄票60、顾客已收票70,只能填写一种。 
6.订单行项目金额计算公式:实际收款=价格*数量+运费-优惠劵金额-优惠单金额。整个订单的运费、优惠金额分担到每个订单行项目。
7.退货订单标志位为1时,表示订单行项目为退货状态。
8.订单总金额=订单行项目金额总和。

公共参数
请求参数
名称 类型 是否必须 示例值 描述
endTimeStringYyyyy-MM-dd HH:mm:ss结束时间
orderItemStatusStringN订单行状态,10:待发货,40:已发货,45:已代顾客确认收货,50:顾客已收货,60:单证已寄票,70:顾客已收票,75:交易关闭订单行状态
pageNoStringN1页码
pageSizeStringN10每页条数
startTimeStringYyyyy-MM-dd HH:mm:ss开始时间
supplierCodeStringY123456789供应商编码
响应参数
名称 类型 示例值 描述
addressString南京市江宁区经济开发平安路8号顾客送货地址
cityNameString南京市收件人地址(市)中文
cmmdtyCodeString123456789苏宁商品编码
cmmdtyNameString篮球商品名称
couponTotalMoneyString20.00优惠券总金额
customerNameString张三顾客姓名
deliveryTypeString01配送方式
detailAddressString苏宁大道1号详细地址
distChannelString50分销渠道
districtNameString玄武区收件人地址(区)中文
expressCompanyNameString顺丰物流公司名称
expressNoString123456789物流公司单号
hopeArrivalTimeString2013-11-29 23:06:10交货时间
invoiceConentString中国移动发票内容
invoiceHeadString中国移动发票抬头
invoiceTypeString01-增值税发票 02-普通发票发票类型
memberOrgNameString中国移动会员单位名称
mobilePhoneString15805190183移动电话
needInvoiceFlagString是否需要发票
orderCodeString123456789订单号
orderItemBizTypeString联营特卖订单订单类型
orderItemIdString000666999666999OMS订单行号
orderItemStatusString10支付关闭0、未支付5、订单待发货10、订单不能满足20、订单延迟发货30、厂家已发货40、厂家确认顾客已收货45、顾客已收货50、单证已寄票60、顾客已收票70、订单已关闭75
orderItemStatusChangeTimeString 2014-03-05 04:22:39 订单行状态变更时间
orderRemarkString123订单备注
packageOrderIdString123456789包裹号
payAmountString25.00应付金额
payItemsString
bankTypeCodeString01银行种类编码,表示对订单使用的券用积分类型:5998-店铺优惠券、6998-联合0元购券、7998-0元购券、8012-积分抵现、9994-优惠券、9995-优惠券、10001-云券、10002-限品类云券、10003-店铺云券、10004-易券、10005-限品类易券、10006-店铺易券、10009-无敌券。
bankTypeNameString云钻抵扣银行种类名称
parentPayCodeString01支付方式上级编码
payAmountString2.00支付方式分摊金额
payCodeString01支付方式编码,4148-易付宝支付、5002-礼品卡支付、9003-门店付款、6901-券或云钻支付、6903-易付宝优惠券支付、2037-光大MIS银行卡(新)、1001-现金(CASH)、2044-建行MIS银行卡(新)、6906-赠品支付、4237-支付宝支付、4245-微信支付
alipayPayNoString122215522外部支付流水号
payIdString123456789支付单号
phoneNumString66996699固定电话
platFormStringA平台来源。苏宁:A ,天猫:B, 抖音:C, 拼多多:D ,快手:E ,淘特:F ,视频号:G ,百度小店:BD,小红书:H,
posOrderIdString123456789POS单号
priceString1.00销售价
prmtBillTotalAmtString2.00优惠单总金额
provinceNameString江苏省收件人地址(省)中文
saleQtyString5.00销售数量
saleTimeString2013/11/29 23:06:10订单销售日期时间
statusString100 未支付取消;5 未支付;10 订单待发货;20 厂家已发货; 21 订单部分发货;30 顾客已收货;40 交易关闭;50交易成功
supplierCmmdtyCodeString123456789商家商品编码
supplierCodeString123456789供应商编码
taxIfSendString发票是否需要邮寄
taxPayerAddressString苏宁大道1号增值税发票收件人地址
taxPayerMobileNumString15805190183增值税发票收件人手机
taxPayerNameString张三增值税发票收件人姓名
taxPayerPhoneNumString15805190183增值税发票收件人电话
totalAmountString1.00行项目销售额
transportFeeString2.00运费
userNameString123@qq.com买家帐号
zipCodeString210000邮政编码
townNameString鼓楼街道镇街道
wareCodeStringZ01供应商填写的仓库编码
returnorderflagString1退货标识 0:非退货; 1:退货
returnStatusString80退货状态
exchangeGoodsFlagString0换货标识:无换货(0),换货中(1),换货完成(2)
returnFlagString1退货标识 0:非退货; 1:退货
expressInfosString
deliverytypeString1发货方式
expressnoString00101316800801物流单号
expressCompanyCodeStringD01快递公司编码
expresscompanyNameString德邦快递公司名称
deliAmountString1发货数量, 仅在多运单下有效, 非多运单取saleqty.
storeNameString某某门店门店名称
storeCodeString0073门店编码
salesPersonString李四营业员名称
isShowPriceString1是否展示价格,0-不展示,1-展示
factoryIWDFlagString1苏宁仓配:1-是 0-否
pickDateString2020-11-18 12:00:00承诺发货日期
purchasePriceString12采购价
isOtherDeliveryString1其他商家发货标识0否1是
distributorNameStringxxx分销商名称
oldChangeNewFlagString10-以旧换新家电两步式订单且旧机已回收完成,1代表以旧换新家电两步式订单且旧机未回收完成。为空表示非以旧换新家电两步式订单
townCodeString0251545镇/街道编码
sidStringBBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...address+customerName+detailAddress+mobilePhone+userName+phoneNum加密字段,解密后格式为:{address:南京市江宁区经济开发平安路8号,customerName:张三,detailAddress:苏宁大道1号,mobilePhone:15805190183,userName:张哈哈,phoneNum:66996699}
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字段
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>
    <queryOrd>
      <orderItemStatus>订单行状态,10:待发货,40:已发货,45:已代顾客确认收货,50:顾客已收货,60:单证已寄票,70:顾客已收票,75:交易关闭</orderItemStatus>
      <pageNo>1</pageNo>
      <pageSize>10</pageSize>
      <startTime>yyyy-MM-dd HH:mm:ss</startTime>
      <endTime>yyyy-MM-dd HH:mm:ss</endTime>
      <supplierCode>123456789</supplierCode>
    </queryOrd>
  </sn_body>
</sn_request>

			
                                
                                
{
  "sn_request": {
    "sn_body": {
      "queryOrd": {
        "orderItemStatus": "订单行状态,10:待发货,40:已发货,45:已代顾客确认收货,50:顾客已收货,60:单证已寄票,70:顾客已收票,75:交易关闭",
        "pageNo": "1",
        "pageSize": "10",
        "startTime": "yyyy-MM-dd HH:mm:ss",
        "endTime": "yyyy-MM-dd HH:mm:ss",
        "supplierCode": "123456789"
      }
    }
  }
}
			
                                
响应示例
  • 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>
    <queryOrd>
      <distChannel>50</distChannel>
      <hwgPayerDocumentNumber>110110200001010002</hwgPayerDocumentNumber>
      <orderItemBizType>联营特卖订单</orderItemBizType>
      <hwgStatus>1</hwgStatus>
      <returnStatus>80</returnStatus>
      <factoryIWDFlag>1</factoryIWDFlag>
      <returnFlag>1</returnFlag>
      <payAmount>25.00</payAmount>
      <price>1.00</price>
      <hwgPayerDocumentType>01</hwgPayerDocumentType>
      <cscPrice>1</cscPrice>
      <cardExamine>0</cardExamine>
      <townName>鼓楼街道</townName>
      <exchangeGoodsFlag>0</exchangeGoodsFlag>
      <needInvoiceFlag>是</needInvoiceFlag>
      <serialNum>969670000000000</serialNum>
      <consignee>张**</consignee>
      <wareCode>Z01</wareCode>
      <customerName>张三</customerName>
      <prmtBillTotalAmt>2.00</prmtBillTotalAmt>
      <posOrderId>123456789</posOrderId>
      <orderTypeMulti>XA005,XA006</orderTypeMulti>
      <invoiceHead>中国移动</invoiceHead>
      <mobilePhone>15805190183</mobilePhone>
      <hwgMergePayNo>1</hwgMergePayNo>
      <orderItemStatusChangeTime> 2014-03-05 04:22:39 </orderItemStatusChangeTime>
      <provinceName>江苏省</provinceName>
      <platForm>A</platForm>
      <status>10</status>
      <invoiceConent>中国移动</invoiceConent>
      <taxIfSend>是</taxIfSend>
      <supplierCode>123456789</supplierCode>
      <idNumber>34****************</idNumber>
      <taxPayerPhoneNum>15805190183</taxPayerPhoneNum>
      <encryptInfo>
        <encryptCustomerName>ABCDE</encryptCustomerName>
        <encryptMobilePhone>ABCDE</encryptMobilePhone>
        <encryptDetailAddress>ABCDE</encryptDetailAddress>
      </encryptInfo>
      <hwgRfreight>2</hwgRfreight>
      <distributorName>xxx</distributorName>
      <referencePrice>1</referencePrice>
      <returnorderflag>1</returnorderflag>
      <address>南京市江宁区经济开发平安路8号</address>
      <districtName>玄武区</districtName>
      <hwgPayAmount>1</hwgPayAmount>
      <orderItemId>000666999666999</orderItemId>
      <cmmdtyName>篮球</cmmdtyName>
      <expressInfos>
        <expressno>00101316800801</expressno>
        <expresscompanyName>德邦</expresscompanyName>
        <expressCompanyCode>D01</expressCompanyCode>
        <deliAmount>1</deliAmount>
        <deliverytype>1</deliverytype>
      </expressInfos>
      <hwgRpayTaxAmount>1</hwgRpayTaxAmount>
      <hwgCustomsMode>01</hwgCustomsMode>
      <zpOrderFlag>0</zpOrderFlag>
      <hwgPayerName>张三</hwgPayerName>
      <salesPerson>李四</salesPerson>
      <zipCode>210000</zipCode>
      <townCode>0251545</townCode>
      <hwgCouponTotalMoney>1</hwgCouponTotalMoney>
      <phoneNum>66996699</phoneNum>
      <pickDate>2020-11-18 12:00:00</pickDate>
      <hwgRtotalAmount>82.78</hwgRtotalAmount>
      <purchasePrice>12</purchasePrice>
      <payItems>
        <payAmount>2.00</payAmount>
        <bankTypeCode>01</bankTypeCode>
        <bankTypeName>云钻抵扣</bankTypeName>
        <alipayPayNo>122215522</alipayPayNo>
        <payId>123456789</payId>
        <payCode>01</payCode>
        <parentPayCode>01</parentPayCode>
      </payItems>
      <hwgTotalCount>1</hwgTotalCount>
      <hwgFreight>1</hwgFreight>
      <hwgCountryCode>中国</hwgCountryCode>
      <deliverMemo>请发顺丰</deliverMemo>
      <packageOrderId>123456789</packageOrderId>
      <invoiceType>01-增值税发票 02-普通发票</invoiceType>
      <hopeArrivalTime>2013-11-29 23:06:10</hopeArrivalTime>
      <memberOrgName>中国移动</memberOrgName>
      <taxPayerMobileNum>15805190183</taxPayerMobileNum>
      <supplierCmmdtyCode>123456789</supplierCmmdtyCode>
      <outCode>200111111111</outCode>
      <isCardOrder>1</isCardOrder>
      <outItemCode>20011111111101</outItemCode>
      <yjhOrderFlag>0</yjhOrderFlag>
      <totalAmount>1.00</totalAmount>
      <isShowPrice>1</isShowPrice>
      <serialNumFlag>1</serialNumFlag>
      <hwgDeclareFlag>未申报,申报成功</hwgDeclareFlag>
      <storeCode>0073</storeCode>
      <isOtherDelivery>1</isOtherDelivery>
      <hwgDistType>03</hwgDistType>
      <transportFee>2.00</transportFee>
      <expressNo>123456789</expressNo>
      <cmmdtyCode>123456789</cmmdtyCode>
      <orderRemark>123</orderRemark>
      <taxPayerName>张三</taxPayerName>
      <hwgRpayAmount>88.0</hwgRpayAmount>
      <virtualNumMark>Y是,N否</virtualNumMark>
      <sid>BBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...</sid>
      <saleTime>2013/11/29  23:06:10</saleTime>
      <actSettlementPrice>12</actSettlementPrice>
      <cityName>南京市</cityName>
      <orderItemStatus>10</orderItemStatus>
      <hwgPayTaxAmount>1</hwgPayTaxAmount>
      <oldChangeNewFlag>1</oldChangeNewFlag>
      <storeName>某某门店</storeName>
      <hwgOrderTotalAmount>1</hwgOrderTotalAmount>
      <hwgRcouponTotalMoney>3</hwgRcouponTotalMoney>
      <deliveryType>01</deliveryType>
      <userName>123@qq.com</userName>
      <couponTotalMoney>20.00</couponTotalMoney>
      <expressCompanyName>顺丰</expressCompanyName>
      <taxPayerAddress>苏宁大道1号</taxPayerAddress>
      <hwgPackageOrderId>4863317887330092865</hwgPackageOrderId>
      <detailAddress>苏宁大道1号</detailAddress>
      <orderCode>123456789</orderCode>
      <saleQty>5.00</saleQty>
      <hwgPayOrderId>18741998</hwgPayOrderId>
    </queryOrd>
  </sn_body>
</sn_responseContent>

			
                              
                              
{
  "sn_responseContent": {
    "sn_head": {
      "totalSize": "1",
      "pageTotal": "1",
      "pageNo": "1",
      "returnMessage": "biz.handler.data-get:success"
    },
    "sn_body": {
      "queryOrd": [
        {
          "distChannel": "50",
          "hwgPayerDocumentNumber": "110110200001010002",
          "orderItemBizType": "联营特卖订单",
          "hwgStatus": "1",
          "returnStatus": "80",
          "factoryIWDFlag": "1",
          "returnFlag": "1",
          "payAmount": "25.00",
          "price": "1.00",
          "hwgPayerDocumentType": "01",
          "cscPrice": "1",
          "cardExamine": "0",
          "townName": "鼓楼街道",
          "exchangeGoodsFlag": "0",
          "needInvoiceFlag": "是",
          "serialNum": "969670000000000",
          "consignee": "张**",
          "wareCode": "Z01",
          "customerName": "张三",
          "prmtBillTotalAmt": "2.00",
          "posOrderId": "123456789",
          "orderTypeMulti": "XA005,XA006",
          "invoiceHead": "中国移动",
          "mobilePhone": "15805190183",
          "hwgMergePayNo": "1",
          "orderItemStatusChangeTime": " 2014-03-05 04:22:39 ",
          "provinceName": "江苏省",
          "platForm": "A",
          "status": "10",
          "invoiceConent": "中国移动",
          "taxIfSend": "是",
          "supplierCode": "123456789",
          "idNumber": "34****************",
          "taxPayerPhoneNum": "15805190183",
          "encryptInfo": {
            "encryptCustomerName": "ABCDE",
            "encryptMobilePhone": "ABCDE",
            "encryptDetailAddress": "ABCDE"
          },
          "hwgRfreight": "2",
          "distributorName": "xxx",
          "referencePrice": "1",
          "returnorderflag": "1",
          "address": "南京市江宁区经济开发平安路8号",
          "districtName": "玄武区",
          "hwgPayAmount": "1",
          "orderItemId": "000666999666999",
          "cmmdtyName": "篮球",
          "expressInfos": [
            {
              "expressno": "00101316800801",
              "expresscompanyName": "德邦",
              "expressCompanyCode": "D01",
              "deliAmount": "1",
              "deliverytype": "1"
            }
          ],
          "hwgRpayTaxAmount": "1",
          "hwgCustomsMode": "01",
          "zpOrderFlag": "0",
          "hwgPayerName": "张三",
          "salesPerson": "李四",
          "zipCode": "210000",
          "townCode": "0251545",
          "hwgCouponTotalMoney": "1",
          "phoneNum": "66996699",
          "pickDate": "2020-11-18 12:00:00",
          "hwgRtotalAmount": "82.78",
          "purchasePrice": "12",
          "payItems": [
            {
              "payAmount": "2.00",
              "bankTypeCode": "01",
              "bankTypeName": "云钻抵扣",
              "alipayPayNo": "122215522",
              "payId": "123456789",
              "payCode": "01",
              "parentPayCode": "01"
            }
          ],
          "hwgTotalCount": "1",
          "hwgFreight": "1",
          "hwgCountryCode": "中国",
          "deliverMemo": "请发顺丰",
          "packageOrderId": "123456789",
          "invoiceType": "01-增值税发票 02-普通发票",
          "hopeArrivalTime": "2013-11-29 23:06:10",
          "memberOrgName": "中国移动",
          "taxPayerMobileNum": "15805190183",
          "supplierCmmdtyCode": "123456789",
          "outCode": "200111111111",
          "isCardOrder": "1",
          "outItemCode": "20011111111101",
          "yjhOrderFlag": "0",
          "totalAmount": "1.00",
          "isShowPrice": "1",
          "serialNumFlag": "1",
          "hwgDeclareFlag": "未申报,申报成功",
          "storeCode": "0073",
          "isOtherDelivery": "1",
          "hwgDistType": "03",
          "transportFee": "2.00",
          "expressNo": "123456789",
          "cmmdtyCode": "123456789",
          "orderRemark": "123",
          "taxPayerName": "张三",
          "hwgRpayAmount": "88.0",
          "virtualNumMark": "Y是,N否",
          "sid": "BBDF4B492FA1878D7A73C25F5EE4DA22D425C50DDD181E50CE3D8234C4B27DD8A65CB...",
          "saleTime": "2013/11/29  23:06:10",
          "actSettlementPrice": "12",
          "cityName": "南京市",
          "orderItemStatus": "10",
          "hwgPayTaxAmount": "1",
          "oldChangeNewFlag": "1",
          "storeName": "某某门店",
          "hwgOrderTotalAmount": "1",
          "hwgRcouponTotalMoney": "3",
          "deliveryType": "01",
          "userName": "123@qq.com",
          "couponTotalMoney": "20.00",
          "expressCompanyName": "顺丰",
          "taxPayerAddress": "苏宁大道1号",
          "hwgPackageOrderId": "4863317887330092865",
          "detailAddress": "苏宁大道1号",
          "orderCode": "123456789",
          "saleQty": "5.00",
          "hwgPayOrderId": "18741998"
        }
      ]
    }
  }
}
			
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.selfmarket.queryord.missing-parameter:* 参数必填 请检查此参数的值,*号表示参数字段名
biz.handler.data-get:no-result 查询没结果 请检查查询参数
isp.sys.service.unavailable.somp 服务不可用 请联系苏宁技术人员
公共异常码
API工具
FAQ