Hi there!

You could add a variation to a product by either creating a list of variations field to the product or adding a product field to the variation data type.

To retrieve the variation on the product page you could do either reference to the product’s variation list field or search for variations with a constraint of the page’s product.

Here’s how the db structure could look like:

List:

Product:

  • Product name
  • Product Description
  • List of variations (Variation data type)

Adding the product in the variation:

Variation:

  • Variation Name
  • Variation Description
  • Product (Product data type)

To create a variation, you just create the variation data and add it in the list of variations field or add the product in the variation’s product field (depending on which route you would do)