Fluent Commerce Logo
Docs

fc.analytics.queries.inventory

Setting

Changed on:

13 Nov 2025

Setting AreaUI component
Supported context levels:ACCOUNT, RETAILER

Overview

The `fc.analytics.queries.inventory` is a configuration that defines the analytics queries for the Fluent Analytics inventory dashboard

Values

Data TypeValues
JSON
1{
2  "queries": [
3    {
4      "name": "status_breakdown",
5      "resource": {
6        "type": "PATH",
7        "value": "Standard Template/Dashboards/Inventory/Inventory Quantity Status Breakdown"
8      },
9      "roles": [
10        "INVENTORY_MANAGER"
11      ]
12    },
13    {
14      "name": "rank_most_frequently_purchased_products_most_to_least_(sortable)",
15      "resource": {
16        "type": "PATH",
17        "value": "Standard Template/Dashboards/Inventory/Rank most frequently purchased products most to least (sortable)"
18      },
19      "roles": [
20        "INVENTORY_MANAGER"
21      ]
22    },
23    {
24      "name": "rank_reserved_products_most_to_least_(sortable)",
25      "resource": {
26        "type": "PATH",
27        "value": "Standard Template/Dashboards/Inventory/Rank reserved products most to least (sortable)"
28      },
29      "roles": [
30        "INVENTORY_MANAGER"
31      ]
32    },
33    {
34      "name": "sku_velocity_(list_view_across_all_skus_@_location)",
35      "resource": {
36        "type": "PATH",
37        "value": "Standard Template/Dashboards/Inventory/SKU Velocity (list view across all SKUs @ location)"
38      },
39      "roles": [
40        "INVENTORY_MANAGER"
41      ]
42    },
43    {
44      "name": "top_10_reserved_products",
45      "resource": {
46        "type": "PATH",
47        "value": "Standard Template/Dashboards/Inventory/Top 10 Reserved Products"
48      },
49      "roles": [
50        "INVENTORY_MANAGER"
51      ]
52    },
53    {
54      "name": "top_10_frequently_purchased_products",
55      "resource": {
56        "type": "PATH",
57        "value": "Standard Template/Dashboards/Inventory/Top 10 Purchased Products"
58      },
59      "roles": [
60        "INVENTORY_MANAGER"
61      ]
62    },
63    {
64      "name": "sell_through_rate",
65      "resource": {
66        "type": "PATH",
67        "value": "Standard Template/Dashboards/Inventory/Sell Through Rate"
68      },
69      "roles": [
70        "INVENTORY_MANAGER"
71      ]
72    },
73    {
74      "name": "coverage_days",
75      "resource": {
76        "type": "PATH",
77        "value": "Standard Template/Dashboards/Inventory/Inventory Coverage Days"
78      },
79      "roles": [
80        "INVENTORY_MANAGER"
81      ]
82    },
83    {
84      "name": "sku_velocity",
85      "resource": {
86        "type": "PATH",
87        "value": "Standard Template/Dashboards/Inventory/SKU Velocity"
88      },
89      "roles": [
90        "INVENTORY_MANAGER"
91      ]
92    },
93    {
94      "name": "sold_inventory",
95      "resource": {
96        "type": "PATH",
97        "value": "Standard Template/Dashboards/Inventory/Sold Inventory"
98      },
99      "roles": [
100        "INVENTORY_MANAGER"
101      ]
102    },
103    {
104      "name": "total_on_hand",
105      "resource": {
106        "type": "PATH",
107        "value": "Standard Template/Dashboards/Inventory/Total On Hand"
108      },
109      "roles": [
110        "INVENTORY_MANAGER"
111      ]
112    },
113    {
114      "name": "short_picked_products",
115      "resource": {
116        "type": "PATH",
117        "value": "Standard Template/Dashboards/Inventory/Short Picked Products"
118      },
119      "roles": [
120        "INVENTORY_MANAGER"
121      ]
122    },
123    {
124      "name": "top_short_picked_products",
125      "resource": {
126        "type": "PATH",
127        "value": "Standard Template/Dashboards/Inventory/Top 10 Short Picked Products"
128      },
129      "roles": [
130        "INVENTORY_MANAGER"
131      ]
132    },
133    {
134      "name": "total_available",
135      "resource": {
136        "type": "PATH",
137        "value": "Standard Template/Dashboards/Inventory/Total Available"
138      },
139      "roles": [
140        "INVENTORY_MANAGER"
141      ]
142    },
143    {
144      "name": "total_correction",
145      "resource": {
146        "type": "PATH",
147        "value": "Standard Template/Dashboards/Inventory/Total Correction"
148      },
149      "roles": [
150        "INVENTORY_MANAGER"
151      ]
152    },
153    {
154      "name": "aged_last_on_hand_by_product",
155      "resource": {
156        "type": "PATH",
157        "value": "Standard Template/Dashboards/Inventory/Aged Last On Hand by Product"
158      },
159      "roles": [
160        "INVENTORY_MANAGER"
161      ]
162    }
163  ]
164}

Detailed technical description

The queries configured in this setting serve as an example aligned with the Fluent Analytics reference inventory dashboard. You can customize these values to match the relevant to your setup.

