I have a project in which there are multiple products, brands and retailers. I want to understand how to set prices to the products based on the price set by retailer for that particular state
The relation between these are given below:
1. Product many2one Brand
2. Brand many2many Retailer
- Each brand can have only one retailer in every state they operate.
- Brand can have multiple retailers in the country bu tonly one in a state.
3. Retailer may have a single address for each state from where they conduct their operations.
What is an efficient model to develop this environment so that it is easier for the client to update the data at a later date.
The changes may include -
Brand retailer change in a state.
Brand stops operating in a state.
I do not want to keep the addresses of retailer where they used to deliver a particular brand from.