Multi-Seller Pricing for Items - Need Advice

Hello,

I’m considering creating an app, and I’m wondering if it’s feasible to include a feature where users can list prices for items, like a wooden chair. I want to invite three friends (let’s call them person 1, person 2, and person 3) to enter their respective prices for the same chair. When users search for chairs on the app, it should display the prices for the same chair from different sellers. Is this possible to implement in an app, and if so, how would I go about doing it?

The wooden chair item is also in the database which was already added by me, so what they have to do is put the price

Thank you!

Add a array of prices to the items table. Let’s say prices has user/seller and price. Then when displaying the chair show a rg of the prices records associated (you’re leaving out inventory which may be important to a count for now as you create the dDB architecture)

I see Thank you! But for example, a user wants to search somewhere near him or a specific location like new york then it will only show the seller’s price near the location that was provided.

Sorry what’s an rg?

My bad. Repeating group. And then you’d add location to the prices table and filter out prices records that aren’t nearby

You’re a life saver, haven’t thought of doing it like this, thank you very much!

My pleasure.

Just keep in mind that if you don’t want to show items that aren’t available near the user you are going to want to flip around the setup so that the prices table has the item. That way you can do a search for prices records near the user and then group the results by item.

Otherwise you will have items displaying but no price records near the user (which may work for you but if it doesn’t then rearrange)

I see yes, this is also what i wanted to ask, thank you! So what i can do is recommend the buyer another place that’s closer to him?

It seems you first gotta scope out what tables and fields you need, as well as what kind of searches will be necessary.

I’d start with Understanding Bubble's Data Type Fields and What Is A Data Concept? | Bubble.io | What Is It And Why Use It? and really anything by @petter especially his book.