Delivery Status
Share the order history (pre-Magic Checkout) and monthly delivery status for Razorpay Magic Checkout orders to improve intelligence and RTO protection.
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:
- for Magic Checkout orders.
- .
- Reduce the RTO rate in the long run.
- Get improved COD intelligence from day 1.
- Better RTO protection.
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
, , , and , you must manually upload the data.-
Log in to the
and navigate to Magic Checkout → Setup & Settings → Platform Setup. -
Select the platform of your e-commerce website, enter the relevant details and click Next.
-
Navigate to RTO Reduction Setup → Delivery Data Upload.
-
In the RTO Reduction Setup section, navigate to the Delivery Data Upload tab.
-
Click + Upload Delivery Statuses.
-
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
.csvor an.xlsxfile. - The maximum size of the file is 50MB.
- The number of rows in the file should not exceed 1 million.
Here is a glimpse of the sample file:
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:
- Log in to the and navigate to Orders.
- Under All, select Custom and filter the data for the last 6 months. Click Apply.
- Click the download icon.
.
- Your report is sent to your email id or you can also download it from the Reports Panel.
Follow the steps given below:
- Log in to the and click Go to Dashboard.
- Click APPLY FILTER.
- Click Custom Date Range and select the Start Date and the End Date. Click Apply Filter.
- Click Download.
Follow the steps given below:
- Log in to the .
- Navigate to Reports → Advanced Report.
- Select Download By Data Range.
- Select upload dates.
- Select the File Type as MIS.
- Select the Status as All from the drop-down list.
- Enter your Email Address and click Download. The report download link is sent to your email ID.
To upload order history:
-
Log in to the
and navigate to Magic Checkout → Setup & Settings → Platform Setup. -
Select the platform of your e-commerce website, enter the relevant details and click Next.
-
In the RTO Reduction Setup section, navigate to the RTO History tab.
-
Click + Upload Order History.
-
Select the Shipping Provider from the drop-down list.
-
Upload the order history file you downloaded in the
.Watch Out!
- Upload a
.csvfile. 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.
- Upload a
-
Click Confirm.
Was this page helpful?