Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 7 replies
  • Subscribers 291 subscribers
  • Views 1960 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, 

    I am trying to do the same thing, glad you posted. Currently, I have not been able to achieve this either. I attempted to create the one-to-one relationship but it wasn't working how I intend for this to be configured.

    We have a requirement to have a parent product record for each 'item'. This would hold the latest version details of the item(s) that we sell. The sales team have price breaks per item, so still require several instances of the same item. 

    The idea was that our dev team update the parent record with new version details and then by an automated workflow, it updates all the child products so that they pull through the very latest version. This in turn would then pull through to the other modules that utilise the Product Catalogue.

    If any one has any suggestions, I would also be keen to know. 

    Jenny

Reply
  • 0

    Hi James, 

    I am trying to do the same thing, glad you posted. Currently, I have not been able to achieve this either. I attempted to create the one-to-one relationship but it wasn't working how I intend for this to be configured.

    We have a requirement to have a parent product record for each 'item'. This would hold the latest version details of the item(s) that we sell. The sales team have price breaks per item, so still require several instances of the same item. 

    The idea was that our dev team update the parent record with new version details and then by an automated workflow, it updates all the child products so that they pull through the very latest version. This in turn would then pull through to the other modules that utilise the Product Catalogue.

    If any one has any suggestions, I would also be keen to know. 

    Jenny

Children
  • 0 in reply to Jenny Connell

    Hi Jenny, I see what you're trying to do. 

    It sounds like you have multiple Product Template records, that are essentially the same product but duplicated for different qty levels? Like:

    Product A (Main)
    Product A 1-10
    Product A 11-20
    Product A 21-30
    Product A 31-40

    ...but you only want to update the details on the Main Product and have that filter down?

    What we're doing is creating a new module (module builder) and relating the products M:M and 1:M so we end up with one 'Parent' record and several 'Child' products which will be part of a 'bundle' of products. Our developer will be using custom code to handle the relationships as Studio is limited with this.