Skip to content

Retail ERP for consignment, billing and loyalty

A multi-brand store in India now runs purchasing, consignment stock, billing, store credit, loyalty and staff commission in one ERP, with a daily email for the owners.

Operations and logisticsA multi-brand retail store in India · 4 min read

Store assistant serving a customer at the counter with a laptop, holding up a shirt on a hanger
Client
A multi-brand retail store in India
Industry
Operations and logistics
Platforms
Web
Download one-pager (PDF)
  1. The challenge

    The store buys from many suppliers, holds some stock on consignment and sells across several brands. Purchases, returns, discounts, store credit and staff commission all had to be tracked together. The owners also wanted customer messages and a daily view of sales and purchases.

  2. What we built

    We built a web ERP around the store's own workflow. Purchasing covers orders, invoices, payments, returns, debit notes and consignment stock. Sales covers invoices, discounts, returns, store credit and settlement adjustments. A customer module adds messages, gift vouchers and loyalty cards, with reports across the business.

  3. The result

    The store runs buying, consignment, billing and customer follow-up from one web system. Owners receive a daily email of sales and purchases and can open brand, supplier, employee and margin reports when they need them.

What the system does.

The parts of the system that made the difference for the client and the people who use it.

  • Full purchase cycle

    Purchase orders, invoices, payments, returns and debit notes, with discount and tax handling.

  • Consignment stock

    Items received on consignment are tracked separately, with their own invoices and returns.

  • Item master with labels

    Units, categories, sale prices and photographs, with printable item labels.

  • Counter billing and store credit

    Invoices, discounts, item returns, store credit and settlement adjustments.

  • Customer messages

    Thank-you, promotion, birthday and anniversary messages from the customer database.

  • Gift vouchers and loyalty cards

    Vouchers and loyalty cards are issued and redeemed inside the same system.

  • Stock checks and commission

    Physical stock verification, with employee commission calculated automatically.

  • Reports and daily email

    Sales, purchase, aging, brand, supplier, employee, margin and outstanding reports, ledgers and a daily summary email.

Built with

The tools behind it, layer by layer.

  1. Front end

    • React
  2. Back end

    • Node.js
    • Express.js
  3. Database

    • MongoDB
  4. Cloud and hosting

    • AWS
  5. CI/CD and DevOps

    • GitHub Actions
    • Git
  6. Integrations

    • SMS gateway

The full story

The challenge

A multi-brand retail store in India needed one system for buying and selling. It buys from many suppliers and holds part of its stock on consignment.

At the counter, staff give discounts, take returns and issue store credit, and they earn commission on what they sell. The owners wanted retail ERP software for India's way of trading, built around their store rather than bent to fit it.

Every one of those threads touches the others. A return changes stock, a store credit changes what a customer owes, and a sale changes what a salesperson earns. Kept in separate places, they drift apart.

The owners also wanted two more things: a daily view of the numbers, and a way to stay in touch with customers after they leave the counter.

What we built

We built a web ERP around the store's real workflow, in three connected parts.

Purchasing. Purchase orders, invoices, payments, returns and debit notes, with discounts and tax handled on each. Consignment stock has its own invoices and returns, so it stays separate from stock the store owns. The item master holds units, categories, sale prices and photographs, and prints item labels for the shelves.

Sales. Invoices, discounts, item returns and store credit. The system also records the small settlement adjustments agreed with each customer, so the books match what was settled at the counter.

Customers and staff.

  • Customer messages for thank-yous, promotions, birthdays and anniversaries, sent from the customer database.

  • Gift vouchers and loyalty cards, issued and redeemed inside the same system.

  • Physical stock checks run in the system rather than on paper.

  • Employee commission calculated from sales, so nobody works it out by hand.

How it works day to day

Follow one sale. A salesperson bills the items at the counter and applies the agreed discount. If the customer brings something back later, the return goes against the original invoice and can become store credit. A loyalty card or gift voucher is redeemed on the same screen.

