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