Discounts scoped to products at a specific retail location

I want an Advanced Discount Code that applies only to products that are in stock or assigned to a specified retail/location (i.e., restrict the discount to inventory at a particular physical store).