Define a specific discount for every customer on every category
I would like to know how and if it is possible to set the following in eCart:
I have different products' category/brands and I need to set a specific discount for each of them to every customer. To explain better. Customer 1 is an electrical repairer and normally buys products from brand "AC" and brand "DC" and brand "Cable". As he is a regoular customer and buys good quantities, I want to give him a discount on those brands only on a list of 10.
Obviously, his discounts will differ from those of Customer 2 that is not so regoular, and Customer 3 that is my best customer.
So, after this example, have you understood what I need?
I have a table with the Customer (user) data (id, username, name, password, email, address, phone) and a table with all the Brands.
I was thinking to create a table, into the Customer Admin page (the admin page where I look at their orders and status) where list all the Brands and set a specific discount (if any).
Then, how to handle this in the eCart shopping process? How to show all the discounts on the confirmation order page?
Thanks in advance for your suggestions and help!