Selling by fixed bundles

Hello,

I am trying to find a solution to my need to sell products in three different formats for the same product, which is also the same way I would purchase the products.

For example:

  • small package of 50 pieces for 2.00 euros/each
  • medium package of 200 pieces for 1.00 euro/each
  • large package of 1000 pieces for 0.50 euros/each

If a customer needs, for example, 2550 pieces, they would have to purchase:
3 x small packaging of 50 pieces for 2.00 euros/each → total 300.00 euros
2 x medium packaging of 200 pieces for 1.00 euro/each → total 400.00 euros
1 x large packaging of 1000 pieces for 0.50 euros/each → total 500.00 euros

Grand total €1,200.00

I have found three ways to do this:

Solution A:
Make a significant change to the code by adding a box where the total quantity required is entered and the number of formats needed to cover the request is calculated.

Solution B:
Add three product variants, but this causes too much confusion for the customer.

Solution C:
Using a quantity discount, but since I cannot enter a fixed discount amount (e.g., the price difference between small and medium packaging), I cannot use it at the moment because it is only possible to set a new price/unit, and this would cause me to lose money. For example, in the first case, if they buy 350 pieces, the price would drop, while I would find myself buying a box of 200 pieces plus 3 boxes of 50 pieces.

Furthermore, solutions B and C would not be optimized in terms of price. For example, in the first example, it would be better to purchase two packs of 1000 at a total price of 1000 euros (2x1000x0.50).

Is there any functionality in Shopware that handles this situation other than those mentioned above?

This is the way to go. I do not understand what can be confusing about sized packs? This is a box with 50 items, this is a box with 200, etc.

You can find these variants on Amazon and any other store.

Often it is cheaper to buy more, e.g. one 1000, even if you only need 800.

I tried this solution and it works very well, except that in my case, having to manage the sale of screws with 200k products, a user may have to add different quantities for each screw size, and this could create a lot of work for them.
What’s more, this way there is no way to get a clear overview of what they are buying in the shopping cart.
@Max_shop, don’t you think this could cause frustration for the customer?

If you know your customers, maybe ask them. Or look what the competition is doing.