The price depends on the total weight of the supplier's goods in the order ...

Hello,

Is it possible somehow using your plugins to realize the price of the goods in the order based on the total weight of the goods in the order of a particular supplier or maybe you can recommend something else?

Initial data

The supplier has three products: product 1, product 2 and product 3.

The minimum order is 500 kg

The prices of all goods is equal to price 1, price 2 and price 3 with a total order weight of more than 5 tons

With the total weight of the order of goods from this supplier from 1.5 tons to 5 tons, the prices of all goods is equal to (price 1 + 5%), (price 2 + 5%) and (price 3 + 5%)

With the total weight of the order of goods from this supplier from 0.5 tons to 1.5 tons, the price of all goods is equal to (price 1 + 10%), (price 2 + 10%) and (price 3 + 10%)

The weight is calculated only for the products of a specific supplier in order

================================================================

For example,

Price 1 = 10$

Price 2 = 6$

Price 3 = 3$

-------------------------------------------------------------------------------------------------------------------------------

Order 1 (Total Weight = 5300 kg) → 1200 kg of Product 1, 2000 kg of Product 2 and 2100 kg of Product 3

Then the price of the goods is equal to

Price 1 → 10,00$

Price 2 → 6,00$

Price 3 → 3,00$

Order value 1 = (1200kg*10,00$) 12000$ + (2000kg*6,00$) 12000$ + (2100kg*3,00$) 6300$ = 30300$

-------------------------------------------------------------------------------------------------------------------------------

Order 2 (Total Weight = 3300 kg) → 1200 kg of Product 1, 2000 kg of Product 2 and 100 kg of Product 3

Then the price of the goods is equal to

Price 1 + 5% → 10 + 5% = 10,50$

Price 2 + 5% → 6 + 5% = 6,30$

Price 3 + 5% → 3 + 5% = 3,15$

Order value 2 = (1200kg*10,50$) 12600$ + (2000kg*6,30$) 12600$ + (100kg*3,15$) 315$ = 25515$

-------------------------------------------------------------------------------------------------------------------------------

Order 3 (Total Weight = 600 kg) → 200 kg of Product 1, 200 kg of Product 2 and 200 kg of Product 3

Then the price of the goods is equal to

Price 1 + 10% → 10 + 10% = 11,00$

Price 2 + 10% → 6 + 10% = 6,60$

Price 3 + 10% → 3 + 10% = 3,30$

Order value 3 = (200kg*11$) 2200$ + (200kg*6,6$) 1320$ + (200kg*3,30$) 660$ = 4180$

Best regards