Chiming in here to follow along and to say that I also need discounts code to apply to MSRP (compare at price) instead of the sale price. Seems like it would be quite easy to implement by Shopify or an app.
I have a bunch of sponsored athletes and coaches, and their discounts need to apply to full price. My scenario is quite common in the outdoor sports industry. My workaround is to always use discount codes for sales, but that has a few major downsides.
1) I have a lot of variants, and if I'm overstock on one particular variant, I run a deeper sale on that specific variant. This doesn't work easily for customers with codes.
2) Google shopping really needs a sale price, not a code, otherwise you're just advertising your MSRP, not your discount price. This obviously isn't going to convert.
Seriously. We need this issue fixed! We have a sale collection. Excluded from most discount codes HOWEVER.... if you uses a rewards program and they are generating codes for discounts.... the customer is then able to use it to get additional sale. Our sale items are 30% marked down, but a customer just used their 25% off code. SO they got 55% off. Please Shopify help us.
Derek, you magnificent problem solver. This solution worked a treat! I couldn't figure out how to exclude products from discounts (as it's not a built-in Shopify feature) but this workaround did the job for me. I did not realise before that entering $0 into the Compare At Price has virtually no effect on the frontend, but can be used for rule setting in the backend.
Thank you for sharing your expertise!
Thanks for posting this. It is a really simple but elegant solution. Ideal for flash "discount" sales that won't discount already on sale products.
For those who don't understand the steps, this is what I did: