Just in case
These were the tables I tryed to update but not able to still have the products visible on search and cateogy listings, otherwise on backoffice looked good.
note: bellow the example queries was for a product which setting the threshold 0 would still have stock >0 thus putting stock status "instock".
update wp_atum_product_data set out_stock_threshold = 0, atum_stock_status = 'instock' where product_id=123
update wp_postmeta set meta_value='instock' where post-id = 123 and meta_key ='_stock_status'
update wp_wc_product_meta_lookup set stock_status='instock' where product_id=123
But I believe going directly to tables is starting a hard kung fu. but anyway I drop them here just in case you would be able to advise on some other table and fields Im missing to update.
Maybe this feature is possible with a PRO version?
Many thanks in advance for any help