Nutan Inventory Tool

👓

Welcome to Nutan Inventory Tool

Upload your inventory report and sales report to get your full analysis — BUY/HOLD/STOP, Transfer Plan with barcodes, Reorder Plan within budget, and more.

📁 Upload Your Data

Upload your Tally/billing export files directly — no renaming columns needed. The app reads your exact format.

1

Upload your Inventory Report (XLS/CSV from billing system)

2

Upload one or more Sales Reports (same format)

3

Click Run Analysis

Upload Mode: Currently: Optical Frames

📦

Inventory Report

Your stock export — reads: Branch Name, Barcode, Product, Brand, Color, Shape, Material, Size, Total Sales (Rs), Quantity, Status

📂 Choose File

💰

Sales Report(s)

Your sales export — reads: Branch Name, Order Date, Product Type, Brand, Color, Shape, Material, Size, Net Amount, Quantity, Barcode, Status

📂 Choose File(s)

🔭

Lens Sales Report (Lens Division)

Your lens billing export — reads: Branch, Date, Design, Coating, Material, Brand, Revenue, Cost

📂 Choose Lens File

🏥

Hospital Retail Report (Gajanan + Vasudev)

Combined frame + lens billing export for Gajanan Nagar & Vasudev Nagar hospital branches

📂 Choose Hospital Report

🏷️

Supplier Code List (optional)

Maps the last 2 digits of each barcode to a supplier name. Two columns: Code (2-digit) and Supplier Name. Once loaded, Supplier shows across all tables & exports.

📂 Choose File

🎨

Color Code List (optional)

Maps the 3rd and 4th digits from end of each barcode to a color name. Two columns: Code (2-digit) and Color Name. Once loaded, Color shows in Supplier Intelligence.

📂 Choose File

MRP Range (₹) – Purchase Price (₹) –

Branch

All Branches▾

Brand

All Brands▾

Shape

All Shapes▾

Size

All Sizes▾

Color

All Colors▾

Type (Material)

All Types▾

Vendor

All Vendors▾

BUY / HOLD / STOP by New Product Code

Photos	New Product Code	Original Code	Bin Code	Supplier Code	Supplier Name	All Suppliers	Brand	Branch	Material	Color	Shape	Size	Stock Qty	Sold 12M	Monthly Avg	Stock Cover (Months)	Velocity	MRP (₹)	Action	Qty to Buy	Suggested Vendor	Last Buy Date	Barcodes

Manual Budget Override (₹) — leave 0 for auto GP budget

Min Sales / Year

Min Order Qty

Margin Divisor

Branch

All Branches▾

Brand

All Brands▾

Shape

All Shapes▾

Size

All Sizes▾

Color

All Colors▾

Type (Material)

All Types▾

Vendor

All Vendors▾

MRP Range (₹) – Purchase Price (₹) –

Purchase / Reorder Plan — Fast → Medium → Slow priority within budget

		Photos	Branch Stock	Short Branches	New Product Code	Original Code	Bin Code	Supplier Code	Supplier Name	★ Recommended Supplier	Signal & Reasoning	Brand	Material	Color	Shape	Size	Current Stock	Sold 12M	Monthly Avg	Velocity	Trend	Target Mo.	Target Stock	Units to Buy	Tags	MRP (₹)	Purchase Price (₹)	Total Cost (₹)	Cumulative (₹)	Budget Status	Last Buy Date	Barcodes (Current Stock)

Stock Transfer Plan — Barcode Level (staff pick list)

Filter: From → To Min units to justify a trip: 🏷 Clearance cap — Gajanan Nagar: Vasudev Nagar: Karanja: New-branch protection (days):

Photos	New Product Code	Material	Color	Shape	Size	From Branch	To Branch	Transfer Qty	From Stock	To Stock	From Share %	To Share %	Barcodes to Pick	🗂 Tray No	Flag	Decision

Top 100 Product Codes — All Branches Combined

Photos	Rank	New Product Code	Original Code	Brand(s)	Material	Color	Shape	Size	Units Sold	Monthly Avg	Current Stock	Revenue (₹)	Sell Through %	Active Branches	Barcodes (In Stock)

Dead & Slow Moving Stock

Photos	Barcode	Product Code	Brand	Branch	Material	Color	Shape	MRP (₹)	Age (Days)	Purchase Date	Tray No	Status	Action

Stock Cover by Branch (Months)

