In the product overview, you can find specific products using the filters and the search. Once you have found the products you need, you can edit them in one step using bulk edit.

Open the product overview under Catalogues → Products and click the filter icon. The filters can be combined. For example, to find inactive variants with stock, activate the filter for inactive products and the filter for available stock, and use Show variants to list the variants as well. For more on the variant display, see Should variants be displayed in the product overview?.

The supplier product number is not a column in the product overview.

You can't see which products are in which bin location in the product overview. Instead, go to Warehousing → Stock overview and open the Per product and bin location view.

Select the filtered products using the checkbox and edit them together using Bulk edit.