There are two types of Order return :

  1. Delivered Return or Customer Return: Orders which are delivered to the customer but then customer created a return of all items or a few items due to reason like Size not correct, Doesn't like the product.
  2. Return to Origin (RTO Return): Orders which are not being delivered to customer after being shipped from the warehouse due to reason like Invalid Address, Customer Cancelled at Doorstep, or Customer not found.


In e-Retail Express, User can manage both types of Returns. Let's go one by one on how to create returns manually via import.



Import: Click on Import and Download the template. An excel template will get downloaded. 






Template consists of fields like Return Type, Channel Code, Order no/Invoice No/awb No, eRetail SKU Code, Qty, Return BIN and Remarks

Note:

  • Return Type and Channel are Mandatory.
  • Orderno, Invoice No and Awb No - Any one of the following is Mandatory.
  • If return type is Delivered Return, then SKU And QTY is Mandatory else not.
  • BIN is by default Good if it is not mentioned.
     

The Bulk Order Return template gives five different criteria’s to create an order return :


  • Return Type: The drop down contains the type of return - Delivered or RTO.
  • Channel: Channel Code can be found under My App. Each channel consist of channel code, which can be seen in Channel Name as M00, M01 and M02 etc.
  • Order no/Invoice No/AWB no: Mention the order no for which you want to create an return. (in case of one order has muliple Delivery or invoice, Enter the Invoice no or AWB number.
  • SKU: Enter the Master SKU code.
  • Quantity: Enter the quantity of that returned product or SKU.
  • Return BIN: Enter the BIN code where SKU is being PUT. (If you are using default BINs, then It will automatically, take the GOOD BIN.
  • Remarks: Add remarks if any.


After filling all the details, user can save the template on desktop/laptop. To import the duly filled excel sheet, select the file location under ‘Upload Template’ option. Click on Import. An import batch number will get generated corresponding to this import.