当前位置: 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接口名称

typeString

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  IntegerERP售后状态非必填


erp_mall_no  StringERP店铺编码非必填"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结束时间时间戳  非必填1761926400end_time结束时间
query_time_start  Long开始时间时间戳 非必填1761926400start_time开始时间
query_time_typeInteger查询时间类型: 1-售后申请时间 2-售后更新时间非必填

0:最后修改时间,1:结算时间,2:创建时间。默认为0

pageInteger页码必填1page_no分页编号,分页查询必传
page_sizeInteger返回数量,最大100
必填100page_size分页大小,分页查询必传
sid
String商家唯一标识必填wdtapi3sid旺店通卖家账号


响应信息

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_timeString售后申请时间 

created

创建时间
erp_after_sales_id  String ERP 售后单号  refund_no退换单号
erp_after_sales_status  IntegerERP售后状态  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_amountString 实退⾦额  actual_refund_amount实际退款/收款金额
refund_reason String 退款原因  refund_reason 退款原因  
speed_refund_flagInteger 极速退款标志位 1:极速退款,0:⾮极速退款  

tracking_numberString 退货快递单号return_logistics_no退货物流单号
updated_timeString售后更新时间  

modified

最后修改时间
itemsList<item>


items

PDD字段参数类型PDD字段名wdt字段wdtERP字段名
erp_goods_id Stringerp 商品编码goods_no货品编号
erp_sku_id Stringerp 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


常用工具