National Canadian Drug Store Poor Merchants

I went to a national Drug Store chain (name withheld until they have time to respond ) in Victoria to purchase Colgate toothpaste on sale for .44 cents but there was no stock and no manager on duty to make a substitution (crest would have sufficed and would be on sale the next day for about the same price) the clerk said she could not make a substitution. Had a manager been available, perhaps I wouldn't have wasted my time. Also, no rain checks were being offered although this, nor a limit was stated in the ad. Were there a limit, perhaps there would have been sufficient stock for me as well. Is this how (the national chain drug store) wants to conduct themselves as a retailer? I have been alienated due to this and may never shop at their stores again due to this. A lost customer is bad for business, but I shouldn't have to tell them that either. UPDATE March 30/07: I received an email from SDM Customer Service saying I should have received a raincheck. The merchant will honor the advertised price. However, I feel I should not have had to complain in this manner. Fight for your rights!