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.
Note: To create a vendor, see our help article How to Add a Vendor in Shopify.
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
The Vendor ID is the Vendor's unique identifier.
The Vendor Name is the name of a product's Vendor.
The Product Name is the product's name. It is not the same as the SKU.
The SKU is your product's unique identifier.
The Manufacturer 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.
The Cost Price is the price you pay the Vendor for the products.
The Update 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.