Importing Amazon Prime Returns
Returns for Amazon Prime 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 Amazon Prime 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 Amazon Prime?
How to download the Eshopbox return template?
How to convert Amazon Prime return information to the Eshopbox return template?
Steps to create Amazon Prime returns
You need to follow the below-given steps to create Amazon Prime returns on your Eshopbox workspace:
Step 1: Get return information from Amazon
You will receive your Amazon Prime return information at your primary email address registered with your Amazon Seller Central account. The return information is provided in an attachment file consisting of two sheets named Returns and Rejected.
Returns: This sheet consists of all customer-initiated returns (CIR)
Rejected: This sheet consists of all failed-delivery Returns (FDR)
Step 2: Download the Eshopbox return template
Once you have received the return information from Amazon, you need to download the Eshopbox return template by following the steps below:
Step 2.1: Login to your Eshopbox workspace.
Step 2.2: From the header, navigate to Orders > All orders. You will be redirected to the Orders page.
Step 2.3: Navigate to the top right corner and click on Import.
Step 2.4: Select Create new returns.
Step 2.5: 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 Amazon Prime return details in the Eshopbox return template. While filling out the template, you need to be aware of the terminologies used in both Amazon and Eshopbox.
The following table will help you to provide return details of Amazon in the return import template:
Column in Eshopbox | Column in Amazon | What to fill? | Example |
Portal | Does not exist | You need to enter the Portal name as Amazon | Amazon |
Order ID | order_id | Fill in the order_id from the Amazon returns sheet | 408-0101270-8211523 |
SKU | merchant_sku | Fill in the merchant_sku from the Amazon returns sheet | A16413GRZXH |
Return tracking ID (field must be filled based on the type of return) | tracking_id | In case of customer-initiated returns, fill the tracking_id. | 634693469785 |
reverse_tracking_id | In case of failed delivery returns, fill the reverse_tracking_id. | 37465783456 | |
Return type (field must be filled based on the type of return) | reverse_type | If the return is Undelivered_Rejected in the Amazon sheet, then you need to fill FDR against it. | FDR |
reverse_type | If the return is Customer_return in the Amazon sheet, then you need to fill CIR against it. | CIR | |
Sales channel | Does not exist | Leave this field as blank for Amazon Prime. | |
Quantity (field must be filled based on the type of return) | returned_quantity | In case the return is customer initiated, you need to fill the returned_quantity value from the Amazon returns sheet. | 3 |
qty | In case the return is failed delivery return, you need to fill the qty value from the Amazon returns sheet. | 5 | |
Reason | return_reason | Fill in the return_reason from the Amazon returns sheet. This only needs to be done for customer-initiated returns. If a return reason is not available, leave the field blank. | Did not receive the item that was ordered |
Invoice number | Does not exist | Leave this field as blank for Amazon Prime. | |
Delivery status as per channel | Does not exist | Leave this field as blank for Amazon Prime. | |
Delivery date as per channel | delivered_to_seller_date | Fill in the delivered_to_seller_date from the Amazon returns sheet. | 8/31/2021 |
Delivery location | Does not exist | Leave this field as blank for Amazon Prime. | |
Shipping provider | Does not exist | Leave this field as blank for Amazon Prime. | |
Expected arrival by | Does not exist | Leave this field as blank for Amazon Prime. |
Note: Once you have prepared the return template, make sure you save it in CSV format.
Step 4: Upload the 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 Amazon Prime 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.