Open the Admin tab to upload your price file — you only need to do this once.
⌕
0 results
0 selected
🔎
No products match
Try adjusting your filters
—
Rows:
⚙️ 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 search
Ctrl+F
Export to Excel
Ctrl+E
Select all visible rows
Ctrl+A
Close detail panel / modal
Esc
Clear all filters
Ctrl+Shift+X
🔍 Filter Modes
Contains
Value appears anywhere in cell
Starts with
First character(s) match
Ends with
Last character(s) match
Exact
Full cell value match only
Not contains
Exclusion filter
Picker
Multi-select from unique values
💾 Storage Notes
Storage type
Browser IndexedDB (local)
Survives browser restarts
✓ Yes
Sent to any server
✗ Never
Per browser
Chrome ≠ Firefox
Replace file
Admin → 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 QUOTEDAll quotes
0
$0.00
✅ WONClosed wins
0
$0.00
❌ LOSTClosed losses
0
$0.00
⏳ IN PIPELINEOpen + Follow up
0
$0.00
Quote Status
Offer Value by Status
📋
No quotes yet
Create your first quote to get started
📋 Project Pricing Enter part numbers, get GMI & list pricing, compare savings
Paste your list — one item per line. Works with qty first or last, and with whole rows copied from a quote-request Excel (tabs, headers and extra columns are handled automatically). Or import the request file directly:
Reads the Qty + Product columns from the quotes-team template
0
Lines
$0
List Total
$0
Offer Total
$0
Total Discount
0%
Avg Discount
0
GMI Matched
0
Discounted
0
Not Found
📊 Quote Lines
#
Part Number
Qty
Screen Price exact price-file value
GMI Price GMI
Offer / Unit GMI or discounted
Discount vs screen price
Line Total
✏️ Edit part numbers and quantities directly in the table. Press Tab to move between cells. Changes recalculate instantly.