SolarClue Price Book
Your private vendor price list — add once, find the best deal instantly. Saved on this device.
🗾 States
Add the states you deal in. Lets a vendor cover a whole state at once instead of listing every city.
🏙️ Cities
Add the cities you deal in. These will appear in dropdowns everywhere. Linking a state is optional but powers state-wide vendor coverage.
🏷️ Brands
Add brand names (e.g. Vgaurd, Supreme, Racold, Nuetech, Havells, Anu, Inca).
📦 Models
Define each model under a brand & category, with its standard capacities (e.g. 100, 150, 200, 250, 300, 500 LPD) and warranty. These capacities become the rows of the matrix entry grid.
| Category | Brand | Model | Spec | Warranty | Capacities | Stock |
|---|
Tick a category to mark the whole category out of stock. The quote tool shows a warning when a quoted item is in an out-of-stock category.
🧑💼 Vendors
Add vendor name, home city, contact, the areas they cover (can be cities in other states too), and what they deal in. Used both for price entry dropdowns and the Vendor Directory search.
| Vendor | Home City | Contact | Coverage | Deals in |
|---|
Find vendors & compare prices
Leave both blank to see all India. Pick a state to narrow to that state. Pick a state + city to narrow to that exact city (state-wide and Pan-India prices still apply automatically).
Vendor Directory — all vendors, filter to narrow down
Every vendor's full profile — home city, everywhere they cover (cities, states, or Pan India), and what they deal in — whether or not a price has been uploaded yet. Apply filters below to narrow the list.
Add / Update a price entry
Pick from your saved cities/vendors/brands/models (set these up once in the Setup tab). Re-selecting the same combination updates the existing price instead of duplicating.
Bulk update prices
Like your Excel sheet: pick a price scope, vendor, category & brand — a grid opens with capacities as rows and that brand's models as columns. Fill in prices and save once. A vendor covering the whole state or all of India does not need a specific city.
Pick a vendor first — Pan-India and whole-state vendors don't need a city. All of that vendor's products appear below; use the city filter only to narrow down a vendor that covers many places. Update prices and click Save once.
| Category | Product | Brand | Area | Price (₹) | Transport (₹) | Lifting (₹) | Install (₹) | Total (₹) | Comments |
|---|
Every saved entry, editable directly. Use search to narrow down. Edited cells highlight in orange — click "Save all changes" when done.
| Category | Product | Brand | City | Vendor | Price (₹) | Transport (₹) | Lifting (₹) | Install (₹) | Total (₹) | Comments |
|---|
All saved entries
| Category | Product | Variant | Brand | City | Vendor | Price | Transport | Lifting | Install | Accessories | Contact | Comments | Updated |
|---|
💾 Backup Everything — all 3 tools in one file
This single backup covers everything in the whole portal — the Price Book, the Products Quote tool, and the Solar Power Quote tool — including all saved quotes, settings, vendors and gallery photos. One file, one restore. Keep a copy in Google Drive; to move to a new device, back up here and restore there.
📂 Automatic backup — no files to hand around
Set this up once and stop exporting JSON by hand. Point it at a cloud-synced folder (iCloud / Google Drive) and every save backs up there automatically, off-site.
Advanced — Price Book only
These export/import only the Price Book price entries (not quotes or power quotes). Most of the time you want "Backup Everything" above instead. Importing here automatically rebuilds your Setup (vendors, cities, brands, models) from the price entries.
🔧 Rebuild Setup from price entries
If vendors, cities, brands or models are ever missing from Setup/Bulk Update dropdowns even though the prices show up fine elsewhere, click this — it scans all your price entries and re-creates anything missing (never deletes existing Setup data).
📄 Price List PDF
Generates a clean, minimal price list — just the essentials (category, product, brand, city, vendor, price). Apply any filters below to narrow it down first. Opens a print preview where you can choose "Save as PDF".
📈 Price Trends
Pick a product to see how its price has moved over time across vendors/cities. Only products with more than one recorded price show a trend line.
🕒 Recent price changes
🗓️ Price as of a date
Pick any past date and see what the price was on that day, across all products matching your filters (not just one product).
🖼️ Reference Gallery
Keep product photos, vendor quotations, catalogues or any reference document — tag each by category, brand and vendor so you can find it fast.
Browse
Solar Quote System
Varistor Technologies
Customer Details
Reference: —
Quote Program
Is this quote under the subsidy program? The subsidy deduction is applied only on subsidy-program quotes.
Type of System
Select the system type for this installation.
The net meter is always a smart meter and its phase follows the inverter. If the Bescom meter isn't already smart, a Bescom smart-meter cost is added automatically.
Solar Panels
Select a panel product, then enter quantity. Capacity is calculated automatically.
On-Grid Inverter
Select brand, then capacity. Price is tied to this exact brand + capacity combination.
Solar Structure
Build any combination — add one row per structure the panels sit on (e.g. Elevated GI + Sheet Roof, or Normal + Mangalorean). The panel counts must add up to the total number of panels.
Cables
Select cable brand, then size and length for each type. Set any length to 0 to leave that cable out of the combined cable line.
DCDB / ACDB
🔒 DCDB / ACDB price is determined automatically from capacity.
Battery (Hybrid System)
Meters
The meter charge is calculated automatically: the net meter (always smart) follows the inverter phase, plus a Bescom smart-meter cost if the Bescom meter isn't already smart. Set on the System Type step.
Engineering & Notes
🔒 Engineering price and Subsidy amount are determined automatically from capacity.
Set the split and TAT for this quote. These appear on page 4 (Payment Schedule & Project Timeline).
These notes appear on the customer's PDF. The admin can review and edit them before approving.
✅ Review & Submit for Approval
Check the summary below, then submit to admin for approval.
My Submitted Quotes
Track status, revise materials, or apply a discount. Click a row to see version history.
Customers
Everyone you've prepared a quote for. Start a new quote pre-filled with their details.
🖼 Photo Gallery
Add installation photos with details, or select multiple photos and download them. Photos are stored on this device with effectively unlimited capacity.
📚 Datasheets — Solar Panels, Inverters & Batteries
Store product datasheets with brand, capacity and technology, then filter, select and download them anytime. Stored on this device with effectively unlimited capacity.
✅ Pending Quote Approvals
Review each quote, then approve or reject.
Quote Review
🏙 City Pricing
Each city keeps its own full copy of all pricing sections (panels, inverter, structure, cables, margins, subsidy, terms — everything below). Pick a city to edit its prices; adding a city starts as a copy of the current one. New quotes use the pricing of the city selected here (and on the New Quote screen).
Company & Letterhead
🔢 Reference Number
Format: PREFIX + number. Number auto-increments with every new quote (not on revisions).
🏷 Brands
Add every brand once, and tag which category it belongs to. A brand can belong to more than one category (e.g. DEYE makes both inverters and batteries) — only matching brands will show up in each product dropdown.
🛡 Warranty Options
Add the warranty terms you offer once (e.g. "10 Years"). They'll appear as a dropdown when adding inverters and batteries — pick instead of retype.
💾 Backup & Share Pricing Data
This tool runs entirely in your browser — there's no shared server. Configure everything here on your laptop, then Export a data file and send it to your employees (email, WhatsApp, USB, anything). They open the tool on their own laptop and use the "📥 Load Pricing Data" button (top of the page, no admin password needed) to load it instantly — no retyping. Re-export and resend whenever you update prices.
Note: this syncs pricing/product data only. Submitted quotes and approvals still need to be reviewed on whichever device they were submitted from, since this is also browser-only storage.
☀ Panel Products
Brand + wattage + purchase price per watt. Panel cost = wattage × price/W × quantity. Capacity = wattage × quantity ÷ 1000.
🔌 Inverter Products
Price depends on Brand AND Capacity together — a 3kW and 5kW inverter from the same brand can (and usually do) cost differently. Add one row per brand + capacity combination, with separate On-Grid and Hybrid prices.
🏗 Structure Cost Formula
Normal (RCC) structure cost = (Number of Panels ÷ 3) × A × B, where A depends on elevation and B on material. Sheet Roof and Mangalorean Roof are priced per panel. Mixed roofs price each segment with its own structure rate.
🔗 Cable Sizes & Prices (per metre)
Add as many sizes as you need. Used for DC, AC, Earthing, and Battery cables alike.
⚡ DCDB / ACDB — Price by Capacity
Add a price for each kW tier. The nearest tier at or above the system's capacity is used. Hybrid systems automatically add the fuse protection price below.
🔋 Battery Products (Hybrid)
Add Brand + Capacity (Ah) + Type + Price per unit. Different capacities and types can have different prices.
📟 Meters & Fixed Items
Meter cost = Net-meter cost (always smart; phase follows the inverter) + Bescom smart-meter cost when the Bescom meter isn't already smart. No permanent meter at site = ₹0.
🛠 Engineering & Commissioning — Price by Capacity
Same pattern as DCDB/ACDB.
💰 Profit Margin — by Capacity (Admin Only)
Every kW tier can have its own margin — either a fixed ₹ amount or a % of the total quote. Employees never see or control this.
🎁 Subsidy Logic
Linear ramp from Tier-1 capacity/amount up to Tier-2, then fixed beyond Tier-2. Applied automatically — never asked from employee.
🚧 Discount & Profit Protection
Controls the "Discount" button employees use on submitted quotes. Whichever limit is tighter wins — if the profit floor would be breached before the max discount is reached, the floor takes priority. Employees cannot enter any value above this; the field is enforced automatically.
Quote Text Sections
🔒 Admin Login
Enter the admin password to access pricing and approvals.
Confirm
Varistor Solar Quotes
Choose the quotation you want to prepare.
Varistor Solar Heater
Solar water heater quotations — ETC & FPC, pressure & non-pressure — output with company profile, installation gallery & technical data sheet.
Prepare Solar Heater Quote →Varistor Solar Heat Pump
Commercial heat-pump quotations — tank, compressors, transport & payment terms with a live summary and branded PDF.
Prepare Heat Pump Quote →Varistor Solar Heater — Quote
📋 My Quotes & Versions
📷 Client Photo Gallery
⚙️ Settings
| Icon | Category | GST % | Models |
|---|