BUY Codes by Branch

Branch-wise Detail

Branch	Total Stock	Sold 12M	Monthly Avg	Stock Cover (Months)	BUY Codes	HOLD Codes	STOP Codes	TRANSFER Codes	Fast	Medium	Slow	Dead

📊 Branch × Type — Demand vs Supply

Sold = last 3 months actual · Stock = current · Gap = units missing

🔴 Below threshold | 🟠 Stock < demand | 🟡 Cover < 2 months | ✅ Adequate

📋 Picker List — One Barcode Per Row

Photos	#	✓	🗂 Tray ↕	Barcode ↕	From Branch ↕	To Branch ↕	Brand	Material	Color	Shape	Size	MRP	Flag

📦 Physical Shelf Layout

Rows Cols Boxes/cell Frames/box Stock months

📋 Box List — Capacity & Fulfilment

Material	Box / Group	Qty (stock period)	Boxes	Fill %

💎 Brand Section — MRP ≥ ₹3,000

⭐ A = sold monthly | 🔵 B = sold every 2–3 months | ⚪ C = sold rarely | 🔴 Reorder = days since last sale ≥ avg interval

📊 ABC Analysis — Product SKU Performance

A = top 50% of revenue | B = next 30% | C = bottom 20% | Velocity = units/month | Revenue = MRP × units sold

#	ABC	OldCode / SKU	Brand	Material	Color	Price Band	MRP	Units Sold	Vel/mo	Revenue	Rev %	Cum %	In Stock	Stock Status	3mo S/T (OldCode)	3mo S/T (Barcode)

Filter Items Before Generating PO

Brand / Vendor

All Brands▾

Shape

All Shapes▾

Size

All Sizes▾

Color

All Colors▾

Material / Type

All Materials▾

Branch

All Branches▾

Price Range (₹)

–

GST %

📍 Branch:

🧾

No Purchase Orders Yet

Run your analysis first, then click Generate POs to auto-create orders grouped by brand/supplier.

Manual PO — built by hand, not from Generate POs

🧾

No Manual POs Yet

Use "New Supplier PO" to start one from scratch, or create one from Reorder Plan / Transfer Vendor.

New Format Stock — Barcode + Product Code Both Verified

Only NPCs where at least one physical unit has a fully decodable barcode AND product code (real or high-confidence generated). Stock, velocity and signal figures are the same trusted numbers used everywhere else in the app.

MRP Range (₹) – Purchase Price (₹) –

Nutan Inventory Tool · v4.2

Kaise Use Karein Ye Tool?

Poora guide — pehli baar file upload karne se lekar Frame Finder tak sab kuch step by step.

Seedha jump karo

① Data Upload ② Analysis Chalao ③ Stock Action ④ Reorder Plan ⑤ Transfer Plan ⑥ Frame Photos ⑦ Purchase Orders ⑧ ASN / GRN ⑨ Frame Finder

Step 1

Data Upload Karo

Sidebar mein Upload Data pe click karo. Apne billing system se do files export karke upload karo:

📦 Inventory Report

Abhi jo stock hai uski Excel file. Ismein hona chahiye: Branch Name, Barcode, Brand, Color, Shape, Material, Size, Quantity, MRP, Status.

Dhyan rakho: Status column mein "Confirm" hona chahiye — tabhi row count hogi.

💰 Sales Report

12 mahine ki sales ki Excel file. Ek file ya multiple bhi chal sakti hain (jaise Apr–Dec 2025 + Jan–Mar 2026 alag alag).

Dhyan rakho: Sales mein Status "Confirmed" hona chahiye. Return, Pending, Deleted wali rows automatically exclude ho jaati hain.

💡 File upload hone ke baad Column Mapper khulta hai. Yahan dekho ki columns sahi match ho rahe hain ya nahi — agar galat lage toh correct karo — phir Import with this mapping pe click karo.

Step 2

Analysis Chalao

Top bar mein ▶ Run Analysis pe click karo. 10 second mein poora kaam ho jaata hai — saare reports ek saath ready ho jaate hain:

✓Har frame ka New Product Code banata hai (FR-MAT-CLR-SHP-SZ)

✓Har branch ka stock cover aur velocity calculate karta hai

✓BUY / HOLD / STOP signal deta hai

✓Dead stock detect karta hai (frames 180+ din, sunglasses 120+ din)

