Request a cancellation report

The on-request cancellation report provides details about canceled orders.

Report field descriptions

The CSV report file contains the following fields. The identifiers can be specified by either the seller or Walmart.

FieldDescriptionOrigin
actualDeliveryDateThe date the item was delivered.Walmart
cancelDateThe date the item was canceled.Seller
cancelReasonThe reason the item was canceled.Walmart/Seller
carrierThe shipping carrier used to deliver the order.Seller
catlgItemIdThe unique identifier for the item.Walmart
defectTypeThe type of defect associated with the item. In a cancellation report, this field is always "Cancel."Walmart/Seller
destinationStateThe two-letter state code for the shipping address. For example, VA (Virginia), CA (California), WA (Washington).Walmart
estimatedDeliveryDateThe estimated delivery date of the order.Walmart/Seller
legacySlrIdThe unique identifier for the seller.Walmart
offerConditionCodeThe condition of the item. Refer to the Item conditions table for a list of possible conditions.
offerIdA unique identifier consisting of the SKU and partner ID.Walmart
orderPlacedDtThe date the order was placed.Walmart
poNumThe purchase order number, which represents Walmart placing the order with the seller.Walmart
returnDateThe date the return request was placed.Walmart
returnReasonThe reason for the return.Walmart
salesOrderThe unique customer order number assigned by Walmart.Walmart
trackingNumThe tracking number associated with the order.Seller

Item conditions

The following is a list of item conditions and the corresponding condition codes.

Item conditionCondition code
New1
New without box2
New without tags3
Restored: Premium4
Restored: Like New5
Restored: Good6
Restored: Fair7
Remanufactured8
Open Box9
Pre-Owned: Like New10
Pre-Owned: Good11
Pre-Owned: Fair12
New with defects13