If you put sugar in granulated or powdered solid form into soda, it’ll create a lot of convection points and the soda will rapidly foam up and lose a lot of its carbon dioxide.

You could use a sweet syrup instead.