Importing Tata Cliq returns

Returns for Tata Cliq are automatically imported to your Eshopbox workspace. However, there may be instances where the return is received at the fulfilment location, but a corresponding return is not created on your workspace. In such cases, you need to create the returns via manual import.

You need to create returns for Tata Cliq so that Eshopbox can identify the returns that are expected at Eshopbox fulfilment centres.

In this article, you will learn:

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

Follow the below steps to create Tata Cliq returns in Eshopbox:

Step 1: Get return information from Tata Cliq

You will receive your Tata Cliq return information at your primary email address registered with your Tata Cliq seller account. The return information is provided in an attachment file consisting of an excel sheet.

Step 2: Download the Eshopbox return template

Once you have received the return information from Tata Cliq, 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 Tata Cliq return details in the Eshopbox return template. While filling the template, you need to be aware of the terminologies used in both Tata Cliq and Eshopbox.

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

Column in Eshopbox	Column in Tata Cliq	What to fill?	Example
Portal	Does not exist	You need to enter Portal name as Tata Cliq	Tata Cliq
Order ID	OrderId	Fill in the OrderId from the Tata Cliq returns sheet	210627-013-015165
SKU	Product SKU	To create a return in Eshopbox, the SKU provided by Tata Cliq 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.	8.90386E+12
Return tracking ID	AWB # 1	Fill in the AWB # 1 from the Tata Cliq returns sheet	2.37772E+12
Return type (field must be filled based on the type of return)	Return Type	A) If the return is CIR in the Tata Cliq sheet, then you need to fill CIR against it. B) If the return is RTO in the Tata Cliq sheet, then you need to fill FDR against it.	CIR/FDR
Sales channel	Does not exist	Leave this field as blank for Tata Cliq
Quantity	Does not exist	Leave this field as blank for Tata Cliq
Reason	Does not exist	Leave this field as blank for Tata Cliq
Invoice number	Invoice#	Fill in the Invoice# from the Tata Cliq returns sheet	'C23527210628A008'
Delivery status as per channel	Shipment mode	Fill in the Shipment mode as Delivered from the Tata Cliq returns sheet	Delivered
Delivery date as per channel	Shipment Delivery Date	Fill in the Shipment Delivery Date from the Tata Cliq returns sheet	8/30/2021
Delivery location	Does not exist	Leave this field as blank for Tata Cliq.
Shipping provider	Return Delivered by LP	Fill in the Return Delivered by LP from the Tata Cliq returns sheet	XpressBees
Expected arrival by	EDD for In-transit Shipment	Fill in the EDD for In-transit Shipment from the Tata Cliq returns sheet	8/31/2021

💡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 home and you will be able to see that your import is in progress as shown:

Your Tata Cliq 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.