jushuitan.orders.upload{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | shop_id | shop_id | string | 1 | Required | 店铺编号 |
| 2 | so_id | so_id | string | 1 | Required | 线上订单号, 长度 <= 50 |
| 3 | order_date | order_date | string | 1 | Required | 订单日期 |
| 4 | shop_status | shop_status | string | 1 | Required | 订单: 等待买家付款=WAIT_BUYER_PAY, 等待卖家发货=WAIT_SELLER_SEND_GOODS,等待买家确认收货=WAIT_BUYER_CONFIRM_GOODS, 交易成功=TRADE_FINISHED, 付款后交易关闭=TRADE_CLOSED,付款前交易关闭=TRADE_CLOSED_BY_TAOBAO;发货前可更新 |
| 5 | shop_buyer_id | shop_buyer_id | string | 1 | Required | 买家帐号 长度 <= 50 |
| 6 | receiver_state | receiver_state | string | 1 | Required | 收货省份 长度 <= 50;发货前可更新 |
| 7 | receiver_city | receiver_city | string | 1 | Required | 收货市 长度<=50;发货前可更新 |
| 8 | receiver_district | receiver_district | string | 1 | Required | 收货区 长度<=50;发货前可更新 |
| 9 | receiver_address | receiver_address | string | 1 | Required | 收货地址 长度<=200;发货前可更新 |
| 10 | receiver_name | receiver_name | string | 1 | Required | 收件人 长度<=50;发货前可更新 |
| 11 | receiver_phone | receiver_phone | string | 1 | Required | 联系电话 长度<=50;发货前可更新 |
| 12 | receiver_mobile | receiver_mobile | string | 1 | Optional | 手机 长度<=50;发货前可更新 |
| 13 | pay_amount | pay_amount | string | 1 | Required | 应付金额,保留两位小数,单位元) |
| 14 | freight | freight | string | 1 | Required | 运费 |
| 15 | buyer_message | buyer_message | string | 1 | Optional | 买家留言 长度<=400;可更新 |
| 16 | remark | remark | string | 1 | Optional | 卖家备注 长度<=150;可更新 |
| 17 | is_cod | is_cod | string | 1 | Optional | 是否货到付款 |
| 18 | shop_modified | shop_modified | string | 1 | Required | 订单修改日期 |
| 19 | l_id | l_id | string | 1 | Optional | 快递单号 |
| 20 | logistics_company | logistics_company | string | 1 | Optional | 快递公司名称 |
| 21 | question_desc | question_desc | string | 1 | Optional | 订单异常描述 |
| 22 | seller_flag | seller_flag | string | 1 | Optional | 卖家标签(旗帜),可选1:red, 2:yellow, 3:green, 4:blue, 5:purple |
| 23 | items | items | array | 1 | Required | 商品明细 |
| 24 | sku_id | sku_id | string | 1 | Required | ERP内商品编码 长度 <=40 PS: 设置预售标识订单,修改商品编码=商品编码+预售(或==)+预计交货日期(可选) 比如: "A321232" 修改为 "A321232预售2015-12-12" 或者 "A321232" 修改为 "A321232==2015-12-12" 当商品被购买后ERP将自动识别为预售订单并更正商品编码为正确商品编码 |
| 25 | shop_sku_id | shop_sku_id | string | 1 | Required | 店铺商品编码 长度<=128 |
| 26 | i_id | i_id | string | 1 | Optional | ERP内款号/货号 长度<=40 |
| 27 | pic | pic | string | 1 | Optional | 图片地址 长度<=300 |
| 28 | properties_value | properties_value | string | 1 | Optional | 商品属性;长度<=100 |
| 29 | amount | amount | string | 1 | Required | 成交总额,保留两位小数,单位(元);备注:可能存在人工改价 |
| 30 | base_price | base_price | string | 1 | Required | 原价,保留两位小数,单位(元) |
| 31 | qty | qty | string | 1 | Required | 数量 |
| 32 | name | name | string | 1 | Required | 商品名称 长度<=100 |
| 33 | refund_status | refund_status | string | 1 | Optional | PS:值存在,会自动将订单转异常,success 状态的,发货将不发该商品,不支持单商品发部分; 退款状态:可选 退款中=waiting; 退款成功=success,closed=退款关闭:发货前可更新 |
| 34 | outer_oi_id | outer_oi_id | string | 1 | Required | 商家系统订单商品明细主键,为了拆单合单时溯源,最长不超过 50,保持唯一 |
| 35 | remark | remark | string | 1 | Optional | 订单明细备注 |
| 36 | pay | pay | array | 1 | Optional | shop_status=WAIT_BUYER_PAY 的时候可不给 |
| 37 | outer_pay_id | outer_pay_id | string | 1 | Required | 外部支付单号,最大50 |
| 38 | pay_date | pay_date | string | 1 | Required | 支付日期 |
| 39 | payment | payment | string | 1 | Required | 支付方式,最大20 |
| 40 | seller_account | seller_account | string | 1 | Required | 卖家支付账号,最大 50 |
| 41 | buyer_account | buyer_account | string | 1 | Required | 买家支付账号,最大 200 |
| 42 | amount | amount | string | 1 | Required | 支付总额 |
| 43 | card | card | array | 1 | Optional | 身份证信息;非必填节点 |
| 44 | name | name | string | 1 | Required | 姓名;可更新,card节点存在必填 |
| 45 | card_id | card_id | string | 1 | Required | 证件号;可更新,card节点存在必填 |
| 46 | send_date | send_date | string | 1 | Optional | 发货日期 |
| 47 | labels | labels | string | 1 | Optional | 订单多标签 长度<=200 以逗号分隔,单个标签不能超过十个字符 |
| 48 | lc_id | lc_id | string | 1 | Optional | 快递公司编码 |
| 49 | receiver_country | receiver_country | string | 1 | Optional | 收货国家 仅支持二字码 |
| 50 | receiver_zip | receiver_zip | string | 1 | Optional | 邮政编码 |
| 51 | currency | currency | string | 1 | Optional | 货币代码,跨境自有平台可使用 |
| 52 | invoice_type | invoice_type | string | 1 | Optional | 发票类型:个人电子普通;单位电子普通;个人纸质普通;单位纸质普通;个人电子增值税;单位电子增值税;个人纸质增值税;单位纸质增值税 |
| 53 | invoice_title | invoice_title | string | 1 | Optional | 发票抬头 |
| 54 | buyer_tax_no | buyer_tax_no | string | 1 | Optional | 发票税号 |
| 55 | invoice | invoice | array | 1 | Optional | 专票信息 |
| 56 | address | address | string | 1 | Optional | 专票地址 |
| 57 | bank | bank | string | 1 | Optional | 专票银行 |
| 58 | phone | phone | string | 1 | Optional | 专票电话 |
| 59 | account | account | string | 1 | Optional | 专票账户 |
| 60 | string | 1 | Optional | 专票邮箱 | ||
| 61 | userName | userName | string | 1 | Optional | 专票人姓名 |
| 62 | userPhone | userPhone | string | 1 | Optional | 专票人电话 |
| 63 | userAddress | userAddress | string | 1 | Optional | 专票人地址 |
| 64 | node | node | string | 1 | Optional | 线下备注 |
| 65 | receiver_town | receiver_town | string | 1 | Optional | 收货街道 |
| 66 | receiver_email | receiver_email | string | 1 | Optional | 收获邮箱(需符合邮箱格式否则忽略上传,不可更新) |
No parameter reference available
The 订单上传_v1 API (jushuitan.orders.upload) of 聚水潭 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 聚水潭 version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.