| PO Number | DC / Store | Brand | Amount | Status |
|---|---|---|---|---|
| Load data to see recent POs | ||||
Reliance Retail
D-Mart
Apollo
Vishal Mega Mart
V-Mart
Blinkit
Flipkart
No data yet. Process files or load from server.
Review the details below, set extension dates, then send the email.
| # | PO Number | Plant/Site | Store Name | Brand | Req Extension Till (edit) |
|---|
🕐 Viewer Timestamp Banner
Tokens: {DATE} {TIME} {ROWS} {USER}
🎨 Theme
Choose your color theme. Saved automatically. Works on mobile & desktop.
🏷 Brand Pill Style
Controls how brand & DC labels look in the Reliance and D-Mart tables — and in the brand legend bars. Saved automatically.
📱 Mobile Card Layout
Choose how PO rows are displayed on mobile. The selected template is saved automatically.
🔑 Change Passwords
👥 User Management
Roles: admin = full access · user = PO viewer · user_einvoice = PO viewer + E-Invoice · einvoice = E-Invoice only. Use Module Permissions to further restrict non-admin users.
| # | Username | Role | Actions |
|---|---|---|---|
| Loading users… | |||
🌐 External Page Access
Control which external tool pages require login to access.
Each keyword/prefix is matched against item descriptions to assign a brand automatically.
| Keyword / Prefix | Brand Name | Buyers | Actions |
|---|
When a PO is parsed (Vishal, D-Mart, V-Mart, Apollo), the first 5 characters of each item name are extracted as a Sub Brand code. If no brand mapping is found for that code, it appears below — assign a brand to add it to the mapping.
Keywords to auto-detect Store Location from V-Mart & Apollo PO PDFs.
🏬 VMM Store Location Master
Store names for Vishal Mega Mart PO are loaded automatically from the existing VMM Location Master using the Site Code field. When a PO Excel is uploaded, each store code is looked up here — name and location are filled from the master automatically.
| Site Code | Trade Name (Store) | Shipping Location | State |
|---|---|---|---|
| Loading… | |||
📧 Brand & DC Mail Mapping
Configure auto-filled recipients for appointment and base price mails.
☁ Server
Save or load data from server database.
🗂 Fill Rate — HA SKU Code Master
Upload the SKU master file to enable delivery matching in the Fill Rate tracker.
Expected columns: Product | Packing Type | Reliance SKU | V-Mart SKU | Flipkart SKU | Apollo SKU | Blinkit SKU
Only rows matching these names (partial match, case-insensitive) are processed from Sale & Return files.
📊 Fill Rate — Server Table
Manage the persistent fill_rate table on the server. PO data auto-syncs after each upload.
🗑 Reliance — Delete PO Data
Deleted records are moved to the Audit tab — not permanently lost.
Permanently removes all Fill Rate rows for Reliance from the server table. Delivered quantities will be lost. PO data will re-sync on next upload.
🗑 V-Mart — Delete PO Data
Clear V-Mart PO data from the current session and server.
🗑 D-Mart — Delete PO Data
Clear D-Mart PO data from the current session and server.
🗑 Apollo Healthco — Delete PO Data
Clear Apollo Healthco PO data from the current session and server.
🗑 Blinkit — Delete PO Data
Clear Blinkit PO data from the current session and server.
🗑 Flipkart — Delete PO Data
Clear Flipkart PO data from the current session and server.
🗑 Vishal Mega Mart — Delete PO Data
Clear Vishal Mega Mart PO data from the current session and server.
🗑 Supply Register — Clear Data
Clear all supply values loaded from the sales register. Removes data from both server and this device. You will need to re-upload the supply register after clearing.
📦 PDF Vault — Restore Deleted POs
All parsed PDFs are stored on the server even after PO data is deleted. Use this to restore accidentally deleted POs by re-parsing their stored PDF.
📄 PDF / Image Converter — User Restrictions
Set limits for regular users. Admins always have unlimited access.
ℹ️ How It Works
User: Limited by daily file count and max pages per PDF.
Model: Haiku (fast, cheap) is tried first. If it fails (large/complex file), Sonnet is used automatically.
Cost: ~₹0.15 per file with Haiku · ~₹2.50 with Sonnet fallback.
PO records deleted from the server are archived here for audit. Independent of the Viewer — data here is never loaded into active view.
⬇ Download Excel — Vishal Mega Mart
Select download options below.
🖨 Print Setup
Select one or more Purchase Orders. Customize PDF format below then download.
📄 PDF Print Settings
Configure which columns appear in the PDF, their widths and alignment. Drag to reorder.
Select DC, Date, and POs — then pick an appointment date to save as a legend.
Setting appointment for selected POs
Appointment request for — — Appt Date: —
| # | Site | PO No | PO Date | Exp Date | No of Packs (editable) |
SKUs | Vehicles (editable) |
|---|
Configure the SMTP server used to send appointment emails.
Admin only — update the expected date for a PO across all or selected brands.