Product variation in marketplace

ynseif19 · 2024-09-02T14:00:13.512Z

I want to create a functionality where the merchant can create/add a product with multiple variation, for example tshirt size and color combination. Im stuck on how to structure this in a database . Also on how to retrieve this on product page. I would appreciate if anyone can help

ntabs · 2024-09-02T14:11:35.983Z

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)

ynseif19 · 2024-09-04T13:05:24.550Z

Hi

Thanks for the tip, Im working on it, currently I’m stuck in displaying the product price after the end-user select variants field from 2 dropdowns, I mean displaying the default price and also change the price whenever another variants selected from the combination of dropdowns. Ive put the price of each variation in the variation database.