Importing AJIO returns

You need to create returns for AJIO so that Eshopbox can identify the returns that are expected at Eshopbox fulfillment centers.

In this article, you will learn:

How to get return information from AJIO?
How to download the Eshopbox return template?
How to convert AJIO return information to the Eshopbox return template?

Follow the below steps to create AJIO returns in Eshopbox:

Step 1: Get return information from AJIO

You will get your AJIO return information from your AJIO seller central account. Follow the below steps to download the returns details:

Navigate to Ajio Seller Central.
Provide the credentials and click on the Sign-in button.
From the side menu bar of Ajio, navigate to Reporting.
Select View Reports from the dropdown.

Apply the filters. Select report type as Return Report and select your place of business.
Select the appropriate date range.
Click on the View button.

You will be able to view your reports in the Return reports section. To download your report click on the report you wish to download, then click on the Export.

Step 2: Download the Eshopbox return template

Once you have received the return information from AJIO, you need to download the Eshopbox return template by following the steps below:

From the sidebar of the workspace, navigate to Orders.
Click on the Import button in the top right corner of your screen
Select Create new returns.

Download the import report template. The template will include all the guidelines required to enter your return details.

Step 3: Convert return information to Eshopbox return template

You need to now fill in your AJIO return details in the Eshopbox return template. While filling the template, you need to be aware of the terminologies used in both AJIO and Eshopbox.

The following table will help you to provide return details of AJIO in the return import template:

Column in Eshopbox	Column in AJIO	What to fill?	Example
Portal	Does not exist	You need to enter the Portal name as Ajio	Ajio
Order ID	FWD_PO_NUMBER	Fill in the FWD_PO_NUMBER from the AJIO returns sheet	4050250441
SKU	Seller_SKU	To create a return in Eshopbox, the SKU provided by Ajio must be configured with the product as the SKU or additional name (alias) in Eshopbox. (ESIN/SKU/UPC/EAN/GTIN). If your return is still unidentified due to SKU, you need to contact the sales channel.	7684983765
Return tracking ID	RETURN_DOC_NO	Fill in the RETURN_DOC_NO from the AJIO returns sheet	5147036157
Return type (field must be filled based on the type of return)	Return_Type	A) If the return is Order cancellation in the AJIO sheet, then you need to fill FDR against it. B) If the return is Customer Returns in the AJIO sheet, then you need to fill CIR against it.	CIR/FDR
Sales channel	Does not exist	Leave this field as blank for AJIO
Quantity	RTV_Quantity	Fill in the RTV_Quantity from the AJIO returns sheet	2
Reason	Does not exist	Leave this field as blank for AJIO
Invoice number	FWD_Invoice_number	Fill in the FWD_Invoice_number from the AJIO returns sheet.	HR1168
Delivery status as per channel	Return_Status	If the Return_Status is Success in the AJIO sheet, then you need to fill Delivered against it	Delivered
Delivery date as per channel	Does not exist	Leave this field as blank for AJIO
Shipping provider	Does not exist	Leave this field as blank for AJIO
Expected arrival by	Does not exist	Leave this field as blank for AJIO

💡Once you have prepared the return template, make sure you save it in CSV format.

Step 4: Upload return template in Eshopbox

Once you have prepared the return template, you need to upload it into Eshopbox.

From the sidebar of the workspace, navigate to Orders.
Click on the Import button in the top right corner of your screen
Select Create new returns.
Click on the Add CSV button and select the file you wish to upload.
Click on Submit.
Once you have submitted the return template, you will be redirected to the Eshopbox workspace and you will be able to see that your import is in progress as shown:

Your AJIO returns are now being created in Eshopbox.

Step 5: Track your returns

Once your return template has been imported into Eshopbox, you can track the status of your returns by navigating to the 'Files' tab from the sidebar of the Eshopbox workspace. Here, you will be able to see one of the following statuses for the returns that have been imported:

Returns created: This means that returns have been successfully imported into Eshopbox. For example, 200 returns created.
Returns failed: This means that returns could not be created in Eshopbox. This usually happens when there are errors while processing the return template. For example, 125 returns failed.

You need to take corrective action for these failed returns and re-upload the modified return template into Eshopbox. To understand how to handle failed returns, read troubleshooting return import.