If you are using the Shipping Pass and you want  to subtract the shipping cost you have to add an additional formula for walmart


Use this formula


(-1*(min(max(50-vendor_price, 0),1))*5.97)