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)
1: Order
2: Refund
3: CreditRequest
4: Chargeback
5: MonthlyFee
6: FulfillByNeweggFee
7: Multi-ChannelFee
8: RMAProcessingFee
9: Tax & Duty
10: StorageFee
11: RMABuyoutFee
12: AdjustmentFee
13: MonthlyFeeByCC
14: SBNInboundFee
15: MerchandisingFee
16: NeweggPremierFee
17: NeweggShippingLabelFee
18: ReturnAndDisposalFee
19: NeweggRelabelingFee
20: Recycling Fee / EHF
21: Return Shipping Label Fee
22: Newegg Service Fee Tax (Newegg.ca only)
23: Print Shipping Label Service
24: Reserved Balance
25: Previous Reserved Balance
26: Commission Incentive Refund
27: Unsold Listing Fee
28: Order Processing Fee
29: Sales Tax/Fees
30: SBN Inbound Incompliance Charges
31: Sponsored Ads

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
False: Not 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