coupang
GET/v2/providers/openapi/apis/api/v5/vendors/{vendorId}/ordersheets2609170000

订单列表查询(以分钟为单位)

# 01

简介

订单列表查询(以分钟为单位)

# 02

详细内容

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

可以分钟为单位查询24小时内的订单列表。

注意:CGF 订单不会通过 Open API 返回给您。 请通过 Wing 查看。

例) (2022-08-10T00:00~2022-08-10T23:59)

搜索超过 24 小时时出现错误。

除部分Path Parameter外,整体配置与订单列表查询(以天为单位)相同。

订单列表中无法查看已完成退货的订单,请通过“退货/取消申请列表查询”API查看。

顾客可在付款完成后修改收货地址,

因此将商品状态处理为“商品准备中”后,请务必通过单件订单查询更新配送地信息("receiver")。

  • 发货前,请一定要确认"sellerProductName + sellerProductItemName"和"vendorItemName"上的信息是否一致。
  • 构成、数量、容量等有不同时,请先暂停发货,通过在线咨询申请的话我们会尽快给予帮助的。(商品信息显示错误。> 请选择“是”来申请。)
  • 若确认为错误显示,扣除的卖家分数就会恢复。

路径

GET/v2/providers/openapi/apis/api/v5/vendors/{vendorId}/ordersheets

示例端点

https://api-gateway.coupang.com/v2/providers/openapi/apis/api/v5/vendors/A00012345/ordersheets?createdAtFrom=2025-07-10T00:00%2B09:00&createdAtTo=2025-07-10T23:59%2B09:00&searchType=timeFrame&status=DEPARTURE
# 03

Path 参数

NameTypeDescription
vendorId*object
vendor ID

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

ex) A00012345
# 04

Query 参数

NameTypeDescription
createdAtFrom*string
查询起始时间(符合ISO-8601標準)

查询起始时间请按照此格式填写 "yyyy-mm-ddT01:00%2B09:00"
ex) 2025-07-01T01:00%2B09:00 (请求台湾店铺时,时区为08:00)
createdAtTo*string
查询结束时间
查询结束时间请按照此格式填写 "yyyy-mm-ddT02:00%2B09:00"
ex) 2025-07-01T02:00%2B09:00 (请求台湾店铺时,时区为08:00)
最多可以查询24小时(日期可以不是同一天)
status*string
订单状态
参数名称 订单状态
ACCEPT 付款完成
INSTRUCT 产品准备中
DEPARTURE 运送开始
DELIVERING 运送中
FINAL_DELIVERY 配送完成
NONE_TRACKING 卖家自行配送 (或者其配送系统未与Coupang对接); 无法追踪
nextTokenstring
请求下一页内容时所需的 Token 值
查询第一页内容时无需填写此字段值.
每页最多返回50个订单. 请使用 [nextToken] 来查询之后的页面
searchTypestring
订单列表查询类型
当 "searchType=timeFrame" 时,使用的是按分钟查询订单列表功能。除此之外,使用的是按天查询订单列表功能。
# 05

响应体

响应消息

