Price Intelligence
Sign in to your account
Forgot your password? Reset by email
⚙️ Admin Panel
Manage your price file, branding, filters, and access settings.
📁 Current File
No file loaded
File Name
Products
Columns
Loaded
Valid From
Storage Used
Browser Storage
⬆️
Upload your Price File
Supports .xlsx, .xls, .csv
Saved locally and securely synced to all signed-in devices
📋 Load History
No history yet
💹 GMI Price Files

Upload your GMI pricing files here. They are stored locally and persist across sessions. Update them here whenever Schneider releases new pricing.

📂
Under $30K GMI File
.xlsx or .csv
📂
Over $30K GMI File
.xlsx or .csv
🎯 Column Mapping Tell the tool which columns hold prices — load your files first

Select the exact columns to use for price comparison and GMI pricing. The screen price is read directly from the selected price-file column and is never adjusted for GST.

📋 Price File (Screen Price)
Screen Price Column (shown exactly as supplied in the price file)
GMI files contain (GST)
Part Number Column
Description Column
💹 GMI Under $30K Columns
Part Number Column (Under $30K)
"Best" Price Column
"RHA/BGW" Price Column
💹 GMI Over $30K Columns
Part Number Column (Over $30K)
"Best" Price Column
"RHA/BGW" Price Column
🎨 Tool Identity
Tool Name
Company / Sub-title
Creator Name
Logo (upload)
Remove Logo
✉️ Email Template used by Project Pricing → Export → Copy email table

Placeholders you can use: {project} {quote_num} {total} {valid_to} {wholesaler} {contractor} {creator}

Text BEFORE the price table
Text AFTER the price table
🌗 Theme
Color Scheme
Accent Color
Affects buttons, highlights, badges
Export Header
🔍 Filter Configuration Toggle which filters appear in the Search sidebar
🔗 Product Link Configuration
SE Link Pattern
Clipsal Link Pattern
Use {part_raw} for Part Number. Products with prefix starting CLI use the Clipsal pattern; all others use the SE pattern.
📊 Export Link Column

One smart "Product Link" column is appended to every Excel/CSV export. CLI products get the Clipsal URL; all others get the SE search URL. The full URL is shown as the hyperlink text.

🔐 My Password
New Password
Confirm Password
👥 How access works

Each person signs in with their own email and password (create accounts in the Users tab). Users see the shared price data and only their own quotes and clients. You (admin) see everything, including the Log Book of all activity.

✓ Send the link → they sign in → data isolation is enforced by the server, not just the interface.
🗂️ Tab Order & Visibility

Drag to reorder tabs. Toggle visibility. Changes apply immediately and are saved.

➕ Create User
Email
Display Name
Temporary Password

Send them the app link + their email and temporary password. They can change the password in Admin-free Settings (Access tab is visible to every user for their own password).

👤 All Users
Loading…
📜 Activity Log Book
Loading…
👥 CAP Contact List

Upload your Commercial Action Plan spreadsheet. The tool will read all contacts and let you track calls, meetings and notes per client. Uploading a new file merges data — existing activity logs and notes are preserved.

📋
Upload your CAP Excel file
Supports .xlsx, .xls, .csv — first row must be headers
Column Detection

Columns are auto-detected from your file's header row. No manual mapping needed — the tool reads all columns automatically. You choose which columns are visible in the CAP tab using the Columns panel on the left.

Upload a file to see detected columns.
Data Summary
No data loaded yet. Upload a CAP file above.
⌨️ Keyboard Shortcuts
Focus searchCtrl+F
Export to ExcelCtrl+E
Select all visible rowsCtrl+A
Close detail panel / modalEsc
Clear all filtersCtrl+Shift+X
🔍 Filter Modes
ContainsValue appears anywhere in cell
Starts withFirst character(s) match
Ends withLast character(s) match
ExactFull cell value match only
Not containsExclusion filter
PickerMulti-select from unique values
💾 Storage Notes
Storage typeBrowser IndexedDB (local)
Survives browser restarts✓ Yes
Sent to any server✗ Never
Per browserChrome ≠ Firefox
Replace fileAdmin → File tab
⚠️
Clear stored file?
This deletes the price data from your browser. You'll need to re-upload to use search again.
Done
📋 My Quotes All your quotes in one place — create, track, send
💰 Sales Performance
TOTAL QUOTED All quotes
0
$0.00
✅ WON Closed wins
0
$0.00
❌ LOST Closed losses
0
$0.00
⏳ IN PIPELINE Open + Follow up
0
$0.00
Quote Status
Offer Value by Status
💰 STIP Bonus Calculator Quarterly lodgments, payout curve, year-end true-up
Annual bonus target
Paid so far (gross)
Year-end entitlement
🎯 Path to Full Bonus what you need in the remaining quarters to reach 100% on every KPI for the year
🧮 Year-End True-Up
Quarterly payout (gross $)
KPI achievement — full year
👥 CAP Activity — This Year
TOTAL CLIENTS
Load CAP data
ACTIVITIES
This year
📱 VIRTUAL
Phone calls
🤝 FACE TO FACE
Visits
⚠ OVERDUE
Need attention
Activity This Year — by Month
■ Virtual ■ F2F ■ Email ■ Other
CAP Coverage
🔴 Needs Attention
View all →
🔔 Upcoming Reminders
View all →
🔍
Click any column header to sort ▲▼