ItemSmart Configurator

Alert Groups

Alert rules showing variance alerts, overstocked/understocked, FMOS alerts etc.

7 configurations

Alert Aggregation Backbone

Edit in spreadsheet

CTE config, aggregation formulas, and alert group definitions. NOT per-alert — defines shared columns.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Alert Row Template

Edit in spreadsheet

Per-alert row structure: alert_id, source_config, item_count_keys.

Important to know before configuring:

  • IMPORTANT TABLE SPLIT: Runtime reads config across TWO tables — columns_data and client_hierarchy_config from alert_groups_configurations (no _test), but rowdata and display_order from alert_groups_configurations_test. hierarchy_to_table_mapping comes from item_groups_configurations (shared).
  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Alert Grid Columns

Edit in spreadsheet

AG-Grid column definitions with value formatters and color rules.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Alert Display Order

Edit in spreadsheet

Column field order and alert group ordering.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Hierarchy Config (Alerts)

Configure in form

Same as grid_configurations.client_hierarchy_config. Must be kept in sync.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Related setup to check

Complete first: Hierarchy Level Definitions

Client Hierarchy Config settings must stay aligned across their related areas.

Configure in form

Table Routing (Alerts)

Review carefully

Same as hierarchy_dictionary_json. Must be kept in sync.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.

Related setup to check

Complete first: Department → Table Routing

Hierarchy → Table Routing settings must stay aligned across their related areas.

Review carefully

Filters (Alerts)

Copy from reference

Maps API filter parameters to DB columns.

Important to know before configuring:

  • Not found in source DB — may be deprecated or renamed

No reference value is available; use the guided form or ask the AI Agent for help.