Hi,
I have a custom attribute "point" for each of my products. I would appreciate if anyone can guide me on how to add and keep track of these custom attributes/fields:
1) Add "point" field to "sales_invoice_item", "sales_order_item", "quote_item"
- Sort of like price field in each of these tables. Just copy over point value from product attribute
2) Add "total_point" field to "sales_invoice_item", "sales_order_item", "quote_item"
- point x qty
3) Add "total_point" field to "sales_invoice", "sales_order", "quote"
- Sum of total point of each ???_item's total point
