Supermarket & Wholesale ERP Case Study

Lakshminaryan Super Shopy

Integrated Retail, Wholesale & Inventory Management with Uttercode ERP
Retail POS + Wholesale Slabs + Repacking Barcode

Integrated Retail, Wholesale & Inventory Management with Uttercode ERP

Lakshminaryan Super Shopy, Jalgaon, operates across both retail and wholesale business segments. With a vast grocery catalogue, diverse customer tiers, quantity slab rates, credit accounts, loose bulk repacking, expiry-sensitive products, and delivery logistics, the business required far more than a basic supermarket billing machine.

Client Lakshminaryan Super Shopy
Location Jalgaon, Maharashtra
Industry Supermarket, Retail & Wholesale
Business Model Retail Store, Wholesale & Distribution
Solution Deployed Uttercode ERP + Retail POS + Mobile Billing + Loose Repacking & Barcode + Batch Expiry + Delivery Management
Lakshminaryan Super Shopy Retail and Wholesale ERP Case Study
One Connected Ecosystem
Retail • Wholesale • Repacking • Delivery
Live Deployment
Connected Operational Cycle

From Bulk Procurement to Barcode Repacking & Credit Delivery

Uttercode ERP unifies retail counter transactions and wholesale distribution into a single synchronized workflow:

1
Purchase
Bulk Inward
2
Inventory
Batch & Expiry
3
Repacking
Bulk → Packets
4
Barcode
Label Printing
5
Pricing
Slabs & Credit
6
Billing
POS & Mobile
7
Credit
Ledger Limits
8
Delivery
Dispatch Logs
9
Accounts
Payables & MIS

Operational Complexity

9 Core Business Challenges Faced

Operating hybrid retail and wholesale businesses presents challenges that generic retail software cannot solve.

1. Retail & Wholesale Coexistence

The same SKU (e.g. 1kg Basmati Rice or Cooking Oil) has different prices depending on whether the buyer is a retail consumer, a wholesale dealer, or an institutional credit buyer.

2. Multiple Pricing Structures

Cashiers previously had to remember manual discounts, negotiated rates, and dealer category price lists, leading to frequent pricing discrepancies and billing delays.

3. Quantity Slab Pricing

Wholesale buyers purchase in bulk. A product needed automatic price tier adjustments based on order volume (e.g. 1–9 pcs at ₹100, 10–49 at ₹95, 50+ at ₹90) without manual cashier override.

4. Credit Customer Rate Lock

Key credit buyers have pre-agreed contract pricing. Cashiers needed an ERP that automatically applies customer-specific rates and enforces credit exposure limits.

5. Batch & Expiry Management

Managing thousands of packaged food products, dairy, and cosmetics with varying expiry dates across multiple purchase batches risked dead inventory and customer complaints.

6. Loose Bulk Repacking

Grains, sugar, and pulses are purchased in 25kg or 50kg bulk sacks and repacked in-house into 500g and 1kg branded packets. The ERP needed to convert bulk stock into packed inventory automatically.

7. In-House Barcode Printing

Repacked packets require custom barcodes containing product name, batch, net weight, MRP, and packed date for rapid scanning at checkout counters.

8. Mobile Billing for Field & Yard

Wholesale sales representatives visit customer shops and warehouses to take orders. They required a mobile billing app synced with the central stock ledger in real time.

9. Delivery & Van Dispatch

Wholesale orders must be packed, assigned to vehicles, dispatched, and confirmed with digital proof of delivery and payment collection.


Core Innovation

Multi-Tier Pricing & Quantity Slabs Engine

"The system selects the right price based on who is buying and how much they buy."

Rather than maintaining flat price lists, Uttercode ERP features an automated pricing hierarchy:

Customer Pricing Hierarchy:
Customer-Specific Rate (Highest Priority) Quantity Slab Rate Wholesale Category Rate Standard Retail MRP

Cashiers never have to memorize pricing or negotiate on the fly. The moment an item and quantity are entered, the correct slab triggers instantly.

Real-World Quantity Slab Example
Quantity Tier Customer Type Effective Rate Margin %
1 – 9 Units Retail Shopper ₹100 25%
10 – 24 Units Small Grocery ₹96 20%
25 – 49 Units Wholesale Buyer ₹93 16%
50 – 99 Units Bulk Trader ₹90 12%
100+ Units Super Distributor ₹87 9%
Configured credit customers can further lock custom negotiated rates automatically.
Supply Chain Efficiency

Loose Repacking & Custom Barcode Generation