NameTypeDescription
object
code
code
number
服务器返回码
message
message
string
服务器返回信息
data
data
number
订单列表
如果没有订单,则返回空列表
shipmentBoxId
data.shipmentBoxId
number
合并配送号码
orderId
data.orderId
number
订单号
orderedAt
data.orderedAt
string
订单日期/时间 (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
orderer
data.orderer
object
订购人信息
name
data.orderer.name
string
订购人名字
email
data.orderer.email
string
订购人电子邮箱

未使用/則会显示空值(“”)
safeNumber
data.orderer.safeNumber
string
收货人电话号码(隐私号码) (格式需符合E.164標準)
ordererNumber
data.orderer.ordererNumber
string
收货人电话号码 (真实电话号码) (格式需符合E.164標準)
paidAt
data.paidAt
string
付款完成时的日期/时间 (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
status
data.status
string
订单状态码
状态 含义
ACCEPT 付款完成
INSTRUCT 产品准备中
DEPARTURE 开始运送
DELIVERING 运送中
FINAL_DELIVERY 运送完成
NONE_TRACKING 卖家自行配送 (或者其配送系統未与Coupang对接); 无法追踪
shippingPrice
data.shippingPrice
object
配送费
currencyCode
data.shippingPrice.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.shippingPrice.units
number
货币整数部分,64-bit
nanos
data.shippingPrice.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
remotePrice
data.remotePrice
object
偏远地区运送费
currencyCode
data.remotePrice.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.remotePrice.units
number
货币整数部分,64-bit
nanos
data.remotePrice.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
remoteArea
data.remoteArea
boolean
收货地址是否为偏远地区
parcelPrintMessage
data.parcelPrintMessage
string
买家备注
splitShipping
data.splitShipping
boolean
是否为分开配送
ableSplitShipping
data.ableSplitShipping
boolean
是否可以分开配送
receiver
data.receiver
object
收货人信息

订单在付款完成状态下,买家可以更改。请在确认订单更改为“产品准备中”状态时,检查收货地址是否有改变。
name
data.receiver.name
string
收货人姓名
safeNumber
data.receiver.safeNumber
string
收货人联系方式 (隐私号码) (格式需符合E.164標準)
receiverNumber
data.receiver.receiverNumber
string
收货人电话号码 (真实号码) (格式需符合E.164標準)
addr1
data.receiver.addr1
string
收货人地址1
addr2
data.receiver.addr2
string
收货人地址2
postCode
data.receiver.postCode
string
收货人邮编
consigneePrimaryAddress
data.receiver.consigneePrimaryAddress
string
基于邮政编码的收件人基本地址
orderItems
data.orderItems
object[]
订单物品信息
sequenceNo
data.orderItems[].sequenceNo
string
订单商品 3 位序列号,从 "001" 开始
vendorItemPackageId
data.orderItems[].vendorItemPackageId
number
vendorItemPackageId

未使用/不存在则返回0
vendorItemPackageName
data.orderItems[].vendorItemPackageName
string
vendorItemPackageName
productId
data.orderItems[].productId
number
产品ID

未使用/不存在则返回0
vendorItemId
data.orderItems[].vendorItemId
number
产品单项ID/OptionID
vendorItemName
data.orderItems[].vendorItemName
string
产品单项名称
shippingCount
data.orderItems[].shippingCount
number
shippingCount = 订购时的产品数量

holdCountForCancel = 被取消待退款的产品数量
cancelCount = 已经确认要被取消的产品数量
可配送产品数量 = shippingCount - (holdCountForCancel + cancelCount )
salesPrice
data.orderItems[].salesPrice
object
产品单项单价
currencyCode
data.orderItems[].salesPrice.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].salesPrice.units
number
货币整数部分,64-bit
nanos
data.orderItems[].salesPrice.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
orderPrice
data.orderItems[].orderPrice
object
付款金额: salesPrice*shippingCount
currencyCode
data.orderItems[].orderPrice.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].orderPrice.units
number
货币整数部分,64-bit
nanos
data.orderItems[].orderPrice.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
discountPrice
data.orderItems[].discountPrice
object
打折金额总和,
discountPrice(打折金额总和) =
instantCouponDiscount(立減优惠券) +
downloadableCoupon(下载优惠券) +
coupangDiscount(Coupang 专享优惠)
currencyCode
data.orderItems[].discountPrice.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].discountPrice.units
number
货币整数部分,64-bit
nanos
data.orderItems[].discountPrice.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
instantCouponDiscount
data.orderItems[].instantCouponDiscount
object
立減优惠券
currencyCode
data.orderItems[].instantCouponDiscount.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].instantCouponDiscount.units
number
货币整数部分,64-bit
nanos
data.orderItems[].instantCouponDiscount.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
downloadableCouponDiscount
data.orderItems[].downloadableCouponDiscount
object
下载优惠券
currencyCode
data.orderItems[].downloadableCouponDiscount.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].downloadableCouponDiscount.units
number
货币整数部分,64-bit
nanos
data.orderItems[].downloadableCouponDiscount.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
coupangDiscount
data.orderItems[].coupangDiscount
object
Coupang 专享优惠

