Skip to main content
Available in🇮🇳 India
You can share your historical order data (pre-Magic Checkout) and delivery status with Razorpay Magic Checkout for improved COD intelligence and better RTO protection. You must upload the following:

​
Advantages

  • Reduce the RTO rate in the long run.
  • Get improved COD intelligence from day 1.
  • Better RTO protection.

​
Monthly Delivery Data

You can share the monthly delivery status data for Magic Checkout orders to be eligible for RTO protection and get improved COD intelligence. If you have not integrated with logistics partners like Shiprocket, Delhivery, iThink Logistics, Unicommerce and ClickPost, you must manually upload the data.
  1. Log in to the Dashboard and navigate to Magic Checkout.
  2. Select the platform of your e-commerce website, enter the relevant details and click Next.
  3. Navigate to RTO Reduction Setup → Delivery Data Upload.
  4. In the RTO Reduction Setup section, navigate to the Delivery Data Upload tab.
  5. Click + Upload Delivery Statuses. Monthly delivery data on the Razorpay Dashboard and upload the file
  6. Download the sample file for the template. Enter the Order id, Status, Shipping Charges, AWB number and Shipping Provider to claim RTO Insurance. Upload the file.
Watch Out!
  • Shipping provider and AWB number fields are mandatory.
  • Merchant_order_id should contain your platform order id as mentioned in the order. For example, #BCA1011.
  • The status should contain the shipping status against the order. For example, RTO, Delivered, Cancelled and so on.
  • Upload a .csv or an .xlsx file.
  • The maximum size of the file is 50MB.
  • The number of rows in the file should not exceed 1 million.
download the sample file and enter the details requiredHere is a glimpse of the sample file:

​
Pre-Magic Delivery Data

You can share your shipping provider’s pre-Magic Checkout order history on Razorpay Magic Checkout for the last 6 months to get improved COD intelligence and better RTO protection. Follow the steps given below to share the order history:
We recommend that you upload the data for the last 6 months. Currently, Magic Checkout supports order history upload for:
Follow the steps given below:
  1. Log in to the Shiprocket Dashboard and navigate to Orders. Navigate to orders on the Shiprocket Dashboard
  2. Under All, select Custom and filter the data for the last 6 months. Click Apply. Filter the data for the last 6 months
  3. Click the download icon. Download the data filtered.
  4. Your report is sent to your email id or you can also download it from the Reports Panel.
Follow the steps given below:
  1. Log in to the Delhivery Dashboard and click Go to Dashboard. Navigate to the Delhivery Dashboard
  2. Click APPLY FILTER.
  3. Click Custom Date Range and select the Start Date and the End Date. Click Apply Filter. Filter the data for the last 6 months
  4. Click Download. Download the data filtered
Follow the steps given below:
  1. Log in to the Pickrr Dashboard.
  2. Navigate to Reports → Advanced Report. Navigate to Advanced Reports on the Pickr Dashboard
  3. Select Download By Data Range.
  4. Select upload dates.
  5. Select the File Type as MIS.
  6. Select the Status as All from the drop-down list.
  7. Enter your Email Address and click Download. The report download link is sent to your email ID. Download the data filtered
To upload order history:
  1. Log in to the Razorpay Dashboard and navigate to Magic Checkout.
  2. Select the platform of your e-commerce website, enter the relevant details and click Next.
  3. In the RTO Reduction Setup section, navigate to the RTO History tab.
  4. Click + Upload Order History. Upload order history on the Razorpay Dashboard
  5. Select the Shipping Provider from the drop-down list.
  6. Upload the order history file you downloaded in the previous step.
Watch Out!
  • Upload a .csv file. Only one file upload is allowed.
  • The maximum size of the file is 50MB.
  • If you use multiple shipping providers, please upload the file from your most frequently used provider.
  1. Click Confirm. Upload the order history file