Vendor Bulk Edit allows you to update many vendors at once by uploading a spreadsheet. This feature is used to edit existing vendor information and not to create new ones.
How to Edit Multiple Vendors in Bulk
- Go to Purchase Orders > Vendors.
- Click the Upload CSV button located on the top right-hand of the dashboard.
- Follow the instructions on the Download Vendor Products page to create your CSV.
- At the bottom of the page, under Upload Vendor Products CSV file, choose your CSV file and click on Upload.
Note: The CSV file must contain the 'SKU' field, the 'Vendor ID' field, the 'Update Row' field, and at least one other field.
Understanding the Column Headers
TheVendor ID is the Vendor's unique identifier.
TheVendor Name is the name of a product's Vendor.
TheProduct Name is the product's name. It is not the same as the SKU.
TheSKU is your product's unique identifier.
TheManufacturer SKU is the Vendor's SKU. In ShipHero, you can assign items a Manufacturer SKU in case you have different Vendors with the same product but different SKUs. Giving a Manufacturer SKU to a product will not affect your workflow.
TheCost Price is the price you pay the Vendor for the products.
TheUpdate Row column determines if the vendor data should be updated once uploaded. By default, the cells contain a 0, where 0 represents false and 1 true. Make sure to change the 0 to 1 if the row was edited.
Note: Do not change the column headers as this will result in an upload error.