How Lakshminaryan Super Shopy converts wholesale bulk sacks into shelf-ready retail packets with complete inventory traceability:

The Repacking Transformation Process
BULK PURCHASE INWARD (e.g. Premium Basmati Rice – 50 KG Sack)
               ↓
REPACKING WORK ORDER
Input: 50 KG Bulk Sack → Output: 50 × 1 KG Packets
               ↓
AUTOMATIC BARCODE ASSIGNMENT
Generates EAN / Code-128 label with Weight, Batch, Expiry & MRP
               ↓
SHELF INVENTORY UPDATED
Bulk Stock deducted by 50 KG → Packaged SKU increased by 50 units
               ↓
INSTANT POS CHECKOUT SCANNING

Captures input weights, packaging bag costs, sealing labour, and spillage wastage % to maintain exact per-packet profitability.

Integrated Barcode Label Designer

Uttercode ERP includes an in-built label designer compatible with standard thermal barcode printers (TVS, Zebra, TSC):

Lakshminaryan Super Shopy Batch: R-OCT26
PREMIUM SHARBATI WHEAT Net Weight: 5.000 KG
||| | ||||| || |||||| ||| |||| |
8904589201948
Packed: 23-Sep-2026 MRP: ₹260.00

Cashiers scan repacked items in under 1 second with 100% pricing and weight accuracy.

Risk Mitigation

Batch & Near-Expiry Monitoring

"Zero expired stock reaching customers; zero write-off losses."

With thousands of perishable grocery, dairy, beverage, and confectionery SKUs, Uttercode ERP logs batch numbers and manufacture/expiry dates at purchase inward:

  • FEFO (First Expired, First Out): Cashiers are guided to sell older batches first.
  • 30-60-90 Day Expiry Alerts: Proactive dashboard notifications highlighting stock approaching expiry.
  • Supplier Return Tracking: Facilitates timely debit note returns to vendors before goods expire.
Live Batch Expiry Tracking Matrix
Product SKU Batch Expiry Date Stock Alert Status
Pasteurized Butter 500g B-108 15-Oct-2026 24 Units Expiring in 22 Days
Almond Milk 1 Litre B-204 20-Dec-2026 60 Units Expiring in 88 Days
Refined Sunflower Oil 5L B-319 15-Mar-2027 150 Units Fresh Stock
Omnichannel Distribution

Mobile Billing & Vehicle Delivery Dispatch

Empowering warehouse teams and on-the-field wholesale sales reps to book orders, verify deliveries, and collect payments on mobile:

Mobile Billing Application
Field Sales & Stock Yard POS

Sales representatives visiting rural grocery dealers take bulk orders directly on mobile devices with live stock validation:

  • Instant access to dealer-specific pricing and quantity slabs
  • Order booking directly from customer premises
  • Instant verification of client's pending ledger balance
  • Digital invoice generation shared over WhatsApp
Vehicle Delivery Management
Dispatch Logs & Delivery Proof

Converts bulk orders into delivery challans with real-time stage progression:

1. Pending Packing 2. Vehicle Assigned 3. Dispatched 4. Delivered

Tracks vehicle number, driver details, dispatched quantities, and cash/cheque collected on delivery.


Architecture Blueprint

Complete Business Workflow Architecture

How Uttercode ERP coordinates purchasing, repacking, multi-tier pricing, checkout, and distribution:

                    SUPPLIERS
                        │
                        ▼
                    PURCHASE
                        │
                        ▼
              ┌─────────────────┐
              │    INVENTORY    │
              └─────────────────┘
                  │          │
          ┌───────┘          └────────┐
          ▼                           ▼
    NORMAL STOCK                 BULK STOCK
          │                           │
          │                           ▼
          │                       REPACKING
          │                           │
          │                           ▼
          │                       BARCODE
          │                           │
          └────────────┬──────────────┘
                       ▼
                RETAIL / WHOLESALE
                       │
             ┌─────────┼──────────┐
             ▼         ▼          ▼
          RETAIL    WHOLESALE   CREDIT
             │         │          │
             └─────────┼──────────┘
                       ▼
                PRICING ENGINE
                       │
              ┌────────┼────────┐
              ▼        ▼        ▼
          RETAIL     SLAB    CUSTOMER
           RATE      RATE     RATE
              │        │        │
              └────────┼────────┘
                       ▼
                 POS / MOBILE BILLING
                       │
                       ▼
                  SALES INVOICE
                       │
              ┌────────┴────────┐
              ▼                 ▼
           DELIVERY          CUSTOMER COLLECTION
              │                 │
              ▼                 │
       DELIVERY RECORD          │
              │                 │
              └────────┬────────┘
                       ▼
                   ACCOUNTS
                       │
                       ▼
               REPORTS & DASHBOARD

