Custom relational data for a product

TheTheraghaut
New Member
1 0 0

This is quite a head-scratcher.

 

I'm building an e-commerce website for a bookstore. A product (i.e. a book) has additional fields. One such field is the "author". An author can have multiple books. A book can also have multiple authors. Essentially, it's a many-to-many relationship in a relational database system.

 

When a user clicks on a book, it should display all of the book's authors. An individual author should have a clickable link to see other books (products) written by the same author.

 

Images attached for better explanation.

 

How can I produce this many-to-many relationship in my Shopify storefront? This seems like a very common scenario for a typical online store. I would be VERY surprised if Shopify couldn't handle the above mentioned use case.


example-1.png

example-2.png

example-3.png

Replies 0 (0)