pie pumpkins, also called sugar pumpkins, are smaller in shape than the monstrous pumpkins you'd find at your typical pumpkin patch. sugar pie pumpkins are commonly found in the grocery store in the produce section or at farm stands.