Key Modules Implemented

Module Major Functions & Capabilities
Retail POS Ultra-fast counter billing, barcode scanning, category shortcuts, multi-payment (Cash, UPI, Card), thermal receipts.
Wholesale Billing Bulk quantity sales, credit billing, customer-specific rates, wholesale invoicing, delivery challans.
Pricing Engine Multi-tier hierarchy: Retail MRP, Wholesale rates, Quantity slab discounts, and negotiated customer contract rates.
Inventory & Batch Expiry Real-time stock balance, purchase batch logging, FEFO dispatch, 30/60/90-day near-expiry alerts, stock adjustments.
Loose Repacking Bulk sack to retail pack conversion work orders, input/output tracking, repacking cost allocation, spillage auditing.
Barcode Management Integrated thermal barcode label generator for loose repacked packets, weighing scale barcodes, and variant identification.
Mobile Billing App Android handheld mobile billing for wholesale sales visits, warehouse order taking, and outdoor delivery sales.
Delivery Management Vehicle assignment, dispatch slips, driver assignment, real-time stage tracking (Assigned → Dispatched → Delivered).
Credit & Customer Ledger Customer exposure limits, outstanding balances, overdue invoices, payment reminders, and customer ledger statements.
Purchase & Supplier Management Supplier purchase bills, rate comparisons, stock inward verification, debit notes for returns, and payment ledgers.
Accounting Integration Automated day-end cash drawer tally (Z-Report), bank reconciliation, GST sales/purchase registers, and financial reporting.

Impact Analysis

Before & After Transformation

How Uttercode transformed manual supermarket and wholesale operations:

Traditional / Manual Process
  • • Pricing: Cashiers had to manually remember wholesale discounts and negotiated credit prices.
  • • Quantity Rates: Manual calculator math for bulk quantity price slabs, causing billing errors.
  • • Loose Repacking: Bulk sugar, pulses, and grain conversions written in paper registers without barcode labels.
  • • Expiry: Staff manually inspected shelves; expired goods were frequently discovered too late.
  • • Wholesale Orders: Orders collected via phone/WhatsApp and entered manually later at the counter.
  • • Delivery: Handled through paper delivery slips with zero driver accountability.
  • • Credit Control: High overdue balances due to lack of automated customer credit limits.
Uttercode ERP Workflow
  • • Pricing: System automatically locks customer contract rates and category pricing tiers.
  • • Quantity Rates: Instant slab triggers based on quantity entered with zero manual override.
  • • Loose Repacking: Automated bulk deduction, custom barcode printing, and shelf stock creation.
  • • Expiry: Batch-wise tracking with 30-day proactive expiry notifications and vendor return notes.
  • • Wholesale Orders: Sales reps book orders on mobile at customer shops with real-time stock sync.
  • • Delivery: Digital delivery assignment, driver tracking, and digital acknowledgement.
  • • Credit Control: Strict credit limits with automated reminders and instant ledger statements.
Scalability & Expansion

Future Scalability Capabilities

As Lakshminaryan Super Shopy expands its wholesale footprint, the Uttercode platform effortlessly scales with modular extensions:

Multi-Branch & Central Warehouse Inter-branch stock transfers, hub-and-spoke replenishment, and consolidated MIS.
Route-Wise Delivery Planning Optimized van route scheduling, geo-tagged proof of delivery, and driver collection apps.
B2B Customer WhatsApp Portal Dealers can check live stock availability, place reorders, and download ledger statements.
Conclusion

One Unified ERP for Retail, Wholesale & Distribution

Lakshminaryan Super Shopy required far more than a basic retail cash register. Their business model involves counter retail sales, wholesale dealer orders, customer-specific rates, credit limits, quantity slab pricing, loose bulk repacking, custom barcode labels, mobile sales, and vehicle deliveries.

Uttercode ERP successfully unites these complex retail and distribution operations into one digital command centre — establishing a scalable foundation for regional retail dominance and high wholesale margins.

Lakshminaryan Super Shopy
Jalgaon, Maharashtra Live Deployment
Supermarket & Wholesale Automation

Ready to Streamline Your Supermarket & Wholesale Operations?

Consult with Uttercode's enterprise retail architects. We configure tailored POS, quantity slab pricing, loose repacking barcodes, and delivery workflows for your store.

WhatsApp