Vendor export missing vendors when status and type filters are applied

AJ Suurhoff
AJ Suurhoff

If your vendor export includes fewer vendors than expected when both the Vendor Status and Vendor Type filters are applied, this is because the export only includes vendors that have both fields populated. Vendors missing either field are excluded from the results.

Follow the steps below to identify and resolve the issue.

Who can use this feature?

  • Super Admins and Compliance Managers

Why this happens

The Vendor Status and Vendor Type filters in the vendor export work together as an "and" condition. When both filters are applied, a vendor must have both a status and a type assigned to appear in the export.

This means that selecting "All Status" and "All Type" doesn't return every vendor. It returns every vendor that has both a status and a type. Vendors that are missing one or both of these fields are excluded.

The most common cause is vendors that don't have a Vendor Type assigned.

Identify missing vendors

  1. Navigate to Reports > Vendor Assessment > Vendors Export.

  2. Apply the Vendor Status and Vendor Type filters and click Download Report.

  3. Review the exported results and compare them against your full vendor list.

  4. If vendors are missing, check whether those vendors have a Vendor Type assigned in Vendor Assessment.

Resolve the issue

You can resolve this in one of two ways:

a. Remove the Vendor Type filter: Generate the export with only the Vendor Status filter applied. This removes the requirement for a Vendor Type and includes all vendors that have a status assigned.

b. Assign a Vendor Type to all vendors: Update each vendor in Vendor Assessment to include a Vendor Type. Once every vendor has both fields populated, the export with both filters applied returns all vendors.


Any questions? Reach out to our support team by submitting a ticket.

Related to

Was this article helpful?

Yes! No