This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category Views

Standardized views across all categories of SkuDB

Each category has the following standard view, which can be accessed by opening a category:

1 - Dashboard

Contains basic statistics about a category or branch. Can be customized to include any project summary information.

In its default state, the dashboard displays basic statistics about a category or branch.

It can be customized to include data quality rules, before and after summaries, and other project-specific summary information.

The SkuDB dashboard can be customized with any set of analyses, tailored to a given project. The image above shows an example set of customized metrics, with many slices of the data available at a glance. All aspects can be customized upon request, including both style and content.

2 - Metadata

Contains category field values, as defined in the Fields view.
The category metadata view, showing metadata fields including name, category table break, category table columns, long name, ready status, short name, table category, total revenue, create date, and category id.

The category metadata view allows you to update the metadata attached to a given category, without leaving the category tab. An unlimited number of metadata can be tracked here. For more information on adding new metadata fields, see Fields.

3 - Descendants

A table-view summary of child categories.

The Descendants tab contains a spreadsheet view of all the child categories of the selected category, with columns for standard or user defined fields including category name, category path, description, child counts, category level, variant type, category ID, and a creation timestamp.

A dropdown menu provides the following functionality:

  • Move Selected Categories
  • Delete Selected Categories
  • View all descendants, or view terminal categories only
  • Control the Number of Categories Displayed
  • Control the Columns Displayed
  • Control the Levels of Categories Displayed  
A screenshot showing the Descentants view in SkuDB. Five categories are displayed: ACME Master Taxonomy, Abrasives, Abrasive Accessories, Abrasive Adapters, and Backup Pads & Disc Holders. Some of the categories' metadata is displayed as well, including the Table Category, Total Revenue, Short Name, Child Count, Descendant Count, and Product Count

The Descendants view contains the same fields as displayed in the Metadata view, as well as standard columns like Child Count and Item Count to provide the most commonly used metrics out of the box.

4 - Master Attributes

A consolidated list of unique attributes in the project, including summary statistics.

The Master Attributes view contains a searchable list of unique attributes throughout the project, and metadata about said attributes. Any fields on the attributes will also be displayed here.

Multiple Values for a Single Field

Note that when viewing Master Attributes from a non-terminal category, all values held by that attribute for a given field will be displayed in that field, separated by a pipe | delimiter. You can double-click on the field value to see all category paths containing the attribute, as well as each value held by the field within a given category path.

Example - ANSI Cut Resistance Order

Attributes with differing values in different classifications will show all values within a cell, separated by a pipe | character.

When an attribute has multiple values in different categories, you can double-click the field to trace their origins.

5 - Attributes

A list of all attributes related to the category, including global attributes, inherited attributes, and category-specific attributes. Also includes any attribute fields set up via the Fields view.

The Attributes tab contains a spreadsheet view of all the attributes in the category, with columns for standard or user defined metadata fields including attribute name, attribute ID, breadcrumb, units of measure, allowed values, data type, display type, rank, required, sample values, and a creation timestamp.

A dropdown menu provides the following functionality:

  • Create New Attributes
  • Copy Attributes
  • Merge Attributes
  • Promote Attribute to a higher Hierarchy Level
  • Delete Attributes
  • Recalculate Attribute Fill Rates
  • Export Attributes
  • Control the Number of Attributes Displayed
  • Control the Columns Displayed
  • Control the Levels of Attributes Displayed

Single Value vs. Multivalue

An attribute can be single-valued or multivalued. Multivalued attributes can have multiple pipe-delimited values assigned to a single attribute. By default, SkuDB will order these values alphanumerically.

6 - Values

An editable list of category-specific attribute values. Contains each unique value for each attribute.

The Values tab contains a spreadsheet view of all unique values in the category, with columns for standard or user defined metadata fields including attribute name, value, ID, breadcrumb, units of measure, and a creation timestamp.

A dropdown menu provides the following functionality:

  • Create New Value
  • Delete Selected Value
  • Export Values
  • Control the Number of Values Displayed
  • Control the Columns Displayed
  • Control the Levels of Attributes Displayed