✓Monthly budget (₹1,60,000) ke andar reorder plan banata hai

✓Transfer plan mein exact barcode numbers deta hai

✓ABC / FIFO / Gross Margin / Brand analysis ek saath

✓Auto-save hota hai — agli baar tool khologe toh data wapas aa jaayega

⚠️ Agar console mein totalMonths: 1 dikh raha hai toh sales file dobara upload karo aur Run Analysis dobara chalao — dates se automatically 12 mahine calculate hote hain.

Step 3

Stock Action Report — Kya Khareedna Hai?

Har product code, har branch pe — ek clear action signal ke saath. Top pe teen view modes hain:

📦

By Product

NPC ke hisaab se grouped — har category ka aggregate stock aur signal

🏷

By Barcode

Ek ek frame level pe. Upar analytics panel aata hai — age chart, branch chart, price band chart

🔍

Frame Finder

PDF catalogue ya photo upload karo — seedha is page pe match dekhna

🟢 BUY Stock cover 3 mahine se kam — abhi order karo 🟡 HOLD 3–6 mahine — dekho, abhi mat order karo 🔴 STOP 6+ mahine ya dead — bilkul mat order karo

Photos: Thumbnail pe left-click karo → fullscreen lightbox khulta hai, ← → se navigate karo. Right-click → photo manage karo (reupload/delete). ⬇ Export ▾ se CSV, Excel, Excel+Photos (.xls), ya PDF+Photos download karo.

Step 4

Reorder Plan — Exactly Kya Order Karna Hai?

Sirf BUY wale items — Fast → Medium → Slow sorted, monthly budget mein cap. Har row mein ek ▶ button hai — click karo toh us NPC ke andar ke top 10 models dikhaata hai:

▶ Model Breakdown Kaise Kaam Karta Hai

1. Kisi bhi reorder row pe ▶ click karo
2. Us NPC ke andar ke top 10 OldCodes dikhte hain — photo ke saath, supplier name, kitne bika, last sale date, aur suggested order quantity
3. Quantities sales velocity ke hisaab se split hoti hain — jo jyada bika usko jyada units
4. Har supplier ke liye alag 📋 Generate PO button — OldCode level pe exact PO banta hai

By Barcode view mein barcode analytics panel aata hai. Frame Finder view mein seedha is page pe catalogue ya photo upload kar sakte ho.

Step 5

Transfer Plan — Ek Branch Se Doosri Pe Stock Shift Karo

Jab ek branch mein zyada stock ho aur doosri mein kam — toh khareedne ki zaroorat nahi, bas shift karo. Har row mein exact barcode numbers diye hain jo staff ko shelf se pick karne hain.

Logic: Ek branch 60% se zyada hold kare AND doosri 35% se kam — tabhi transfer trigger hota hai

⚠ Flag: Jo barcodes ⚠ se mark hain — unhe physically verify karo pehle (sold, missing ya misplaced ho sakta hai)

By Barcode view: Individual frames dikhta hai jo move karne hain — age charts ke saath analytics panel upar aata hai

Frame Finder inline: Photo ya PDF upload karo — dekho exactly kaunse frames kahan se transfer karein

Step 6

Frame Photos — Upload Karo, Dekho, Manage Karo

Photos browser ke IndexedDB mein save hote hain — session close ho toh bhi rehte hain, aur poore tool mein dikhaate hain (Stock, Reorder, Transfer, PO, ASN, sab jagah).

📤 Upload Kaise Karein

Option A: Frame Photos page pe jao → Individual Images ya ZIP upload karo

Option B: Kisi bhi table row mein 📷 icon pe click karo → us barcode ka photo management modal khulta hai

ZIP naam: File ka naam barcode number rakho (jaise 669592.jpg) — automatic match ho jaayega

🖼 Dekhna Kaise

Thumbnail pe left-click → fullscreen lightbox
Keyboard: ← → se navigate karo, Esc se band karo
Dot indicators neeche — seedha kisi photo pe jump karne ke liye click karo

Right-click thumbnail → manage modal (Reupload / Delete)

💡 Best practice: Saare frames ko white background pe same angle se photo lo. Isse Photo Finder matching bahut accurate ho jaati hai.

Step 7

Purchase Orders — Reference Photos ke Saath

POs analysis ke baad auto-generate hote hain, ya Reorder Plan se manually banate ho. Har line item ke neeche top 5 most-sold barcodes ke reference photos dikhaate hain — taki ordering ke waqt exact frame pehchan mein aaye.

