This is due to the culling and depth settings. There are Presets in the shader at the bottom, including: Opaque, Transparent, Additive, Transparent Additive, Opaque Cutout. For example, transparent objects need to have Z-Write disabled and Render Queue at 3000 or higher.