Hi Bubblers!
As this is my first forum message, I’d like to thank @emmanuel and the whole Bubble team for making such a great tool that can help us, non-developers, to create some cool apps! 
On the topic, I’m creating my first app, went through so many tutorials (videos, docs, forum topics…) but I just can’t get my head around it… I do not know how to setup a DB, I have followed some tutorials but it looked like I did not have the same options as in tutorial. I must have done some wrong steps but I could not find them…
Here’s the case.
- I’ll have a database of users of the app (I have already built the interface and all the logic for it, it works great! Added social networks logins, specific fields, etc…)
- I’ll have a database of products. Products will have several prices depending on the physical stores from which I’m collecting the data. I’m not sure how to manage that in the DB - as separate columns in table or as a list of prices?
- The user will search and list the products (I did it with Repeating Group and Fuzzy search and autocorrect plugin - thanks @dambusmedia !). I’m creating categories and filtering by it. I plan to create filters based on selected stores too but that can come later.
- The list of products should show minimal and maximal price for that product.
- The product in the list is clickable, so it opens up additional info about the product and shows all prices per stores (Product pop-up).
- The user should have +/- option in the list, in each product cell, as well as input filed if they want to enter the amount of product instead of clicking + sign several times. This should also be present on Product pop-up. By doing this, the user will fill in his shopping cart.
- Shopping cart should be “presentable” as Repeating Group where it should have similar options to increase/decrease amount or completely remove the product from the list.
- When on Shopping cart view, the user should have an option to create a Shopping list out of his actual Shopping cart. All the Shopping lists should be saved as some kind of history so user can see them later on…
Additional planned features:
- Users can share the Shopping Lists among them by entering the other user’s email address.
- Users can publish their Shopping Lists to the public environment, where some other user can pick it up.
If someone can help me with creating Shopping Cart and Shopping Lists that would be great, then I’m sure that I could advance further with some of these additional features that I was mentioning. I just do not know how to start, how to setup the whole database in order for this to work. 
Thanks in advance!