Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 7 replies
  • Subscribers 293 subscribers
  • Views 1967 views
  • Users 0 members are here
Related content from around SugarClub

Many to Many relationship with Product Templates

James Banbury

Hi, has anyone been able to create a many-to-many relationship with the Product Catalogue?

I'm trying to relate 'child' products to a main 'bundle product record (and then use custom code logic hook to pull in child products into new revenue line items when the bundle is selected.

I prefer to make relationships in Studio as the best practice is for most configurations to be done in this way.

I discovered that I cannot create any 'many' relationships with the Product Templates module.

Any ideas?

Thanks, JB

Parents
  • 0

    Hi James,

    We have implemented many-to-many relationship for the product catalog and discount policy / block pricing feature for the product catalog.

    Creating a many-to-many relationship requires code level modifications to few files. So you can create the Bundle Product. And using custom code we have added another tab "Bundle Products" to the "Product Catalog Dashlet" so that users can add the Bundled Product.

    This feature implementation is quite complex.

    However implementing a discount policy / block or tier pricing is much more simpler. For block / tier pricing implementation we dont need to have the parent-child relationship for the product catalog.

    We are planning to publish a blog soon on how to add the many-to-many relationship to product catalog. 

    Warm Regards

    Ram Kumar LK

    https://www.bhea.com

    Ram Kumar LK

    Sr Solution Architect

    https://www.bhea.com

Reply
  • 0

    Hi James,

    We have implemented many-to-many relationship for the product catalog and discount policy / block pricing feature for the product catalog.

    Creating a many-to-many relationship requires code level modifications to few files. So you can create the Bundle Product. And using custom code we have added another tab "Bundle Products" to the "Product Catalog Dashlet" so that users can add the Bundled Product.

    This feature implementation is quite complex.

    However implementing a discount policy / block or tier pricing is much more simpler. For block / tier pricing implementation we dont need to have the parent-child relationship for the product catalog.

    We are planning to publish a blog soon on how to add the many-to-many relationship to product catalog. 

    Warm Regards

    Ram Kumar LK

    https://www.bhea.com

    Ram Kumar LK

    Sr Solution Architect

    https://www.bhea.com

Children
No Data