Check the historical documents to which the public can not easily get to these days. I.e. way back machine or whatever. The reasoning was provided there.

Quote Originally Posted by lat9 View Post
... and if a category is on sale, IMO, the sale should apply to all of its products, whether via master_categories_id or linked.
Quote Originally Posted by torvista View Post
Agreed.
And so a product could be bought from two different lists of the same site at two different prices or would the sales be cumulative by all sales applied to every category?

Category 1 has category 2, category 3, and category 4 in it.
Product 1 has a master_categories_id of 2.
Product 1 is linked to category 3.
Product 1 is linked to category 4.
Sale of 20% off on category 2.
Sale of 50% off on category 3.
If product 1 base price is 10, has no attributes, no other discount pricing like a coupon or special, then for what price is it on sale under the proposed premise? 10, 8, 5?

Under the current arrangement/programming, at every location that product 1 is shown it would be 8.