当前位置: API文档
pdd.erp.refund.list.get(售后单查询--pdd业务(字段映射))
1.接口说明
| 1.1 接口描述:获取ERP销售退货(换货)订单信息 |
| 1.2 适用版本: |
| 1.3 增量获取:按照旺店通ERP订单的最后修改时间增量获取数据 |
| 1.4 时间跨度:start_time和end_time最大跨度为30天 |
1.5注意事项: |
2.调用场景
| 2.1 举例说明: |
3.请求参数说明
3.1 请求地址
| 环境 | HTTP地址 |
|---|---|
| 测试环境 | |
| 正式环境 | https://ark-api.pinduoduo.com/ark/router |
3.2 拼多多公共请求参数
| 名称 | 字段 | 类型 | 必须 | 描述 |
|---|---|---|---|---|
API接口名称 | type | String | 是 | API接口名称 |
拼多 erp_goods_price 多POP分配给应用的client_id | client_id | String | 是 | 拼多多POP分配给应用的client_id |
通过code获取的access_token | access_token | String | 是 | 通过code获取的access_token |
UNIX时间戳,单位秒,需要与拼多多服务器时间差值在10分钟内 | timestamp | String | 是 | UNIX时间戳,单位秒,需要与拼多多服务器时间差值在10分钟内 |
响应格式,即返回数据的格式,JSON或者XML(二选一),默认JSON,注意是大写 | data_type | String | 否 | 响应格式,即返回数据的格式,JSON或者XML(二选一),默认JSON,注意是大写 |
API协议版本号,默认为V1,可不填 | version | String | 否 | API协议版本号,默认为V1,可不填 |
API输入参数签名结果,签名算法参考开放平台接入指南第三部分底部。 | sign | String | 是 | API输入参数签名结果,签名算法参考开放平台接入指南第三部分底部拼多多sign说明。 |
目标应用client_id | target_client_id | String | 是 | 目标应用client_id 旺店通client_id:e6c4b8a127c14831b2ff860735cf8680 |
业务请求参数
| PDD字段 | 参数类型 | PDD字段名 | 是否必填 | 示例 | wdt字段 | wdtERP字段名 |
|---|---|---|---|---|---|---|
| erp_after_sales_id_list | string[] | ERP 售后单号,最多100个 | 非必填 | ["123456"] | refund_no | 退换单号 |
| erp_after_sales_status | Integer | ERP售后状态 | 非必填 | |||
| erp_mall_no | String | ERP店铺编码 | 非必填 | "123" | shop_nos | 店铺编号 |
| erp_order_sn_list | String[] | ERP订单号,最多100个 | 非必填 | ["123456"] | trade_no | 订单编号 |
| pdd_after_sales_id_list | Long | 拼多多售后单号,最多100个 | 非必填 | [“123456”] | raw_refund_nos | 原始退款单号 |
| pdd_after_sales_status | Integer | 拼多多售后状态 | 非必填 | |||
| pdd_mall_id | Long | 拼多多店铺id | 非必填 | |||
| pdd_order_sn_list | String[] | 拼多多订单号,最多100个 | 非必填 | [“123456”] | tid | 原始订单号 |
query_time_end | Long | 结束时间时间戳 | 非必填 | 1761926400 | end_time | 结束时间 |
| query_time_start | Long | 开始时间时间戳 | 非必填 | 1761926400 | start_time | 开始时间 |
| query_time_type | Integer | 查询时间类型: 1-售后申请时间 2-售后更新时间 | 非必填 | 0:最后修改时间,1:结算时间,2:创建时间。默认为0 | ||
| page | Integer | 页码 | 必填 | 1 | page_no | 分页编号,分页查询必传 |
| page_size | Integer | 返回数量,最大100 | 必填 | 100 | page_size | 分页大小,分页查询必传 |
| sid | String | 商家唯一标识 | 必填 | wdtapi3 | sid | 旺店通卖家账号 |
响应信息
refund_list
| PDD字段 | 参数类型 | PDD字段名 | wdt字段 | wdtERP字段名 |
|---|---|---|---|---|
| after_sale_reason | String | 售后原因 | refund_reason | 退款原因 |
| after_sales_type | Integer | 售后类型 | type | 退换单类型1退款(未发货,退款申请)2退货3换货4退款不退货5订单补款 |
| common_ext_param | String | 其他 | {"refund_version":"退款版本","warehouse_type":仓库类型,"swap_logistics_id":换出物流id,"bad_reason":错误原因,"logistics_style":物流形式,"other_amount":其它金额,"swap_warehouse_id":换出仓库id,"wms_result":"wms结果","advance_status":预先状态,"outer_no":"外部编号","fenxiao_nick_name":"分销商名称","shop_no":"店铺编号","is_trade_charged":是否结算后生成订单,"customer_no":"客户档案编号","shop_name":"店铺名称","refund_id":退换单主键,"finish_time":"结算时间","shop_id":店铺id,"sales_trade_id":系统订单ID,"refund_time":"退款创建时间","fenxiao_refund_no":"分销商退换单号","swap_warehouse_no":"换出货品出库仓库编号","swap_logistics_type":换货新订单物流公司类别,"wms_status":wms状态,"remark":"退款说明","swap_trade_no":"换出原始单号","wms_outer_no":"外部仓库的单号","flag_name":"标记名称","swap_logistics_name":"换货新订单物流公司名称","return_goods_count":退回货品数量,"warehouse_no":"期望退回的仓库编号","refund_out_goods_list":[非换货类型的单据不返回该节点下的字段{"rec_id":主键id,"refund_id":退换单主键id,"target_type":商品类型,"target_id":商品id,"goods_name":"商品名称","spec_name":"规格名称","merchant_no":"商家编码","retail_price":零售价,"num":数量,"remark":"备注","barcode":"主条码","spec_code":"规格编码","is_sn_enable":是否启用序列号,"oid":"原始子订单id","brand_name":"品牌","created":"创建时间","modified":"modified"}],"return_address":"退回仓库地址","refund_amount":买家申请退款金额,"revert_reason_info":"驳回原因名称","guarantee_mode":担保方,"from_type":建立方式,"push_no":"物流递交单号","swap_trade_id":换出原始单id,"stockin_pre_no":"预入库单","error_msg":"逆向物流错误信息","goods_amount":退货金额,"is_goods_received":是否收到货品,"consign_mode":发货方式,"exchange_amount":换货金额,"reason_id":原因,"guarante_refund_amount":平台退款金额,"revert_reason":驳回原因,"fenxiao_tid":"分销原始单号","op_constraint":约束,"direct_refund_amount":线下退款金额,"paid":已退款/已收款,"cs_status":退款阶段,"creator_name":"建单员姓名","customer_id":客户id,"return_mask":返回标志,"api_outer_no":"API单号","warehouse_id":仓库id} | |
| created_time | String | 售后申请时间 | created | 创建时间 |
| erp_after_sales_id | String | ERP 售后单号 | refund_no | 退换单号 |
| erp_after_sales_status | Integer | ERP售后状态 | process_status | 退换单状态 |
| erp_order_sn | String | ERP 订单号 | sales_tid | 订单编号 |
| expire_time | LONG | 售后逾期时间,时间戳 | ||
| item_refund_amount | DOUBLE | 实退⾦额 | ||
| pdd_after_sales_id | String | 拼多多售后单号 | src_no | 原始退款单号 |
| pdd_after_sales_status | Integer | 拼多多售后状态 | status | 平台状态 |
| pdd_order_sn | String | 拼多多订单号 | tid | 原始单号 |
| postage | String | 邮费 | post_amount | 邮费 |
| refund_amount | String | 实退⾦额 | actual_refund_amount | 实际退款/收款金额 |
| refund_reason | String | 退款原因 | refund_reason | 退款原因 |
| speed_refund_flag | Integer | 极速退款标志位 1:极速退款,0:⾮极速退款 | ||
| tracking_number | String | 退货快递单号 | return_logistics_no | 退货物流单号 |
| updated_time | String | 售后更新时间 | modified | 最后修改时间 |
| items | List<item> | |||
items
| PDD字段 | 参数类型 | PDD字段名 | wdt字段 | wdtERP字段名 |
|---|---|---|---|---|
| erp_goods_id | String | erp 商品编码 | goods_no | 货品编号 |
| erp_sku_id | String | erp sku 编码 | spec_no | 商家编码 |
| item_common_ext_param | String | 其他 | {"original_price":原价,"spec_code":"规格编码","edit_mask":编辑掩码,"suite_name":"组合装名称","discount":优惠,"remark":"退款说明","oid":"原始子订单编号","is_sn_enable":是否启用序列号,"from_mask_ext":平台标签,"tid":"订单子订单的原始单号 ","src_no":"平台退款单号","spec_id":erp商品主键,"sales_order_id":销售订单ID,"sales_tid":"销售订单编号","position_no":"货位编号","modified":"最后修改时间","tag":标签,"suite_id":组合装ID,"barcode":"主条码","refund_order_amount":明细退款金额,"cost_price":成本价,"goods_name":"货品名称","stockin_num":退货入库数量,"created":"创建时间","goods_id":货品ID,"brand_name":"品牌","refund_id":退换单主键,"sales_trade_id":系统订单ID,"total_amount":退货金额,"suite_no":"组合装编号","process_status":处理状态,"refund_num":退款数量,"paid":已付金额,"market_price":单品市场价,"spec_name":"规格名称","stockin_amount":退货入库总额,"order_num":实际数量,"suite_num":组合装数量,"order_id":货品明细主键,"position_id":货位ID} | |
| item_goods_number | LONG | 商品数量 | refund_num | 退款数量 |
| item_goods_price | DOUBLE | 商品单价 | price | 价格 |
| item_part_after_sales_value | Integer | 部分退货件数 / 比例 | ||
| pdd_goods_id | LONG | 拼多多商品 ID | ||
| pdd_sku_id | LONG | 拼多多 SKUID | ||