The Vendor Bulk Edit feature allows for large-scale updates to existing vendor information via CSV upload. This process is designed exclusively for modifying existing records and cannot be used to create new vendors.
To create a new vendor, please refer to the guide: How to Create Vendors in ShipHero.
How to Edit Multiple Vendors in Bulk
Follow these steps to update vendor data in your ShipHero dashboard:
- Go to the Purchase Orders > Vendors page.
- Click the Upload CSV button to navigate to the Download Vendor Products page.
- Select the Vendor you need to edit products for and click Download Products to generate your template.
- Edit the data in your file as needed.
- Change the column "Update Row" from 0 to 1 for each row you edited.
- Under the Upload Vendor Products CSV file section, select your completed file and click Upload.
Important
The CSV file must include the 'SKU', 'Vendor ID', and 'Update Row' fields, plus at least one additional field for modification.
Understanding the Column Headers
Correct data mapping requires an understanding of how ShipHero identifies specific entities within your CSV file.
| Column Header | Description/Action |
|---|---|
| Vendor ID | The unique identifier for the Vendor entity. |
| Vendor Name | The display name assigned to the Vendor. |
| Product Name | The name of the item; distinct from the SKU. |
| SKU | The unique identifier for the Product entity. |
| Manufacturer SKU | The Vendor's specific SKU. Used to differentiate products when multiple vendors provide the same item under different codes. |