Complex organic molecules are of great importance to research and industrial chemistry and typically synthesized from smaller building blocks by multistep reactions. The ability to perform multiple (distinct) transformations in a single reactor would greatly reduce the number of manipulations required for chemical manufacturing, and hence the development of multifunctional catalysts for such one-pot reactions is highly desirable. Here we report the synthesis of a hierarchically porous framework, in which the macropores are selectively functionalized with a sulfated zirconia solid acid coating, while the mesopores are selectively functionalized with MgO solid base nanoparticles. Active site compartmentalization and substrate channelling protects base-catalysed triacylglyceride transesterification from poisoning by free fatty acid impurities (even at 50 mol%), and promotes the efficient two-step cascade deacetalization-Knoevenagel condensation of dimethyl acetals to cyanoates.