Create a Product Database In 3 Steps
Tags: database, application, tutorial, beginners
Published: 2024-05-07 22:58:48

<!-- wp:paragraph -->
<p><strong>Product databases </strong>are a critical source of information for brick-and-mortar or e-commerce businesses alike. They store everything your business needs to know about its products and serve as a single source of truth for anyone who needs information about products.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Let's find out how to create the perfect product database in just a few steps.</p>
<!-- /wp:paragraph -->

<!-- wp:essential-blocks/table-of-contents {"blockId":"eb-toc-8kiz9hp","blockMeta":{"desktop":" .eb-toc-8kiz9hp.eb-toc-container{ max-width:610px; transition:all 0.5s, border 0.5s, border-radius 0.5s, box-shadow 0.5s ; }  .eb-toc-8kiz9hp.eb-toc-container .eb-toc-title{ text-align: center; cursor:default; color: rgba(255,255,255,1); background-color:rgba(69,136,216,1); font-size: 22px; font-weight: normal; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper{ background-color:rgba(241,235,218,1); text-align: left; }  .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li { color:rgba(0,21,36,1); font-size: 20px; line-height: 1.4em; font-weight: normal; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li:hover{ color:undefined; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li a{ color:inherit; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li a, .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li a:focus{ text-decoration:none; background:none; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper li { padding-top: 4px; } .eb-toc-8kiz9hp.eb-toc-container .eb-toc-wrapper .eb-toc__list li:not(:last-child) { padding-bottom: 4px; } ","tab":"      ","mobile":"      "},"headers":[{"level":2,"content":"What Is a Product Database?","text":"What Is a Product Database?","link":"what-is-a-product-database"},{"level":2,"content":"How to Create a Product Database in 3 Steps","text":"How to Create a Product Database in 3 Steps","link":"how-to-create-a-product-database-in-3-steps"},{"level":3,"content":"Step 1: List Out All Product Attributes","text":"Step 1: List Out All Product Attributes","link":"step-1-list-out-all-product-attributes"},{"level":3,"content":"Step 2: Define Choices For Each Attribute","text":"Step 2: Define Choices For Each Attribute","link":"step-2-define-choices-for-each-attribute"},{"level":3,"content":"Step 3: Creating Your Product Database","text":"Step 3: Creating Your Product Database","link":"step-3-creating-your-product-database"},{"level":2,"content":"Product Database: Free Sample Application ","text":"Product Database: Free Sample Application ","link":"product-database-free-sample-application"}],"deleteHeaderList":[{"label":"What Is a Product Database?","value":"what-is-a-product-database","isDelete":false},{"label":"How to Create a Product Database in 3 Steps","value":"how-to-create-a-product-database-in-3-steps","isDelete":false},{"label":"Step 1: List Out All Product Attributes","value":"step-1-list-out-all-product-attributes","isDelete":false},{"label":"Step 2: Define Choices For Each Attribute","value":"step-2-define-choices-for-each-attribute","isDelete":false},{"label":"Step 3: Creating Your Product Database","value":"step-3-creating-your-product-database","isDelete":false},{"label":"Product Database: Free Sample Application ","value":"product-database-free-sample-application","isDelete":false}],"isMigrated":true,"titleBg":"rgba(69,136,216,1)","titleColor":"rgba(255,255,255,1)","contentBg":"rgba(241,235,218,1)","contentColor":"rgba(0,21,36,1)","contentGap":8,"titleAlign":"center","titleFontSize":22,"titleFontWeight":"normal","titleLineHeightUnit":"px","contentFontWeight":"normal","contentLineHeight":1.4,"ttlP_isLinked":true,"commonStyles":{"desktop":" .wp-admin .eb-parent-eb-toc-8kiz9hp { display: block; opacity: 1; } .eb-parent-eb-toc-8kiz9hp { display: block; } ","tab":" .editor-styles-wrapper.wp-embed-responsive .eb-parent-eb-toc-8kiz9hp { display: block; opacity: 1; } .eb-parent-eb-toc-8kiz9hp { display: block; } ","mobile":" .editor-styles-wrapper.wp-embed-responsive .eb-parent-eb-toc-8kiz9hp { display: block; opacity: 1; } .eb-parent-eb-toc-8kiz9hp { display: block; } "}} /-->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:tadv/classic-paragraph -->
<div style="background-color: #001524;"><hr style="height: 5px;" />
<pre style="text-align: center; overflow: hidden; white-space: pre-line;"><span style="color: #f1ebda; background-color: #4588d8; font-size: calc(18px + 0.390625vw);"><strong>Develop a Custom Product Database</strong>
<span style="font-size: 14pt;">Stay on top of your products and their attributes</span></span></pre>
<p style="text-align: center;"><a href="https://five.co/get-started" target="_blank" rel="noopener"><button style="background-color: #f8b92b; border: none; color: black; padding: 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 18px; cursor: pointer; margin: 4px 2px; border-radius: 5px;"><strong>Get Started</strong></button><br /></a></p>
<hr style="height: 5px;" /></div>
<!-- /wp:tadv/classic-paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading -->
<h2 class="wp-block-heading">What Is a Product Database?</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>A product database stores information or attributes about products, such as the product name, weight, color, material, size, price, discount levels, minimum order quantity, country of origin, images, category, description, packaging information, margin, production cost, supplier details, colors, or variations. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Depending on the industry you are in, your list of product attributes might include things such as certifications ("certified organic", "GMO-free"), taste or feel ("sweet", "soft"), ingredients, or marketing claims ("long-lasting", "top-rated", "popular choice"). </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>For example, let's say you are in charge of an e-commerce business that is selling posters on Shopify, a popular e-commerce platform. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>On Shopify, your products, i.e. the posters that you are selling online, can have different attributes and variations, such as price, color, size, and paper thickness. But there is a lot of information about your products that you <em>cannot</em> store on Shopify, such as your product ID, Stock Keeping Units (SKUs), suppliers, inputs (materials or ingredients), production cost, margin, or required packaging materials. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>This is where your <strong>product database</strong> comes in: it's a searchable database that stores all attributes about your products.</p>
<!-- /wp:paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading -->
<h2 class="wp-block-heading">How to Create a Product Database in 3 Steps</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Let's map out the steps to create a product database.</p>
<!-- /wp:paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading {"level":3} -->
<h3 class="wp-block-heading">Step 1: List Out All Product Attributes</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>To build your product database, you first want to create a complete list of all product attributes and define your data structure. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Take the list above as an example and think about what matters to your business, your customers and your employees as they are dealing with products. Your product database is supposed to be a "single source of truth" about your products, so make sure it is as complete as possible.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>A good source of inspiration for defining the right product attributes is <strong>listening to your customers:</strong> what are the most common questions they ask about your products? </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Must-have items in your list are typically:</p>
<!-- /wp:paragraph -->