Configuration example

1POST {{fluentApiHost}}/graphql
2
3mutation CreateSetting {
4   createSetting(input: {
5		name: "fc.analytics.queries.inventory", 
6		valueType: "JSON", 
7		lobValue: $lobValue , 
8		context: "ACCOUNT", 
9		contextId: 0}) {
10    id
11    name
12  }
13}
14		
15GraphQL variables:
16{
17    "lobValue" : [
18      {
19        "queries": [
20          {
21            "name": "status_breakdown",
22            "resource": {
23              "type": "PATH",
24              "value": "Standard Template/Dashboards/Inventory/Inventory Quantity Status Breakdown"
25            },
26            "roles": [
27              "INVENTORY_MANAGER"
28            ]
29          },
30          {
31            "name": "rank_most_frequently_purchased_products_most_to_least_(sortable)",
32            "resource": {
33              "type": "PATH",
34              "value": "Standard Template/Dashboards/Inventory/Rank most frequently purchased products most to least (sortable)"
35            },
36            "roles": [
37              "INVENTORY_MANAGER"
38            ]
39          },
40          {
41            "name": "rank_reserved_products_most_to_least_(sortable)",
42            "resource": {
43              "type": "PATH",
44              "value": "Standard Template/Dashboards/Inventory/Rank reserved products most to least (sortable)"
45            },
46            "roles": [
47              "INVENTORY_MANAGER"
48            ]
49          },
50          {
51            "name": "sku_velocity_(list_view_across_all_skus_@_location)",
52            "resource": {
53              "type": "PATH",
54              "value": "Standard Template/Dashboards/Inventory/SKU Velocity (list view across all SKUs @ location)"
55            },
56            "roles": [
57              "INVENTORY_MANAGER"
58            ]
59          },
60          {
61            "name": "top_10_reserved_products",
62            "resource": {
63              "type": "PATH",
64              "value": "Standard Template/Dashboards/Inventory/Top 10 Reserved Products"
65            },
66            "roles": [
67              "INVENTORY_MANAGER"
68            ]
69          },
70          {
71            "name": "top_10_frequently_purchased_products",
72            "resource": {
73              "type": "PATH",
74              "value": "Standard Template/Dashboards/Inventory/Top 10 Purchased Products"
75            },
76            "roles": [
77              "INVENTORY_MANAGER"
78            ]
79          },
80          {
81            "name": "sell_through_rate",
82            "resource": {
83              "type": "PATH",
84              "value": "Standard Template/Dashboards/Inventory/Sell Through Rate"
85            },
86            "roles": [
87              "INVENTORY_MANAGER"
88            ]
89          },
90          {
91            "name": "coverage_days",
92            "resource": {
93              "type": "PATH",
94              "value": "Standard Template/Dashboards/Inventory/Inventory Coverage Days"
95            },
96            "roles": [
97              "INVENTORY_MANAGER"
98            ]
99          },
100          {
101            "name": "sku_velocity",
102            "resource": {
103              "type": "PATH",
104              "value": "Standard Template/Dashboards/Inventory/SKU Velocity"
105            },
106            "roles": [
107              "INVENTORY_MANAGER"
108            ]
109          },
110          {
111            "name": "sold_inventory",
112            "resource": {
113              "type": "PATH",
114              "value": "Standard Template/Dashboards/Inventory/Sold Inventory"
115            },
116            "roles": [
117              "INVENTORY_MANAGER"
118            ]
119          },
120          {
121            "name": "total_on_hand",
122            "resource": {
123              "type": "PATH",
124              "value": "Standard Template/Dashboards/Inventory/Total On Hand"
125            },
126            "roles": [
127              "INVENTORY_MANAGER"
128            ]
129          },
130          {
131            "name": "short_picked_products",
132            "resource": {
133              "type": "PATH",
134              "value": "Standard Template/Dashboards/Inventory/Short Picked Products"
135            },
136            "roles": [
137              "INVENTORY_MANAGER"
138            ]
139          },
140          {
141            "name": "top_short_picked_products",
142            "resource": {
143              "type": "PATH",
144              "value": "Standard Template/Dashboards/Inventory/Top 10 Short Picked Products"
145            },
146            "roles": [
147              "INVENTORY_MANAGER"
148            ]
149          },
150          {
151            "name": "total_available",
152            "resource": {
153              "type": "PATH",
154              "value": "Standard Template/Dashboards/Inventory/Total Available"
155            },
156            "roles": [
157              "INVENTORY_MANAGER"
158            ]
159          },
160          {
161            "name": "total_correction",
162            "resource": {
163              "type": "PATH",
164              "value": "Standard Template/Dashboards/Inventory/Total Correction"
165            },
166            "roles": [
167              "INVENTORY_MANAGER"
168            ]
169          },
170          {
171            "name": "aged_last_on_hand_by_product",
172            "resource": {
173              "type": "PATH",
174              "value": "Standard Template/Dashboards/Inventory/Aged Last On Hand by Product"
175            },
176            "roles": [
177              "INVENTORY_MANAGER"
178            ]
179          }
180        ]
181      }
182    ]
183}
184