The Bulk Product Editor now supports searching and editing the Product Category field. (Please note that up until September 2022 the "Product Category" field was called the "Standard Product Type" field.)
There's full autocomplete support for the categories to minimize input errors and you can bulk edit the Product Category field with a few clicks.
Learn more about bulk editing the Product Category field in Shopify