Integrate MuleSoft or middleware bulk APIs with Apex ingestion patterns

• Bulk API bypasses Apex row limits but triggers still fire per batch • Integration user with trigger bypass during bulk sync windows • Staging object pattern: bulk load staging, batch validates and merges to Product2 • Monitor Bulk API job failure CSV; automated retry for transient errors • Parallel job limit awareness—queue middleware jobs not flood simultaneously • Compare Bulk API vs REST composite for real-time vs batch tradeoff • Reconciliation report: staging vs target counts after each job