Here's a link to our store: http://appalshop.org/store/
We have set up attributes for our films and records in order to allow customers to select format (VHS, DVD, Cassette, etc.) and licensing (Home Use, Educational, etc -- which only applies to our films).
The only exceptions are some products where we offer one license or format, and some of these items to not have attributes.
We would like to discount CDs and Home Use film licenses by $5.00.
Right now I have come up with a scheme of three sales which kind of gets us where we need to be:
Sale 1: Discounts items in our films and music categories that are between $14 and $31 by $5.00
Sale 2: Discounts items in films that are between $0.00 and $0.00 by $5.00 (Side effect: discounts licenses other than Home Use)
Sale 3: Discounts items in Recordings by Format > CD that are between $0.00 and $0.00 by $5.00 (Side effect: had to reassign these products to use the format category as master category, also discounts formats other than CD for these items)
I might be able to set up a test item or something like that to help you diagnose, but unfortunately we're taking an order or two an hour right now and I don't want to do too much testing that affects the whole store. Do you have any recommendations on how to make it easier to demonstrate what is happening?