"Custom price lists" for different customers

[columbo]

Hi,

in addition to the standard price list (PL-Default), we use a wide variety (up to 4.000) of custom price lists.
- Custom price lists can contain several hundred products.
- Custom price lists can be assigned to one or many customers.


Example price lists (PL):
PL-Default:
- Prod 1: 5,90€
- Prod 2: 6,00€
- Prod 3: 8,00€

PL-1:
- Prod 1: 5,50€
- Prod 3: 5,00€

PL-2:
- Prod 2: 4,50€
- Prod 3: 4,00€


Customers with PLs:
Cust-1
- PL-Default
- PL-1

Cust-2
- PL-Default

Cust-3
- PL-Default
- PL-1
- PL-3


What is your recommendation for implementing the described concept?

We already use the "Customer or customer group specific items" extension.
so, our approach would be:
- Create an individual 'customer group' for every 'custom price list'.
- adding an individual price item to every product and assigning this price item to a "customer group" (i.e. a custom price list).

Unfortunately, due to the large number of price lists (customer groups) and products with their own prices (price items), this becomes quite complex and the display very confusing.
- Are there better or easier options?
- Is there a price list item that can be assigned to a customer?

thank you!