Walgreens

I recently received a sales flier for Walgreens. I drove to my local Walgreens to buy the Charmin toilet paper on sale and there was none on the shelf. I also did not find it on any displays. I asked the manager Mike Sullivan where it was and he said they didn't carry it.
Is this normal. Do you really offer sale items only at specific locations? On this day I had a coupon for $9 off if I spent $30. I had to put all my stuff back and go to another store.

best,
Victor Poulin