# Data Structure for one product with multipe urls & prices

**URL:** <https://forum.bubble.io/t/data-structure-for-one-product-with-multipe-urls-prices/140607>\
**Category:** Questions\
**Created:** [March 11, 2021, 1:29am UTC](https://forum.bubble.io/t/data-structure-for-one-product-with-multipe-urls-prices/140607 "2021-03-11T01:29:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mack2580](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mack2580/32/46145_2.png) [@mack2580](https://forum.bubble.io/u/mack2580)\
**Post date:** [March 11, 2021, 1:29am UTC](https://forum.bubble.io/t/data-structure-for-one-product-with-multipe-urls-prices/140607/1 "2021-03-11T01:29:54Z")

</div>

I’ve trying to take a similar concept from one my favorites sites but I’m struggling with how to implement it.

So in pcpartpicker

you’ll have a product say

AMD 5950x then that product will have multiple different merchants will each merchant price attached to them. For example

AMD 5950x  
url to Bestbuy $699 Out of Stock  
url to Newegg $759 In Stock  
url to Amazon $712 out of stock

How to I go about creating the Merchant Data Structure? Then tieing the proper info such as URL, price, and Stock back to the amd 5950x?

---

<div class="post-metadata">

**Author:** ![Neil\_Williams](https://avatars.discourse-cdn.com/v4/letter/n/e56c9b/32.png) [@Neil\_Williams](https://forum.bubble.io/u/Neil_Williams)\
**Post date:** [March 11, 2021, 12:59pm UTC](https://forum.bubble.io/t/data-structure-for-one-product-with-multipe-urls-prices/140607/2 "2021-03-11T12:59:33Z")

</div>

Hi Mark,

How I see it you have two datatypes: One called product and the other called Merchant and one option set

Option set called Status In stock and out of stock  
For Merchant, you can have a  
**text field type for the url link** , called URL  
**status field for the status** , called Status  
**number field** , called Price

The product datatype can include  
**Merchant field** which has multi  
**text field** called Name  
and whatever else you will like

The objective here is to link a merchants to products . Hopefully this helps

Cheers!

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [March 11, 2021, 1:47pm UTC](https://forum.bubble.io/t/data-structure-for-one-product-with-multipe-urls-prices/140607/3 "2021-03-11T13:47:16Z")

</div>

Hi!

Perhaps a structure like this:

Merchant  
Name (text)

Product  
Name (text)  
Merchant (merchant)

This way you can look up all products of a merchant. If you had a list of products under merchant it would slow down your app once you hit 100+ products. By doing it indirectly, you can have a more performant app.
