"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!

[aimeos]

Aimeos doesn't support nested customer groups that would be necessary for your price list structure due to performance reasons. Depending on the complexity of your price list structure, there are two options during product import:

1.) You can merge the nested price lists and create one customer group for each imported price which contains all customers this price is for - but updating the new groups can be complex.

2.) After merging the nested price lists, assign the customer directly to each price. This makes updating much simpler but the list of assigned customers per price item can be very long. That shouldn't be a performance problem but check the loading time in the admin backend (the frontend can handle large assignments without problems).