7 - Products

The primary “grid view” of items and attributes. Includes a toggle between product-level and item-level entities.

The Items tab contains a spreadsheet view of all the items and/or products in the category, with columns for standard or user defined metadata fields including Item ID, and a creation timestamp. The default item tier names can be updated in the project’s Item Tiers Settings.

a menu listing a set of acctions that can be taken on all items or the currently selected item. The list includes Create new item, Create issue for Selected Item, View Related Products, Filter by List of Item IDs, Filter on Selected Items, Copy Selected Item IDs to Clipboard, Map Selected Items, Move Selected Items, Granularize this Category, Parent Product Actions (which features a right arrow indicating more options appear onhover), Export View, and Delete Selected Item Classifications

The Items tab features icons at the far left for “card view” and “image view” and can be customized to contain quick links to other content as needed (e.g., source url, data sheet)

A dropdown menu provides the following functionality:

  • Create New Items
  • Create new Attribute
  • Delete Item Classification
  • Create Issue
  • Move Selected Items
  • Fill Attribute Values & Field Values
  • Transfer Values
  • Export
  • Parent Product Actions
  • Filter on Selected Items

8 - Product Mappings

A summary of item mappings across hierarchies. Product Mappings are only relevant when items are classified to mlutiple hierarchies.

9 - Category Issues

The category-specific issue log

The Issues tab contains a spreadsheet view of all the issues opened in the selected category, with columns for standard and user-defined metadata fields (e.g., issue name, status, author, description, priority).

By selecting “Edit Issue View,” the icon in the second column of the issue log’s spreadsheet view, you can bring up a popup view of all fields related to the issue. This can be helpful in issue review or editing.

There are also dropdown menus for creating and deleting issues, controlling pagination, toggling on/off columns & other configuration options.

10 - Exports

Displays all available standard and custom exports, grouped by type.

The Exports tab offers data export originating in the selected category. If exports are required from the entire hierarchy, open Exports from the Root category. Exports display a progress metric and have a cancel button.

SkuDB’s standard exports include:

  • Category Export
  • Attribution Export
  • Item Export
  • Issue Export
  • Value Export
  • Stacked Value Export

11 - Reports

Summary reports pertaining to the hierarchy, items, and attributes.

Reports provide a way of visualizing statistical information about the data contained in the SkuDB instance. Reports give information on categories and items through a variety of metrics that are useful for QA, descriptive summaries and as design aids.

Reports are typically filterable to include terminal categories, or categories only on certain levels.

Reports can often be toggled between a graphical display and a table of information. Additionally, the scale can typically be adjusted between linear and logarithmic. Standard reports include:

  • Children per Category
  • Category Name Length
  • Attributes per Category
  • Attribute Name Length
  • Items per Category
  • Items Concentration
  • Items Burial  

12 - Radial Tree

A radial tree view of the hierarchy, with the selected category as the center point. If root is selected, allows for a radial view of the entire hierarchy.
An image of a radial tree view, displaying each category under the [Abrasives] L1 as a dot orbiting a central point, representing the parent category. Categories with higher product counts are displayed in red, while lower counts display green. Categories between the min and max threshold appear more green, yellow, or red depending on product count.

The Radial Tree view provides a radial graph of the hierarchy structure from the selected category and down. This is an adjustable graphical representation of the hierarchy that is useful for QA, descriptive summaries, and as a design aid. The radial graph is adjustable on the following parameters: Label Size, Orbit Radius, Category Radius, Extent, and Rotation. There are also buttons to Reset Controls and Toggle Fullscreen.

13 - Preview

An alternate view of items/products in the category that can be customized to reflect the expected display view.

The Preview mode simulates a web navigation experience based on the current state of the selected category and its children. Categories appear as if laid out on a webpage, with a search bar across the top, followed by category tiles, and with a listing of items and a navigation filter below. Preview is a useful mockup of the hierarchy design. It can also be valuable as a classification aid.

While SkuDB comes equipped with a default Preview Mode UI mirroring the typical features of a modern ecommerce experience, it can also be customized to mirror the expected display of category and product landing pages.