Total Posts: 40
Unfortunately I’m not sure this is possible with the logic available. You can add price rules, but the mix of logic you’d need isn’t there.
The only thing I could think of to get this to work with the logic available is going to be pretty cumbersome. But I’ll just throw it out there. You could create a new product attribute called “Ascending Price” which would be a number (1, 2, 3, 4, etc.). Each product is assigned a number (and it has to be unique, so there can only be one ‘1’). So ‘1’ would signify the cheapest product you have available, ‘2’ is the next cheapest product, etc.
Then you could create a pricing rule based on the ‘Ascending Price’ attribute… but you can see how this could be a maintenance nightmare.
Although, if you use Import/Export, it actually probably wouldn’t be that difficult since you can sort and apply those numbers pretty quickly in Excel.
Confused? Hope this helps!
(if anyone knows of a better way, please reply!)