How to add transparency to material

Change Blend Mode (detail panel in the bottom left) to Translucent or Additive. This will enable the Opacity pin on the material node. Plug in the grey pin from the Texture Sample there.

Should work.