Development of module for managing prices by attribute and quantity range

[Lapo Ferrini]

Hello everyone, we have a customer who needs particular management of prices by attribute and quantity range.

One of their products can have n combinations of attributes (e.g. size/colour) and can then be customized with a print performed in different ways (1 color print, 2 color print, four color print, etc) with the price varying by type of print and quantity range.

Let's take as an example a plastic pen for which you can choose personalized printing in 1 or 2 colours.

This product has a cost that varies depending on the quantity and type of print, according to the attached table (range.jpg).

Let's assume we have chosen 1 color printing:
If the quantity in the cart is 1, the cost is that of the minimum range (up to 100 pieces) or €0.70 because it is a "sample without printing".
If the quantity in the cart is > 1 and < 100 the cost is €0.70 + €40 as "Print contribution for quantities less than the minimum".
If the quantity in the cart is > 100 and < 249 the cost is €0.70.
If the quantity in the cart is > 249 and < 500 the cost is €0.36.
... and so on for the other quantity ranges.

For other types of printing, apart from the prices per quantity range, the cost of the "Print contribution for quantities less than the minimum" changes:
2 color print —> €70.00
four-colour printing —> €40.00

Note: if, for example, in the cart we have 125 pieces with "1 color printing" and 125 pieces with "2 color printing", these quantities are added and those in the 250 piece range are considered as the cost, therefore €0.36 respectively and €0.48
However, this does not apply if the sum does not exceed the "minimum quantity" which is equal to the value of the minimum range (up to 100 pieces), therefore we would still have the respective "Print contribution for quantities less than the minimum".

Does anyone know a module that allows this management, or does anyone propose to develop it?

Thanks to everyone who wants to respond.

Lapo