Price and stock changes never reach the storefront on "Update by Schedule", why?

On "Update by Schedule" mode Magento relies on MySQL triggers writing into changelog tables, tracked in mview_state. If the triggers were dropped (common after a raw DB import or a partial migration) the changelog stops growing and edits never get picked up. We rebuild the triggers, toggling the indexer mode regenerates them, verify the changelog tables fill again, and confirm a test edit reflects on the frontend.