Product Price / Sale Price Automatic update

[mcfc4eva]

How are the product price and sale price updated when affected by the pricing formula?

E.g.
Formula;
$0 < cost < $1, Price = $5
$1 < cost < $2, Price = $10

If the supplier cost is originally $1.50 but their sale price is $0.75 (50%). What does my SALE and PRODUCT price become?

 

[mcfc4eva]

Okay I've figured it out with a bit of experimenting. It seems pretty obvious in hindsight, but I'll post how it works here in case anybody else is wondering the same;

The formula is applied to SUPPLIER ORIGINAL price to give your STORE PRODUCT price and also,
the formula is applied to the SUPPLIER SALE price to give your STORE SALE price.
The difference (if any) is then calculated and displayed as a percentage.