I find it incredibly disappointing when a store advertises a product in their ad, but the product hasn't been shipped to their store since February. If you don't have it, don't run a promotion for it!
I will give kudos to the customer service agent for being really nice even though there was no resolution.