Product bundles

Hi, Is this possible to configure bundles of products that can add a pre-set number of products to quotes easily?

Thanks,

Sam

Hi Sam,

You can definitely  add a many to many relationship in Product Catalog module and do few modifications to achieve this.

Adding relationships to product catalog is bit tricky but we have a blog on our website that helps you get ideas.

https://www.bhea.com/blog/sugarcrm-developer-tutorial-on-creating-many-to-many-relationship-with-product-catalog/

Once you add the relationship, you need to make some modifications to achieve your goal.

We have a CPQ native add on that we built for SugarCRM - This has both discount policies, options and features for product catalog and bundled products.

https://www.bhea.com/crm-solutions/bhea-enhancements/cpq-configure-price-quote-solution/

However the best is to extend the product catalog module and change the add to quote functionality.

Excuse my ignorance, but why would we need many-to-many relationship for the scenario of Main product catalogue related to a custom module for elated products?

Why wouldn't a one-to-many work?

Sometimes some of the products might be part of more than one bundle. 

So if you have product bundle 1, and has Product Catalog Item 1, 2 and 3. 

And when you create product bundle 2, and want to add Product Catalog item 4, 5 and 1, the one to one relationship will not work.

If this type of scenario does not work, may be one to one will work. 

Sometimes some of the products might be part of more than one bundle. 

So if you have product bundle 1, and has Product Catalog Item 1, 2 and 3. 

And when you create product bundle 2, and want to add Product Catalog item 4, 5 and 1, the one to one relationship will not work.

If this type of scenario does not work, may be one to one will work. 

if you use a custom module for the 'Related Products' and create a one-to-many, from Product Catalogue to Related Products, and also one-to-many from Related Products to Product Catalogue, it seems to work fine, or have I missed something?

Hi Tony,

Your approach also work fine. 

However you are introducing a new module called "Related Products" that comes with extra effort of maintaining a new module. 

What I am recommending is to create "many to many" relationship between "Product Catalog" to "Product Catalog".  And creating "many to many" relationship between product catalog to product catalog is not that easy so I have forwarded the blog for doing that.