Adding Custom options to products added to cart

Questions
1

Hi all,

I am absolutely stumped, I am a new user to bubble and cannot seem to find any information on this topic.

I am attempting to setup a clothing business where users choose the product they want, then add their size, color and quantity, attached to that product, to a cart that is then added to other products they have done the same thing to.

It does not appear that I can make multiple list entries to the cart field that contain these variables, only static, presets. that are already designated, which would mean i have to created hundreds of entries to allow for all the variables, which I am not about to do.

I am not certain if bubble has this capacity. I see many other clothing stores online have these type of options, where the user will choose a product then filter it to the point where they want it and then they add it to the cart, and the cart displays the list of multiple entries specific to the user, not every entry ever made in a data type.

The entries must be specific to the user and also be separated and must be retrievable to fulfill the order. It seems like this should be a matter of database setup under user, but the user fields will not accept multiple different entries, only changes to current entries, or adding to current entries, which also does not equate to success. Been wasting major time on this and need to know if I just move onto another builder to get this done.

I also see no models with this type of action available in any tutorials or anything, so I may be not using the right software.

All help or conclusions are appreciated.

2

Just create a data type called “Customizations” with inside has option sets for each of your types of customizable components and other data types like text/yes or no’s, etc.

Add that customizations table to a product, and each product will have their own customizations now.

May take you some time to get this right, but Bubble can 100% do what you intend it to do.

3

im lost at the part when you make changes to a thing,vtype is current user: user cart: add: then it wont let me select the drop down the option set is under

4

I have generated a sample DB diagram to showcase what I mean:

Users

  • user_id (PK)
  • username
  • email
  • created_at

Products

  • product_id (PK)
  • name
  • description
  • base_price
  • created_at

Customizations

  • customization_id (PK)
  • product_id (FK)
  • type
  • value
  • additional_price
  • created_at

Carts

  • cart_id (PK)
  • user_id (FK)
  • created_at

Cart_Items

  • cart_item_id (PK)
  • cart_id (FK)
  • product_id (FK)
  • quantity
  • created_at

Orders

  • order_id (PK)
  • user_id (FK)
  • total_price
  • status
  • created_at

As you can see, customizations are linked to a product. So each product will have a series of customizations. When you add that product to the cart, the customizations will show.

NOTICE
This example was generated by AI - so it’s likely not a perfect answer, but serves as an example. Do not expect it to work as intended without modifying.

5

thank you, I will work on it, appreciate it!