Before downloading the template, you can filter by:

This is helpful if you only want to update Rank 1 suppliers for a specific problem type or group of locations

From the supplier private network, click Upload.

Then select Upload Rank 1 Suppliers.

Click Download Rank 1 Suppliers.

OpenWrench will email an Excel template to your email address.

Open the Excel file that was emailed to you.

The file will show the locations and problem types that are included in the upload.

In Column D, enter the supplier that should be ranked first.

It is very important that the supplier name matches exactly how it appears in OpenWrench.

The best way to do this is to copy and paste the supplier name directly from OpenWrench.

If the name does not match exactly, the upload may give you an error.

Once you have updated the Rank 1 suppliers, save the Excel file.

Then close the file before uploading it back into OpenWrench.

Go back to OpenWrench and click Proceed to Upload.

Click Upload File.

Select the updated Rank 1 supplier file that you saved.

OpenWrench will review the file and show you how the data is mapped.

Click Continue in the top right corner.

Continue through the mapping steps.

On the final page, OpenWrench will show you if anything is invalid.

If there are errors, review the supplier names and make any needed corrections.

The most common reason for an error is that the supplier name does not match exactly how it appears in OpenWrench.

If everything looks correct, click Submit.

OpenWrench will update the Rank 1 suppliers based on the file.

The bulk upload does not remove existing suppliers.

If a location and problem type already has a Rank 1 supplier, that supplier will move down to Rank 2. The supplier listed in your upload will become the new Rank 1 supplier.