coupang
GET/v2/providers/openapi/apis/api/v1/revenue-history2609170000

销售明细查询

# 01

简介

销售明细查询

# 02

详细内容

API支持的买家用户地区:韩国

您可根据销售确认日期(确认收货日/配送完成+7天)查询详细的销售明细。

路径

GET/v2/providers/openapi/apis/api/v1/revenue-history

示例端点

https://api-gateway.coupang.com/v2/providers/openapi/apis/api/v1/revenue-history?vendorId=A00012345&recognitionDateFrom=2019-10-01&recognitionDateTo=2019-10-30&token=&maxPerPage=
# 03

Query 参数

NameTypeDescription
vendorId*string
卖家ID

酷澎提供给卖家的固有代码

例) A00012345
recognitionDateFrom*string
销售确认开始日期

最多可输入31天

格式: YYYY-MM-dd
recognitionDateTo*string
销售确认结束日期

最多可输入31天

格式: YYYY-MM-dd
token*string
查询下一页所需的Token 值

调用下一页所需的Token 值

(查询第一页时只输入到”token=”即可)
maxPerPagenumber
每页最多调用数量

默认值: 50; 最小值: 1; 最大值: 50
# 04

响应体

响应消息

NameTypeDescription
codeinteger
服务器响应码
messagestring
详细信息
dataobject[]
结果列表

没有结果时返回为空表
orderId
data[].orderId
integer
订单号
saleType
data[].saleType
string
分类
Status Description
SALE 订单
REFUND 退货订单
saleDate
data[].saleDate
string
付款日期

格式: YYYY-MM-dd
recognitionDate
data[].recognitionDate
string
销售确认日期

格式: YYYY-MM-dd

“配送完成+ 7天“ 或 ”确认收货”
settlementDate
data[].settlementDate
string
预计结算日

格式: YYYY-MM-dd
finalSettlementDate
data[].finalSettlementDate
string
保留金额预计支付日

格式: YYYY-MM-dd

仅在周结时使用
deliveryFee
data[].deliveryFee
object
配送费详细指南
amount
data[].deliveryFee.amount
integer
总配送费

总配送费: 基本配送费+偏远地区配送费
fee
data[].deliveryFee.fee
integer
总配送手续费
feeVat
data[].deliveryFee.feeVat
integer
总配送费附加税
feeRatio
data[].deliveryFee.feeRatio
integer
配送手续费率(%)
settlementAmount
data[].deliveryFee.settlementAmount
integer
配送费结算金额

结算金额:总配送费 - 配送手续费 - 配送费附加税
baseAmount
data[].deliveryFee.baseAmount
integer
基本配送费
baseFee
data[].deliveryFee.baseFee
integer
基本配送手续费
baseFeeVat
data[].deliveryFee.baseFeeVat
integer
基本配送费附加税
remoteAmount
data[].deliveryFee.remoteAmount
integer
偏远地区配送费
remoteFee
data[].deliveryFee.remoteFee
integer
偏远地区配送手续费
remoteFeeVat
data[].deliveryFee.remoteFeeVat
integer
偏远地区配送费附加税
items
data[].items
object[]
各订单商品的结算金额明细
taxType
data[].items[].taxType
string
是否收税
productId
data[].items[].productId
integer
显示商品ID

此ID可随时修改(合并或分离), 不能作为结算时对账的关键数据
productName
data[].items[].productName
string
显示商品名
vendorItemId
data[].items[].vendorItemId
integer
属性ID

酷澎最小的商品单位(用于商品修改、退货)

此ID无法修改。因为是最小单位,所以被用作key
vendorItemName
data[].items[].vendorItemName
string
属性名
salePrice
data[].items[].salePrice
integer
总售价

数量变更后的总售价
quantity
data[].items[].quantity
integer
数量
coupangDiscountCoupon
data[].items[].coupangDiscountCoupon
integer
酷澎专属优惠金额
discountCouponPolicyAgreement
data[].items[].discountCouponPolicyAgreement
boolean
是否同意酷澎专属优惠券
saleAmount
data[].items[].saleAmount
integer
销售金额

销售金额= 销售额 – 酷澎专属优惠券
sellerDiscountCoupon
data[].items[].sellerDiscountCoupon
integer
卖家优惠券
downloadableCoupon
data[].items[].downloadableCoupon
integer
下载优惠券
serviceFee
data[].items[].serviceFee
integer
服务使用费
serviceFeeVat
data[].items[].serviceFeeVat
integer
服务使用附加税
serviceFeeRatio
data[].items[].serviceFeeRatio
number
服务使用率(%, 不包括VAT)
settlementAmount
data[].items[].settlementAmount
integer
结算金额

结算金额= 销售金额 - (服务使用费+服务使用附加税)
couranteeFeeRatio
data[].items[].couranteeFeeRatio
integer
Courantee使用率(%)
couranteeFee
data[].items[].couranteeFee
integer
Courantee使用费(amount)
couranteeFeeVat
data[].items[].couranteeFeeVat
integer
Courantee使用附加税
externalSellerSkuCode
data[].items[].externalSellerSkuCode
string
卖家商品管理编号
storeFeeDiscount
data[].items[].storeFeeDiscount
integer
卖家店铺使用费折扣金额
storeFeeDiscountVat
data[].items[].storeFeeDiscountVat
integer
卖家店铺使用费附加税
hasNextboolean
下一页是否存在信息
nextTokenstring
查询下一页所需的Token值

Response Example

