Fulfillment Hub USA – Using the Bulk Edit CSV Upload in ShipHero

ShipHero’s Bulk Edit CSV Upload is designed to update product properties, not inventory levels.
If you need to adjust on-hand inventory quantities, use the Inventory Upload feature instead.

At Fulfillment Hub USA, we use the Bulk Edit CSV to:

• Update many products at once.

• Create new products in bulk.

• Keep product data in sync when it’s managed in an external system (ERP, catalog, etc.).

With a single spreadsheet, you can update fields like Name, Reorder Level, and customs information, along with other product properties included in the template.

Note for 3PL scenarios:
When creating new products for a client using the Bulk Edit CSV, you must be logged in at the client level.
Simply selecting the client from a dropdown during upload will not create products correctly in the client’s own account.

---

How to Use the Bulk Edit CSV Upload

Using Bulk Edit CSV in ShipHero is straightforward:

1. Go to Inventory > Bulk Edit in the ShipHero Web App.

2. Choose one of the templates:

   • Download Products to get a CSV with all existing products, or

   • Use the standard CSV template provided in the article/tool.

3. Open the file in your spreadsheet tool and make your edits.

4. Save the file in CSV format.

5. Upload the CSV back into the Bulk Edit page.

6. After the upload, monitor progress by selecting the relevant batch from the Batches section.

This flow lets you safely batch changes and track each upload.

---

Important Notes on Preparing Your CSV File

To avoid errors and unexpected updates, keep these rules in mind when preparing your Bulk Edit CSV:

• You can download the official CSV template to modify existing products or create new ones.

• The CSV can be edited with common tools like Microsoft Excel or Google Sheets.

Key behaviors and requirements:

• SKU is required

  • ShipHero uses the SKU column to match rows to existing products in your account.

  • SKU is the only required column in the Bulk Edit CSV.

• You cannot change SKU via Bulk Edit

  • The SKU itself cannot be edited using this upload.

  • To change a SKU, follow ShipHero’s process for updating a product SKU.

• New SKUs create products

  • If a SKU in your file does not exist in ShipHero, the upload will create a new product.

• Only include columns you are updating

  • As a best practice, include only the columns you intend to update.

  • Including extra columns with blank values can overwrite data in ways you don’t expect.

• Column headers are case-sensitive

  • Do not rename headers or change their capitalization.

  • They must exactly match the template.

• Boolean / toggle fields

  • For on/off settings, use:

    • 0 for Off / No / False

    • 1 for On / Yes / True

  • Any other value will be ignored for those fields.

• Avoid special characters in numeric fields

  • Don’t add symbols like $ to currency fields; use plain numeric values only.

  • Special characters in numeric columns can cause the upload to fail.

• Use each SKU only once per upload

  • A SKU must appear only one time in a given CSV.

  • Duplicate SKUs can lead to overwritten data; files are not processed strictly in row order.

---

Note for Accounts with Multiple Warehouses

If your ShipHero account is configured with multiple warehouses, you can target updates to a specific warehouse:

• In the upload interface, choose the correct Warehouse from the dropdown before uploading.

• This selection determines which warehouse-level product data the upload applies to.

This option only appears if your account has more than one warehouse configured.

---

Saving Your CSV File in Microsoft Excel

To ensure your file is saved in a compatible format from Excel:

1. Open your CSV in Microsoft Excel.

2. Click File.

3. Select Save As….

4. In File Type, choose:
   CSV UTF-8 (Comma delimited) (.csv).

5. Click Save.

6. If a prompt appears, select Keep Current Format.

Using UTF-8 ensures special characters (e.g., in product names or notes) are handled correctly.

---

Example: Updating Replenishment Minimum & Maximum

Suppose we want to update a product’s Replenishment Minimum and Replenishment Maximum:

• The CSV needs at least these columns:

  • SKU

  • Replenishment Level

  • Replenishment Max Level

• All other columns can be removed if they are not being updated.

Note:
Updating Replenishment Level and Replenishment Max Level requires a feature flag to be enabled on your ShipHero account.
Please contact ShipHero Support to enable this feature.
For more details, see the Replenishment Minimum / Maximum Feature documentation.

---

Bulk Edit CSV Columns and Definitions

Below is a list of all available product fields/settings that can be updated via the Bulk Edit CSV in ShipHero, along with how values should be formatted.

---

Static Slotting Deprecation

Deprecated Feature
Static Slotting was officially deprecated by ShipHero on September 30, 2025 and is no longer supported.

Fulfillment Hub USA uses Dynamic Slotting for more flexible, scalable inventory management.
If any of your settings still depend on Static Slotting, you should upgrade to Dynamic Slotting as soon as possible.

For assistance with transitioning from Static to Dynamic Slotting, please contact:

• Your ShipHero Customer Success Manager (CSM), or

• support@shiphero.com

They can help ensure your Bulk Edit CSV setup and product data structure follow the latest best practices.