Submit Settlement Transaction Report
Request detailed breakdown of transactions during a given settlement period.
Resource URL
Newegg.com: https://api.newegg.com/marketplace/reportmgmt/report/submitrequest?sellerid={sellerid} Neweggbusiness.com: https://api.newegg.com/marketplace/b2b/reportmgmt/report/submitrequest?sellerid={sellerid} Newegg.ca: https://api.newegg.com/marketplace/can/reportmgmt/report/submitrequest?sellerid={sellerid}
Note: Please make sure your request URL is all in lower case (except for Seller ID) and cannot contain any blank spaces or line breaks.
Parameters
Name | Required? | Description |
sellerid | Yes | Your seller ID on Newegg Marketplace |
Resource Information
HTTP Method | Authentication? | Request Formats | Response Formats | Rate Limited? |
POST | Required | XML, Json | XML, Json | 100 request per hour |
Request Body
Attribute | Required? | Format | Description |
IssueUser | No | String | Issuer’s registered Seller Portal email address. System will only accept Seller’s registered Seller Portal email addresses. If left blank, default value will be Seller ID. |
OperationType | Yes | String | Fixed value: SettlementTransactionReportRequest |
RequestType | Yes | String | Fixed value: SETTLEMENT_TRANSACTION_REPORT |
OrderNumber | No | Integer | Newegg’s assigned number for orders |
TransactionType | No | Integer | Available values:
0: All (Default) |
SettlementDateFrom | No | String | Search by Settlement Date Range (Pacific Standard Time)
Please refer to the Acceptable Date Format |
SettlementDateTo | No | String | Search by Settlement Date Range (Pacific Standard Time)
Please refer to the Acceptable Date Format |
SettlementDate | No | String | Search by Settlement Date (Pacific Standard Time)
Please refer to the Acceptable Date Format |
SettlementID | No | Integer | Newegg’s assigned transaction ID for settlement |
Schema: SettlementTransactionRequest.xsd
Example: XML, Request
POST https://api.newegg.com/marketplace/reportmgmt/report/submitrequest?sellerid={sellerid} Authorization: 720ddc067f4d115bd544aff46bc75634 SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D Content-Type: application/xml Accept: application/xml <NeweggAPIRequest> <OperationType>SettlementTransactionReportRequest</OperationType> <RequestBody> <SettlementTransactionReportCriteria> <RequestType>SETTLEMENT_TRANSACTION_REPORT</RequestType> <TransactionType>1</TransactionType> <SettlementDateFrom>2011-02-21</SettlementDateFrom> <SettlementDateTo>2012-02-22</SettlementDateTo> <SettlementDate>2/23/2012</SettlementDate> </SettlementTransactionReportCriteria> </RequestBody> </NeweggAPIRequest>
Example: Json, Request
POST https://api.newegg.com/marketplace/reportmgmt/report/submitrequest?sellerid={sellerid} Authorization: 720ddc067f4d115bd544aff46bc75634 SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D Content-Type: application/json Accept: application/json { "OperationType": "SettlementTransactionReportRequest", "RequestBody": { "SettlementTransactionReportCriteria": { "RequestType": "SETTLEMENT_TRANSACTION_REPORT", "TransactionType": "1", "SettlementDateFrom": "2011-02-21", "SettlementDateTo": "2012-02-22", "SettlementDate": "2/23/2012" } } }
Response Body
Attribute | Format | Description |
IsSuccess | String | Get feed status operation:
True: Successful |
OperationType | String | Fixed value: SettlementTransactionReportResponse |
SellerID | String | Your seller ID |
RequestId | String | Newegg’s assigned ID for submitted request |
RequestType | String | Fixed value: SETTLEMENT_TRANSACTION_REPORT |
RequestDate | String | The date when the feed was submitted (Pacific Standard Time) |
RequestSatus | String | Status of the submission:
SUBMITTED (Default) |
Memo | String | Additional information |
Schema: SubmitReportResponse.xsd
Example: XML, Response
<NeweggAPIResponse> <IsSuccess>true</IsSuccess> <OperationType>SettlementTransactionReportResponse</OperationType> <SellerID>a001</SellerID> <ResponseBody> <ResponseList> <ResponseInfo> <RequestId>270Z8Y3SYIGQV</RequestId> <RequestType>SETTLEMENT_TRANSACTION_REPORT</RequestType> <RequestDate>07/12/2014 11:02:35</RequestDate> <RequestStatus>SUBMITTED</RequestStatus> </ResponseInfo> </ResponseList> </ResponseBody> </NeweggAPIResponse>
Example: Json, Response
{ "IsSuccess": true, "OperationType": "SettlementTransactionReportResponse", "SellerID": "a001", "ResponseBody": { "ResponseList": [ { "RequestId": "270Z8Y3SYIGQV", "RequestType": "SETTLEMENT_TRANSACTION_REPORT", "RequestDate": "07/12/2014 11:34:57", "RequestStatus": "SUBMITTED" } ] } }
Request Failure Errors
For common HTTP error responses, please refer to Failed Response Error Code List.
Error Code | Description |
RP010 | Invalid Order Number. |
RP018 | Invalid Settlement Date. |
RP019 | The requestID cannot be null or empty. |
RP020 | We are unable to process your request because one of the following search criteria is required: SettlementID, SettlementDate, or SettlementDateFrom and SettlementDateTo. |
RP021 | Maximum item lookup cannot exceed 1000 for each request. |
RP022 | Daily Inventory Report does not support multiple warehouse locations. For multiple warehouse locations, please use International Program – Daily Inventory Report. |
Example: XML, Response
<?xml version="1.0" encoding="utf-8"?> <Errors> <Error> <Code>RP018</Code> <Message>Invalid Settlement Date</Message> </Error> </Errors>
Example: Json, Response
[ { "Code": "RP018", "Message": "Invalid Settlement Date" } ]
Last updated: December 1, 2020