Yes of course, we have sku meta field search enabled by default for woocommerce products. You can choose whichever meta fields you wish to search.

I’m not sure what you mean re: their manual build process – you need a table build on ours the first time you use it but after that the table maintenance is automatic.