How to Transfer Inventory Between Warehouses Using Excel
Overview
This utility allows you to transfer inventory between warehouses by copying and pasting data from an Excel spreadsheet. It is intended for use in a virtual warehouse environment and cannot be used in a Piece/Case/Pallet environment where 3PL billing is enabled.
Step 1: Export Inventory Data
- From the originating warehouse, go to the Inventory tab > New Reports.
- Pull an "Inventory Cycle Count Report" and export it to Excel.
Step 2: Format the Excel File
Required Columns (in this order):
| Column | Field Name | Required? |
|---|---|---|
| A | SKU | ✅ Required |
| B | Transfer Qty | ✅ Required |
| C | From Location | ✅ Required |
| D | From Warehouse | ✅ Required |
| E | To Location | ✅ Required |
| F | To Warehouse | ✅ Required |
💡 See the attached document for a sample layout.
Modify the File:
- Remove the following fields: Description, Released, Total, Count.
- Add the required fields listed above.
- Remove any SKUs that you are not transferring.
- Ensure the Originating and Destination Shelf Locations match.
- Warehouse ID can be found in DC Address settings and is typically 0001, 0002, 0003, or 0004, etc.
Step 3: Upload the Transfer Data
- In Blast Ramp, navigate to:
📍 Advanced > Utilities > Upload Inventory Transfers - Copy/Paste from Excel. - In Excel, copy all data cells for the transfer (DO NOT include the title row or any empty rows).
- Paste the data into the Upload Inventory Transfers utility.
- Click Upload.
Step 4: Review the Transfer
- If successful, the tool will display successful transfers.
- If there are errors, the tool will display error messages indicating what needs to be corrected.