Hi miberk90,
You can use the WooCommerce Product Table to sort, categorize and search products.
I am also looking for a way to automatically update products from web scraping, except I only have a few products compared thousands as you suggested. Have you had any luck? I can web scrape using Python and update the products by uploading a CSV to WooCommerce, but I cannot work out how to combine this and do it automatically in the cloud.
More detail in my post: https://www.ads-software.com/support/topic/web-scraping-to-automatically-update-woocommerce-product-data/#new-topic-0
Charlie