There's currently not a way to do this for more than one product at a time using the UI, but there's an Issue created to change that in the future.

https://github.com/Hotcak...merce/core/issues/92

Until then, you'll need to do this using a query, as you suggest. An example query is below, but it hasn't been tested to verify if it will work in your environment, so please make sure you back up your database before you try it. It has been tested against a clean instance of Hotcakes 03.01.00.

[code=sql]UPDATE [dbo].[hcc_Product] SET [IsSearchable] = 1;[/code]

If you're running the query in the built-in SQL query tool, the query below will be better.

[code=sql]UPDATE {databaseOwner}[{objectQualifier}hcc_Product] SET [IsSearchable] = 1;[/code]

Once you run the query, you'll likely need to clear the cache on the website. You can do that using the documentation below.

https://hotcakescommerce....6-Clearing-the-Cache

On a side note, questions like this are fully supported for anyone subscribed to our Developer Support Services plan.

https://upendoventures.co...ce-Developer-Support