I think question is pretty clear and code is elaborating the problem more clearly,
I have variant table for Systems, Systems will have variant. With property I am checking Systems has any variants, if SysVariant table has any variant of Systems product I am defining result dictionary value on_sale as True. I am trying do other a lot of required maths with this so adding this on dictionary.
I hope I am able to elaborate the remaining confusions.