Treating the index as a slightly stale copy, with MySQL deciding price and stock at checkout, answers the first question well. Search can be a little behind, but the order cannot. Keeping price and stock updates on their own path, apart from bulk imports, also seems like the right call. One small addition to the outage plan: if results come from cache or FULLTEXT, the "search is limited" notice could also say whether prices shown might be out of date. That way a user is not surprised when checkout shows a different number.