The sale counts toward that salesperson's commission without a separate sheet. The customer's details stay in the database, ready for the next thank-you, birthday or promotion message.

At the end of the day, the owners receive an email summarizing sales and purchases. When they want more, they open brand-wise, supplier-wise, employee-wise, margin, aging and outstanding reports, with client and firm ledgers alongside.

The result

The store runs buying, consignment, billing and customer follow-up from one web system. Owners get a daily email of sales and purchases and can open brand, supplier, employee and margin reports whenever they need detail. Consignment stock, store credit and commission are tracked in the same records as everything else, instead of in side ledgers.

What the research says about retail ERP software in India

  • Counter payments have gone digital. UPI handled about 24,162 crore transactions worth roughly ₹314 lakh crore in FY 2025-26, and payments to merchants made up 63% of its volume, according to the Ministry of Finance (Press Information Bureau, April 2026). Each of those payments needs a matching bill, which the ERP's counter billing records.

  • Customers respond to messages that know them. In a survey of more than 7,600 consumers in 18 countries by communications platform vendor Twilio, 88% said they are more likely to buy when engagement is personalized in real time (Twilio, 2025). The ERP's birthday, anniversary and thank-you messages draw on the same customer records as billing and loyalty.

  • Small firms are investing in their data. In the sixth Small and Medium Business Trends report by CRM vendor Salesforce, a survey of 3,350 SMB leaders, 84% said complete and correct data is becoming more important to business success, and 66% were increasing their investment in data management (Salesforce). Keeping purchases, consignment stock, sales and commission in one set of records is this store's version of that.

Where AI fits next

The store has none of this yet; each is a next step its sales history would allow. A model could suggest reorder quantities for each brand from past sales and the season, for the buyer to approve.

It could pick which customers should receive a promotion based on what they have bought before. Consignment items that are not selling could be flagged early, while there is still time to return them.

Forecasting of this kind is covered in our guide to inventory optimization with predictive analytics.

Planning something similar?

Before you commission a retail ERP, answer these four questions:

  1. Which stock do you own, and which do you hold on consignment with its own returns?

  2. How are discounts, returns, store credit and settlement adjustments agreed at your counter?

  3. How is staff commission calculated, and who checks it today?

  4. Which few numbers would you want in your inbox every evening?

Learn how we handle ERP development, the ERP implementation mistakes worth avoiding, and our retail and e-commerce software work.

More of this kind of work sits under our operations and logistics software.

Common questions

What does a retail ERP cover that a billing tool does not?

In this store's system: the full purchase cycle with debit notes, consignment stock kept separate from owned stock, store credit, settlement adjustments, staff commission, loyalty cards, customer messages and owner reports, all in one set of records.

How does retail ERP software handle consignment stock?

Items received on consignment are tracked separately from owned stock, with their own invoices and returns.

Can retail ERP software send customer birthday messages?

This store's ERP sends thank-you, promotion, birthday and anniversary messages from its customer database, and issues and redeems gift vouchers and loyalty cards in the same system.

What reports do the owners get?

A daily email of sales and purchases, plus brand-wise, supplier-wise, employee-wise, margin, aging and outstanding reports, and client and firm ledgers.

Can an ERP calculate retail staff commission automatically?

Yes. In this store's ERP, each salesperson's commission is calculated from the sales recorded in the system, so nobody works it out by hand.

More of our work.

Projects that used the same services or served the same industry.

See all our work

Free project estimate

Talk through a project like these.

Thirty minutes with a founder, not a salesperson. Bring the problem; leave knowing what we'd build first and what it would cost.

What you get back

  • An indicative budget range
  • A realistic timeline
  • What moves the cost up or down
  • A reply within 4 business hours
  • Answered by a founder
  • NDA on request, before you share details

Tell us what you need

A few lines is plenty. You get a number before any call.

Fields marked * are required.