📸 Reference strip: Har line ke neeche blue row mein top 5 OldCodes ke photos, kitne bike, aur OldCode dikhta hai. Photo click karo → fullscreen lightbox

Reorder expand se: ▶ click karo → model breakdown dekho photos ke saath → 📋 Generate PO click karo → exact OldCode level PO banta hai

Frame Finder se: Supplier PDF upload karo → model numbers analyse ho → tick karo → Generate PO directly catalogue se ban jaata hai

Download: ⬇ Download PO (PDF format) ya 🖨 Print. Quantities inline edit kar sakte ho download se pehle.

✅ Supplier decode: Barcode ke last 2 digits = supplier code (jaise barcode ending 42 = Speco). Isse automatically supplier assign ho jaata hai aur quantities split ho jaati hain.

Step 8

ASN / GRN — Maal Aaya? Yahan Check Karo

Jab supplier se maal aaye, ASN / GRN pe jao. Har PO automatically yahan ASN card ke roop mein dikh jaata hai — reference photos ke saath taki receiving staff visually verify kar sake.

1Har PO card mein ordered lines dikhti hain — reference photos ke saath. Dekho kaunsa frame aa raha hai — photo se verify karo

2Received column mein kitna maal aaya woh quantity daalo. Status apne aap update hota hai: Pending → Partial → Received

3Ek hi baar sab mark karna ho toh ✅ Mark All Received pe click karo

4Receipt status auto-save hota hai — agli baar tool khologe toh bhi dikh jaayega

Step 9

Frame Finder — Catalogue Scan Karo ya Photo Match Karo

Sidebar mein TOOLS ke andar milega. Aur Stock / Reorder / Transfer pages pe bhi 🔍 Frame Finder toggle se seedha us page pe use kar sakte ho.

📄 Catalogue Scanner

1. Supplier code daalo (jaise 42) aur naam
2. Supplier ka PDF drop karo — AI har page pe model number padhta hai (9000, 8978 waale numbers)
3. Har model tumhari inventory aur sales se match hota hai
4. Decision table dikhta hai:
  🟢 ORDER — abhi nahi hai, pehle bikta tha
  🟢 REORDER — hai par kam hai
  🟡 HOLD — kaafi hai, ruko
  🔴 DEAD — hai par bikta nahi
  ⚪ NEW — pehle kabhi nahi rakha
5. Tick karo → 📋 Generate PO

📷 Photo Finder

1. Kisi bhi frame ki photo upload karo
2. Tool tumhare IndexedDB mein stored saare photos se pixel matching karta hai (histogram + pHash)
3. Top 5 matches dikhta hai similarity score ke saath:
  🟢 85% se zyada — Strong Match
  🟡 60–85% — Possible Match
  🔴 60% se kam — Weak Match
4. Har card mein OldCode, barcode, branch, tray

Best result: White background, saamne se photo, same lighting.

🔤 New Product Code Samjho

FR — MT — BLK — SQ — M

FR

Type · Frame

MT

Material · Metal

BLK

Color · Black

SQ

Shape · Square

M

Size · 51–53mm

Material codes: TR (Plastic) · MT (Metal) · SH (Sheet) · SP (Supra) · RL (Rimless)

Size codes: S=48–50mm · M=51–53mm · L=54–56mm · XL=57mm+

Shape codes: SQ · RC (Rectangle) · CE (Cateye) · RD (Round) · AV (Aviator)

Supplier code: Barcode ke last 2 digits — jaise 42=Speco, 45=Vybe

⬇ Export Options — Kaise Download Karein

Har table mein ⬇ Export ▾ button hai — click karo toh 4 options milte hain:

⬇ CSV — Simple data file, Excel mein khulti hai, bahut fast

⬇ Excel — Formatted .xlsx, photos nahi honge

📸 Excel + Photos — HTML table format (.xls) jisme photos embedded hain. Excel mein khulta hai — agar format warning aaye toh Yes/OK click karo. Max 300 rows.

📸 PDF + Photos — Landscape A4 PDF, photos column ke saath. Max 180 rows.

📅 Mahine Ka Routine — Kab Kya Karna Hai

Mahine ki 1 tarikh

Billing system se Inventory Report aur full year Sales Report export karo

Upload

Upload Data → column mapping confirm karo → Run Analysis

