Price Variations

Get Help Database
1

Hi everyone!

I am quite new to Adalo, trying to built an ecommerce app. The challenge I can’t solve is having to implement variable pricing. What I mean is:

A product has multiple sizes, and the specific size has a specific price.

Can’t wrap my head around how to organize the collections?
Thanks for the help!

1 Like
2

Hi and welcome to the community,

Thats a pretty simple setup actually. You need to have 2 collections linked to each other.

Collection #1 - We will call this “Products”

  1. Product Name (Text Field)
  2. Product Main Image (Image)
  3. Product Availability (True/False) - to control visibility

Collection #2 - We will call this “Product Sizes and Prices”

  1. Product Name (Text Field)
  2. Product Name Relationship to Collection #1 (One “Products” can have many “Product Sizes and Prices”) - check notes
  3. Size (Text Field)
  4. Price (Number Field)
  5. Total Qty (Number Field)
  6. Available Qty (Number Field)
  7. Sold Qty (Number Field)

With this collections design, you can have different pricing for different sizes of one product.
You would need to create a new item in Collection #2 for each size.

Note If lets say you sell 3 different tshirt designs, yet Size S is $10 and Size M is $20 and Size L is $30 irrespective of the tshirt design, then I would choose the Product Name Relationship to Collection #1 to be a Many-to-many relation (i.e. Many “Products” can have many “Product Sizes and Prices”.

Hope this helps!

3

@lexflorea You can expand on Collection #2 and include properties such as Discount % or Discounted Price, etc

4

Thank you for your prompt answer.