Store Dashboard

CTUIT Data Sync

Fetch data from CTUIT for a date range, then import it into the database once you've confirmed it looks right.

Step 1 — Fetch from CTUIT

Date range to

Step 2 — Review & Import

#	Type	Date Range	Records	Status	Fetched	Action
No sync jobs yet. Use the buttons above to fetch data.

Upload CSV from CTUIT

Use this when a CTUIT export times out. Download the CSV manually from the CTUIT website, then upload it here to import it directly.

Export type

Date range to

CSV file

Upload Product Mix (PMIX)

Download the PMIX by Location export from CTUIT for one period, then upload it here. Import one period at a time.

Year Period

CSV file

Historical Import

Fetches and imports all three export types (daily sales, half-hour, order mode) for a full calendar year in one go. No review step — data goes straight into the database. Run one year at a time, oldest first.

Year Half-hour metric

Use Entrees for 2020 and later. Switch to Guests for 2019 and earlier — entrees were not tracked in CTUIT before 2020.

Admin

Data Entry

Product Mix

Stores & Periods

Users

Enter manual data by period — labor, comps, and platform orders.

Period

Labor

Store	Labor Hours	Labor Cost ($)

Comps

Store	Amount ($)	Notes

Platform Orders

Store	ChowNow Pickup		Postmates Pickup		Postmates Delivery
Store	Orders	Sales ($)	Orders	Sales ($)	Orders	Sales ($)

Item Management

Assign a display category to each menu item and choose whether it appears in the Product Mix dashboard. Items without a category are hidden from the dashboard until you assign one. New items imported from CTUIT appear here automatically.

Loading items…

Aggregated Fields

Define custom computed rows that appear at the bottom of the Product Mix table. Each field sums the percentages of any items you choose — for example, "Singles" could sum HiHo, Classic, and Willie Mae's single-patty items.

Add New Field

Field Name

Items to Sum (hold Ctrl/Cmd to select multiple)

Loading fields…

Add a New Store

Short Name (CTUIT ID)

Display Name

Store Number

Opened Date

Region

City

Existing Stores

Loading…

Add a New Year

Year

Period 1 Start Date

Existing Periods

Loading…

Add City

City Name

State

Cities

Loading…

Add Region

Region Name

City

Regions

Loading…

User Management

Manage who has access to this application.

Add User

Name

Permissions

Dashboard Sync Admin

Name	Email	Permissions	Active	Added

Dashboard

Store performance metrics by period.

Detailed

Graphical

Product Mix

Export

View by

Year

—

Overview

Actual Days

—

Total Guests

—

Avg Guests / Day

—

Total Net Sales

—

Net Sales

Avg Daily Net Sales

—

Annualized Rate

—

avg/day × 360

vs Prev Period

—

vs Same Period LY

—

Labor

Total Labor Hours

—

Guests per Hour

—

Total Labor Cost

—

Cost per Guest

—

Guest Flow by Daypart

Daypart	Guests	Avg / Day	% of Total

Dollar per Guest

Order Mode	$/Guest

Net Sales & Guest Mix by Order Mode

Order Mode	Net Sales	% of Sales	Guests	Avg/Day	$/Guest

Guest Behavior

Type	Total Guests	Avg / Day

Guest Behavior by Daypart

Daypart	Net Sales	Guests	Dine In/Day	Dine Out/Day

Comps

—

Total comps this period

Pickup & Delivery Platforms

Platform	Orders	Total Sales	Avg Order

Trend Chart

Store Comparison

Trend Chart

Pick an entity, a period range, and up to 5 metrics to plot over time.

View by

From period

To period

Metrics selected: 0 / 5 · ($) = left axis (#/%) = right axis

Store Comparison

Pick one metric and any combination of stores to compare trends side by side.

From period

To period

Select one metric

Stores

From Period

To Period

🤖

AI analysis — coming soon

Store Dashboard

Period Detail