👤 TODAY CASHIER & REGISTER BREAKDOWN
Live POS Machine Feed
Clerk Code
Cashier Name
POS Register #
Bills Handled
Net Sales (QAR)
Loading active registers...
📅 RECENT SALES TREND & DAILY DRILLDOWN
Click any day row below to drilldown by Group & Item GP%
Date (DD/MM/YYYY)
Bills Count
Total Sales (QAR)
Average Ticket
Analysis
Loading sales trend...
🎯 ACTIVE SPECIAL PROMOTIONS & SYSTEM OFFERS (SQL SETUP)
Live promotional campaigns configured in local DB (promotion_hd / promotion_tran). Track today's sold volume, revenue, true profit via Cloud ERP costs, and customer reach.
Promo Code
Validity (DD/MM/YYYY)
Barcode
Item Description
Normal Price (ERP)
Promo Offer
Sold Qty
Total Sales
True Cost
Profit
GP %
Customers Count
Cardex
Loading active promotions...
👥 CUSTOMER-WISE & CHANNEL SALES BREAKDOWN
Audit customer and platform sales (In-Store Cash, Talabat, Snoonu, Credit Accounts). Click any customer row to toggle department group drilldown with Stock vs Sublease separation.
Customer / Channel
Account Code
Orders / Bills
Total Sales (QAR)
True Cost (QAR)
Profit (QAR)
GP %
Department Breakdown
Loading customer sales...
🚀 SALES GROWTH, MARGIN & VELOCITY INSIGHTS
Algorithmic discovery of fast-moving products, high-margin drivers, and low-margin risk alerts to optimize store profitability.
⚡ TOP VELOCITY MOVERSHighest Units Sold Today
#
Barcode
Item Description
Qty Sold
Sales (QAR)
Cardex
Loading velocity data...
💎 HIGH MARGIN DRIVERS (>35% GP)Profit Generators
Barcode
Item Description
Qty Sold
Sales (QAR)
Cost (QAR)
Profit (QAR)
GP %
Cardex
Loading high margin items...
⚠️ MARGIN RISK ALERTS (<10% GP)Loss / Low Margin
Barcode
Item Description
Sold
Retail
Cost
GP %
Cardex
Loading risk alerts...
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX CYBER-HYPER EXECUTIVE DASHBOARD ⚡
Format: Barcode | Supplier Code | Supplier Name (e.g. 629100100100 S00001 Abc Trading) or Barcode | S00001 Abc Trading. Automatically links Supplier Code & Name across all reports and filters!
[ SCAN AN ITEM ]
Main Inv—
Today Sold—
Today Return—
Live Stock—
Group / Dept
Supplier Code
Supplier Name
Barcode
Item Description
Packing (Click to Switch)
Cost
Live Stock (Pieces)
Today Sold
3Wk Sales
Status
AI Order Qty
[ SYSTEM ONLINE — LOADING SKUs... ]
Group / Dept
Supplier Code
Supplier Name
Barcode
Item Description
Packing
Live Stock
3Wk Sales
Status
ENTER QTY
No items loaded.
CRITICAL DEFICIT: Items with active sales velocity and 0 or negative stock.
Group / Dept
Supplier Code
Supplier Name
Barcode
Item Description
Packing
Live Stock (≤ 0)
Velocity (Sales)
Order Qty
[ NO URGENT ITEMS ]
RESTRICTED ITEMS: High return rates (PR ≈ GR) with low sales. Orders locked to prevent losses.
Group / Dept
Supplier Code
Supplier Name
Barcode
Item Description
Packing
Live Stock
Total GR (Purchases)
Total PR (Returns)
Status
[ NO RESTRICTED ITEMS ]
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
🚨 ATTENTION: ITEMS IN STORE STOCK BUT CLOSED / FALSE ONLINE
0 items have live stock in store but are marked offline/inactive on platforms.
Barcode
Item Name
Packing
Live Stock
Cost
Selling
Target Price
Last Sale / Return
Audit Verification
Channel Status
Cardex
Action
ENGINE READY
📊 Strategic Discrepancy Matrix
No reconciliation pass executed yet. Click "EXECUTE RECONCILIATION" above.
🏷️ Online Active Promotions & Discounts
0 Active Campaigns
Platform
Identifier (Barcode / SKU)
Item Name
Normal Price
Discount Amt
Promo Price
Discount %
Validity / Schedule
Status
No active online promotions detected yet. Click "REFRESH PROMOS" or run Reconciliation.
🌐 Dynamic Channel Quick-Commerce Feeds
Edit platform names, add platforms (e.g. Keeta), or delete. If data is unpasted, the engine continues cleanly!
🏢 Sub-Lease Dedicated Multi-Tier Terminal (Veg • Fish • HGB)
Manage Sub-Lease categories independently: Auto-Sync from Cloud ERP by Group Code or Manual Paste. Cost is strictly 0.00. Pasted price is final online price (0% Mu), or enter custom Mu% markup.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
📦 Full Item Master Report & Catalog
Complete catalog with all packaging units (Pcs, Box, Outer), unit stock, costs, retail, supplier, and group.
Item Code
Barcode
Item Description
Packing
UM Qty
Cost
Avg Cost
Selling Price
Supplier Name
Group / Dept
Stock (In Unit)
Stock (Base Pcs)
Cardex
Click "RELOAD CATALOG" to view master items.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
📥 Cloud ERP Purchases, GRN & Adjustments Ledger
Direct live ingestion from Cloud ERP (web.mycomsys.com). View Goods Receipts (GRN), Purchase Returns (PR) and Stock Adjustments (ADJ) with true supplier names & codes.
Entry #
Date (DD/MM/YYYY)
Item Code
Supplier
Barcode
Item Name
Packing
Received Qty
Unit Cost (QAR)
Total Cost Amt (QAR)
Selling Price (QAR)
MU %
Live Stock
Received in
Cardex
Click "LOAD PURCHASES" to retrieve live Cloud ERP records.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX CLOUD ERP CONNECTOR ⚡
🏷️ Online Price Change Audit Report
View item price updates with date selection (1 day or date range). Copy barcodes and target prices in 1 click!
Entry #
Barcode
Full Item Description
Packing
UM Qty
Supplier Name
Cost
Old Selling
Current Selling
Online Target Price
Live Stock
Other Units
Updated Date
Cardex
Select date or Entry # and click "LOAD REPORT" above.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
✨ New Items Catalog Export
Newly added SKUs with full descriptions, packings, costs, average costs, selling, and online target price.
Barcode
Full Item Description
Packing / UM
UM Qty
Cost
Avg Cost
Selling Price
Supplier Name
Group / Dept
Live Stock
Online Target Price
Date Added
Cardex
Click "LOAD NEW ITEMS" to retrieve newly introduced SKUs.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
⏳ Non-Moving Inventory Aging Report
Identifies stagnant stock (>0 qty) with zero POS sales or GRN movements for selected threshold. Strictly Stock Items (item_type=1), excludes non-stock / sub-lease.
Item Code
Barcode
Item Description
Packing
Live Stock
Cost
Total Dead Cost
Selling
Last Sale Date
Last GRN Date
Days Inactive
Supplier Name
Cardex
Click "RUN AGING REPORT" to detect stagnant stock.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX INVENTORY INTELLIGENCE ⚡
🚀 Fast Moving Products & Best Sellers
Top performing products ranked dynamically by Quantity Sold, Total Revenue, or Total Gross Profit. Strictly Stock Items (item_type=1).
Rank
Barcode
Item Description
Packing
Sold Qty
Cost
Selling Price
Total Revenue (QAR)
Total Profit (QAR)
GP %
Current Stock
Supplier Name
Cardex
Click "LOAD BEST SELLERS" to analyze top movers.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX BEST-SELLER ANALYTICS ⚡
📊 Universal Business Report Launcher
Instant server-computed executive reports: Cloud Purchases & GRN, Overrides, Voids, Stock Ledger, Out of Stock, Sales, and Margin Loss.
Select a business report type and click "GENERATE REPORT".
🛠️ Custom Interactive Query & Column Builder
Design and execute tailored reports by picking fields, metrics, and criteria according to your own operational needs.
1. SELECT COLUMNS TO INCLUDE:
2. FILTER CONDITIONS:
Pick fields on the left and click "RUN CUSTOM REPORT".
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
🚫 Cancelled, Voided & Refunded Bills Audit
Comprehensive audit of all transaction voids, refunds, and cancelled tickets across POS registers for today and previous days.
Date (DD/MM/YYYY)
Time
Bill #
POS Reg #
Cashier / Clerk
Type
Barcode
Item Description
Qty
Unit Price (QAR)
Total Amount (QAR)
Reason / Remarks
Cardex
Click "LOAD VOIDS & REFUNDS" to audit transactions.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX POS AUDIT MATRIX ⚡
Detailed cashier-level audit of manual price overrides, item discounts, and retail changes. Strictly excludes online aggregator user ('ONLINE').
Date (DD/MM/YYYY)
Time
Bill #
POS Reg #
Cashier Name
Barcode
Item Description
Original ERP Price
Changed / Sold Price
Unit Diff
Qty Sold
Total Discount Given
Reason / Status
Cardex
Click "LOAD PRICE OVERRIDES" to audit cashier discounts.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX CASHIER AUDIT SUITE ⚡
📉 Below Margin Sales Audit
Lowest margin items sold displayed on top. Audits clerk name, POS machine #, time, date, cost, and MU%.
Date & Time
Barcode
Item Description
Packing
Qty
Sold Price
Cost
MU %
Clerk Name
POS Machine
Live Stock
Cardex
Click "RUN AUDIT" to detect below margin transactions.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
💰 Omnichannel Sales Performance & Profitability
Live and historical sales across In-Store and Online Channels (Talabat, Snoonu, Rafeeq). Sub-Lease cost = 0.
Total Sales Amount
0.00
Total Cost of Goods
0.00
Total Gross Profit
0.00
Overall Margin GP %
0.0%
🚨 CYBER NOTICE: BELOW-COST SALES DETECTED
0 items were sold at prices below invoice purchase cost!
Date
Bill #
Channel
Barcode
Description
Qty
Sold Price
Cost
Loss / Unit
MU % Loss
🛵 CHANNEL SALES SUMMARY
Channel
Bills Count
Total Sales (QAR)
Cost (QAR)
Profit (QAR)
GP %
🏢 GROUP / DEPARTMENT PROFITABILITY
Group / Dept
Sales
Cost
Profit
GP %
Type
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
👥 Customer-Wise Sales & Gross Profit
Detailed breakdown of customer accounts, total orders, sales volume, cost, and gross profit percentage. Click customer row to view Group breakdown.
Customer Code
Customer / Channel Name
Total Bills
Total Sales (QAR)
Total Cost (QAR)
Gross Profit
GP %
Click "LOAD CUSTOMER REPORT" to retrieve customer gross margins.
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
⚙️ Live System Configuration & Channel API Gateways
Settings password is 112233. Strict Read-Only policy active. Zero POST, Zero DELETE.
🔒 ZERO POST • ZERO SQL MODIFICATIONS ACTIVE
☁️ CLOUD INVENTORY API (GET ONLY)
🖥️ LOCAL POS SQL SERVER (SELECT ONLY)
🛵 AGGREGATOR API GATEWAY (GET ONLY TESTER)
⚡ INNOVATED & ARCHITECTED BY MR. SUBASH KAFLE • APEX DATABANKS ⚡
🔑 Aggregator Portal Logins & 1-Click Sync Setup
Save credentials once on your local PC. Enables 1-click automated live catalog syncing with zero copy-pasting.
🛍️ Snoonu Merchant PortalDIRECT REST AUTH
✓ Enables instant 1-click live refresh without opening the browser.
🍔 Talabat Partner PortalGRAPHQL & BEARER AUTH
Click to log in once on Talabat & save permanent token
💡 You can also use the "Auto-Import Talabat" button anytime you click Export in the Talabat portal!
🚗 Rafeeq Partner PortalEXCEL & API READY
🛵 Keeta Merchant PortalEXCEL & API READY
📋 SMART PASTE & RECONCILIATION INGEST
Paste API JSON payload (GraphQL / REST) or Web Page Table (TSV/CSV) from Keeta, Rafeeq, Talabat, or Snoonu.
💡 How to get FULL items (All Products):
• Option 1 (Excel Export - Recommended): In the Talabat/Snoonu merchant portal, click "Export Products / Catalog" to download the Excel file. Copy all rows from Excel (Ctrl+A, Ctrl+C) and paste them here!
• Option 2 (Live API Auto-Download): Click "⚡ Auto-Download Full Catalog (API Token)" below and paste your Bearer token. The system will automatically fetch all pages of your catalog directly from the aggregator!
• Note: If copying from Chrome F12 Network tab, make sure the search bar on the portal is completely empty so it returns full catalog pages instead of 1 searched item.
Target Platform:
Barcode
Product Name
Platform Price
POS Price
Diff
Discount
Status
Sync Status
📅 SALES & PROFIT DRILLDOWN:--/--/----
Click any department/group row to drill down into SKU item-wise sales, costs, gross profit & GP%.
📍 VIEW:DEPARTMENT GROUPS
Group Code
Department / Group Name
Bills Handled
Units Sold
Total Sales (QAR)
Total Cost (QAR)
Gross Profit (QAR)
GP %
Action
Loading group sales...
Barcode
Full Item Description
Units Sold
Avg Price
Sales (QAR)
Unit Cost
Total Cost (QAR)
Gross Profit
GP %
Live Stock
Supplier
Cardex
Loading item sales...
📜 CARDEX FY TRANSACTION LEDGER
Full movement history for current financial year
Date
Time
Movement Type
Doc / Bill #
Party / Cashier
In (+)
Out (-)
Rate (QAR)
Total (QAR)
Running Stock
Cashier / Terminal
Loading ledger...
🌐 Server Details & Tailscale Funnel Control
Manage Localhost & LAN Server, Public Tailscale Funnel Tunnel, and Live Endpoints.
Plays a chime tone whenever sub-leasers or auditors submit live reports or price changes.
💡 Desktop Launcher Available: A one-click launcher Shopwise_Server_Funnel_Manager.bat has been placed directly on your Desktop and in project root to start/stop the server and funnel anytime without opening terminal.