獲取結算匯總報表
每個結算日獲取結算/退款/傭金匯總報表。
相關URL
Newegg.com: https://api.newegg.com/marketplace/reportmgmt/report/result?{sellerid}&version={version}
Neweggbusiness.com: https://api.newegg.com/marketplace/b2b/reportmgmt/report/result?{sellerid}&version={version}
Newegg.ca: https://api.newegg.com/marketplace/can/reportmgmt/report/result?sellerid={sellerid}={version}
註:請確保您的請求URL全都是小寫(除Seller ID)並且不能包含任何空格或者分行符號。
參數
| 名稱 | 是否必填? | 描述 | ||||||||||||||||||||||||
| sellerid | 是 | 您在新蛋商城的商家編號 | ||||||||||||||||||||||||
| version | 是 | 有效版本:
|
相關請求資訊
| HTTP方式 | 是否需要認證? | 請求格式 | 回覆格式 | 頻率限制 |
| PUT | 需要 | XML,Json | XML,Json | 500 請求/小時 |
請求文件主體
| 屬性 | 是否必填? | 格式 | 描述 |
| IssueUser | 否 | String | 請求發送者在Seller Portal上註冊過的郵箱位址 。 系統只接受商家註冊過的Seller Portal郵箱位址。如果為空,預設值為商家編號 |
| OperationType | 是 | String | 固定值:SettlementSummaryReportRequest |
| RequestID | 是 | String | 新蛋分配的已提交的請求的編號 |
| PageIndex | 是 | Integer | 當前頁索引 |
| PageSize | 是 | Integer | 單頁返回的記錄總數 每頁最多100條。 |
Schema: GetReportRequest.xsd
示例:XML, Request
PUT https://api.newegg.com/marketplace/reportmgmt/report/result?sellerid={sellerid}
Authorization: 720ddc067f4d115bd544aff46bc75634
SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D
Content-Type: application/xml
Accept: application/xml
<NeweggAPIRequest >
<OperationType>SettlementSummaryReportRequest</OperationType>
<RequestBody>
<RequestID>2PQBYWH4V68ZP</RequestID>
<PageInfo>
<PageIndex>1</PageIndex>
<PageSize>10</PageSize>
</PageInfo>
</RequestBody>
</NeweggAPIRequest>
示例:Json, Request
PUT https://api.newegg.com/marketplace/reportmgmt/report/result?sellerid={sellerid}
Authorization: 720ddc067f4d115bd544aff46bc75634
SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D
Content-Type: application/json
Accept: application/json
{
"OperationType": "SettlementSummaryReportRequest",
"RequestBody": {
"RequestID": "2PQBYWH4V68ZP",
"PageInfo": {
"PageSize": "10",
"PageIndex": "1"
}
}
}
回覆文件主體
| 屬性 | 格式 | 描述 |
| IsSuccess | String | 用於獲取資料狀態的操作 True:成功 False:失敗 |
| SellerID | String | 你的商家編號 |
| OperationType | String | 固定值: GetSettlementSummaryInfoResponse |
| RequestID | String | 你的請求編號 |
| RequestDate | String | 請求時間(太平洋標準時間) |
| TotalCount | Integer | 總記錄數 |
| TotalPageCount | Integer | 總頁數 |
| PageIndex | Integer | 當前頁索引 |
| PageSize | Integer | 單頁的記錄個數 |
| SettlementDateFrom | String | 結算起始時間(太平洋標準時間) |
| SettlementDateTo | String | 結算結束時間(太平洋標準時間) |
| SettlementID | String | 結算編號 |
| CheckNumber | String | 核查編號 |
| ItemPrice | Decimal | 商品價格
|
| Shipping | Decimal | 運費
|
| TaxDuty | Decimal | 關稅
不適用於Newggbusiness.com 和 Newegg.ca平台 |
| GSTTotal | Decimal | 增值稅總額
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| HSTTotal | Decimal | 消費稅總額
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| GSTAndHST | Decimal | 消費稅和增值稅
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| PSTTotal | Decimal | 省銷售稅
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| PSTAndQST | Decimal | 省銷售稅(PST, QST)
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| EHFTotal | Decimal | 環境處理費
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| Other | Decimal | 其他
|
| RecyclingFeeTotal | Decimal | 回收費是政府對新購買的電子產品、電池、新輪胎等徵收的費用。這些費用用於支付這些產品的未來回收,因為其中許多產品含有有害物質。以下回收費用將添加到回收費用總額中:電子廢物回收費、電池回收費、輪胎回收費、環保費。
|
| TotalOrderAmount | Decimal | 訂單總金額
|
| Refunds | Decimal | 退款額
|
| ChargeBack | Decimal | 信用卡扣款
|
| MiscellaneousAdjustment | Decimal | 雜項調整
|
| CourtesyRefund | Decimal | 補償性退款
|
| TotalRefunds | Decimal | 退款總金額
|
| NeweggCommissionFee | Decimal | 新蛋傭金
|
| NeweggTransactionFee | Decimal | 新蛋交易費
|
| NeweggRefundCommissionFee | Decimal | 新蛋退款傭金
|
| NeweggMonthlyFee | Decimal | 新蛋月費
|
| NeweggStorageFee | Decimal | 新蛋保管費
|
| NeweggRMABuyoutFee | Decimal | 新蛋RMA Buyout費
|
| NeweggServiceFeeTax | Decimal | 新蛋Service稅費
不適用於Newgg.com 和 Neweggbusiness.com平台 |
| NeweggPremierFee | Decimal | 新蛋Premier費
|
| NeweggShippingLabelFee | Decimal | 新蛋發貨標籤費
|
| CreditCardPayment | Decimal | 信用卡支付
|
| FulfillmentByNeweggFee | Decimal | 新蛋配送費
|
| MultiChannelFee | Decimal | 多管道運費
|
| AdjustmentFee | Decimal | 其他
|
| MerchandisingFee | Decimal | 廣告費
|
| TotalNeweggFee | Decimal | 新蛋費用總計
|
| TotalSettlement | Decimal | 結算總計
|
| ReservedBalance | Decimal | 預留金額 新蛋暫時扣留的金額,用於支付您帳戶上潛在的索賠,退貨和退單 |
| PreviousReservedBalance | Decimal | 前次預留金額:上一次匯款時暫時扣留的金額 |
| Memo | String | 附加資訊 |
Schema: settlementSummaryResponse.xsd
示例: XML, Response
<?xml version="1.0" encoding="utf-8"?>
<NeweggAPIResponse>
<IsSuccess>true</IsSuccess>
<SellerID>A09D</SellerID>
<OperationType>GetSettlementSummaryInfoResponse</OperationType>
<ResponseBody>
<PageInfo>
<TotalCount>1</TotalCount>
<TotalPageCount>1</TotalPageCount>
<PageSize>10</PageSize>
<PageIndex>1</PageIndex>
</PageInfo>
<RequestID>2PQBZMZTL3DYF</RequestID>
<RequestDate>2/21/2012 15:12:55</RequestDate>
<SettlementSummaryList>
<SettlementSummary>
<SettlementDate>2/21/2012 12:00:00</SettlementDate>
<SettlementDateFrom>8/5/2011 12:00:00</SettlementDateFrom>
<SettlementDateTo>2/21/2012 12:00:00</SettlementDateTo>
<SettlementID>0</SettlementID>
<CheckNumber />
<ItemPrice>71.00</ItemPrice>
<Shipping>31.95</Shipping>
<Other>0.00</Other>
<TotalOrderAmount>102.95</TotalOrderAmount>
<Refunds>-1.98</Refunds>
<ChargeBack>0.00</ChargeBack>
<MiscellaneousAdjustment>-182.53</MiscellaneousAdjustment>
<TotalRefunds>-184.51</TotalRefunds>
<NeweggCommissionFee>-7.71</NeweggCommissionFee>
<NeweggTransactionFee>0.00</NeweggTransactionFee>
<NeweggRefundCommissionFee>0.15</NeweggRefundCommissionFee>
<NeweggMonthlyFee>0.00</NeweggMonthlyFee>
<NeweggStorageFee>-59.05</NeweggStorageFee>
<NeweggRMABuyoutFee>-0.72</NeweggRMABuyoutFee>
<NeweggPremierFee>0.00</NeweggPremierFee>
<NeweggShippingLabelFee>0.00</NeweggShippingLabelFee>
<TotalNeweggFee>-638.63</TotalNeweggFee>
<TotalSettlement>-720.19</TotalSettlement>
<ReservedBalance>12.22</ReservedBalance>
<PreviousReservedBalance>1.22</PreviousReservedBalance>
</SettlementSummary>
</SettlementSummaryList>
</ResponseBody>
<Memo />
</NeweggAPIResponse>
<?xml version="1.0" encoding="utf-8"?>
<NeweggAPIResponse>
<IsSuccess>true</IsSuccess>
<SellerID>BFUS</SellerID>
<OperationType>GetSettlementSummaryInfoResponse</OperationType>
<ResponseBody>
<PageInfo>
<TotalCount>2</TotalCount>
<TotalPageCount>1</TotalPageCount>
<PageIndex>1</PageIndex>
<PageSize>10</PageSize>
</PageInfo>
<RequestID>24L8PVM11WG8S</RequestID>
<RequestDate>04/27/2020 02:49:09</RequestDate>
<SettlementSummaryList>
<SettlementSummary>
<SettlementDate>10/16/2019 00:00:00</SettlementDate>
<SettlementDateFrom>05/14/2012 00:00:00</SettlementDateFrom>
<SettlementDateTo>10/16/2019 00:00:00</SettlementDateTo>
<SettlementID>0</SettlementID>
<CheckNumber></CheckNumber>
<ItemPrice>1256.46</ItemPrice>
<Shipping>611.90</Shipping>
<GSTTotal>41.00</GSTTotal>
<HSTTotal>0.00</HSTTotal>
<PSTTotal>0.00</PSTTotal>
<EHFTotal>0.00</EHFTotal>
<Other>0.00</Other>
<TotalOrderAmount>1909.36</TotalOrderAmount>
<Refunds>-36.50</Refunds>
<ChargeBack>0.00</ChargeBack>
<MiscellaneousAdjustment>-75.67</MiscellaneousAdjustment>
<TotalRefunds>-112.17</TotalRefunds>
<NeweggCommissionFee>-186.85</NeweggCommissionFee>
<NeweggTransactionFee>0.00</NeweggTransactionFee>
<NeweggRefundCommissionFee>3.65</NeweggRefundCommissionFee>
<NeweggMonthlyFee>-19.99</NeweggMonthlyFee>
<NeweggStorageFee>-6.98</NeweggStorageFee>
<NeweggRMABuyoutFee>0.00</NeweggRMABuyoutFee>
<NeweggServiceFeeTax>0.00</NeweggServiceFeeTax>
<TotalNeweggFee>-263.29</TotalNeweggFee>
<TotalSettlement>1533.90</TotalSettlement>
<ReservedBalance>12.22</ReservedBalance>
<PreviousReservedBalance>1.22</PreviousReservedBalance>
</SettlementSummary>
<SettlementSummary>
<SettlementDate>04/22/2020 00:00:00</SettlementDate>
<SettlementDateFrom>11/19/2013 00:00:00</SettlementDateFrom>
<SettlementDateTo>04/22/2020 00:00:00</SettlementDateTo>
<SettlementID>0</SettlementID>
<CheckNumber></CheckNumber>
<ItemPrice>1256.46</ItemPrice>
<Shipping>611.90</Shipping>
<GSTTotal>41.00</GSTTotal>
<HSTTotal>0.00</HSTTotal>
<PSTTotal>0.00</PSTTotal>
<EHFTotal>0.00</EHFTotal>
<Other>0.00</Other>
<TotalOrderAmount>1930.36</TotalOrderAmount>
<Refunds>-36.50</Refunds>
<ChargeBack>0.00</ChargeBack>
<MiscellaneousAdjustment>-75.67</MiscellaneousAdjustment>
<TotalRefunds>-112.17</TotalRefunds>
<NeweggCommissionFee>-186.85</NeweggCommissionFee>
<NeweggTransactionFee>0.00</NeweggTransactionFee>
<NeweggRefundCommissionFee>3.65</NeweggRefundCommissionFee>
<NeweggMonthlyFee>0.00</NeweggMonthlyFee>
<NeweggStorageFee>0.00</NeweggStorageFee>
<NeweggRMABuyoutFee>0.00</NeweggRMABuyoutFee>
<NeweggServiceFeeTax>-2.52</NeweggServiceFeeTax>
<TotalNeweggFee>-200.79</TotalNeweggFee>
<TotalSettlement>1617.40</TotalSettlement>
<ReservedBalance>12.22</ReservedBalance>
<PreviousReservedBalance>1.22</PreviousReservedBalance>
</SettlementSummary>
</SettlementSummaryList>
</ResponseBody>
<Memo></Memo>
</NeweggAPIResponse>
示例: Json, Response
{
"NeweggAPIResponse": {
"IsSuccess": "true",
"SellerID": "A09D",
"OperationType": "GetSettlementSummaryInfoResponse",
"ResponseBody": {
"PageInfo": {
"TotalCount": "1",
"TotalPageCount": "1",
"PageSize": "10",
"PageIndex": "1"
},
"RequestID": "2PQBZMZTL3DYF",
"RequestDate": "2/21/2012 15:12:55",
"SettlementSummaryList": [
{
"SettlementDate": "2/21/2012 12:00:00",
"SettlementDateFrom": "8/5/2011 12:00:00",
"SettlementDateTo": "2/21/2012 12:00:00",
"SettlementID": "0",
"ItemPrice": "71.00",
"Shipping": "31.95",
"Other": "0.00",
"TotalOrderAmount": "102.95",
"Refunds": "-1.98",
"ChargeBack": "0.00",
"MiscellaneousAdjustment": "-182.53",
"TotalRefunds": "-184.51",
"NeweggCommissionFee": "-7.71",
"NeweggTransactionFee": "0.00",
"NeweggRefundCommissionFee": "0.15",
"NeweggMonthlyFee": "0.00",
"NeweggStorageFee": "-59.05",
"NeweggRMABuyoutFee": "-0.72",
"NeweggPremierFee": "0.00",
"NeweggShippingLabelFee": "0.00",
"TotalNeweggFee": "-638.63",
"TotalSettlement": "-720.19",
"ReservedBalance": "12.22",
"PreviousReservedBalance": "1.22"
}
]
}
}
}
{
"IsSuccess": "true",
"SellerID": "BFUS",
"OperationType": "GetSettlementSummaryInfoResponse",
"ResponseBody": {
"PageInfo": {
"TotalCount": "2",
"TotalPageCount": "1",
"PageIndex": "1",
"PageSize": "10"
},
"RequestID": "24L8PVM11WG8S",
"RequestDate": "04/27/2020 02:49:09",
"SettlementSummaryList": [
{
"SettlementDate": "10/16/2019 00:00:00",
"SettlementDateFrom": "05/14/2012 00:00:00",
"SettlementDateTo": "10/16/2019 00:00:00",
"SettlementID": "0",
"CheckNumber": [],
"ItemPrice": "1256.46",
"Shipping": "611.90",
"GSTTotal": "41.00",
"HSTTotal": "0.00",
"PSTTotal": "0.00",
"EHFTotal": "0.00",
"Other": "0.00",
"TotalOrderAmount": "1909.36",
"Refunds": "-36.50",
"ChargeBack": "0.00",
"MiscellaneousAdjustment": "-75.67",
"TotalRefunds": "-112.17",
"NeweggCommissionFee": "-186.85",
"NeweggTransactionFee": "0.00",
"NeweggRefundCommissionFee": "3.65",
"NeweggMonthlyFee": "-19.99",
"NeweggStorageFee": "-6.98",
"NeweggRMABuyoutFee": "0.00",
"NeweggServiceFeeTax": "0.00",
"TotalNeweggFee": "-263.29",
"TotalSettlement": "1533.90",
"ReservedBalance": "12.22",
"PreviousReservedBalance": "1.22"
},
{
"SettlementDate": "04/22/2020 00:00:00",
"SettlementDateFrom": "11/19/2013 00:00:00",
"SettlementDateTo": "04/22/2020 00:00:00",
"SettlementID": "0",
"CheckNumber": [],
"ItemPrice": "1256.46",
"Shipping": "611.90",
"GSTTotal": "41.00",
"HSTTotal": "0.00",
"PSTTotal": "0.00",
"EHFTotal": "0.00",
"Other": "0.00",
"TotalOrderAmount": "1930.36",
"Refunds": "-36.50",
"ChargeBack": "0.00",
"MiscellaneousAdjustment": "-75.67",
"TotalRefunds": "-112.17",
"NeweggCommissionFee": "-186.85",
"NeweggTransactionFee": "0.00",
"NeweggRefundCommissionFee": "3.65",
"NeweggMonthlyFee": "0.00",
"NeweggStorageFee": "0.00",
"NeweggRMABuyoutFee": "0.00",
"NeweggServiceFeeTax": "-2.52",
"TotalNeweggFee": "-200.79",
"TotalSettlement": "1617.40",
"ReservedBalance": "12.22",
"PreviousReservedBalance": "1.22"
}
]
},
"Memo": []
}
請求失敗錯誤資訊
常規HTTP錯誤回應,請參考回覆失敗錯誤代碼清單。
示例: XML, Response
<?xml version="1.0" encoding="utf-8"?>
<Errors>
<Error>
<Code>CE001</Code>
<Message>SellerID cannot be null or empty</Message>
</Error>
</Errors>
示例: Json, Response
[
{
"Code": "CE001",
"Message": "SellerID cannot be null or empty"
}
]
更新日期:09/23/2021