{
  "code": 200,
  "message": "OK",
  "data": [
    {
      "orderId": 28000048862315,
      "saleType": "REFUND",
      "saleDate": "2019-09-06",
      "recognitionDate": "2019-10-02",
      "settlementDate": "2019-11-21",
      "finalSettlementDate": "2019-11-21",
      "deliveryFee": {
        "amount": 0,
        "fee": 0,
        "feeVat": 0,
        "feeRatio": 3,
        "settlementAmount": 0,
        "baseAmount": 0,
        "baseFee": 0,
        "baseFeeVat": 0,
        "remoteAmount": 0,
        "remoteFee": 0,
        "remoteFeeVat": 0
      },
      "items": [
        {
          "taxType": "TAX",
          "productId": 294693352,
          "productName": "gtest 테스트 비정품잉크",
          "vendorItemId": 5307184135,
          "vendorItemName": "gtest 테스트 비정품잉크, 1개, 블랙",
          "salePrice": 300,
          "quantity": 2,
          "coupangDiscountCoupon": 0,
          "discountCouponPolicyAgreement": false,
          "saleAmount": 300,
          "sellerDiscountCoupon": 0,
          "downloadableCoupon": 0,
          "serviceFee": 22,
          "serviceFeeVat": 2,
          "serviceFeeRatio": 7,
          "settlementAmount": 276,
          "couranteeFeeRatio": 0,
          "couranteeFee": 0,
          "couranteeFeeVat": 0,
          "storeFeeDiscountVat": 0,
          "storeFeeDiscount": 0,
          "externalSellerSkuCode": ""
        },
        {
          "taxType": "TAX",
          "productId": 294692050,
          "productName": "gtest 테스트 훈제란",
          "vendorItemId": 5307179471,
          "vendorItemName": "gtest 테스트 훈제란, 1개, 500g",
          "salePrice": 100,
          "quantity": 1,
          "coupangDiscountCoupon": 0,
          "discountCouponPolicyAgreement": false,
          "saleAmount": 100,
          "sellerDiscountCoupon": 0,
          "downloadableCoupon": 0,
          "serviceFee": 10,
          "serviceFeeVat": 1,
          "serviceFeeRatio": 10,
          "settlementAmount": 89,
          "couranteeFeeRatio": 0,
          "couranteeFee": 0,
          "couranteeFeeVat": 0,
          "storeFeeDiscountVat": 0,
          "storeFeeDiscount": 0,
          "externalSellerSkuCode": ""
        }
      ]
    },
    {
      "orderId": 2000050175528,
      "saleType": "SALE",
      "saleDate": "2019-09-26",
      "recognitionDate": "2019-10-03",
      "settlementDate": "2019-11-21",
      "finalSettlementDate": "2019-11-21",
      "deliveryFee": {
        "amount": 0,
        "fee": 0,
        "feeVat": 0,
        "feeRatio": 3,
        "settlementAmount": 0,
        "baseAmount": 0,
        "baseFee": 0,
        "baseFeeVat": 0,
        "remoteAmount": 0,
        "remoteFee": 0,
        "remoteFeeVat": 0
      },
      "items": [
        {
          "taxType": "TAX",
          "productId": 290865426,
          "productName": "쁘띠드엔 ㅇㅇ",
          "vendorItemId": 5291775079,
          "vendorItemName": "쁘띠드엔 ㅇㅇ, 남아, L(7호)",
          "salePrice": 200,
          "quantity": 1,
          "coupangDiscountCoupon": 0,
          "discountCouponPolicyAgreement": false,
          "saleAmount": 200,
          "sellerDiscountCoupon": 0,
          "downloadableCoupon": 0,
          "serviceFee": 21,
          "serviceFeeVat": 2,
          "serviceFeeRatio": 10.5,
          "settlementAmount": 177,
          "couranteeFeeRatio": 0,
          "couranteeFee": 0,
          "couranteeFeeVat": 0,
          "storeFeeDiscountVat": 0,
          "storeFeeDiscount": 0,
          "externalSellerSkuCode": ""
        }
      ]
    },
    {
      "orderId": 0,
      "saleType": "SALE",
      "saleDate": "2019-10-31",
      "recognitionDate": "2019-10-31",
      "settlementDate": "2019-11-21",
      "finalSettlementDate": "2019-11-21",
      "deliveryFee": {
        "amount": 0,
        "fee": 0,
        "feeVat": 0,
        "feeRatio": 3,
        "settlementAmount": 0,
        "baseAmount": 0,
        "baseFee": 0,
        "baseFeeVat": 0,
        "remoteAmount": 0,
        "remoteFee": 0,
        "remoteFeeVat": 0
      },
      "items": [
        {
          "taxType": "",
          "productId": 0,
          "productName": "",
          "vendorItemId": 0,
          "vendorItemName": "",
          "salePrice": 0,
          "quantity": 0,
          "coupangDiscountCoupon": 0,
          "discountCouponPolicyAgreement": false,
          "saleAmount": 0,
          "sellerDiscountCoupon": 0,
          "downloadableCoupon": 0,
          "serviceFee": 0,
          "serviceFeeVat": 0,
          "serviceFeeRatio": null,
          "settlementAmount": 0,
          "couranteeFeeRatio": 0,
          "couranteeFee": 0,
          "couranteeFeeVat": 0,
          "storeFeeDiscountVat": 0,
          "storeFeeDiscount": 0,
          "externalSellerSkuCode": ""
        }
      ]
    }
  ],
  "hasNext": false,
  "nextToken": ""
}
# 05

错误码

HTTP代码消息
--