Get RMA List Report

Get a list of returns, replacements, and refunds from seller’s account.

Resource URL

Newegg.com: https://api.newegg.com/marketplace/reportmgmt/report/result?sellerid={sellerid}&version={version}
Neweggbusiness.com: https://api.newegg.com/marketplace/b2b/reportmgmt/report/result?sellerid={sellerid}&version={version}
Newegg.ca: https://api.newegg.com/marketplace/can/reportmgmt/report/result?sellerid={sellerid}&version={version}

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
version Yes Available versions:

Version Available Platform Impact
305 Neweggbusiness.com, Newegg.ca Response includes the Seller Order Number assigned by seller when using for SBN to fulfill multi-channel orders.
306 Newegg.com Response includes the Seller Order Number assigned by seller when using for SBN to fulfill multi-channel orders.
307 Newegg.com Response includes SalesTax amount for U.S., VAT and Duty amount for Newegg Global.
309 All Response includes the replacement order #s for related RMAs.

Resource Information

HTTP Method Authentication? Request Formats Response Formats Rate Limited?
PUT Required XML, Json XML, Json 500 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 values: RMAListReportRequest
RequestID Yes String Newegg’s assigned ID for submitted request
PageIndex Yes Integer Current page index
PageSize Yes Integer Return records count in one page

Max is 100 per page

Schema: GetReportRequest.xsd

Example: XML, Request

PUT https://api.newegg.com/marketplace/reportmgmt/report/result?sellerid={sellerid}&version={version}
Authorization: 720ddc067f4d115bd544aff46bc75634
SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D
Content-Type: application/xml
Accept: application/xml

<NeweggAPIRequest >
    <OperationType>RMAListReportRequest</OperationType>
    <RequestBody>
        <RequestID>2PQBYWH4V68ZP</RequestID>
        <PageInfo>
            <PageIndex>1</PageIndex>
            <PageSize>10</PageSize>
        </PageInfo>
    </RequestBody>
</NeweggAPIRequest>

Example: Json, Request

PUT https://api.newegg.com/marketplace/reportmgmt/report/result?sellerid={sellerid}&version={version}
Authorization: 720ddc067f4d115bd544aff46bc75634
SecretKey: 21EC2020-3AEA-1069-A2DD-08002B30309D
Content-Type: application/json
Accept: application/json

{
    "OperationType": "RMAListReportRequest",
    "RequestBody": {
        "RequestID": "2PQBYWH4V68ZP",
        "PageInfo": {
            "PageSize": "10",
            "PageIndex": "1"
        }
    }
}

Response Body

Attribute Format Description
IsSuccess String Get feed status operation:

True: Successful
False: Not successful

SellerID String Your seller ID
OperationType String Fixed value: GetRMAListInfoResponse
RequestID String Newegg’s assigned ID for submitted request
RequestDate String Your request date time (Pacific Standard Time)
TotalCount Integer Total number of records
TotalPageCount Integer Total page count
PageIndex Integer Current page index
PageSize Integer How many records in a page
SellerID String Your seller ID
RMANumber Integer Newgg’s assigned number for RMA
RMAType Integer Available values:

1:Replacement
2:Refund

RMATypeDescription String Available values:

Replacement:RMAType value 1
Refund:RMAType value 2

SellerRMANumber String Seller’s user defined RMA number

  • An alphanumeric string, max 50 characters
  • Available for version: 309
ReplacementOrderNumber String The Order Number of the replacement order. After confirming the return item is received, Newegg will create a replacement order for you to process.

Note: Available for RMA type: Replacement (RMAType value= 1) and the request version=309

RMADate String Date of RMA (Pacific Standard Time)
RMAStatus Integer Available values:

1: Open
2: Received
3: Rejected
4: Voided
5: Closed
6: Processing

RMAStatusDescription String Available values:

Open: If RMAStatus value = 1
Received: If RMAStatus value = 2
Rejected: If RMAStatus value = 3
Voided: If RMAStatus value = 4
Closed: If RMAStatus value = 5
Processing: If RMAStatus value = 6