Transfer

Transfer Plan → barcode pick list export karo → staff ko do shelf se pick karne ke liye

Order

Reorder Plan → har row mein ▶ click karo → model photos dekho → PO generate karo → supplier ko email karo

Catalogue

Frame Finder → Catalogue Scanner → supplier ka PDF upload karo → AI model numbers padhta hai → kya order karna hai decide karo → PO generate karo

Maal Aaya

ASN / GRN → reference photos se verify karo → received quantity daalo → Mark All Received

Clearance

Dead Stock report → 180+ din wale frames → discount offer karo, bundle karo, ya supplier ko wapas karo

🧰 Baaki Tools — Kaam Kya Hai

🏆 Top Sold — Sabse zyada biki frames sab branches mein, velocity se ranked. Display placement aur reorder priority decide karne ke liye.

📊 ABC Analysis — A = top 20% jo 80% revenue laate hain · B = medium · C = slow movers. Inventory investment decisions ke liye.

📦 FIFO Tracker — Sabse pehle ka stock pehle becho. 90d/180d/270d/365d+ age filter karo. Purana stock naya aane se pehle nikalna chahiye.

💹 Gross Margins — Har brand ki revenue vs cost. Kaun sa brand sabse zyada profitable hai — supplier se negotiation mein kaam aata hai.

🏪 Branch Summary — Har branch ka stock cover, BUY count, dead count. Branch × Type demand vs supply matrix bhi hai — gap analysis ke saath.

🔬 Supplier Intel — Supplier ke Available + Sold files upload karo → full cross-analysis — kya reorder karna hai margin data ke saath.

💾 Auto-Save — Sidebar ke neeche save indicator hai. Analysis ke baad 1.5 second mein auto-save hota hai. Tool dobara kholo — data wapas aa jaayega (30 din tak).

📤 Export / Import JSON — Export All se poora session save hota hai — photos samet. Doosre device pe Import JSON se restore kar sakte ho.

📅 4-Month Inventory Policy — Tool Ka Poora Support

Ye tool specifically 4-month inventory cycle ke liye design kiya gaya hai (branch target 4 mahine, network target 5 mahine — 1 mahina distribution buffer). Neeche har feature ka role explain hai.

✅ 4 Mahine Ka Stock Kyun?

• Frames expire nahi hote — fashion slowly badalta hai

• Top 20% products 80% revenue karte hain — unka cover hamesha ready

• Suppliers local hain — delivery 2-7 din mein, 6 mahine buffer nahi chahiye

• Zyada stock = dead capital + stale assortment

• 12+ mahine ka stock = paisa banta nahi, shelf mein sada rehta hai

• 3x turnover/year = 4-month cycle ka natural result

🛠 5 Systems Jo 4-Month Policy Ko Enforce Karte Hain

System 1

Transfer Plan — Pehle Move Karo, Phir Khareedna

Nayi cheez: Transfer qty ab velocity se calculate hoti hai — equal split nahi.
Formula: Target = Velocity × 4 months
Agar kisi branch ka stock target se 40% zyada hai → surplus hai → donor banti hai.
Agar target se 40% kam hai → deficit → receiver banti hai.
Result: Har branch exact 4 mahine ka stock receive karti hai transfer ke baad — bina kuch khareedne ke.

System 2

Per-Branch Cover Target — Dashboard Pe Set Karo

Dashboard pe neeche Cover Target per Branch sliders hain.
Har branch ka alag target set kar sakte ho — 1 se 6 mahine tak (0.5 step mein).
Example use:
  Gajanan Nagar → 5 months (restock mushkil hai, zyada buffer chahiye)
  Madhav Nagar → 4 months (main branch, default target)
  Khamla → 3 months (chhoti branch, slow market)
Settings auto-save hoti hain — agli baar tool khologe toh wahi rahegi.

System 3

Open PO Deduction — Double Order Mat Karo

Agar pichle hafte koi PO place ki hai aur maal abhi tak nahi aaya — Reorder Plan ko pata hai.
In-transit frames automatically detect hote hain (DRAFT_POS + DRAFT_ASNS se).
Reorder rows mein ⏳ N in transit badge dikhta hai.
Result: Tum same items dobara order nahi karoge — paisa waste nahi hoga.

System 4

Monthly Cycle Dashboard — Kab Kya Karna Hai

