# Create a Stock Database

<span style="white-space: pre-wrap;">To create a stock database, go to the Home Page of the Database Module and create a new database. Click the “Create Database” button and input a database title and description. Select the appropriate database group from the dropdown menu. You can use default access parameters, or customize database specific parameters. </span>

<details id="bkmrk-how-to%3A-create-a-dat"><summary>How To: Create a Database</summary>

{{@329}}

</details>[![image.png](https://kaswiki.kastrack.com/uploads/images/gallery/2026-01/scaled-1680-/AIJimage.png)](https://kaswiki.kastrack.com/uploads/images/gallery/2026-01/AIJimage.png)

Select “Save” and the system will direct you to the Fields Page, where new fields can be added. Your stock database can include a variety of fields, but for the Inventory Module to function properly there are required fields.

<p class="callout info"><span style="white-space: pre-wrap;">If no fields have been entered into the database yet, you can import fields in bulk via a PDF Entry or a CSV file. If fields have already been created in the database, new field must be added individually. </span></p>

<details id="bkmrk-how-to%3A-add-a-databa"><summary>How To: Add a Database Group</summary>

{{@322}}

</details><details id="bkmrk-how-to%3A-import-form-"><summary>How To: Import Form Fields from a CSV File</summary>

{{@402}}

</details><details id="bkmrk-how-to%3A-import-field"><summary>How To: Import Fields from a PDF Field Import</summary>

{{@400}}

</details><table id="bkmrk-stock-database-requi" style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0.3em 0px 1.375em; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-variant-alternates: inherit; font-variant-position: inherit; font-variant-emoji: inherit; font-weight: 400; font-stretch: inherit; font-size: 14px; line-height: inherit; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Oxygen, Ubuntu, Roboto, Cantarell, "Fira Sans", "Droid Sans", "Helvetica Neue", sans-serif; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: baseline; border-collapse: collapse; border-spacing: 0px; min-width: 100px; max-width: 100%; hyphens: auto; table-layout: fixed; color: rgb(68, 68, 68); letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><colgroup><col></col><col></col></colgroup><tbody><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td colspan="2" style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">**Stock Database Requirements**

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">**Required Fields\***

</td><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">**Explanation**

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">Location

</td><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">Inventory location can be defined through a single database, or multiple databases if desired.

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">Inventory Item Title

</td><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">This field will be used to identify the stock inventory item. Some examples of possible field names include title, item, part, etc. The Title will be comprised out of fields in the stock database.

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">Quantity

</td><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">This field will state the number of stock items currently in the inventory.

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">Part Type

</td><td style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;">A inventory item must be specified as generic or unique if the inventory is integrated with a unique items database.

<p class="callout info">Part Type is only a required field if you have both a stock and a unique database.</p>

</td></tr><tr style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"><td colspan="2" style="box-sizing: border-box; outline-color: rgb(32, 110, 167); outline-width: 1px; margin: 0px; padding: 6px 8px; border: 1px solid rgb(221, 221, 221); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: 1.2; font-family: inherit; font-optical-sizing: inherit; font-size-adjust: inherit; font-kerning: inherit; font-feature-settings: inherit; font-variation-settings: inherit; font-language-override: inherit; vertical-align: top; min-width: 10px; overflow: auto; word-break: break-word;"><p class="callout danger">\* The actual field name for required fields can be customized to your preference.</p>

</td></tr></tbody></table>

All fields created in the database will show in the Fields Table.

[![image.png](https://kaswiki.kastrack.com/uploads/images/gallery/2026-01/scaled-1680-/qlCimage.png)](https://kaswiki.kastrack.com/uploads/images/gallery/2026-01/qlCimage.png)

After your fields have been generated, stock inventory items can now be entered into the database in bulk via a CSV file import or entries can be added individually.

<details id="bkmrk-how-to%3A-import-datab"><summary>How To: Import Database Entries from a CSV</summary>

{{@338}}

</details><details id="bkmrk-how-to%3A-add-an-indiv"><summary>How To: Add an Individual Database Entry</summary>

{{@325}}

</details>Now that your stock database has been created and filled with inventory item entries, it is ready to be integrated into an inventory.