Forum Academy Marketplace Showcase Pricing Features

Help with a door, window and sliding windows online store

Hello everyone,
I have a bit of struggle with a online store where an user, logged in or not, can make a project in which he can choose a door, a window or a sliding window. Each has different fields but with some identical fields. For example a sliding window doesn’t have the same particularities as a door but both have dimensions.
Also, at the end, to buy the items, the user has to connect or create an account.
So what I did is I created a table Project, a table Window, a table Door, a table Sliding Window, a table Cart and a table List Cart for the moment.
And I’m struggling with the cart displaying at the end.
And I can’t have a product table.
If you need more info please ask.
Also, I’m fairly new with bubble and maybe my DB is miscreated.
Thanks for the help !

Hi,

Try to have new datatype table called “Categories”, which contains all the type of things (Door, Window, Sliding Window etc) like names (it does not contain any other fields like quantity. just put names)
Create another datatype table called Product/Project. add new field as Categories and add more fields as your wish.

Create another datatype table called “Cart” when user/customer adding product to the cart add things to Cart table based on user/customer.

It can be easy to display the list of cart items based on the user/customer.

1 Like

Thanks for the answer !
Just to be sure, the specific fields for each type of things will be saved in Product am I right ?
Also, when you say:

Try to have new datatype table called “Categories”, which contains all the type of things (Door, Window, Sliding Window etc) like names (it does not contain any other fields like quantity. just put names)

You mean that in Categories Table, I have a Door with type of Door and so on right ?

And the tables Doors, Sliding Windows and Windows are filled by the user

Product have all the details about the item like color/size/dimensions/quantity/price etc.

Category will be the type of various products like liquid / solid / wooden (for this case you can choose door, Sliding window , window etc) these are just a names.

But major details to be filled in the product table.

So you should list out the product table in website, user will add these items to their cart.

Cart table have list of product things with user.

You just list out the cart things filtered by user, you have all the cart products added by user.

So, if I have a field Filling Type unique to a Door, I have to put this field in Product Table right ?
And yes, I have to filter the cart depending of the User Project ID.

For now, all the choices are made in the Front-End. Example: a color is written in a Dropdown for now. But I will store them in the database in the future.

Thanks for your reply and sorry to bother and to make you repeat.