Dashboard pe Monthly Inventory Cycle checklist hamesha dikhi rahti hai.
6 steps track hote hain automatically:
  ① Inventory uploaded   ② Sales uploaded   ③ Analysis run
  ④ Transfers executed   ⑤ POs placed   ⑥ GRN received
Data freshness indicator:
  🟢 Green = data 20 din se kam purana
  🟡 Amber = 20–35 din — refresh karne ka time
  🔴 Red = 35+ din — zaroor upload karo
Mahine ki 1-5 tarikh ko special reminder banner dikhta hai.

System 5

Partial Report Detection — Purana Data Mat Chalao

Upload ke baad tool automatically check karta hai ki inventory report complete hai ya date-filtered.
Kya detect hota hai:
• Agar sabse purana frame 400 din se kam purana hai → ⚠️ warning
• Agar total frames 500 se kam hain → ⚠️ warning
Warning message: "Possible partial export detected — oldest stock is X days ago. Re-export WITHOUT date filter."
Fix: CRM se inventory export karo — Added Date filter blank rakho — sab stock aa jaayega.

📋 Mahine Ka Complete Workflow — 3-Month Policy ke Saath

1 tarikh

CRM se fresh inventory export karo — NO date filter — phir sales report. Tool mein upload karo.

Check

Upload hone ke baad f-inv-label check karo — partial report warning toh nahi? Agar hai → re-export karo.

Analysis

▶ Run Analysis. Dashboard pe cycle checklist dekho — steps tick hote jayenge.

Transfer

Transfer Plan → velocity-based qty dikhi hogi. Pehle ye execute karo — free mein stock level fix ho jaata hai.

Reorder

Reorder Plan → in-transit badges dekho pehle — jo already order kiya hai wo show hoga. Baaki ke liye PO generate karo.

PO → ASN

PO generate karo → PDF with Photos supplier ko bhejo → maal aaye toh ASN/GRN mein receive karo.

Clearance

Dead Stock → 180+ din wale frames → vendor return ya markdown. PO mein Dead Stock Return section use karo — negotiate karo.

Filter by Branch

Filter by Brand

Brand Sales — Product Codes by Branch

Photos	Brand	New Product Code	Original Code(s)	Branch	Material	Color	Shape	Size	Units Sold	Monthly Avg	Current Stock	Stock Cover	MRP (₹)	Purchase Price (₹)	Revenue (₹)	Action	Reorder Qty	Barcodes

📅

No History Yet

Each time you click Run Analysis, a snapshot is saved here automatically.

📋 Data Guide — Clean Data Requirements

Exact column specs, common mistakes, and downloadable templates

📦 Inventory File — Required Columns

Column Name	Required	Example Value	Rules
Branch Name	Required	NUTAN OPTICS -(Madhav Nagar )	Must contain branch keyword: Madhav Nagar, Manish, Khamla, Vasudev, Gajanan
Product	Required	Frame	Must be exactly "Frame" — app filters on this
Status	Required	Confirm	Must be exactly "Confirm" (not Confirmed) — app filters on this
Quantity	Required	2	Whole number. No negatives.
Total Sales (Rs )	Required	2050.00	MRP per unit. Number only, no ₹ symbol needed.
Barcode	Important	669592	Unique per frame. Used for transfer pick list. App strips leading apostrophe automatically.
Product Code	Important	GRE6082BLA	Your existing product code. Shown alongside new FR- code.
Brand	Optional	GREAT	Used for Brand Sales tab and PO grouping.
Color	Optional	BLACK	Used to build New Product Code. Spell consistently — app normalizes 50+ variants.
Shape	Optional	ROUND	Valid: SQUARE, RECTANGLE, CATEYE, ROUND, OVAL, AVIATOR, HEXAGON, WAYFARER
Material	Optional	TR	Valid: TR, METAL, SHEET, SUPRA, RIMLESS, 3PCS, 3PCS-METAL
Size	Optional	52	Frame lens size in mm. Must be 40–70. Values above 100 are temple lengths — leave blank if unsure.
Added Date	Optional	20-04-2026	Used for Last Buy Date. Format: DD-MM-YYYY
Stock Age (In Days)	Optional	30	Used for dead stock detection. Whole number.

💰 Sales File — Required Columns

