The Bulk Edit CSV Upload is specifically for adjusting product properties, not inventory quantities. If you need to change inventory levels, use the Inventory Upload feature.
The Bulk Edit CSV allows you to update and create many products at once by uploading a spreadsheet. You can quickly make updates to a product's Name, Reorder Level, or customs information (as well as other properties listed in the CSV template). This feature is often helpful when many products require updating or are being managed in an external program and you need to update them in ShipHero.
How to Use the Bulk Edit CSV Upload
Using the Bulk Edit CSV upload is pretty straightforward.
- Go to the Inventory > Bulk Edit page.
- Use the Download Products option for a template with all the products, or use the CSV template here.
- Make the necessary edits in the file.
- Save the file in a CSV format and Upload.
Important Note for 3PLs
When using the Bulk Edit CSV to create new products for a client, you must be logged in at the client level. Selecting the client from the dropdown in the upload section will not create the products accurately in the client's account.
Tracking a Bulk Edit CSV's Upload Progress
Every upload creates a new batch; review the progress of the changes made by selecting the batch from the Batches section. Monitor the progress of your updates using the following statuses:
| Status | Description/Action |
|---|---|
| New | The data is currently uploading to ShipHero. |
| Processed | The updates have been successfully applied. |
| Error | Updates failed; review the file for formatting issues. |
Important Notes on How to Prepare Your CSV File
You can download the official CSV template here to start making changes to your existing products. This CSV file can be opened and edited with popular spreadsheet applications like Microsoft Excel or Google Sheets.
| Rule | Details |
|---|---|
| SKU is the only required column | ShipHero uses the SKU column to match CSV rows to existing products in your account. All other columns are optional. |
| SKU cannot be edited via CSV | The SKU of an existing product cannot be changed using the Bulk Edit CSV. See How to Update a Product's SKU for this process. |
| New SKUs will create new products | Any SKU included in the CSV that does not already exist in ShipHero will result in a new product being created. |
| Only include columns being updated | As a best practice, only include columns that contain data you intend to update. Including columns with blank values can lead to unexpected results. |
| Column headers are case-sensitive | Do not modify the column header names from the templated format — they must match exactly, including capitalization. |
| Use 0 or 1 for boolean fields | For on/off settings, use 0 to indicate Off / No / False and 1 to indicate On / Yes / True. Any other value will not update the setting as expected. |
| No special characters | Do not include special characters in any data fields. For example, do not add $ to currency columns, as this will cause the upload to fail. |
| One SKU per upload | Each SKU should appear only once per CSV file. Duplicate SKUs can cause data to be overwritten, as the file is not processed in sequential order. |
Note for Accounts with Multiple Warehouses: If you manage products across multiple warehouses, you'll need to specify which warehouse the updates apply to. Select the correct warehouse from the dropdown menu when uploading your CSV file. This option is only available if your ShipHero account is configured with more than one warehouse.
Saving Your CSV File in Microsoft Excel
Follow these steps to correctly save your .CSV files in Microsoft Excel:
- Open your .CSV document in Microsoft Excel.
- Click on File.
- Select Save As...
- From the "File Type" dropdown, select CSV UTF-8 (Comma delimited) (.csv).
- Click Save.
- If a prompt appears, choose Keep Current Format.
Example Upload
We are going to update a product's Replenishment Minimum and Replenishment Maximum amounts. The CSV file requires the SKU column to match the products from the file to the existing products in ShipHero and the Replenishment Level and Replenishment Max Level to edit those values; all other columns have been removed since we are not updating those.
To adjust the Replenishment Level, a feature flag must be enabled in your account. Please contact support to enable this feature. To learn more about the Replenishment Feature, check out our Replenishment Minimum/Maximum Feature article.
Bulk Edit CSV Columns and Definitions
Below is a chart with the fields that are available to edit using the Bulk Edit CSV Upload feature. Please note the Values to Use column in this chart will provide what format the data should be entered in for each product data point/setting.
Each data point that has additional resources is linked accordingly for you to reference.
| Product Data Fields/Settings | Description | Values to Use |
|---|---|---|
| Name | The name of your product. | Alpha, Numeric, and Special characters |
| On Hand | Deprecated field; be sure to remove this column from your download. | |
| Thumbnail | Link to the product's thumbnail image. | |
| Reorder Level | The minimum quantity before a reorder is suggested. | Numeric Values Only |
| Reorder Amount | The quantity to reorder when the reorder level is met. | Numeric Values Only |
| Bin | Deprecated field; be sure to remove this column from your download. | |
| Overstock Bin | Deprecated field; be sure to remove this column from your download. | |
| Barcode | The product's barcode. | Numeric Values Only |
| Warehouse | The warehouse associated with the product data. | Alpha-Numeric and Special Characters |
| Value | The cost of the product. | Numeric Values Only |
| Customs Value | The declared value for customs purposes. | Numeric Values Only |
| Customs Description | Description for customs declarations. | Alpha-Numeric and Special Characters |
| Price | The product's selling price. | Numeric Values Only |
| No Air | Indicates if the product cannot be shipped via air (i.e., hazardous materials). | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Weight | The product's weight. | Numeric Values Only |
| Height | The product's height. | Numeric Values Only |
| Width | The product's width. | Numeric Values Only |
| Length | The product's length. | Numeric Values Only |
| Reserve Inventory | Quantity of inventory to be reserved. | Numeric Values Only |
| Country Of Manufacture | The country where the product was manufactured. | 2-Digit Country Code |
| Tariff Code | The product's tariff code for international shipping. | Alpha-Numeric Values Only |
| Do Not Cycle Count | Deprecated field; be sure to remove this column from your download. | |
| Do Not Show On Invoice | Set to 'TRUE' to hide on invoices. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Do Not Show On Customs | Set to 'TRUE' to hide on customs forms. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Not Owned | *Deprecated Feature | |
| Product Note | Internal notes about the product. | Alpha, Numeric, and Special Characters |
| Virtual Product | Set to 'TRUE' if it's a virtual product (i.e., a service). | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Custom Product | Set to 'TRUE' if it's a custom-made product that will require a custom barcode to track. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Value Currency | The currency of the product's value. | Alphabetic values only — Currency Abbreviation i.e. USD/CAD |
| Final Sale | Set to 'TRUE' if the product is final sale. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Build Kit | Set to 'TRUE' if the product is part of a kit. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Dropship | Set to 'TRUE' if the product is dropshipped. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Needs Serial Number | Set to 'TRUE' if the product requires a serial number. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Auto Fulfill | Set to 'TRUE' to automatically fulfill the product. | 1 or 0 (1 for Yes/True, 0 for No/False) |
| Tags | Keywords or tags for organizing products. | Alpha, Numeric, and Special Characters |
| Active | Set to 'TRUE' if the product is active/available. | 1 or 0 (1 for Yes, 0 for No) |
| Packer Note | Notes for the packing team. | Alpha, Numeric, and Special Characters |
| Replenishment Level | Minimum quantity for replenishment suggestions. | Numeric Values Only |
| Replenishment Max Level | Maximum quantity for replenishment suggestions (requires feature flag). | Numeric Values Only |
| Replenishment Increment | The increment for replenishment suggestions (requires feature flag). | Numeric Values Only |