Price Comparison Table Build

[Kevin]

Hi, I am creating a Price Comparison Site/Table and need help how to create the main table. We will offer multiple products, with multiple features, from multiple vendors.Customers need to be able to choose different products from different providers - and one single total sum calculated. An example is below.
Important: I have limited tech knowledge, but I must be able to edit the tables myself after go-live and not have to rely on anyone else. Thanks all. Kevin.

Process:

1. Choose a Base Product / Product(s)

2. Choose from various product features for each chosen product(s)

3. Press “get quote” (show list and price from all vendors who provide the chosen product and chosen product features.

4. Choose preferred Vendor(s).

5. Show Summary Total of total price for all products chosen.

6. Allow user to click on each vendor offer to either (order now, or buy now, or ask for more information).

   Vendor 1 vendor 2 vendor 3 vendor 4 vendor 5 vendor 6 vendor 7 vendor 8 vendor 9 vendor 10
   Product A € 100 € 110 € 120 € 130 € 140 € 150 € 160 € 170 € 180 € 190
   Product A € 120 € 140 € 160 € 180 € 200 € 220 € 240 € 260 € 280 € 300
   Product B € 140 € 140 € 140 € 140 € 140 € 140 € 140 € 140 € 140 € 140
   Product B € 160 € 160 € 160 € 160 € 160 € 160 € 160 € 160 € 160 € 160
   Product C € 180 € 180 € 180 € 180 € 180 € 180 € 180 € 180 € 180 € 180
   Product C € 200 € 200 € 200 € 200 € 200 € 200 € 200 € 200 € 200 € 200
   Product D € 220 € 220 € 220 € 220 € 220 € 220 € 220 € 220 € 220 € 220
   Product D € 240 € 240 € 240 € 240 € 240 € 240 € 240 € 240 € 240 € 240
   Product E € 260 € 260 € 260 € 260 € 260 € 260 € 260 € 260 € 260 € 260
   Product E € 280 € 280 € 280 € 280 € 280 € 280 € 280 € 280 € 280 € 280

Total for Products Chosen €920

[Pierce_Baugh]

Hi Kevin,
Airtable is fantastic software and has amazing capabilities. That said, what you’re looking for is out of the sweet spot for Airtable. The application you suggest would require an individual to log in and interact with a custom set of data. Airtable is more of a shared space, if you have the ability to edit one record you can edit others. There are a number of other things you mention such as an “order now” button which does not exist in Airtable capabilities. You could use it as a back end database but most of what you’re talking about would need to be built in another tool. You’ll either need to simplify your requirements or look at other platforms. I invite others to agree/disagree, but I don’t see this working for this use case.
Best of luck
Pierce

[Kevin]

Hi Pierce, many thanks for your reply and input.

Much appreciated.

Kevin.

[Ken_Moholt-Sieb]

I agree with the prior comment that you may be asking for something that Airtable is not designed to do. You might be able to try this though:

Table VENDORS to list all vendors, with a column for products, which are linked to…
Table PRODUCTS list all products and prices, which could have a column if you want that looks up the vendors, and would definitely have a column for variations that is linked to…
Table VARIATIONS that would list various variations and the cost for each of these. If you things get complicated, you might have to have a join table where…
Table PRODUCT-VARIATIONS, each product-x-variation combination is listed, with the relevant price
Table QUOTES, where each row is a numbered quote, and the columns are Quote No., Customer, Product-Variation, Vendor, Price

Then,

Group the table, QUOTES, by customer.

Now,

Create a form from QUOTES, to populate the customer’s information and choices into the table.

This works so far as it goes, but your form won’t show the customer the totaled price. You’d have to take an email from the form and then respond to the customer with the price.

---

Alternative to Airtable would be an online shopping cart such as Square, Ecwid, WooCommerce, or any number of other options. This would get you the product list, categories of products, variations of products, and even discount options, shipping options and costs.

–Ken