I am trying to figure out what the best way to store tax rates is. Each of my products would be assigned a tax class such as:
- Standard rate
- Reduced rate
- Zero rate
Each of these tax classes has a value:
- Standard rate - 20%
- Reduced rate - 5%
- Zero rate - 0%
I don’t want to store the actual rates at product level as that does not make sense if things change in future. My dilemma is:
- Do I create global constants?
- Do I create another sheet that stores tax rates and use link and load?
Appreciate your help.