---
title: Mapping product type database columns
related:
  - https://docs.kentico.com/13/e-commerce-features/configuring-on-line-stores/configuring-product-page-types.md
  - https://docs.kentico.com/13/developing-websites/defining-website-content-structure/managing-page-types.md
  - https://docs.kentico.com/13/developing-websites/defining-website-content-structure/managing-page-types/creating-page-types.md
---

> Agent instructions:
> **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown.
>
> - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version.
> - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt).

When using [pages](https://docs.kentico.com/13/managing-website-content/working-with-pages.md), you can set the [page type](https://docs.kentico.com/13/developing-websites/defining-website-content-structure/managing-page-types.md)'s **Page name source** attribute to determine the mapping of the page type database columns. However, [products](https://docs.kentico.com/13/e-commerce-features/managing-on-line-stores/products.md) from the E-commerce Solution connect the _CMS\_Document_ table and the given [product page type](https://docs.kentico.com/13/e-commerce-features/configuring-on-line-stores/configuring-product-page-types.md)'s table also to the _COM\_SKU_ table. On this page, you can find which columns are mapped to which other columns.

The _SKUName_, _SKUShortDescription_ and _SKUDescription_ columns in the _COM\_SKU_ table are always mapped to another column:

- The _COM\_SKU.SKUName_ column is mapped based on setting of the **Page name source** attribute.
  - If you leave the _(Use product name)_ option in the **Page name source** field, the value from the **Product name** field of the product page type is saved to the _COM\_SKU.SKUName,_ _CMS\_Document.DocumentSKUName_ and _CMS\_Document.DocumentName_ columns.
  - If you select a specific column in the **Page name source** field, the value from the **Product name** field is saved just to the _COM\_SKU.SKUName_ and _CMS\_Document.DocumentSKUName_ columns. The value from the selected column in the **Page name source** field is saved to the _CMS\_Document.DocumentName_ column and is displayed in the [product tree](https://docs.kentico.com/13/e-commerce-features/configuring-on-line-stores/configuring-products/configuring-product-structure.md) and the page tree.

    ![The Product name field](https://docs.kentico.com/docsassets/13/mapping-product-type-database-columns/product_name.png "The Product name field")
- The _COM\_SKU.SKUShortDescription_ column is mapped to the _CMS\_Document.DocumentSKUShortDescription_ column.
- The _COM\_SKU.SKUDescription_ column is mapped to the _CMS\_Document.DocumentSKUDescription_ column.

> **Info:** If you run a [multilingual store](https://docs.kentico.com/13/e-commerce-features/configuring-on-line-stores/configuring-multilingual-stores.md), the fields are mapped to each other only in the default culture of the site.

## Using different names for SKUs and product pages

Due to the possibility of mapping some of the database columns, you can have different names for SKUs and for product pages.

1. [Create a new field](https://docs.kentico.com/13/custom-development/extending-the-administration-interface/developing-form-controls/reference-field-editor.md) in the desired product page type. To be able to use different names:

   - In the **Data type** drop-down list, select _Text_.
   - Select the **Required** check box.

     ![New field properties](https://docs.kentico.com/docsassets/13/mapping-product-type-database-columns/new_field_properties.png "New field properties")
2. After saving of the new field, select the created field in the **Page name source** drop-down list.

   ![Selecting the field in the Page name source field](https://docs.kentico.com/docsassets/13/mapping-product-type-database-columns/selecting_page_name_source_field.png "Selecting the field in the Page name source field")
3. **Save** the product page type.

If you now navigate to the **Products** application and edit a product of the modified product page type, you will see two name fields – the **Product name** field, which names the SKU, and the field you just created, which names the page.