Airtable

How to create a product catalog in Airtable?

Discover how to easily build an all-encompassing product catalog using Airtable. Follow straightforward instructions starting with database setup, moving to inventory organization, and ending with optimizing everything to suit your needs perfectly.

Developer profile skeleton
a developer thinking

Overview

Crafting a product catalog in Airtable offers a seamless method to keep tabs on your inventory. This tool mixes the ease of a spreadsheet with the robustness of a database. Perfect for managing products, prices, descriptions, stock levels, and beyond. With the right approach, you can create tables, set up fields, and neatly organize your info. Whether you're running a tiny shop or overseeing loads of stock, understanding how to use Airtable's capabilities will supercharge your cataloging and boost efficiency.

Get a Free No-Code Consultation
Meet with Will, CEO at Bootstrapped to get a Free No-Code Consultation
Book a Call
Will Hawkins
CEO at Bootstrapped

How to create a product catalog in Airtable?

Step 1: Set Up Your Base

  1. Open Airtable and log in, or create an account if you don't have one yet.
  2. Click on the "Add a base" button.
  3. Choose "Start from scratch" and give your new base a name, like "Product Catalog".

Step 2: Create and Customize Tables

  1. Your new base will start with one table named "Table 1". Rename this table to "Products".
  2. Click the "+" icon next to the table tab to create more tables if you need them, like "Categories" or "Suppliers".

Step 3: Define Fields for the 'Products' Table

  1. Change the first field (default "Name") to "Product Name".
  2. Add other fields by clicking the "+" icon on the right side of the existing fields. Possible fields include:
  • SKU (Single line text)
  • Price (Currency)
  • Stock Quantity (Number)
  • Description (Long text)
  • Product Image (Attachment)
  • Category (Linked Record, linking to the "Categories" table)
  • Supplier (Linked Record, linking to the "Suppliers" table)

Step 4: Populate the 'Categories' Table

  1. In the "Categories" table, rename the primary field to "Category Name".
  2. Optionally, add other fields like:
  • Description (Long text)
  • Category Image (Attachment)
  1. Enter your product categories into this table.

Step 5: Populate the 'Suppliers' Table

  1. Rename the primary field of the "Suppliers" table to "Supplier Name".
  2. Add relevant fields such as:
  • Contact Person (Single line text)
  • Email (Email)
  • Phone (Phone number)
  • Address (Long text)
  1. Fill this table with the details of your suppliers.

Step 6: Link Tables

  1. Make sure the "Category" field in the "Products" table is a Linked Record pointing to the "Categories" table.
  2. Make sure the "Supplier" field in the "Products" table is a Linked Record pointing to the "Suppliers" table.
  3. Now you can select categories and suppliers for each product from the linked tables.

Step 7: Input Product Data

  1. Go back to the "Products" table.
  2. Start entering your product details row by row, filling in each field accordingly.

Step 8: Create Views

  1. Click the "Grid view" dropdown in the "Products" table to add new views.
  2. Create different views like "Gallery" for a visual representation or "Kanban" to organize the products by category.
  3. Customize each view to show the fields relevant to that particular perspective.

Step 9: Customize Formulas and Automations (Optional)

  1. Add formula fields if needed, like calculating the total value of stock.
  2. Automate tasks using Airtable's Automations feature, like sending a notification when stock is low.

Step 10: Share and Collaborate

  1. Use the "Share" button to invite team members to your base.
  2. Define their permissions so they can view or edit the catalog as needed.
  3. Use the "Share view" option to create a shareable link to a specific view of your product catalog.

Explore more Airtable tutorials

Complete Guide to Airtable: Tutorials, Tips, and Best Practices

Explore our Airtable tutorials directory - an essential resource for learning how to create, deploy and manage robust server-side applications with ease and efficiency.

Why are companies choosing Bootstrapped?

40-60%

Faster with no-code

Nocode tools allow us to develop and deploy your new application 40-60% faster than regular app development methods.

90 days

From idea to MVP

Save time, money, and energy with an optimized hiring process. Access a pool of experts who are sourced, vetted, and matched to meet your precise requirements.

1 283 apps

built by our developers

With the Bootstrapped platform, managing projects and developers has never been easier.

hero graphic

Our capabilities

Bootstrapped offers a comprehensive suite of capabilities tailored for startups. Our expertise spans web and mobile app development, utilizing the latest technologies to ensure high performance and scalability. The team excels in creating intuitive user interfaces and seamless user experiences. We employ agile methodologies for flexible and efficient project management, ensuring timely delivery and adaptability to changing requirements. Additionally, Bootstrapped provides continuous support and maintenance, helping startups grow and evolve their digital products. Our services are designed to be affordable and high-quality, making them an ideal partner for new ventures.

Engineered for you

1

Fast Development: Bootstrapped specializes in helping startup founders build web and mobile apps quickly, ensuring a fast go-to-market strategy.

2

Tailored Solutions: The company offers customized app development, adapting to specific business needs and goals, which ensures your app stands out in the competitive market.

3

Expert Team: With a team of experienced developers and designers, Bootstrapped ensures high-quality, reliable, and scalable app solutions.

4

Affordable Pricing: Ideal for startups, Bootstrapped offers cost-effective development services without compromising on quality.

5

Supportive Partnership: Beyond development, Bootstrapped provides ongoing support and consultation, fostering long-term success for your startup.

6

Agile Methodology: Utilizing agile development practices, Bootstrapped ensures flexibility, iterative progress, and swift adaptation to changes, enhancing project success.

Yes, if you can dream it, we can build it.