• Login to Assure and click on CIMS. 



  • In CIMS, click on “Return Order Upload” 


  • Select Client, Channel and Location from Dropdown
  • Download the template and populate the details as per the format
  • Upload the CSV by clicking Submit button




MarketplacechannelOrderId
channelSubOrderId
channelReturnOrderId

productId
returnOrderType

transporter
trackingId
reasonForReturn
price
quantity

CHANNEL_ORDER_ID
CHANNEL_SUB_ORDER_ID
CHANNEL_RETURN_ORDER_ID
CHANNEL_SKU_ID
CUSTOMER_RETURNTRANSPORTER_NAME
AWB_No.
RETURN_REASON
PRICE
QUANTITY
FlipkartAssure Channel Order IDOrder Item ID
Return ID
Channel_SKU_IDCustomer_Return/RTOVendor NameTracking IDReturn ReasonTotal PriceQuantity
Amazon EDIAssure Channel Order IDOrder idChannel Order ID + FNSKU +Day-MonthFNSKUCustomer_Return/RTO
AmazonTracking IDReturn Reason
Selling PriceQuantity
MyntraPPMPOrder IDOrder IDChannel Return Id
Channel_SKU_IDCustomer_Return/RTO
Transporter NameChannel Return Id
Return ReasonSelling Price1
Tata CliqOrder IDTransaction ID
Transaction ID
Channel_SKU_ID
Customer_Return/RTO
Return Delivered by LPAWBReturn ReasonForward Order PriceQuantity
PaytmOrder IDItem IDIDChannel_SKU_ID
Customer_Return/RTO
Shipper NameTracking IDReject ReasonPrice1
Nykaa/Nykaa FashionOrder NumberOrder IDOrder NumberChannel_SKU_ID
Customer_Return/RTO
TransporterAWB NumberReturn ReasonForward Order PriceQuantity
SnapdealAssure Channel Order ID
Sub Order IDSub Order IDChannel_SKU_ID
Customer_Return/RTO
SnapdealTracking NumberReturn Reason
Selling Price1


Note

  • Product ID will be Channel SKU ID of respective channels, which are uploaded in Listing.
  • Return Order Type will be Customer_Return or RTO
  • The details mentioned in above image, are available in return report of respective channels with same header.
  • System doesn't allow to upload more 5000 rows in CSV at a time 



Once the return order is created in the system, it can be processed in WMS. 

Please click on Channel wise Return Order Processing link which will guide you on how to process the return order Channel wise in the Warehouse.