Column Name	Required	Example Value	Rules
Branch Name	Required	NUTAN OPTICS -(Madhav Nagar )	Same branch names as inventory file
Order Date	Required	01-04-2026	Format: DD-MM-YYYY. Must be a valid date.
Product Type	Required	Frame	Must be exactly "Frame" — app filters on this
Status	Required	Confirmed	Must be exactly "Confirmed" (not Confirm) — opposite of inventory
Quantity	Required	1	Units sold in this transaction. Whole number.
Net Amount (Rs )	Required	2050.00	Actual sale price after discount. Used as MRP for revenue calculations.
Brand, Color, Shape, Material, Size	Important	GREAT, BLACK, ROUND, TR, 52	Used to build NPC for matching with inventory. Must be consistent with inventory file.

⚠️ Common Mistakes to Avoid

❌ Wrong Status

Inventory: "Confirmed" instead of "Confirm"
Sales: "Confirm" instead of "Confirmed"
App will show 0 rows if wrong.

❌ Size = Temple Length

Size should be lens diameter (40–70mm).
Values like 140, 145 are temple arm lengths — leave blank.
App treats any value outside 40–70 as UNK.

❌ Shape Spelling Errors

RACTANGLE, SQAURE, AVIETOR, CAT EYE
→ App normalizes 80+ variants automatically
but consistent spelling = better NPC matching.

❌ Product Type Wrong

Inventory: "Frame" column = "Frames" or "FRAME"
Sales: "Product Type" column must equal "Frame"
Exact match required.

❌ Missing Barcodes

Transfer plan needs barcodes to generate pick list.
Make sure Barcode column is included and populated.
App strips leading apostrophe automatically.

❌ Inconsistent Branch Names

Branch names must contain: Madhav Nagar / Manish / Khamla / Vasudev / Gajanan
App normalizes but Vasudev must be checked before Netralaya.

📥 Download Clean Templates

Pre-filled with 5 example rows using real Nutan-style data. Use these as the starting point for your monthly exports.

📦 Inventory Template

15 columns · 5 example rows · all 5 branches represented

💰 Sales Template

13 columns · 5 example rows · all 5 branches represented

ASN & GRN Documents

Generate from your Purchase Orders. ASN goes to supplier. GRN is filled when stock arrives.

Purchase Tracker

Every incoming shipment, tracked stage-by-stage from order to shelf. Update the stage dropdown as a shipment moves — the expected date and late-flag are computed automatically.

Lead times (working days, Sundays excluded)

Order → Warehouse Barcodes/day per person Mumbai travel Mumbai job Shelf prep Pick + transfer

+ Add a shipment

Needs Mumbai print

Shipment	Qty	Order Date	Current Stage	Expected By	Status

Gross Margin % by Brand

Revenue vs Cost by Brand

Brand-wise Gross Margin Analysis

Brand	Units Sold	Total Revenue (₹)	Total Cost (₹)	Gross Margin (₹)	Margin %	Avg Selling Price (₹)	Avg Cost Price (₹)	Active NPCs	Stock Units	Stock Value (₹)

📷 Frame Photos

Upload images matched to barcodes — supports individual files or a ZIP

📁 Upload ZIP 🖼 Upload Individual Images

How it works: Name your image files using the barcode number as the filename. Example: 669592.jpg will automatically match to barcode 669592. Supported formats: JPG, PNG, WEBP. Upload as individual files or a ZIP containing all images.

🖼

No Photos Uploaded Yet

Upload frame images named by barcode number. They will appear here and also show in your reports.

📂 Upload Supplier Files (Inventory report format — one for Available, one for Sold)

Export from Tally filtered by date/supplier → upload both → get full cross-analysis, reorder signals, Excel & PDF download

⬆ Available File ⬆ Sold File

Filter by period:

From

To

Top 10 Products Sold

Revenue vs Cost

Top Sold Products

Photo	New Product Code	Original Code	Bin Code	Sup Code	Supplier Name	Brand	Units Sold	Revenue (₹)	Avg Sell Price (₹)	Avg Cost Price (₹)	Margin %	Velocity	In Stock	Barcodes

What to Reorder from This Supplier

Photo	New Product Code	Original Code	Branch	Material	Color	Shape	Size	Current Stock	Monthly Avg	Stock Cover	Units to Buy	Purchase Price (₹)	Total Cost (₹)	Last Buy Date	Barcodes

📦 FIFO Tracker — First In, First Out

Shows your oldest stock that must be sold first. Frames sitting longest are marked — these should be prioritised for display, promotion or markdown before newer stock.

