Okay
  Public Ticket #3745413
The price depends on the total weight of the supplier's goods in the order ...
Closed

Comments

  • Dennis started the conversation

    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

  •  2,212
    WebWizards replied

    Hello Dennis,

    Thank you for getting in touch,

     

    I'm afraid our plugins do not have a way to do this based on weight.

     

    Generally I think it is quite feasible to do it with a custom code snippet. I would suggest to look at a simple snippet that adds a fee to the cart page, for each supplier, based on weight. It may be possible to write a simple snippet for it just with the help of chatgpt or similar tools,

     

    Kind regards,

    Stefan