"Dad, I need pads for my period."
You know he is your dad, and not a total stranger, right?
Plus he should already know about this kind of stuff.
Don't be shy, if you hide conversations like this, future ones might just get more awkward.
Trust me, just get it over with. Ask him to give you a ride to get some. :)
Me, Myself and I