--- title: Fulfillment Hub USA – Using the Bulk Edit CSV Upload in ShipHero description: Update product data at scale with Fulfillment Hub USA’s Bulk Edit CSV in ShipHero. Learn how to prepare, format, and upload CSV files to edit products safely. --- [Skip to content](https://knowledgebase.fulfillmenthubusa.com/fulfillment-hub-usa-using-the-bulk-edit-csv-upload-in-shiphero#main-content) English Show submenu for translations ![FHU-LOGO-DESKTOP.png\]](https://knowledgebase.fulfillmenthubusa.com/hs-fs/hubfs/FHU-LOGO-DESKTOP.png?height=43&name=FHU-LOGO-DESKTOP.png) Open main navigation Close main navigation - English Show submenu for translations - Go to fulfillmenthubusa.com Go to fulfillmenthubusa.com Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Fulfillment Hub USA Knowledge Base](https://knowledgebase.fulfillmenthubusa.com/?hsLang=en) 2. [Platform User Guides](https://knowledgebase.fulfillmenthubusa.com/platform-user-guides?hsLang=en) # 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. ![](https://software-help.shiphero.com/hc/article_attachments/37491078050957) --- #### 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. > **![](https://software-help.shiphero.com/hc/article_attachments/37491078054285)** > > **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. | **Product Data Field / Setting** | **Description** | **Values to Use** | | --- | --- | --- | | **Name** | The name of your product. | Alpha, numeric, and special characters | | **On Hand (for Static Slotting accounts only)** | Used **only** to set the initial quantity of a *newly created* product in Static Slotting accounts. Ignored for existing products. | Numeric values only | | **Thumbnail** | URL/link to the product’s thumbnail image. | Valid URL | | **Reorder Level** | Minimum quantity at which a reorder is suggested. | Numeric values only | | **Reorder Amount** | Quantity to reorder when the reorder level is reached. | Numeric values only | | **Bin (for Static Slotting accounts only)** | Primary bin location for the product in Static Slotting. | Alpha-numeric and special characters | | **Overstock Bin (for Static Slotting accounts only)** | Additional overstock bin locations for the product. | Alpha-numeric and special characters | | **Barcode** | Product barcode used for scanning. | Numeric values only | | **Warehouse** | Warehouse associated with this product data row. | Alpha-numeric and special characters | | **Value** | Cost of the product. | Numeric values only | | **Customs Value** | Declared value for customs. | Numeric values only | | **Customs Description** | Description used for customs declarations. | Alpha-numeric and special characters | | **Price** | Selling price of the product. | Numeric values only | | **No Air** | Indicates if the product cannot ship via air (e.g., hazardous materials). | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Weight** | Product weight. | Numeric values only | | **Height** | Product height. | Numeric values only | | **Width** | Product width. | Numeric values only | | **Length** | Product length. | Numeric values only | | **Reserve Inventory** | Quantity of inventory to reserve. | Numeric values only | | **Country Of Manufacture** | Country where the product was manufactured. | 2-digit country code (e.g., US, CA) | | **Tariff Code** | Tariff/HS code for international shipping. | Alpha-numeric values only | | **Do Not Cycle Count (for Static Slotting accounts only)** | Excludes the product from cycle counting when set. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Do Not Show On Invoice** | Hides the product from customer invoices when set. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Do Not Show On Customs** | Hides the product from customs forms when set. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Not Owned** | *Deprecated feature.* | — | | **Product Note** | Internal note or comments about the product. | Alpha, numeric, and special characters | | **Virtual Product** | Marks a product as virtual (e.g., a service, non-physical item). | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Custom Product** | Marks the product as custom-made and requiring a custom barcode to track. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Value Currency** | Currency for the product’s value. | Alphabetic currency code (e.g., USD, CAD) | | **Final Sale** | Marks the product as final sale (non-returnable). | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Build Kit** | Indicates that the product is part of a kit build. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Dropship** | Identifies the product as dropshipped. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Needs Serial Number** | Indicates that the product requires a serial number. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Auto Fulfill** | Automatically fulfills the product when orders are created. | `1` or `0` (`1` = Yes/True, `0` = No/False) | | **Tags** | Keywords or tags used to group or filter products. | Alpha, numeric, and special characters | | **Active** | Marks the product as active/available when set. | `1` or `0` (`1` = Yes, `0` = No) | | **Packer Note** | Notes specifically for the packing team to see. | Alpha, numeric, and special characters | | **Replenishment Level** | Minimum quantity used to trigger replenishment suggestions. | Numeric values only | | **Replenishment Max Level** | Maximum quantity used in replenishment suggestions (requires feature flag). | Numeric values only | | **Replenishment Increment** | Increment used for replenishment suggestions (requires feature flag). | Numeric values only | --- ### 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. - [FAQs](https://knowledgebase.fulfillmenthubusa.com/faqs?hsLang=en) - [Troubleshooting](https://knowledgebase.fulfillmenthubusa.com/troubleshooting?hsLang=en) - [General](https://knowledgebase.fulfillmenthubusa.com/general?hsLang=en) - [Reports](https://knowledgebase.fulfillmenthubusa.com/reports?hsLang=en) - [Integrations](https://knowledgebase.fulfillmenthubusa.com/integrations?hsLang=en) - [Return Management](https://knowledgebase.fulfillmenthubusa.com/return-management?hsLang=en) - [Store Integration](https://knowledgebase.fulfillmenthubusa.com/store-integration?hsLang=en) - [Platform User Guides](https://knowledgebase.fulfillmenthubusa.com/platform-user-guides?hsLang=en) - [Inventory Management](https://knowledgebase.fulfillmenthubusa.com/inventory-management?hsLang=en) - [Order Management](https://knowledgebase.fulfillmenthubusa.com/order-management?hsLang=en) [![Chill listening crop-3](https://knowledgebase.fulfillmenthubusa.com/hs-fs/hubfs/FHU_big_scaled-05.png?width=56&height=24&name=FHU_big_scaled-05.png "Chill listening crop-3")](https://fulfillmenthubusa.com) Reach out, if you need more information. Copyright © 2026, Fulfillment Hub USA