This view mirrors your Google Sheets backend. All three relational tables are displayed below.
Changes made via forms are instantly reflected here.
🔗 Relational Schema
User_Master
🔑 email (PK) name role region manager (→ email) target
→
Customer_Master
🔑 id (PK) name industry tier rep (→ User.email) city
→
Enquiry_Ledger
🔑 id (PK) custId (→ Customer.id) received component stage value followup rep (→ User.email) lastUpdate note
🗂️ Product Catalogs
🖼️ Product Images & Videos
📦 Items Master Data
🔍
Item Code
Description
Vendor
Product Group
Price
Currency
Material ID
Updated
Updated By
Status
Actions
Showing 0 to 0 of 0 entries
Page 1 of 1
🚢 Trade Finance & Compliance
FEMA Risk: 0
📉
Open Import Exposure
$0.00
Active Bills of Entry
📤
Advance Outward Remittances
$0.00
Pending mapping to BOE
⚠️
Critical FEMA Alerts
0
Unresolved warnings
🚨
FEMA Risk Score
0
Compliance index (0-100)
🏢
Company Trade Profile
Corporate credentials for customs, export under LUT, and banking compliance
IEC Number-
PAN-
GSTIN-
LUT ARN (Letter of Undertaking)
-Active
Counterparty Registry
Name
Type
Country
Currency
Payment Terms
Loading...
Authorized Dealer (AD) Banks
Bank Name
Branch
AD Code
Account No
Loading...
Import Purchase Orders
PO Number
Supplier
Date
Value
Status
No Import POs registered.
Outward Remittances (SWIFT)
SWIFT Reference
Supplier
Date
Amount
Purpose Code
IDPMS Status
Loading...
Bills of Entry (BOE)
BOE Number
Invoice Number
AWB / BL Number
Supplier
BOE Date
Assessed Value
FEMA Deadline
Status
Loading...
Active Compliance Alerts
Rule Code
Description
Severity
Deadline
Days Left
FEMA Clause
No active alerts.
1. Select Import Format & View Template
CSV Header Format:
Sample Rows:
2. Choose CSV File
📥
Upload a clean CSV file matching the format template.
Parsed Data Preview (0 rows)
📝 Commercial Quotations
🔍
Quotation No
Customer Name
Date
Status & Ref
Total Value
Sales Rep
Actions
📊 Your Metrics Performance
📋 Quotations by Status
⚠️ Pipeline Risk Alert
🎯 Quote-to-Win Funnel
📈 Monthly Trend
🌍 Quotations by Currency
⚠️ Quotes Needing Follow-up0 at risk
Quotation No
Customer
Value
Viewed on
Days since viewed
Rep
Action
✏️New Quotation
🤖 Quick Quote Agent (Natural Language Drafting)
⏳ Agent is analyzing catalog products, customer discounts and drafting quotation...
📋 Quotation Information
📦 Line Items
S.No
Ordering Code
Description
MOQ
Unit Rate (₹)
Disc (%)
Value
Actions
💰 Summary & Taxes
Subtotal:₹0.00
GST (18%):₹0.00
Total Amount:₹0.00
INR Equivalent:≈ ₹0.00
📄 Terms Preview:
• Payment: —
• Delivery: —
• Taxes: —
🧠
AI Copilot Diagnostics
🧠 AI RFQ Parser (Text & Documents)
Paste email lists or upload RFQ documents (PDF, Excel, Images) to extract lines automatically.
No file selected
Analyzing document structure & resolving items...
🚚 Shipments
🔍
AWB / CN No
Carrier
Customer
Destination
Status
Last Update
ETA
Sales Rep
Actions
🧠 Upload Air Waybill (AI auto-fill)
Upload a courier consignment note or AWB (PDF or photo). The AI reads the AWB number, carrier, consignee and details, and auto-detects the customer. You can correct anything before saving.
No file selectedReading document…
✍️ Shipment Details
🏬 Inventory
Add Product
Adjust Stock
For GST compliance
Document date
🤖 Import from Invoice
Upload a supplier invoice or stock list (PDF, Excel or CSV). AI will extract the line items for you to review before anything is saved.
Review & edit before importing. Existing SKUs update; new SKUs are created.
SKU
Name
Qty
Unit Price
📄 Bulk Upload Products
Step 1: Download Template
Download the Excel template to ensure your data is formatted correctly.
Step 2: Upload Your File
Select the Excel file containing your product data.
Field Types Reference:
TEXT Fields:
NUMBER Fields:
* Product Name (Required) * SKU (Required) Description Barcode Bin Location Supplier Name Category Image URL
* Unit Price (Required) Current Stock Min Stock Level Max Stock Level
Important: SKU and Barcode must be entered as TEXT, not numbers. Format cells as "Text" in Excel.
The template includes a data types row for reference — this row will be automatically skipped during import.
Categories
🧾 Purchase Requisitions
🔍
PR No
Customer
Status
Lines
Raised By
Date
Actions
🧠 Quick add from a message or file (AI)
Paste the customer's WhatsApp/email order text, or upload a PO / RFQ as PDF, image or Excel — the AI splits it into line items you can review and edit before saving.
— or —No file selectedReading…
✍️ Requisition Details
📦 Line Items
#
Part No
Description
Qty
UOM
📎 Attach technical drawings / PDFs / images per line item using the 📎 button on each row above. Files on new lines upload automatically when you save.
🤖 Ask about your orders
Supplier
Lines (this year)
Last Generated
Rev
Portal Login
Share
Pick a supplier to see exactly what they see in their portal — and update any order line on their behalf.
PR / Customer
Item
Qty
Status
Initial ETA
Revised ETA
Unit Price
Line Total
Alert
Recd / Bal
Remarks
Update
Select a supplier above to view their orders.
PR No
Customer
Raised By
Lines
Total Qty
Pending
Actions
🧰 Software
Engineering Tools
🔩
ThreadMill Pro
Thread-milling CNC program generator — tool catalog, cutting data & multi-controller G-code (Fanuc, Heidenhain, Siemens, Num, Fagor, Mazak, Mitsubishi).
⚠ Generated data are recommended starting values — verify on the machine before production.
🛡️ Admin Panel
Management Only
Name
Email
Role
Region
Status
Joined
Actions
🤖 Follow-up Queue
🎉
No leads need follow-up right now
All active opportunities have recent activity or pending follow-ups scheduled. The agent will scan again automatically or you can trigger a manual run above.
📈 Sales Insights
🤖 Ask Sales Intelligence Agent
Suggested Questions:
💬 Conversation History
📈
Ask a question above to get started.
⚡ AI Costing Engine
📤 Upload CAD Geometry
📄
Drag & Drop CAD file (.step, .stp, .iges) or browse
Max file size: 5MB. Assemblies are simplified automatically.
Monthly Deal Value Breakdown (Financial Year: April - March)Enter projected/actual repeat orders for each month
7. Media▼
Trial Photos & Videos
Upload images or video files related to this machining enquiry (Max 2MB per file)
8. PDF Report▼
📤
Export Reports
Choose the type of PDF report to generate. Both are print-ready and include the EcoCut branding.
📋
Technical Enquiry Report
Full enquiry profile with application specs, tooling benchmark, cutting parameters, monthly allocation, media gallery & AI diagnostics.
📊
Customer Trial & ROI Report
Professional customer-facing validation report with trial results, cost-benefit analysis, ROI summary & sign-off block.
Include Trial Media in Reports
Select which trial photos or videos from Tab 7 should appear in the generated PDF reports.
9. AI Insights▼
🧠
AI Machining Expert Diagnostic Engine
Run a multi-vector diagnostic analysis on this enquiry. The AI will evaluate cutting forces, power consumption, vibration/chatter risks, and diagnose any uploaded wear-out photos to provide world-class remediation suggestions.
10. Trial & ROI▼
⚗️
Trial Performance & ROI Analysis
Fill in trial data — all cost & ROI outputs compute automatically in real time
A — Test Results Matrix
PARAMETER
COMPETITOR
ECOCUT ✦
Tool Life / Edge (Pcs)
Usable Edges per Insert
Tool Life / Insert (Min)
Tool Wear Type
Surface Finish Class
Chip Formation Shape
B — Cost-Benefit Analytics Engine
Input Parameters
PARAMETER
COMPETITOR
ECOCUT
Price Per Unit (₹)
Inserts on Tool Body
Cutting Time / Comp (Min)
Machine Hour Rate (₹/hr)
Monthly Volume (Pcs)
⚡ Auto-Computed Outputs
METRIC
COMPETITOR
ECOCUT
Parts per Insert
—
—
(A) Tool Cost/Component
—
—
Productivity (pcs/hr)
—
—
(B) Machine Cost/Job
—
—
Total Cost per Job (A+B)
—
—
Monthly Tool Consumption
—
—
C — ROI Executive Summary
—
Tool Life Extension
—
Cycle Time Reduction
—
Cost per Component Saved
—
Annual Savings (INR)
💡 Values update live as you enter trial data. Click 📊 Trial Report PDF to export a customer-ready sign-off document.
D — Live Comparison Charts
Total Cost per Component (INR)
Tool CostMachine Cost
Productivity Index (Parts / Hr)
Add New Customer
Create Folder
Edit Customer
Upload Catalog Document
Maximum recommended file size: 1.5MB (larger files may exceed browser storage quotas).
Reject Account Request
Provide a reason for rejection. The applicant will see this message.
Edit Account Details
Modify the employee's profile and region assignments below.
Admin Data Transfer
Transfer all active customer accounts, technical enquiries, quotation drafts, and direct reports from this employee to another active representative.
Name (email@example.com)
More Options
💔 Mark Quotation as Lost
📦 Shipment Tracking
✍️ Update Shipment Status
✉️ Email AWB to Customer
🗳️ Review Requisition
🔑 Approval Delegation
Temporarily hand your approval authority to someone else (e.g. while travelling). They'll see the approval queue and approve on your behalf, with a clear audit trail.
Delegations
✍️ Manual Order Update
Update this order on the supplier's behalf — use this when the supplier doesn't have portal access.
Promised ETA is never changed — only the Revised ETA is updated.
Add New Supplier
Supplier Visibility
By default the supplier's name is hidden from all sales reps in tracking. Tick the reps who are allowed to see this supplier.
📎 Attachments
PDF, images, drawings (DWG/DXF), Office docs — up to 10MB each.
📄 Upload document
No file chosen
PDF, JPG, PNG, TIFF, XLSX or DOCX — up to 25 MB.
Supplier Portal Login
The supplier signs in with this email & password (no OTP). Share it securely — it's also emailed to them if their address is on file.
📧 Email Quotation
📎(Click to view PDF)
Select ISO 513 Workpiece Material Group
🔍
Bulk Enquiry Import (CSV)
Upload enquiry records in bulk using a CSV file. Download the CSV template, populate the columns, and upload it here.
Parsed Enquiries (0)Please review before importing
Row
Action
Enquiry ID
Customer
Component
Stage
Value (₹)
Rep
Status
Bulk Customer Import (CSV)
Upload customer records in bulk using a CSV file. Download the CSV template, populate the columns, and upload it here.
Parsed Customers (0)
Row
Action
ID
Name
Industry
Tier
Rep
City
Status
Adjust & Crop Profile Photo
Add New Item
Bulk Items Import (.xlsx / .csv)
Upload products in bulk using an Excel file or CSV. Download the Excel template, fill it out, and upload it here.