Locations in ShipHero are the named storage areas in your warehouse, like bins, shelves, and pallet positions. You can update settings for multiple existing locations at once by exporting them to a CSV file, editing the file, and uploading it back into ShipHero. Use this when you need to rename locations, change pick priorities, or update pickable and sellable status for many locations without editing them one at a time.
Before You Begin
- This method updates existing locations only. It does not create new locations. To create new locations in bulk, see How to Create and Manage Locations in ShipHero.
- You need permission to manage locations in the warehouse you're updating.
For an overview of all location settings in ShipHero, see How to Create and Manage Locations in ShipHero.
Table of Contents
- How to Export Locations for Update in ShipHero
- How to Edit the Location Update CSV Template
- How to Upload the Location Update CSV in ShipHero
- Location Update CSV Template Structure
How to Export Locations for Update in ShipHero
Export the locations you want to update to generate a pre-filled CSV template with each location's current settings.
- Go to Inventory > Locations.
- If you manage multiple warehouses, select the warehouse with the locations you want to update.
- Apply any filters or search terms to narrow the list to the locations you want to update.
- Select Export for Location Update.
ShipHero downloads a CSV file that includes only the locations that matched your filters, along with their current settings.
How to Edit the Location Update CSV Template
Open the exported file and update the settings for each location.
- Open the exported CSV file.
- Keep the ID column unchanged for every row. ShipHero uses this value to match each row to an existing location.
- Edit the Name column to rename a location. Leave it unchanged if you are not renaming the location.
- Edit the Pickable, Priority, Type, or Sellable columns to update those settings.
- Save the file as a CSV.
Important
ShipHero can only change a location's Sellable setting (switching between Sellable and Non-Sellable) if the location is empty. If a location still has inventory, its Sellable status will not update.
Note for Mac users: Save the file using the Windows Comma Separated (.csv) format. The default Mac CSV format is not supported for uploads.
How to Upload the Location Update CSV in ShipHero
- Go to My Account > CSV Management.
- Select the Select Item to Update dropdown and choose Update Locations.
- If you manage multiple warehouses, select the warehouse for the locations you're updating from the Warehouse dropdown.
- Select Choose File and select your edited CSV file.
- Select Update.
Location Update CSV Template Structure
The Location Update CSV template includes the following columns.
| Column | Description | Example Values |
|---|---|---|
| ID | Uniquely identifies an existing location. Do not change this value. | 22821995 |
| Name | The location's name. Edit this value to rename the location. | A-01-01, Rack-North-01 |
| Pickable | Whether the location is accessible for picking. | Yes, No |
| Priority | The picking order for the location. | 1, 2, 3 |
| Type | The location's classification. Leave blank to remove a location's type. | Bin, Shelf, Pallet |
| Sellable | Whether inventory at this location counts toward available stock. | Yes, No |
The Location Update CSV template does not include the Transfer Bin (Is Cart) or Staging columns. To update a location's Transfer Bin or Staging status, edit the location individually on the Inventory > Locations page.