Branch

Age Filter

Show

FIFO Stock List — Oldest First

Nutan Inventory Tool

📋 Workflow Dashboard

Daily briefing, monthly cycle tracker, weekly checklist, quarterly aur yearly review — sab ek jagah.

📋

Workflow Load Ho Raha Hai...

Agar yahan kuch nahi dikh raha toh ek baar koi aur tab open karo phir wapas aao.

🚨 Critical Stock — Demand vs Supply per Product Code per Branch

Photos	Barcode / Product	Branch	Band	Status	Must-Stock	Demand/mo	Consistency	Trend	In Stock	Cover	Safety Stock	Reorder Qty	MRP	Last Units (Barcodes)

🏭 Supplier Scorecard

Revenue · Sell-through · Top model per supplier

Supplier	Code	Models	Units Sold	Revenue	In Stock	Sell-Through	Top Color	Top Model

🎨 Color Performance

Color	Type	Code	Units Sold	Revenue	In Stock	Sell-Through	Unique Models

🔍 Model × Color × Supplier

Supplier	Model No.	Color	Units Sold	Revenue	In Stock	Cover	Active Months	Avg Price

🔍 Frame Finder

Match frames from supplier catalogues or photos against your inventory

📄 Supplier Catalogue Scanner

Supplier Code

Supplier Name (optional)

Upload Supplier PDF or Images

📄

Drop PDF or images here

Supports PDF, JPG, PNG — multiple files OK

Dashboard

Welcome to Nutan Inventory Tool

Branch-wise Sales (12M)

Stock Action Distribution

Inventory by Price Bucket

Top 10 Product Codes Sold

📁 Upload Your Data

Inventory Report

Sales Report(s)

Lens Sales Report (Lens Division)

Hospital Retail Report (Gajanan + Vasudev)

Supplier Code List (optional)

Color Code List (optional)

BUY / HOLD / STOP by New Product Code

Purchase / Reorder Plan — Fast → Medium → Slow priority within budget

Stock Transfer Plan — Barcode Level (staff pick list)

Top 100 Product Codes — All Branches Combined

Dead & Slow Moving Stock

Stock Cover by Branch (Months)

BUY Codes by Branch

Branch-wise Detail

📊 Branch × Type — Demand vs Supply

📋 Picker List — One Barcode Per Row

📦 Physical Shelf Layout

📋 Box List — Capacity & Fulfilment

💎 Brand Section — MRP ≥ ₹3,000

📄 Purchase Order — Brand Frames

📊 ABC Analysis — Product SKU Performance

No Purchase Orders Yet

No Manual POs Yet

Kaise Use Karein Ye Tool?

Data Upload Karo

Analysis Chalao

Stock Action Report — Kya Khareedna Hai?

Reorder Plan — Exactly Kya Order Karna Hai?

Transfer Plan — Ek Branch Se Doosri Pe Stock Shift Karo

Frame Photos — Upload Karo, Dekho, Manage Karo

Purchase Orders — Reference Photos ke Saath

ASN / GRN — Maal Aaya? Yahan Check Karo

Frame Finder — Catalogue Scan Karo ya Photo Match Karo

🔤 New Product Code Samjho

⬇ Export Options — Kaise Download Karein

📅 Mahine Ka Routine — Kab Kya Karna Hai

🧰 Baaki Tools — Kaam Kya Hai

📅 4-Month Inventory Policy — Tool Ka Poora Support

Brand Sales — Product Codes by Branch

No History Yet

📦 Inventory File — Required Columns

💰 Sales File — Required Columns

⚠️ Common Mistakes to Avoid

📥 Download Clean Templates

ASN & GRN Documents

Purchase Tracker

Gross Margin % by Brand

Revenue vs Cost by Brand

Brand-wise Gross Margin Analysis

No Photos Uploaded Yet

Top 10 Products Sold

Revenue vs Cost

Top Sold Products

What to Reorder from This Supplier

FIFO Stock List — Oldest First

📋 Workflow Dashboard

Workflow Load Ho Raha Hai...

🚨 Critical Stock — Demand vs Supply per Product Code per Branch

🏭 Supplier Scorecard

🎨 Color Performance

🔍 Model × Color × Supplier

🔍 Frame Finder

📄 Supplier Catalogue Scanner

Catalogue Analysis Results

📷 Photo Finder — Match a Frame

Top Matches

Map Columns