LastEditDate String Last edit date (Pacific Standard Time)
LastEditUser String Las edit user
OrderNumber Integer Order Number of the RMA requested order
OrderDate String Order Date (Pacific Standard Time)
InvoiceNumber Integer Invoice Number of the order RMA requested order
OrderAmount Decimal Order Amount

  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)
RMAProcessedBy String Available values: “Newegg” or “Seller”
CustomerName String Customer Name
CustomerPhoneNumber String Customer Phone Number
CustomerAddress String Customer Address
RMAReceiveDate String RMA shipment received date (Pacific Standard Time)
RMANote String Comment in this RMA if any noted
RefundGSTorHSTAmount The refund GST or HST tax amount of this RMA

Not available for Newegg.com and Neweggbusiness.com

RefundPSTorQSTAmount The refund PST or QST amount of this RMA

Not available for Newegg.com and Neweggbusiness.com

SellerPartNumber String The seller part number to identify seller’s item
MfrPartNumber String Manufacturer Part Number assigned to item
NeweggItemNumber String Newegg’s assigned number to item
Description String The item’s website short title
UnitPrice Decimal The item’s selling price

  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)
ItemReturnQty Integer The return quantity of each SKU in this RMA
ItemRefundPerQty Integer Refund per qty of the item
ItemShippingRefund Decimal The shipping amount of refund of each SKU in this RMA
RMATotalRefund Decimal RMA total Refund
RefundReason Integer The refund reason of each item’s in RMA

Available values:

1: Carrier damage
2: Defective
3: Incompatible
4: No longer needed
5: Not match what we show
6: Ordered wrong item
7: Sent wrong item
8: Unsatisfied
9: Personal Reason | Other Reason

RMAReasonDescription String The replacement/refund reason of each item’s in RMA

Available values:

Carrier damage: If RMAReason value = 1
Defective: If RMAReason value = 2
Incompatible: If RMAReason value = 3
No longer needed: If RMAReason value = 4
Not match what we show: If RMAReason value = 5
Ordered wrong item: If RMAReason value = 6
Sent wrong item: If RMAReason value = 7
Unsatisfied: If RMAReason value = 8
Personal Reason | Other Reason: If RMAReason value = 9

ShippedBy Integer If RMA type = Replacement, available values to indicate who will ship replacement:

0: SBS (Shipped by Seller)
1: SBN (Shipped by Newegg)

RMAShipMethod Integer The ship method if the RMA type = Replacement:

1: Super Saver(7-14 business days)
2: Standard Shipping(5-7 business days)
3: Expedited Shipping(3-5 business days)
4: Two-Day Shipping(2 business days)
5: One-Day Shipping(Next day)
6: International Economy Shipping(8-15 business days)
7: International Standard Shipping(5-7 business days)
8: International Expedited Shipping(3-5 business days)
9: International Two-Day Shipping(2 business days)
10: APO/FPO – Military ONLY
11: Newegg Premier 3 Days
12: Newegg Premier 2 Days
13: Newegg Premier Next Day

If RMA type = Refund, this element will be blank.

RMAShipMethodDescription String The ship method if the RMA type = Replacement:

Super Saver(7-14 business days): If RMAShipMethod value = 1
Standard Shipping(5-7 business days): If RMAShipMethod value = 2
Expedited Shipping(3-5 business days): If RMAShipMethod value = 3
Two-Day Shipping(2 business days): If RMAShipMethod value = 4
One-Day Shipping(Next day): If RMAShipMethod value = 5
International Economy Shipping(8-15 business days): If RMAShipMethod value = 6
International Standard Shipping(5-7 business days): If RMAShipMethod value = 7
International Expedited Shipping (3-5 business days): If RMAShipMethod value = 8
International Two-Day Shipping(2 business days): If RMAShipMethod value = 9
APO/FPO – Military: If RMAShipMethod value = 10
Newegg Premier 3 Days: If RMAShipMethod value = 11
Newegg Premier 2 Days: If RMAShipMethod value = 12
Newegg Premier Next Day: If RMAShipMethod value = 13

If RMA type = Refund, this element will be blank.

ReplacementReason Integer The replacement reason of each item’s in RMA

Available values:

1: Carrier damage
2: Defective
3: Incompatible
4: No longer needed
5: Not match what we show
6: Ordered wrong item
7: Sent wrong item
8: Unsatisfied
9: Personal Reason | Other Reason

AvailableRefundAmount Decimal Available Refund Amount

  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)
PriorRefundAmount Decimal Previous Refund Amount if any

  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)
CustomerEmailAddress String Newegg’s masked customer email address, you can reach to the customer through this email address.

For example: gdv6l0viwo4l7j1d@marketplace.newegg.com

ShipToAddress1 String The order’s ship to address 1
ShipToAddress2 String The order’s ship to address 2
ShipToCityName String The order’s ship to city name
ShipToStateCode String The order’s ship to state code
ShipToZipCode String The order’s ship to zip code
ShipToCountryCode String The order’s ship to country code
ShipToLastName String The order’s ship to last name
ShipToFirstName String The order’s ship to first name
ShipToCompany String The order’s ship to company
ReturnQuantity Integer The return quantity of each item in RMA
ReturnUnitPrice Decimal If RMA type = Refund:

  • The return unit price of each item in refund RMA. How much refund will be issued per unit of this item
  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)

If RMA type = replacement, this element will be blank

RefundShippingPrice Decimal If RMA type = Refund:

  • The shipping amount of refund of each item in this RMA
  • Newegg.com and Newggbusiness.com, all amounts are set in U.S. Dollars (USD)
  • Newegg.ca, all amounts are set in Can Dollars (CAD)

If RMA type = replacement, this element will be blank

Memo String Additional notes
ResponseDate String Response date (Pacific Standard Time)

Schema: OrderListResponse.xsd

Example: XML, Response

<?xml version="1.0" encoding="utf-8"?>
<NeweggAPIResponse>
    <IsSuccess>true</IsSuccess>
    <SellerID>V006</SellerID>
    <OperationType>GetOrderInfoResponse</OperationType>
    <ResponseBody>
        <PageInfo>
            <TotalCount>20</TotalCount>
            <TotalPageCount>20</TotalPageCount>
            <PageSize>10</PageSize>
            <PageIndex>1</PageIndex>
        </PageInfo>
        <RequestID>2PQBYWH4V68ZP</RequestID>
        <RequestDate>2/21/2012 14:38:17</RequestDate>
        <OrderInfoList>
            <OrderInfo>
                <SellerID>V006</SellerID>
                <OrderNumber>155738158</OrderNumber>
                <SellerOrderNumber>2153930</SellerOrderNumber>
                <InvoiceNumber>0</InvoiceNumber>
                <OrderDownloaded>false</OrderDownloaded>
                <OrderDate>12/21/2011 1:47:24</OrderDate>
                <OrderStatus>4</OrderStatus>
                <OrderStatusDescription>Voided</OrderStatusDescription>
                <CustomerName>Richard Chen</CustomerName>
                <CustomerPhoneNumber>626-277-1420</CustomerPhoneNumber>
                <CustomerEmailAddress>cq3fw1aierwat94fm@marketplace.newegg.com</CustomerEmailAddress>
                <ShipToAddress1>17708 Rowland St</ShipToAddress1>
                <ShipToAddress2 />
                <ShipToCityName>Rowland Heights</ShipToCityName>
                <ShipToStateCode>DC</ShipToStateCode>
                <ShipToZipCode>20001</ShipToZipCode>
                <ShipToCountryCode>USA</ShipToCountryCode>
                <ShipService>Media Mail (7-14 business days)</ShipService>
                <ShipToFirstName>Richard</ShipToFirstName>
                <ShipToLastName>Chen</ShipToLastName>
                <ShipToCompany />
                <OrderItemAmount>0.00</OrderItemAmount>
                <ShippingAmount>3.00</ShippingAmount>
                <DiscountAmount>-5.00</DiscountAmount>
                <RefundAmount>0.00</RefundAmount>
                <OrderTotalAmount>8.00</OrderTotalAmount>
                <OrderQty>1</OrderQty>
                <IsAutoVoid>false</IsAutoVoid>
                <SalesChannel>0</SalesChannel>
                <FulfillmentOption>1</FulfillmentOption>
                <ItemInfoList>
                    <ItemInfo>
                        <SellerPartNumber>Mike_A006_101478-151</SellerPartNumber>
                        <NeweggItemNumber>9SIA00607Y6664</NeweggItemNumber>
                        <MfrPartNumber>Mike_A006_10114-151</MfrPartNumber>
                        <UPCCode>410997000004</UPCCode>
                        <Description>Tungsten Ladies' Dome Ring w/ CZ</Description>
                        <OrderedQty>1</OrderedQty>
                        <ShippedQty>0</ShippedQty>
                        <UnitPrice>5.00</UnitPrice>
                        <ExtendUnitPrice>1.03</ExtendUnitPrice>
                        <UnitShippingCharge>1.03</UnitShippingCharge>
                        <ExtendShippingCharge>1.03</ExtendShippingCharge>
                        <Status>3</Status>
                        <StatusDescription>Canceled</StatusDescription>
                    </ItemInfo>
                </ItemInfoList>
            </OrderInfo>
        </OrderInfoList>
    </ResponseBody>
    <Memo />
