More specifics about sale strategy and calculations
I currently have a table with sale products. I join this table to my products table using a sub-query so that it only pulls in sale items that are active. In the "sale" table, I have part number, active, saleprice and sale code that is unique to each sale.
I register this sale code with the "Add To Cart" button. So, if the product is on sale, each item that they add to cart will be flagged with a code if it has one. So, I think everything is in place to work if I could just figure out a calculation that would reduce only the "flagged" items with a 20% sale price.
This is the way I would prefer to do it but the only other way to accomplish this is to have the customer login to a sale page where only those products can be purchased.
For me, this feature keeps being requested and I would REALLY like to figure out how to do it.