4.1 查询订单信息
### 1、接口描述
- API 方法 api.biaoju.order.find
- encodeParams 数据 JSON 结构实例
A.通过多条件查询订单
```json
{
"dateFrom":"订单创建时间, 查询开始时间",
"dateTo":"订单创建时间,查询结束时间",
"status":"订单状态",
"page":" 分 页 参 数 , 第 几 页 ",
"rowsPerPage":"分页参数,每页最多显示"
}
```
B.获取待处理的订单
```json
{
"myNotify":"这里固定传值 1"
}
```
C.通过镖局物流单号查询订单
```json
{
"code":"内部订单号"
}
```
D.通过多个镖局物流单号查询订单
```json
{
"codes":"内部订单号,内部订单号,内部订单号"
}
```
### 2、字段说明
| 字段名称 | 字段类型 | 默认值 | 必填 | 备注 |
| ------ | --------| ----- | ----| -----|
| dateFrom | datetime | | false |订单创建时间,查询开始时间,默认近10 天<br>数据可选格式:(2015/01/01, 20150101, 2015-01-01) |
| dateTo | datetime | | false |订单创建时间,查询结束时间,默认当天<br>数据可选格式:(2015/01/01, 20150101, 2015-01-01) |
| status | string |-1 |false|订单状态,可选状态<br>2待入库<br>3已入库<br>4已出库<br>5已完成<br>6已确认(供应商已下载)<br><br>-1 异常订单<br>(订单不符合供应商要求)|
| page| string| 1| false|分页参数,第几页|
| rowsPerPage| string|100 | false|分页参数,每页最多显示|
| myNotify| string| | true|获取通知合作商的订单|
| code| string| | true|镖局物流单号<br>例:891516800021725|
| codes| string| | true|多个镖局物流单号,多个单号以英文逗号(,)隔开<br>例:891516800021725,891516600021720|
### 3、返回数据结构
```json
{
"orders": [{
"code": "内部订单号",
"customizeCode": "ERP自定义单号",
"platformTradeCode": "平台订单编号:例如ebay,wish 等订单编号",
"status": "订单状态",
"poTrackingNumber":"订单对应采购单物流单号,多个用英文逗号分割",
"poLogisticsCompany":"订单对应采购单物流公司",
"hasException": "是否有异常",
"processMessage": "异常信息,物流供应商处理信息",
"packageId": "Package ID",
"priceForcast": "预计订单运费",
"priceReal": "实际订单运费",
"shippingCountryCode": "包裹地址国家代码",
"timeCreated": "订单生成时间",
"weightForcast": "客户预报订单重量(单位:g 克)",
"weightReal": "供应商实际称重订单重量(单位:g 克)",
"length": "包裹长度(单位:mm 毫米)",
"width": "包裹宽度(单位:mm 毫米)",
"height": "包裹高度(单位:mm 毫米)",
"platformName": "平台名称",
"productNameCn": "订单申报物品中文名",
"productNameEn": "订单申报物品英文名",
"productValue": "订单申报价值(USD)",
"remark": "备注",
"buyer_message": "买家留言(平台留言)",
"itemListQuantity": " 货物数量",
"itemListCount": " 订单项数量",
"currencyCode": " 申报币种 ",
"platformPayTime": "交易平台付款时间",
"AUSDetails": "{\"VendorID\":\"澳洲GST供应商ID\",\"abnnumber\":\"收件人税号\"}",
"codFlag": "cod 订单标识 1:是;2:否",
"codValue": "cod 订单金额",
"currencyId": "cod(货到付款金额)币种 ",
"vatNo": "商家税号",
"vatType": "商家税号类型 1.欧盟国IOSS 编号;2.非IOSS或其他国家税(如英国VAT或挪威VAT等);3.空表示other",
"hasBattery": "订单是否带电 1.是 2.否",
"hasMagnetic": "订单是否含磁 1.是 2.否",
"hasPowder": "订单是否含粉末 1.是 2.否",
"shopname": "马帮店铺名称",
"extendFields": {
"fields": [{
"title": "支付时间",
"values": "",
"name": "paytime",
"type": "text"
}],
"values": {
"paytime": "客户上传订单时设置结果"
}
},
"itemList": [{
"sku": "商品SKU",
"platformsku": "平台sku(开放部分物流商)",
"multiattribute": "商品多属性",
"productName": "商品名称",
"declareNameCn": "商品中文申报名称",
"declareNameEn": "商品英文申报名称",
"weight": "商品单件重量(单位:g克)",
"quantity": "数量",
"length": "包裹长度(单位:mm 毫米)",
"width": "包裹宽度(单位:mm 毫米)",
"height": "包裹高度(单位:mm 毫米)",
"declareValue": "商品申报价值(USD)",
"itemUrl": "交易平台商品URL地址",
"itemId": "交易平台商品ID",
"productLink": "交易平台商品销售链接",
"hsCode": "海关编码",
"gridCode": "仓位号",
"sellPrice": " 售 价 ",
"warehouseName": "仓库名称",
"ebayTransactionId": "ebay Transaction ID",
"ebaySellerId": "ebay 商家ID",
"ebayBuyerId": "ebay 买家id",
"commodityMaterial": "商品材质",
"commodityUse": "商品用途",
"salesRecordNumber": "平台交易号",
"unitName": "商品单位"
}, {
"sku": "商品SKU",
"platformsku": "平台sku(开放部分物流商)",
"multiattribute": "商品多属性",
"productName": "商品名称",
"declareNameCn": "商品中文申报名称",
"declareNameEn": "商品英文申报名称",
"weight": "商品单件重量(单位:g克)",
"quantity": "数量",
"length": "包裹长度(单位:mm 毫米)",
"width": "包裹宽度(单位:mm 毫米)",
"height": "包裹高度(单位:mm 毫米)",
"declareValue": "商品申报价值(USD)",
"itemUrl": "交易平台商品URL地址",
"itemId": "交易平台商品ID",
"productLink": "交易平台商品销售链接",
"hsCode": "海关编码",
"gridCode": "仓位号",
"sellPrice": " 售 价 ",
"warehouseName": "仓库名称",
"ebayTransactionId": "ebay Transaction ID",
"ebaySellerId": "ebay 商家ID",
"ebayBuyerId": "ebay 买家id",
"commodityMaterial": " 商 品 材 质 ",
"commodityUse": "商品用途",
"salesRecordNumber": "平台交易号",
"unitName": "商品单位"
}],
"addressPickup": {
"companyName": "发件人公司",
"countryCode": "发件人国家编码",
"contact": " 发 件 人 姓 名 ",
"province": "发件人所属省",
"city": "发件人所属城市",
"area": "发件人所属地区",
"address": "发件人详细地址",
"telephone": "发件人联系电话",
"mobile": "发件人手机",
"zipcode": "发件人邮编",
"email": "发件联系人email"
},
"addressBack": {
"companyName": "退件人公司",
"countryCode": "退件国家编码",
"contact": " 退件人姓名",
"province": "退件人所属省",
"city": "退件人所属城市",
"area": "退件人所属地区",
"address": "退件人详细地址",
"telephone": "退件人联系电话",
"mobile": "退件人手机",
"zipcode": "退件人邮编",
"email": "退件联系人email",
},
"addressReceive": {
"countryCode": "收件人国家",
"province": "收件人省州",
"city": "收件人城市",
"doorcode": "门牌号",
"street1": "详细地址",
"street2": "备用地址",
"zipcode": "收件人邮编",
"receiver": "收件人姓名",
"district": "收件人区",
"companyStreet": "收件人公司名称",
"StoreCode": "门店编码, //针对德国方向为柜号,台湾方向为门店编码",
"StoreName": "门店名称, //德国方向为公司名称,台湾方向为门店名称",
"telephone": "收件人联系方式",
"mobile": "收件人手机",
"email": "收件人邮箱",
"buyeridentity": "{\"idNumber\": \"韩国收件人身份 ID\", \"idName\": \"身份 ID姓名\" }",
"latitude": "纬度",
"longitude": "经度"
},
"customer": {
"username": "卖家帐号",
"name ": "卖家姓名 ",
"logisticsKeys ": {
"wishu": {
"api_key": "物流令牌",
"api_secret": "物流秘钥 //如果物流授权参数只有一个,则接口只有api_key 一个参数。",
"api_token": "物流token //最多支持客户在erp填写三个授权参数"
},
"bub": {
"api_key": "物流令牌",
"api_secret": "物流秘钥 ",
"api_token": "物流token "
}
}
},
"expressChannelCode": "物流产品运单号",
"supplierInnerCode": "物流商内部单",
"expressChannel": {
"name": "产品名称",
"channelType": "产品类型1国际邮政2邮政平邮3邮政挂号",
"allowReturn": "支持退件1是2否",
"allowBattary": "允许带电1是2否"
},
"myExpressChannel": {
"name": "供应商自定义产品名称",
"customerCode": "物流产品自定义字段"
},
"labelHTMLUrl": {
"b10_10": {
"a": "单一地址单URL地址",
"c": "单一报关单URL地址",
"p": "单一配货单URL地址",
"i": "单一发票URL地址",
"ac": "地址单和报关单同一URL地址"
},
"a4": {
"a": "单一地址单URL地址",
"c": "单一报关单URL地址",
"p": "单一配货单URL地址",
"i": "单一发票URL地址",
"ac": "地址单和报关单同一URL地址"
}
},
"labelPDFUrl": {
"b10_10": {
"a": "单一地址单URL地址",
"c": "单一报关单URL地址",
"p": "单一配货单URL地址",
"i": "单一发票URL地址",
"ac": "地址单和报关单同一URL地址"
},
"a4": {
"a": "单一地址单URL地址",
"c": "单一报关单URL地址",
"p": "单一配货单URL地址",
"i": "单一发票URL地址",
"ac": "地址单和报关单同一URL地址"
}
}
},
{
"code": "内部订单号2",
"customizeCode": "ERP自定义单号2",
"platformTradeCode": "平台订单编号:例如ebay,wish 等订单编号",
"status": "订单状态",
……
}
],
"pagination": {
"page": "当 前 页 ",
"rowsPerPage": "每页显示数量",
"totalCount": "总数量"
}
}
```