How to Complete Bulk Returns
Software Plan: Startup, Growth & Enterprise
Account Type: Seller Account
Inventory Type: Serialized & Non-Serialized
Purpose
Use this feature to complete returns in bulk using a CSV file after returns have already been initiated in the system. This applies to both B2C and B2B orders.
Use Case
Use bulk return completion when:
- Returns are already initiated for orders
- You need to mark returns as completed in bulk
Step 1: Download Bulk Returns CSV file
Click on Orders > Returns & Replacements > Hamburger Menu on Top right > Bulk Returns > Click on Save Template > CSV File will be downloaded
Step 2: Fill the required fields & Save the File.
| Column Name | Mandatory | Description |
|---|---|---|
| suborder_num | Yes | Sub-order number for which the return is being completed |
| order_num | Yes | Parent order number |
| sku | Yes | SKU code of the returned item |
| quantity | Yes | Quantity to be marked as returned. Must exactly match the pending return quantity for the same return AWB |
| return_date | Yes | Return completion date in DD-MM-YYYY format |
| return_reason | Yes | Return reason. Must match an active Return QC Reason |
| inventory_status | Yes | Inventory status after return QC (e.g. Repair, Damaged, Quarantine, Good) |
| add_inventory | Yes | Yes or No. Indicates whether inventory should be added back |
| tracking_num | No | Forward shipment tracking number, if applicable |
| return_awb_number | Conditional | Reverse AWB number. Mandatory when completing returns tied to a specific return shipment |
| batch_code | Conditional | Batch code. Applicable for batch-managed inventory |
| item_serial | Conditional | Serial number(s) for serialized inventory |
| gatepass_number | No | Gate pass reference, if used |
| debit_note_num | No | Debit note reference |
| amount | No | Return amount |
| shelf_name | No | Shelf or bin reference |
| comments | No | Internal remarks |
Step 2: Upload the File & Check Import Status
Once Successfully imported, on the Order details page, the return would be marked as completed
Important Rules
1. Quantity Validation Rules
- If a return is initiated for a specific quantity under a single Reverse AWB, the same quantity must be completed together
-
Completing a smaller or larger quantity than what is pending under that Reverse AWB is not allowed
If quantities do not match, the system shows this Error
-
Return all the items that belong to the same return awb_number
or -
Please provide the exact quantity present in the pending/initiate return to mark complete return
2. Multiple Returns for the Same SKU
- If returns are initiated separately for the same SKU:
- Each initiation generates a different Reverse AWB
- Each Reverse AWB must be completed independently
- Bulk CSV supports completing such returns as long as:
- The correct Reverse AWB is provided
- Quantity matches the pending quantity under that AWB
3. Serialized Inventory Handling
For serialized SKUs, both methods below are supported.
Method 1: Single Row
- Enter multiple serial numbers in the
item_serialcolumn - Separate serial numbers using commas
- Quantity must match the number of serials provided
Method 2: Multiple Rows
- Use one serial number per row
- All other fields remain the same
- Each row represents one unit being returned
Related Articles
Related Articles
Steps to Mark Returns in EasyEcom
Software Plan: All Account Type: Seller Account Inventory Type: Serialized & Non-Serialized Overview This feature allows marking returns for orders manually from the Returns screen. You can process returns at sub-order level or apply return details ...Create B2C Replacement Orders in Bulk
Software Plan: Startup, Growth & Enterprise Account Type: Seller Account Inventory Type: Serialized & Non-Serialized Overview This feature allows users to create B2C replacement orders in bulk using a CSV file. Each row in the CSV creates one ...HHT - Putaway - Returns Putaway
Software Plan : Growth & Enterprise Account Type : Seller Account & Aggregator 3PL Inventory Type : Serialized & Non-Serialized Overview The Returns PutAway process is the final step in handling returned items in the warehouse. Once a product is ...Returns: Quick Scan Flow
Software Plan: Starter Account Type: Seller Account Inventory Type: Serialized & Non-Serialized Overview This feature introduces a streamlined return management system for EasyEcom users, particularly focusing on improving efficiency for Small and ...Create Retail (B2C) Orders Individually or in Bulk
Overview EasyEcom allows you to create B2C orders either individually using the Create Retail Order page or in bulk using the Importing Wizard. Bulk order creation supports importing orders as Open or Shipped and also allows importing the Collectable ...