酷澎专享购物車/品类折扣等金额
currencyCode
data.orderItems[].coupangDiscount.currencyCode
string
货币码(符合ISO-4217標準),3位大写字母
units
data.orderItems[].coupangDiscount.units
number
货币整数部分,64-bit
nanos
data.orderItems[].coupangDiscount.nanos
number
货币小数部分,32-bit,取值范围 [-999999999, 999999999]
externalVendorSkuCode
data.orderItems[].externalVendorSkuCode
string
卖家产品 SKU
etcInfoHeader
data.orderItems[].etcInfoHeader
string
各产品单项输入项

可选输入
etcInfoValue
data.orderItems[].etcInfoValue
string
各产品单项输入项的使用者输入值

可选输入

此栏位存在,但是沒有任何值. 如果需要,请使用以下 etcInfoValues.
etcInfoValues
data.orderItems[].etcInfoValues
number
使用者商品单项各属性入值

可先输入
sellerProductId
data.orderItems[].sellerProductId
number
卖家产品ID
sellerProductName
data.orderItems[].sellerProductName
string
注册产品名称
sellerProductItemName
data.orderItems[].sellerProductItemName
string
产品单项名称
firstSellerProductItemName
data.orderItems[].firstSellerProductItemName
string
原始产品单项注册名称
cancelCount
data.orderItems[].cancelCount
number
已取消产品数量
holdCountForCancel
data.orderItems[].holdCountForCancel
number
被取消待退款的产品数量
estimatedShippingDate
data.orderItems[].estimatedShippingDate
string
收到订单后预计发货日期 (符合ISO-8601標準)

格式:YYYY-MM-DD
plannedShippingDate
data.orderItems[].plannedShippingDate
string
计划发货日期(拆分发货订单) (符合ISO-8601標準)