<!-- wp:list -->
<ul><!-- wp:list-item -->
<li>Product Description</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Price</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Ingredients or Materials</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Size(s)</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Weight</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Colors</li>
<!-- /wp:list-item --></ul>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>Once you have your list of attributes, move on to step 2.</p>
<!-- /wp:paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading {"level":3} -->
<h3 class="wp-block-heading">Step 2: Define Choices For Each Attribute</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>In the second step, wherever possible, define choices for each attribute. This will introduce consistency into your database.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>For example, if you are dealing with products that come in different widths, define whether you would like to express width in centimeters, millimeters, or inches. Or, if you require inches for your American customers and centimeters for your European customers, store both in your database, but in separate columns. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Similarly, for colors, it is recommended to define possible choices: green, blue, yellow, etc. If you need to be more granular - dark green, forest green, and olive green - make sure to define these choices as well. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>The advantages of defining choices are data consistency, clean data, and avoidance of errors.  </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>With steps 1 and 2 completed, you should now have a table that looks something like this, but with your own product attributes in row 1, and with pre-defined choices in row 2 (to the extent this is applicable).</p>
<!-- /wp:paragraph -->

<!-- wp:table -->
<figure class="wp-block-table"><table><tbody><tr><td><strong>Product Name</strong></td><td><strong>Description</strong></td><td><strong>Color</strong></td><td><strong>Weight</strong></td><td><strong>Size</strong></td><td><strong>Supplier</strong></td><td><strong>SKU</strong></td><td><strong>Price</strong></td></tr><tr><td>iPhone X</td><td>iPhone X is the future of the smartphone...</td><td>Black</td><td>350g</td><td>Large</td><td>Apple</td><td>12345678</td><td>$1099.99</td></tr></tbody></table></figure>
<!-- /wp:table -->

<!-- wp:paragraph -->
<p>In Step 3, we will create the product database.</p>
<!-- /wp:paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading {"level":3} -->
<h3 class="wp-block-heading">Step 3: Creating Your Product Database</h3>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Now it's time to create your product database. More often than not, people set up their product database in Microsoft Excel or Google Sheets. While these spreadsheet-based solutions are a natural starting point, especially for smaller businesses, a word of caution: these spreadsheets tend to have a life of their own and typically create problems, such as:</p>
<!-- /wp:paragraph -->