</NeweggAPIResponse>

Example: Json, Request

{
    "NeweggAPIResponse": {
        "IsSuccess": "true",
        "SellerID": "V006",
        "OperationType": "GetOrderInfoResponse",
        "ResponseBody": {
            "PageInfo": {
                "TotalCount": "20",
                "TotalPageCount": "20",
                "PageSize": "10",
                "PageIndex": "1"
            },
            "RequestID": "2PQBYWH4V68ZP",
            "RequestDate": "2/21/2012 14:38:17",
            "OrderInfoList": {
                "OrderInfo": {
                    "SellerID": "V006",
                    "OrderNumber": "155738158",
                    "SellerOrderNumber": "2153930",
                    "InvoiceNumber": "0",
                    "OrderDownloaded": "false",
                    "OrderDate": "12/21/2011 1:47:24",
                    "OrderStatus": "4",
                    "OrderStatusDescription": "Voided",
                    "CustomerName": "Richard Chen",
                    "CustomerPhoneNumber": "626-277-1420",
                    "ShipToAddress1": "17708 Rowland St",
                    "ShipToAddress2": null,
                    "ShipToCityName": "Rowland Heights",
                    "ShipToStateCode": "DC",
                    "ShipToZipCode": "20001",
                    "ShipToCountryCode": "USA",
                    "ShipService": "Media Mail (7-14 business days)",
                    "ShipToFirstName": "Richard",
                    "ShipToLastName": "Chen",
                    "ShipToCompany": null,
                    "OrderItemAmount": "0.00",
                    "ShippingAmount": "3.00",
                    "DiscountAmount": "-5.00",
                    "RefundAmount": "0.00",
                    "OrderTotalAmount": "8.00",
                    "OrderQty": "1",
                    "IsAutoVoid": "false",
                    "SalesChannel": 0,
                    "FulfillmentOption": 1,
                    "ItemInfoList": {
                        "ItemInfo": {
                            "SellerPartNumber": "Mike_A006_101478-151",
                            "NeweggItemNumber": "9SIA00607Y6664",
                            "MfrPartNumber": "Mike_A006_10114-151",
                            "UPCCode": "410997000004",
                            "Description": "Tungsten Ladies' Dome Ring w/ CZ",
                            "OrderedQty": "1",
                            "ShippedQty": "0",
                            "UnitPrice": "5.00",
                            "ExtendUnitPrice": "1.03",
                            "UnitShippingCharge": "1.03",
                            "ExtendShippingCharge": "1.03",
                            "Status": "3",
                            "StatusDescription": "Canceled"
                        }
                    },
                    "PackageInfoList": null
                }
            }
        },
        "Memo": null
    }
}

Request Failure Errors

For common HTTP error responses, please refer to Failed Response Error Code List.

Example: XML, Response

<?xml version="1.0" encoding="utf-8"?>
<Errors>
    <Error>
        <Code>CE001</Code>
        <Message>SellerID cannot be null or empty</Message>
    </Error>
</Errors>

Example: Json, Response

{
    "Code": "CE001",
    "Message": "SellerID cannot be null or empty"
}

Last updated: October 15, 2018