格式:YYYY-MM-dd
invoiceNumberUploadDate
data.orderItems[].invoiceNumberUploadDate
string
运单号上传日期 (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
extraProperties
data.orderItems[].extraProperties
string
卖家商品属性的其它信息

key:value 类型
pricingBadge
data.orderItems[].pricingBadge
boolean
是否为最低价

true/false
usedProduct
data.orderItems[].usedProduct
boolean
是否为二手货

true/false
confirmDate
data.orderItems[].confirmDate
string
确认收货日期时间 (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
deliveryChargeTypeName
data.orderItems[].deliveryChargeTypeName
string
配送收费型別

not-free, free
productCategoryLevel1
data.orderItems[].productCategoryLevel1
string
商品分类一级类目名称
productCategoryLevel2
data.orderItems[].productCategoryLevel2
string
商品分类二级类目名称
productSalesPageUrl
data.orderItems[].productSalesPageUrl
string
Coupang 市场商品销售页面 URL
canceled
data.orderItems[].canceled
boolean
订单是否被取消

true/false
overseaShippingInfoDto
data.overseaShippingInfoDto
object
海外配送信息
personalCustomsClearanceCode
data.overseaShippingInfoDto.personalCustomsClearanceCode
string
个人海关通关码
orderersSsn
data.overseaShippingInfoDto.orderersSsn
string
未使用
ordererPhoneNumber
data.overseaShippingInfoDto.ordererPhoneNumber
string
收货人电话号码(格式需符合E.164標準)
oneTimePccc
data.overseaShippingInfoDto.oneTimePccc
string
KCS 签发的一次性个人通关代码(PCCC)。用于基于 CI 认证的自购订单
otpNumber
data.overseaShippingInfoDto.otpNumber
string
通关验证用 OTP(一次性密码
deliveryCompanyName
data.deliveryCompanyName
string
物流配送公司名称

CJ Logistics, Hanjin Express, etc.
invoiceNumber
data.invoiceNumber
string
运单号
inTrasitDateTime
data.inTrasitDateTime
string
配送日期时间 (开始运送时间) (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
deliveredDate
data.deliveredDate
string
结算完成日期时间 (符合ISO-8601標準)

格式:YYYY-MM-DDThh:mm:ss.ssssss±hh:mm
refer
data.refer
string
付款设备信息:

iPhone, Android APP 或者 PC/Mobile 网页。
shipmentType
data.shipmentType
string
运送类别

THIRD_PARTY, CGF, CGF LITE
isCod
data.isCod
boolean
订单是否为货到付款配送 true / false
ecommerceTypeCode
data.ecommerceTypeCode
string
通关申报用电子商务类型代码。C 卖家为 "A"(直接购买),A 卖家为 "B"(购买代行)
tradePartnerCode
data.tradePartnerCode
string
市场中介方代码。例:"K-26-001277"
tradePartnerName
data.tradePartnerName
string
市场中介方名称。例:"쿠팡 주식회사"
seller
data.seller
object
卖家信息
sellerName
data.seller.sellerName
string
在 Coupang 市场注册的卖家名称
sellerId
data.seller.sellerId
string
Coupang 市场分配的卖家 ID
extraProperties
data.extraProperties
object
订单属性的其他信息
key:value 类型

有发票的市场会看到以下信息:
invoiceAmountInfo
invoiceAmountToBuyer:开给买家的发票金额
invoiceAmountToCoupang:开给 Coupang 的发票金额
currency:货币种类
taxReceiptInfo
receiptOption:
“PAPER”:纸质发票
“E-GUI”:电子发票
appliedType:发票类型,取值:
"PERSONAL_COUPANG_MEMBER_CARRIER" :酷澎会员载具
"PERSONAL_MOBILE_BARCODE_CARRIER" :手机条码载具
"DONATION" :发票捐赠
"BUSINESS" :公司发票
appliedValue:发票统编信息,取值:
appliedType为PERSONAL_COUPANG_MEMBER_CARRIER时:null
appliedType为PERSONAL_MOBILE_BARCODE_CARRIER时: 手机条码
appliedType为DONATION时: 发票捐赠编号
appliedType为BUSINESS时: 公司统一编号

SameDayShipping:是否当日出货(可选值):
“true”:当日出货启用
“false”:当日出货终止
cutOffTimeHour:晚于此时间当日出货不适用(可选值)
10~23,0
nextToken
nextToken
string
请求下一页內容时所需的 Token 值。若无下一頁,刚为 “”。

Response Example

{
 "code": 200,
 "message": "OK",
 "data": [
 {
 "shipmentBoxId": 64253897***6401429,
 "orderId": 22000009546234,
 "orderedAt": "2025-01-15T14:17:13.973885-08:00",
 "orderer": {
 "name": "신*희",
 "email": "",
 "safeNumber": "+1(555)444-1234",
 "ordererNumber": null
 },
 "paidAt": "2025-01-15T14:17:13.973885-08:00",
 "status": "FINAL_DELIVERY",
 "shippingPrice": {
 "currencyCode": "KRW",
 "units": 2500,
 "nanos": 0
 },
 "remotePrice": null,
 "remoteArea": false,
 "parcelPrintMessage": "문 앞",
 "splitShipping": false,
 "ableSplitShipping": false,
 "receiver": {
 "name": "신*희",
 "safeNumber": "+1(555)444-1234",
 "receiverNumber": null,
 "addr1": "경기 광명시 하안1동 두산트레지움아파트",
 "addr2": "107동701호",
 "postCode": "423-747"
 "consigneePrimaryAddress": "address based on postcode"
 },
 "orderItems": [
 {
 "sequenceNo": "001",
 "vendorItemPackageId": 0,
 "vendorItemPackageName": "인디고뱅크키즈 기모 테잎배색 트레이닝 팬츠 IKTM17WG1",
 "productId": 31846051,
 "vendorItemId": 3242596358,
 "vendorItemName": "인디고뱅크키즈 기모 테잎배색 트레이닝 팬츠 IKTM17WG1, 07 DARK GREY, 160호",
 "shippingCount": 1,
 "salesPrice": {
 "currencyCode": "KRW",
 "units": 19900,
 "nanos": 0
 },
 "orderPrice": {
 "currencyCode": "KRW",
 "units": 19900,
 "nanos": 0
 },
 "discountPrice": null,
 "externalVendorSkuCode": "170816368810",
 "etcInfoHeader": null,
 "etcInfoValue": null,
 "etcInfoValues": [
 "추가메시지1",
 "추가메시지2"
 ],
 "sellerProductId": 80240831,
 "sellerProductName": "인디고뱅크키즈 A5 기모 배색츄키니 IKTM17WG1",
 "sellerProductItemName": "07 DARK GREY 160호",
 "firstSellerProductItemName": "07 DARK GREY/160호",
 "cancelCount": 0,
 "holdCountForCancel": 0,
 "estimatedShippingDate": "2017-10-16",
 "plannedShippingDate": "",
 "invoiceNumberUploadDate": "",
 "extraProperties": {},
 "pricingBadge": false,
 "usedProduct": false,
 "confirmDate": "2025-01-15T14:17:13.973885-08:00",
 "deliveryChargeTypeName": "유료",
 "productCategoryLevel1": "패션의류",
 "productCategoryLevel2": "남성의류",
 "productSalesPageUrl": "https://www.coupang.com/vp/products/9382706107?vendorItemId=94815759162",
 "canceled": false
 }
 ],
 "overseaShippingInfoDto": {
 "personalCustomsClearanceCode": "",
 "ordererSsn": "",
 "ordererPhoneNumber": ""
 "oneTimePccc": "",
 "otpNumber": null
 },
 "deliveryCompanyName": "CJ 대한통운",
 "invoiceNumber": "340010913442",
 "inTrasitDateTime": "2025-01-15T14:17:13.973885-08:00",
 "deliveredDate": "2025-01-15T14:17:13.973885-08:00",
 "refer": "안드로이드앱"
 "shipmentType": "THIRD_PARTY",
 "isCod": false,
 ecommerceTypeCode": "A",
 "tradePartnerCode": "K26001277",
 "tradePartnerName": "쿠팡 주식회사",
 "seller":
 {
 "sellerName": "TEST SELLER",
 "sellerId": "C01234567"
 },
 "extraProperties":{
 "sameDayShipping": "false",
 "cutOffTimeHour": "0"}
 },
 {
 "shipmentBoxId": 6425389776401428,
 "orderId": 22000009546630,
 "orderedAt": "2025-01-15T14:17:13.973885-08:00",
 "orderer": {
 "name": "김*숙",
 "email": "hs*****@na",
 "safeNumber": "+1(555)444-1234",
 "ordererNumber": null
 },
 "paidAt": "2025-01-15T14:17:13.973885-08:00",
 "status": "FINAL_DELIVERY",
 "shippingPrice": {
 "currencyCode": "KRW",
 "units": 0,
 "nanos": 0
 },
 "remotePrice": null,
 "remoteArea": false,
 "parcelPrintMessage": "직접 받고 부재 시 문 앞",
 "splitShipping": false,
 "ableSplitShipping": false,
 "receiver": {
 "name": "김*숙",
 "safeNumber": "+1(555)444-1234",
 "receiverNumber": null,
 "addr1": "경기도 고양시 일산동구 백석동 **아파트",
 "addr2": "303-*",
 "postCode": "104-48"
 "consigneePrimaryAddress": "address based on postcode"
 },
 "orderItems": [
 {
 "sequenceNo": "001",
 "vendorItemPackageId": 0,
 "vendorItemPackageName": "리틀브렌 후드달이 구스 경량 점퍼 LBJD17WG5",
 "productId": 34047877,
 "vendorItemId": 3261300431,
 "vendorItemName": "리틀브렌 후드달이 구스 경량 점퍼 LBJD17WG5, 04 MIDDLE MELANGE GR, 170호",
 "shippingCount": 1,
 "salesPrice": {
 "currencyCode": "KRW",
 "units": 49900,
 "nanos": 0
 },
 "orderPrice": {
 "currencyCode": "KRW",
 "units": 49900,
 "nanos": 0
 },
 "discountPrice": {
 "currencyCode": "KRW",
 "units": 500,
 "nanos": 0
 },
 "instantCouponDiscount": {
 "currencyCode": "KRW",
 "units": 0,
 "nanos": 0
 },
 "downloadableCouponDiscount": {
 "currencyCode": "KRW",
 "units": 500,
 "nanos": 0
 },
 "coupangDiscount": {
 "currencyCode": "KRW",
 "units": 0,
 "nanos": 0
 },
 "externalVendorSkuCode": "170824416510",
 "etcInfoHeader": null,
 "etcInfoValue": null,
 "etcInfoValues": [
 "추가메시지1",
 "추가메시지2"
 ],
 "sellerProductId": 87037167,
 "sellerProductName": "리틀브렌 후드달이 구스 경량 점퍼 LBJD17WG5",
 "sellerProductItemName": "04 MIDDLE MELANGE GR 170호",
 "firstSellerProductItemName": "04 MIDDLE MELANGE GR/170호",
 "cancelCount": 0,
 "holdCountForCancel": 0,
 "estimatedShippingDate": "2017-10-16",
 "plannedShippingDate": "",
 "invoiceNumberUploadDate": "",
 "extraProperties": {},
 "pricingBadge": false,
 "usedProduct": false,
 "confirmDate": "2025-01-15T14:17:13.973885-08:00",
 "deliveryChargeTypeName": "무료",
 "productCategoryLevel1": "패션의류",
 "productCategoryLevel2": "남성의류",
 "productSalesPageUrl": "https://www.coupang.com/vp/products/9382706107?vendorItemId=94815759162",
 "canceled": false
 }
 ],
 "overseaShippingInfoDto": {
 "personalCustomsClearanceCode": "",
 "ordererSsn": "",
 "ordererPhoneNumber": ""
 "oneTimePccc": "",
 "otpNumber": null
 },
 "deliveryCompanyName": "CJ 대한통운",
 "invoiceNumber": "340010912565",
 "inTrasitDateTime": "2025-01-15T14:17:13.973885-08:00",
 "deliveredDate": "2025-01-15T14:17:13.973885-08:00",
 "refer": "안드로이드앱",
 "shipmentType": "CGF LITE",
 "isCod": false,
 ecommerceTypeCode": "A",
 "tradePartnerCode": "K26001277",
 "tradePartnerName": "쿠팡 주식회사",
 "seller":
 {
 "sellerName": "TEST SELLER",
 "sellerId": "C01234567"
 },
 "extraProperties": {
 "invoiceAmountInfo": {
 “invoiceAmountToBuyer":627,
 "invoiceAmountToCoupang":0,
 "currency":"TWD"
 },
 "taxReceiptInfo": {
 "appliedValue": null,
 "receiptOption": "PAPER",
 "appliedType": "PERSONAL_COUPANG_MEMBER_CARRIER"
 },
 "sameDayShipping": "true",
 "cutOffTimeHour": "18"
 }
 }
 ],
 "nextToken": "448537989"
}
# 06

错误码

HTTP代码消息
400HTTP_400Bad Request

错误说明

HTTP类型错误消息解决方案
400400 (确认请求参数)

Invalid vendor ID

请确认您输入的卖家ID(vendorId)

是否正确。

例) A00012345

400400 (确认请求参数)

endTime-startTime range should less than 0 day

请确认查询时间段是否小于24小时。