While importing the returns, you need to upload the return details via a CSV file. Your return import will if provide improper return details. This article will help you understand each field in the return import template so that you can easily create returns in Eshopbox.
Understanding return import CSV
Below are the field and field descriptions that will help you to create returns:
Portal: The portal on which your customer has placed the order. This is a predefined value and a mandatory field.
Order ID: A unique identification number assigned by the sales channel for each order placed by the customer. Customers initiate the return request against this order ID. This is a mandatory field. For example 171-6316191-5801930, 300924696, 4050321458, and more.
SKU (Stock Keeping Unit): 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. For example, BBSHOCL138137_4, BBSHOCL138091_5, 8776699978, and more.
Return tracking ID: The tracking ID assigned to the return shipment by the courier company. This is used to track returns as they are being returned to Eshopbox fulfilment centres. 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.
Sales channel: The sales channel name on which the return request was initiated. For example, FLIPKART_PATLI, FLIPKART_GGN, and more.
Quantity: This is the number of items for which your customer has initiated the return request. For example 3, 4, 7, and more.
Reason: This specifies the reason for the return (within 100 characters). For example size mismatch, failed delivery, order cancelled, and more.
Invoice number: This is the invoice number generated when the return is created. For example 65758393, 73827464 and more.
Delivery status as per channel: This is the delivery status of the returned item updated by the sales channel. This is a predefined value.
Delivery date as per channel: This is the courier company's estimated date of delivery of the returned items at the Eshopbox fulfilment centre. Enter the date in the required format yyyy-mm-dd.
Delivery location: This is the location of the Eshopbox fulfilment centre where the return is being delivered. This is a predefined value.
Shipping provider: The courier company that will deliver the return back to the Eshopbox fulfilment center. For example, Delivery, Ecomexpress, Xpressbees, and more.
Expected arrival by: The date on which the return is expected to arrive at the Eshopbox fulfilment centre. Enter the date in the required format yyyy-mm-dd.
Cut off date: The last date for receiving the return. Enter the cut off date in the required format yyyy-mm-dd. If the cut-off date expires, a claim-filing report will be generated for you to file for claims.
You will only be able to select the pre-defined values for some fields in the return import template. Choose the predefined value based on your requirement:
Customer Initiated Return (CIR): When the return request is initiated by the customer.
Failed Delivery Return (FDR): When the courier partner fails to deliver the order and it is returned to the fulfilment centre. This is also known as Return to Origin (RTO).
Unknown Return (UR): Return reason is unknown.