<!-- wp:list {"ordered":true} -->
<ol><!-- wp:list-item -->
<li>Different departments or users have their local copy of the spreadsheet ("ProductDatabase_NEW", "Product Database - v2.1", "Old Product Database - DO NOT USE", etc.)</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>A lack of version control or clear ownership (the intern who left us a week ago made some changes, but we can't remember what...)</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Comments, highlights, and overwrites (how about we mark out-of-stock products in red?).</li>
<!-- /wp:list-item --></ol>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p><strong>Setting up your product database as a spreadsheet more often than not <span style="text-decoration: underline;">defeats its purpose of becoming your single source of truth</span>.</strong> Instead, you end up constantly fighting fires and cleaning up spreadsheets. That's why we recommend creating a proper product database using an online database builder, such as Five. Five lets you rapidly create online database web apps. </p>
<!-- /wp:paragraph -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:heading -->
<h2 class="wp-block-heading">Product Database: Free Sample Application </h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>Check out this <a href="https://default-productdatabase-tryfive.5au.co/">sample product database</a> which we created in just 15 minutes and that stores 13 product attributes in an intuitive web interface. Feel free to add more products to the database and navigate through the application. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you think building an entire web app like this is out of your reach, you couldn't be more wrong!</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Here are the steps we took to build this web app:</p>
<!-- /wp:paragraph -->

<!-- wp:list {"ordered":true} -->
<ol><!-- wp:list-item -->
<li>First, we created a<strong> fully customizable product database</strong>, by defining the fields (attributes) we like to store in our database. This required just a few clicks in Five's <strong>Table Wizard</strong>, a point-and-click database design tool.</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>We then created the form that our users can interact with, again using just a few clicks. We added a drop-down for the product category, as we want to adhere to the principles mentioned above: categorization helps us keep our data clean and consistent. <br>We also defined price as a numeric value (a currency field) while description is a longer text field, for example. We did all of this by defining <strong>Display Types</strong> in Five.</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>We also added a simple <strong>product dashboard that gives us insight into stock levels and prices</strong>. Of course, we could have created a more impressive dashboard, using any of the information provided by our product database.</li>
<!-- /wp:list-item -->

<!-- wp:list-item -->
<li>Last, we could have made the application <strong>login-protected</strong> to protect access to our product database. With just a single click, we could have added a login screen and assigned user roles. However, since we want you to be able to see the app, we decided to keep it public.</li>
<!-- /wp:list-item --></ol>
<!-- /wp:list -->

<!-- wp:paragraph -->
<p>To build a product database similar to (or more advanced than) our <a href="https://default-productdatabase-tryfive.5au.co/">simple product database</a> follow these steps:</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>First, set up your database. <a href="https://five.co/get-started">Sign up for free access to Five</a> and create a database table with fields for all your product attributes. Here's what our database table looks like in Five. Notice how the fields in our database match the form fields shown in our sample application.</p>
<!-- /wp:paragraph -->

<!-- wp:image {"id":2821,"width":"840px","height":"auto","sizeSlug":"large","linkDestination":"none"} -->
<figure class="wp-block-image size-large is-resized"><img src="https://five.co/wp-content/uploads/2024/05/image-10-776x1024.png" alt="" class="wp-image-2821" style="width:840px;height:auto"/></figure>
<!-- /wp:image -->

<!-- wp:separator -->
<hr class="wp-block-separator has-alpha-channel-opacity"/>
<!-- /wp:separator -->

<!-- wp:paragraph -->
<p>Second, once your database table has fields for each product attribute, go to Five's <strong>Form Wizard</strong> and create a new table in your application. <a href="https://help.five.org/2.6/docs/visual/form-wizard/introduction/">Follow our documentation</a> to understand how the form wizard works.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>With just one database table and one form, Five gives you an entire ready-to-use web application that can be used as a product database. The application comes with a search bar and filtering feature, which is great once your product catalog grows in size. To preview your application, you can launch the app to the cloud in a single click.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Of course, there's a lot more that you can add to your database, such as unique user roles (read-only roles or supplier roles with limited database access, for example), logins and authentication, or email notifications to alert suppliers when their products are running low on stock. </p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>To build your custom product database with Five, sign up for free access to Five and get started. <a href="https://five.org">Visit our forum</a> to get help from our application development experts as you add more features to your product database!</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p> </p>
<!-- /wp:paragraph -->