While importing the returns, you need to upload the return details via a CSV file. If your return import will provide improper return details or if the file does not contain the proper information, you will need to fix it and re-upload the corrected return before submitting.
In this article, you will learn about each field in the return import template.
Below are the field and field descriptions that will help you to create returns:
Order ID: A unique identification number assigned to each order. For example, 171-6316191-5801930.
SKU: A unique name for your product that helps in easy identification. Customers initiate a return request for some or all SKUs in an order. This is a mandatory field.
Note: If a return contains multiple SKUs, each SKU should be added as a separate row with the same order ID and tracking ID but a different SKU ID.
Return tracking ID: The tracking ID assigned to the return shipment by the courier partner. The return tracking ID should be physically available on the shipment. This is a mandatory field.
Return type: This is the type of returns received. You can only use pre-defined values for this field. This is a mandatory field.
Note: Courier-initiated returns can only be created for all items sent in the shipment. If you mention items other than those present in the shipment, an error will be received.
Sales channel: This is optional, it is required if the mentioned order ID belongs to multiple sales channels. In this case, you need to provide the particular sales channel associated with the order against which you wish to create the return. You can locate the relevant sales channel on the 'All Orders' page under the respective order item you wish to return. For example, FLIPKART_PATLI, FLIPKART_GGN, and more.
Quantity: This is the number of items for which your customer has initiated the return request. If the quantity is not mentioned, then it will be considered as 1.
Reason: Mention the reason for the return (within 100 characters). For example, size mismatch, failed delivery, order cancellation, etc.
You will only be able to select the predefined values for some fields in the return import template. You need to mention the predefined value for the Return type as below.
Value | Description |
CIR | When the return request is initiated by the customer. |
FDR | When the courier partner fails to deliver the order, it is returned to the fulfilment centre. This is also known as Return to Origin (RTO). |
UR | Unknown returns whose reason for the return is not known. |