The following section provides a comprehensive visual and operational breakdown of all 12 core application modules within the Best Sales CRM AI Software in India platform. Each module is documented with its live production interface and architectural role.
What this screen is: The primary data ingestion gateway of Best Sales CRM AI Software in India. Allows operators to drag-and-drop raw Amazon MTR (B2B/B2C) or Shopify spreadsheets. The portal validates MIME types, strips corrupt bytes, normalizes header schemas across 80+ columns, and displays active quota limits.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Drop Zone & File Browser | Accepts .CSV, .XLSX, and .XLS files up to 500MB each with multi-file merging. | Eliminates pre-formatting requirements; accepts raw marketplace exports directly. |
| File Validation Ledger | Displays uploaded filename, byte weight (784.0 KB), and verification checkmark. | Provides visual confirmation that the file structure has been successfully parsed into disk memory. |
| Security & Integrity Badges | End-to-End Encryption active; Automatic schema normalization. | Guarantees enterprise data hygiene and privacy prior to database transformation. |
| Analyze Action Trigger | One-click processing button initiating streaming disk ingestion. | Triggers the full analytics pipeline in under three seconds. |
What this screen is: The primary command screen for C-level executives and business heads. Instantly transforms thousands of raw CSV rows into visual macroeconomic charts, including sales timeline curves, payment method mix, and top geographic revenue drivers.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Payment Method Distribution | Segmented donut chart displaying Credit Card (CC), PayStation, COD, Gift Card, and Net Banking. | Reveals customer payment preferences and cash-on-delivery return risk exposure. |
| Top 10 Revenue-Driving States | Bar chart ranking top state performance: Maharashtra leading at ~₹1 Lakh. | Directs marketing spend and localized promotional campaigns to highest-converting states. |
What this screen is: The platform's proprietary fraud defense system. Scans the entire transaction ledger using identity fingerprinting to isolate serial return abusers, fraudulent buyer entities, and high-risk delivery pincodes.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Alert Banner & Risk Counter | Red alert badge (82 flagged entities) with visual warning. | Immediately alerts management to active refund bleed requiring immediate intervention. |
| Entity Identity Card (#1) | Flags buyer entity 'Ashiyana by Priyanka' in Panipat, Haryana with 2 units refunded across 2 orders. | Unmasks repeat returners hiding behind multiple orders or partial address variations. |
| Risk Scoring Meter | Algorithmic Risk Score calculated at 42% (Medium Risk). | Quantifies threat level objectively so support teams can prioritize escalations. |
What this screen is: The secondary fraud examination surface. Catalogs all secondary and tertiary risk entities detected within the dataset, providing complete address fingerprints, GSTIN audit records, and exportable data for Amazon seller support dispute filings.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Risk Entity #2 Card | Flags 'M s Deshwal Engineering' with ₹1,699 total refund exposure. | Highlights high-value single-order return liabilities that eat disproportionately into margins. |
| Geographic Location Tagging | Pinpoints city, state, and postal code data even when zip codes are omitted in customer invoices. | Enables logistics teams to identify regional courier tampering and delivery scams. |
| Expandable Audit Drawer | 'View Full Refund Details' accordion linking timestamps, IDs. | Provides audit-ready evidence for submitting claims to Amazon seller support. |
What this screen is: The core merchandising intelligence matrix. Ranks every product SKU in the seller's catalog by revenue generated, units sold, and daily sales velocity, enabling brands to distinguish high-performing 'Hero SKUs' from margin-draining 'Bleeding SKUs'.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| SKU & Description Column | Displays manufacturer part number and full Amazon product title. | Ensures unambiguous item identification across warehouse and catalog databases. |
| Revenue Realization | Displays gross invoice revenue attributed to each SKU. | Ranks catalog profitability to guide advertising budget allocation and sponsored ads. |
| Daily Velocity & Status | Calculates daily run-rate (e.g., 0.77/day) and operational catalog status ('ACTIVE'). | Essential input for automated restock modeling and lead-time safety stock calculations. |
What this screen is: The geospatial fulfillment engine. Maps customer order volume and gross revenue across all Indian states and Union Territories, providing critical data for placing stock in Amazon Fulfillment Centers (FCs) across North, South, East, and West zones.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Pan-India State Ranking | Horizontal bar chart ranking states from Maharashtra (lead), Tamil Nadu, Karnataka down to Tripura. | Visualizes geographic market concentration across Indian consumer demographics. |
| Interstate vs Intrastate Ratio | Distinguishes local deliveries from long-haul interstate shipments. | Directly impacts courier freight expenses and inter-state IGST tax liabilities. |
| FC Placement Recommendation | Guides sellers on opening secondary Amazon warehouses to enable Prime Next-Day Delivery. | Reduces delivery times from 4-5 days to under 24 hours in key regional clusters. |
What this screen is: The automated diagnostic engine of Best Sales CRM AI Software in India. Evaluates processed transaction data against 30+ proprietary algorithmic rules, generating prioritized natural-language observations across Revenue, Risk & Fraud, Geography, and Growth.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Severity Summary Badges | Color-coded count badges: 2 Critical (Red), 2 Warning (Orange), 6 Total (Blue). | Allows busy executives to triage urgent operational crises in seconds. |
| Revenue Drop Observation | Critical alert: 'Revenue dropped 68% this week — investigate possible stockouts or demand dip.' | Proactively identifies revenue anomalies before monthly accounting closures. |
What this screen is: The execution-oriented layer of the AI engine. Expanding any observation card reveals the underlying neural pattern-matching logic, the statistical confidence score, and a prioritized checklist of actionable steps for operational teams.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Neural Logic Description | 'Cross-channel pattern matching identified this trend with a precision of 85.0%...' | Transparently explains why the AI flagged the anomaly, eliminating 'black-box' distrust. |
| Actionable Steps Checklist | Prescribes: Review related SKU velocity; Synchronize inventory forecasts; Verify tax anomalies. | Translates raw analytical data directly into standard operating tasks for staff. |
What this screen is: The statutory accounting and GST reconciliation center. Built specifically for CFOs, chartered accountants, and tax consultants to eliminate manual GSTR-1 and GSTR-3B preparation errors, accurately segregating IGST, CGST, SGST, and input tax credit (ITC) liabilities.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Total Taxable Value Card | Displays audited gross taxable transaction amount: ₹5,53,083. | Serves as the benchmark revenue figure for monthly sales tax reporting. |
| GST Donut & Compliance Score | Visual breakdown of IGST, CGST, SGST alongside a 98.4% Compliance Score. | Guarantees tax filing audit-readiness and eliminates GST department mismatch notices. |
What this screen is: The forward-looking financial forecasting engine. Utilizes linear regression, momentum-based run-rate modeling, and historical daily velocity to project multi-horizon sales volume, empowering founders to secure working capital and plan seasonal inventory procurement.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| 7-Day Short-Term Forecast | Projects ₹1,31,925 in near-term revenue (~₹18,846 daily run-rate). | Guides immediate weekly operational cash flow and courier freight dispatch scheduling. |
| 90-Day Quarterly Outlook | Projects ₹23,73,024 over a 3-month rolling operating horizon. | Directs quarterly manufacturing contracts, packaging orders, and warehouse leases. |
What this screen is: The predictive visualization surface. Bridges past financial reality with future projected revenue curves, plotting actual weekly turnover against forward momentum trajectories (Proj+W1 to Proj+W4) to visually highlight anticipated revenue inflection points.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Actual Revenue Timeline (Blue) | Solid line plotting audited weekly revenue across calendar weeks. | Visualizes historical revenue dips, promotional spikes, and settlement cycles. |
| Forward Projection Line (Purple) | Dashed momentum line projecting future trajectory through Proj+W1 to Proj+W4. | Visually communicates forecasted revenue trajectory to executives and stakeholders. |
What this screen is: The operational execution bridge between predictive math and warehouse procurement. Ranks top products by daily dispatch velocity while generating color-coded restock triggers, ensuring high-velocity items never stock out and lose the Amazon Buy Box.
| UI Component | Data Stream / Calculation | Business & Operational Value |
|---|---|---|
| Top SKU Velocity Ranking | Ranks top dispatch items: MJF12V400A-A (0.8/day), SP-ABX96QMax (0.2/day). | Tells warehouse managers exactly how many units leave the warehouse per business day. |
| Restock Alert Card (Green) | Alert: 'Top SKU MJF12V400A-A moving at 0.8/day. Plan 30-day safety stock now.' | Prevents catastrophic stockouts by calculating lead-time reorder thresholds. |
Explore the dedicated interfaces and SOPs for different stakeholders, from secure authentication to role-specific command centers.
The Super Admin holds supreme administrative governance over the entire Best Sales CRM AI Software in India installation. This section documents the standard operating procedures (SOPs) required to maintain tenant accounts, manage subscription allocations, and oversee system health.
For brand founders and managing directors, Best Sales CRM AI Software in India acts as the primary executive command cockpit. The operational routine for business leadership should follow this structured cadence:
Chartered Accountants and tax practitioners utilize Best Sales CRM AI Software in India to audit and reconcile Amazon sales figures for monthly statutory filings (GSTR-1, GSTR-3B, and annual GSTR-9). Below is the recommended reconciliation SOP:
Supply chain and warehouse managers use the platform to eliminate fulfillment bottlenecks, manage Amazon FBA storage limits, and cut shipping courier overhead:
The following illustrates the operational contrast between legacy spreadsheet workflows and Best Sales CRM AI Software in India.
Legacy Manual Approach: 30 to 40 hours spent by senior finance teams manually filtering Excel formulas and pivot tables.
Best Sales CRM AI Software in India Solution: Instantaneous automated ingestion (under 3 seconds) with 100% mathematical precision.
Legacy Manual Approach: Fraudulent customers scatter orders across multiple accounts and addresses, slipping under the radar.
Best Sales CRM AI Software in India Solution: Identity Fingerprinting links buyers via normalized names, GSTINs, and zip codes into single risk profiles.
Legacy Manual Approach: Accountants guess tax splits due to messy positive/negative lines in Amazon MTR files, risking audit notices.
Best Sales CRM AI Software in India Solution: Audited tax ledger segregating IGST, CGST, SGST, and TCS with a 98.4% automated compliance score.
Legacy Manual Approach: Reordering is reactive; stockouts occur during festival surges, losing Prime badges.
Best Sales CRM AI Software in India Solution: Momentum-based trend regression generates automated Restock Alerts based on real daily SKU velocity.
Best Sales CRM AI Software in India is a purpose-built, enterprise-grade e-commerce intelligence and reconciliation platform. Engineered specifically to decode, normalize, and audit high-volume Amazon MTR (B2B/B2C) and Shopify datasets, the platform converts raw, chaotic spreadsheets into instant, executive-grade business intelligence in under three seconds.
The core philosophy of Best Sales CRM AI Software in India is zero-compromise accuracy. While standard business intelligence tools rely on shallow approximations or crash under the memory weight of multi-megabyte files, Best Sales CRM AI Software in India utilizes a disk-streamed chunking architecture coupled with an advanced relational PostgreSQL backend and a mathematical reconciliation engine. It answers the four existential questions of every online brand: Exactly how much profit did we make? Which products are truly driving our business? Who is scamming our return policy? And how much tax do we legally owe?
Best Sales CRM AI Software in India was designed from the ground up to solve the architectural bottlenecks that plague browser-based analytics platforms. Traditional web apps attempt to read 50MB+ CSV files entirely into browser RAM or backend memory, resulting in browser tab freezing or Out-Of-Memory (OOM) backend crashes.
Uploaded files are streamed directly to temporary disk buffers in 1MB chunks, reducing server memory overhead by ~75% and guaranteeing stability during multi-file merges.
All database transactions utilize asynchronous PostgreSQL via SQLAlchemy 2.0 and asyncpg, enabling non-blocking execution under heavy concurrency.
The core backend security configuration enforces a zero-trust startup protocol; if cryptographic secrets are absent, the server refuses to boot, eliminating insecure fallback vulnerabilities.
The data ingestion pipeline is engineered to process enterprise-scale datasets (50MB+ CSV files with 100,000+ rows) without exhausting system memory. When an operator uploads a file, the FastAPI backend does not read the raw payload into Python memory. Instead, it streams incoming bytes directly to temporary operating system disk buffers in exactly 1MB chunks using Python's tempfile module.
Amazon MTR files are notoriously inconsistent, often exported in UTF-8, Latin-1, or Windows CP1252 encodings. The ingestion engine cascades through encoding decoders automatically. Once parsed, a normalization layer scans and maps 80+ potential column variations into unified internal keys.
Best Sales CRM AI Software in India is architected to serve cross-functional enterprise departments, providing tailored data views for each key executive role.
Surfaces: Executive Dashboard, AI Insights, Predictions
Responsibility: High-level margin defense, net realized GMV, return rate trends, and 90-day predictive growth modeling.
Surfaces: Financial Summary, Payment Mix, Overview KPIs
Responsibility: True net cash flow realization, deduction audit, advertising ROI vs. return losses, and working capital optimization.
Surfaces: Financials Hub, Tax Classification Donut, Audit Export
Responsibility: GSTR-1, GSTR-3B, and TCS reconciliation under Section 52 of the CGST Act. Verifying inter-state IGST vs intra-state CGST/SGST.
Surfaces: Regional Fulfillment Map, SKU Velocity Engine, Restock Feed
Responsibility: Regional warehouse placement, minimizing inter-state freight, Amazon FBA vs. MFN stock balancing, and daily SKU dispatch velocity.
Surfaces: Threat Intelligence Shield, Entity Fingerprinting
Responsibility: Identifying serial return abusers, fraudulent pincodes, and tracking high-refund entities to file Amazon SAFE-T claims.
The financial calculation engine operates strictly on verified double-entry accounting formulas:
| Financial Metric | Mathematical Formulation | Accounting Definition |
|---|---|---|
| Gross Realized Revenue | Gross = sum(Invoice Amount) for all Shipments | Total invoiced merchandise value prior to returns and concessions. |
| Refund Total | Refunds = abs(sum(Invoice Amount)) for all Returns/Refunds | Actual value of cash refunded to customers by marketplace. |
| Net Realized Revenue | Net = Gross Revenue - Refund Total - Promo Discounts | True top-line cash flow realized into the company bank account. |
| Average Order Value (AOV) | AOV = Gross Revenue / Total Completed Orders | Average monetary transaction size per customer checkout. |
| Return Rate (%) | Return Rate = (Total Refund Count / Total Orders) * 100 | Critical operating ratio measuring catalog return bleed. |
| Total Tax Liability | Total Tax = sum(Total Tax Amount) or (IGST + CGST + SGST) | Total statutory sales tax liability owed across all jurisdictions. |
Best Sales CRM AI Software in India's fraud detection engine solves the classic problem of return fraud obfuscation. Fraudulent buyers frequently change customer account names or use minor address typos to bypass marketplace return limits.
Product velocity is modeled on a rolling time-delta basis. The daily dispatch velocity for any given SKU is defined as:
In our audited March 2026 dataset, top-performing SKU MJF12V400A-A registered 24 units sold across 31 days, yielding a velocity of 0.77 units/day (rounded to 0.8/day in production restock monitors). The engine simultaneously calculates return attribution per SKU; if an individual SKU exhibits a return rate exceeding 15% alongside customer complaints regarding defects, it is flagged for quality inspection.
The forecasting module deploys a momentum-based trend regression model across historical daily and weekly sales arrays. Rather than relying on flat static run-rates, the engine calculates the week-over-week acceleration coefficient (a) to extrapolate future trajectories across three rolling time horizons:
Under Indian e-commerce GST regulations, inter-state deliveries require the collection of Integrated GST (IGST) and attract higher courier freight surcharges. The Geospatial module audits the ratio of intra-state shipments (local state) to inter-state shipments. By identifying that states like Maharashtra, Tamil Nadu, and Karnataka generate the vast majority of turnover, the system provides mathematical proof supporting multi-location inventory decentralization.
Security in Best Sales CRM AI Software in India is implemented at both the application and database tiers:
User passwords are encrypted using direct bcrypt salting with 12 rounds of computational complexity, completely bypassing fragile third-party wrapper libraries.
Authentication sessions are governed by JSON Web Tokens (JWT) signed with HMAC-SHA256 (HS256) utilizing high-entropy cryptographic secrets. Tokens expire strictly after 7 days.
On application bootstrap, config.py performs a fatal validation check. If JWT_SECRET or DATABASE_URL is unconfigured, the application terminates immediately rather than running insecurely.
Strict CORS policies reject unauthorized cross-origin requests, whitelisting production Vercel domains and verified local development ports.
Best Sales CRM AI Software in India features a complete multi-tier commercial licensing system. Three subscription tiers are defined within the PostgreSQL schema: Starter (3 monthly uploads), Pro (10 monthly uploads), and Enterprise (30 monthly uploads). The platform integrates natively with Razorpay for automated order creation, checkout modal execution, webhook payment signature verification, and instant quota replenishment.
19. Relational Database Schema
Backend REST API Directory
21. Production DevOps & Deployment
The relational database schema is deployed on PostgreSQL 16/18 and managed via SQLAlchemy asyncpg.
| Field Name | Data Type | Constraints | Operational Description |
|---|---|---|---|
| id | String (UUID) | Primary Key | Globally unique user identifier. |
| user_id | String (Unique) | Indexed | Human-readable identifier (e.g., ITAI-1002). |
| String (Unique) | Indexed / Non-null | Registered account email address. | |
| name | String | Nullable | Full name of the account holder. |
| plan | String | Default 'starter' | Active subscription tier (starter, pro, enterprise). |
| status | String | Default 'Active' | Account lifecycle state (Active, Expired, Suspended). |
| monthly_uploads | Integer | Default 0 | Counter tracking reports processed in current billing cycle. |
| hashed_password | String | Bcrypt Hash | Securely hashed password string ($2b$12$...). |
| is_admin | Boolean | Default False | Super Admin role authorization flag. |
| Field Name | Data Type | Constraints | Operational Description |
|---|---|---|---|
| id | String (UUID) | Primary Key | Unique identifier for uploaded report audit. |
| user_id | String | Foreign Key (users.id) | Owner reference linking report to tenant. |
| filename | String | Non-null | Original uploaded spreadsheet filename. |
| upload_date | DateTime | Default utcnow() | Timestamp of report processing. |
| record_count | Integer | Default 0 | Total rows audited (e.g., 1,105 rows). |
| analysis_results | JSON | Structured Blob | Complete processed analytics payload for instant retrieval. |
The FastAPI application exposes a clean, versioned RESTful API under the /api/v1 namespace:
| Method | Endpoint Route | Request Payload | Expected Response | Functional Description |
|---|---|---|---|---|
| POST | /api/v1/auth/login | Email, Password (JSON) | 200 OK, JWT Token, User Profile | Authenticates user and returns JWT bearer token. |
| POST | /api/v1/auth/send-otp | Email, Name (JSON) | 200 OK, Success status | Dispatches 6-digit verification code via SMTP. |
| POST | /api/v1/auth/register | Name, Email, Phone, OTP, Password | 200 OK, Token, User Account | Verifies OTP and provisions new user account. |
| POST | /api/v1/analyze | Multipart Form Data (Files list) | 200 OK, Full Analytics Payload | Core ingestion endpoint; parses and audits MTR reports. |
| GET | /health | None | 200 OK, DB Connected status | Health check endpoint for Docker and uptime monitors. |
| GET | /api/v1/admin/users | Admin JWT Bearer Header | 200 OK, Users array | Super Admin endpoint listing all tenant accounts. |
| POST | /api/v1/payments/create-order | Plan string, Amount | 200 OK, Razorpay Order ID | Generates cryptographic order for Razorpay checkout. |
Best Sales CRM AI Software in India is architected for dual-mode deployment: rapid local development and planetary-scale cloud hosting. The production deployment standard utilizes Docker Compose and Nginx reverse proxying:
We bring architectural rigor, industry expertise, and a business-first approach to marketplace intelligence and tax reconciliation.
1MB chunk streaming and schema normalization with zero-RAM leaks guarantees stability.
Formulas for Gross, Net, CGST, SGST, IGST, and TCS liability executed perfectly.
Identity normalization, serial return hashing, and SAFE-T claims preparation.
Momentum-based trend regression across 7/30/90-day time horizons for revenue forecasting.
State tax liability tracking and Amazon FC stock allocation strategies mapped geospatially.
1MB chunk streaming and schema normalization with zero-RAM leaks guarantees stability.
Formulas for Gross, Net, CGST, SGST, IGST, and TCS liability executed perfectly.
Identity normalization, serial return hashing, and SAFE-T claims preparation.
Momentum-based trend regression across 7/30/90-day time horizons for revenue forecasting.
State tax liability tracking and Amazon FC stock allocation strategies mapped geospatially.
Yes. Best Sales CRM AI Software in India handles both B2B MTR files (containing customer GSTINs and business names) and B2C MTR files seamlessly.
The platform flags suspicious accounts by compiling evidence—including order dates, refunded SKUs, and total monetary value—which sellers download to submit official Amazon SAFE-T reimbursement claims.
No problem. Thanks to our 1MB chunked streaming architecture, large enterprise reports up to 500MB are streamed to disk and parsed without crashing the server.
| Industry Term | Operational Definition |
|---|---|
| MTR | Merchant Tax Report — The official monthly financial and tax statement exported from Amazon Seller Central. |
| AFN / FBA | Amazon Fulfillment Network / Fulfillment by Amazon — Inventory stored and shipped directly by Amazon warehouses. |
| MFN / FBM | Merchant Fulfilled Network / Fulfillment by Merchant — Inventory stored, packed, and shipped directly by the seller. |
| TCS | Tax Collected at Source — A mandatory 0.5% to 1% tax collected by Amazon under Section 52 of the Indian CGST Act. |
| SAFE-T Claim | Seller Assurance for E-Commerce Transactions — Amazon's formal dispute mechanism to reimburse sellers for fraudulent returns. |
| SKU Velocity | The average number of inventory units dispatched per calendar day for a specific product catalog item. |
| GSTR-1 / 3B | Mandatory monthly statutory returns filed with the Indian Goods and Services Tax Network (GSTN). |
Best Sales CRM AI Software in India Platform (Production Edition v1.0.0)