Need to update the inventory for many products at once? The Inventory Upload feature lets you do just that using a simple CSV file.
What You Can and Cannot Do with Inventory Upload
YES, you can:
- Update the quantity of existing products in specific warehouse locations.
- Add new locations to existing products.
NO, you cannot:
- Update the properties of existing warehouse locations (like making a location sellable or non-sellable). You'll need to do this manually on the Warehouse Locations page. Here is more information on Creating and Managing Warehouse Locations.
- Create new SKUs. Use the Bulk Edit upload for that.
Who Can Use Inventory Upload?
- 3PL (Third-Party Logistics) accounts.
- Brand accounts.
NOTE: 3PL Clients CANNOT edit inventory in their accounts as the inventory levels are managed at the 3PL account level.
Understanding the Inventory Upload CSV Template
To update your inventory, you'll need to download a template and fill it out correctly. Here's what each column means:
SKU-The unique identifier for your product.
Action-Tells ShipHero what to do with the quantity. You can choose either:Change: Adds or subtracts the number in the "Quantity" column from the current inventory at the specified location.Replace: Sets the current inventory at the specified location to the exact number in the "Quantity" column.
Quantity-The number of units to add, subtract (use a negative number), or the new total quantity (if using "Replace").
Location- the specific warehouse location you are updating.
Reason- A brief note explaining why you are making this inventory change. This is for your records.
Important Notes About Your CSV File:
- Exact Format: Your uploaded CSV file must have these columns in this exact order with these exact titles. Any changes will cause errors.
- One Line Per Update: For each inventory change, even for the same SKU in different locations, you need a separate line in your CSV file.
- Avoid Conflicting Actions: Don't use both "Change" and "Replace" for the same SKU in the same location in the same upload. Also, avoid using "Replace" more than once for the same SKU and location, as the order of processing isn't guaranteed and could lead to unexpected results.
How to Update Inventory using Inventory Upload
- Go to the Inventory>Inventory Upload page.
- Click Upload CSV button.
- Click Download Inventory Template. This will give you the correct CSV format.
- Open the template and add a new row for each inventory update you need to make. Remember to include the SKU, Action ("Change" or "Replace"), Quantity, Location, and Reason.
- Save the file in a CSV format. If using a Mac, set the format to Windows Comma Separated (.csv)
BEFORE UPLOADING
- For 3PLs: Make sure you select the specific customer whose inventory you are updating.
- For Multiple Warehouses: Choose the correct warehouse where the inventory changes are needed.
- Click Choose your file, select the CSV file from your computer, and then click Upload file.
ShipHero processes each upload as a batch. Once all SKUs are marked as "Success," the upload and update are complete. Processing times may vary depending on the internet connection speed and the file size.
NOTE: CSV uploads have a limit of 1,000 rows. If your CSV is larger than 1,000 rows, we recommend splitting up your file into smaller batches so no data is lost.