Locations in ShipHero are the named storage areas in your warehouse, like bins, shelves, and pallet positions. You can create many locations at once by uploading a CSV file, or update settings for many existing locations by exporting them to a CSV file, editing the file, and uploading it back into ShipHero. Use these methods to add locations, rename locations, change pick priorities, or update pickable and sellable status without working one location at a time.
Before You Begin
- Create or update: The Locations CSV upload creates new locations. The Location Update CSV changes existing locations only and does not create new ones.
- Required permission: You need permission to create and manage locations in the warehouse you are working in.
- Case-sensitive values: Template headers and Yes/No values are case-sensitive. When Yes or No is entered without a capital first letter, ShipHero sets the Pickable and Sellable fields to No.
For an overview of all location settings in ShipHero, see How to Create and Manage Locations in ShipHero.
Table of Contents
- How to Create Multiple Locations via CSV in ShipHero
- Locations CSV Template Structure for Creating Locations
- 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
- Troubleshooting Locations CSV Upload Errors in ShipHero
How to Create Multiple Locations via CSV in ShipHero
The Locations CSV upload creates many locations at once instead of adding them one at a time. Download the template and upload it from My Account > CSV Management.
Important
Template headers and Yes/No values are case-sensitive. When Yes or No is entered without a capital first letter, ShipHero sets the Pickable and Sellable fields to No. For multi-warehouse accounts, select the warehouse from the dropdown when you upload. Do not add a Warehouse column to the file. For uploads over 500 locations, break the CSV into batches of 100 to 200 rows.
- Go to My Account > CSV Management.
- Select the Select Item to Update dropdown and choose Locations.
- Select Download Locations Template. All columns in the template are required fields.
- (Optional) Add an Is Cart column to create Transfer locations in bulk.
- Add your locations and their settings to the template and save the file.
- Select Upload. For multi-warehouse accounts, choose the target warehouse from the dropdown before uploading.
Locations CSV Template Structure for Creating Locations
The Locations CSV template includes the following columns.
| Column Name | Required | Description | Example Values |
|---|---|---|---|
| Name | Yes | Unique location identifier | A1, Rack-North-01, Bin-Low-03 |
| Pickable | Yes | Whether the location is accessible for picking | Yes, No |
| Priority | Yes | Picking order for the location | 1, 2, 3 |
| Type | Yes | Location classification | Bin, Pallet, Rack |
| Sellable | Yes | Whether inventory at this location counts toward available stock | Yes, No |
| Is Cart | Optional | Marks the location as a Transfer Bin | Yes, No |
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.
Troubleshooting Locations CSV Upload Errors in ShipHero
The most common Locations CSV upload errors, for both creating and updating locations, come from the wrong warehouse selection, incorrect capitalization of Yes/No values, missing or extra columns, or duplicate location names.
Check Your Warehouse Selection and Permissions for a Locations CSV Upload
Most Locations CSV upload errors relate to the wrong warehouse being selected during the upload.
- Verify the warehouse selected in the ShipHero dropdown during upload matches the warehouse where you want to create or update the locations.
- Confirm your user account has permission to create and manage locations in that warehouse.
- For multi-warehouse accounts, confirm the CSV file contains only locations intended for the selected warehouse.
Validate Your Locations CSV File Content
Small mistakes in the CSV can cause the entire upload to fail.
- When you create locations, confirm all required columns are present: Name, Pickable, Priority, Type, and Sellable.
- Add the Is Cart column only if you are creating Transfer locations.
- Do not add any other columns. Extra columns cause an error. For multi-warehouse accounts, select the warehouse from the dropdown instead of adding a Warehouse column.
- When you update locations, keep the ID column unchanged for every row.
- Check for hidden characters or extra spaces in your location data that could cause validation errors.
Use a Batch Upload Strategy for Large Locations CSV Files
When a large Locations CSV fails, it can be hard to pinpoint the problem row.
- Split the CSV into smaller batches of 100 to 200 locations and upload each batch separately.
- When one batch fails and others succeed, you have isolated the rows causing the error. Correct those entries and re-upload.