
Closed
Posted
Paid on delivery
I’m looking to introduce a modern customer-management layer to my independent pharmacy, centered on a robust loyalty program that rewards repeat visits and captures meaningful purchase data. Your job is to design and deliver the complete solution—from the data model that stores customer details and point balances to the simple, staff-friendly screens that let us enrol new shoppers in seconds. Core expectations • A fully working loyalty module (points or tier based—justify your choice) that plugs into our existing POS or works through its own light web interface. • Secure storage of personal data with export options for future marketing campaigns. • Real-time dashboards showing points earned, redeemed, and outstanding liabilities. • Documentation and a step-by-step hand-off so my team can operate the system without developer intervention. When you respond, attach a detailed project proposal outlining your preferred tech stack, milestones, and how you will test accuracy and data integrity. Feel free to reference past pharmacy or retail CRM work only if it directly informs this build—the focus is on a clear plan for my shop’s loyalty experience.
Project ID: 40768492
10 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average ₹17,080 INR for this job

Loyalty system v1 is built as a points-based module with a lightweight web interface, since points scale more simply into tiers later than reworking a tier system down to points for single-location enrolment. This price covers the core schema (customer profiles, point balances, transaction log) and a staff enrolment screen, delivered as a working checkpoint within 5 working days. POS integration, CSV export for marketing lists, and the real-time earned/redeemed/liability dashboard follow as a next milestone once this checkpoint is approved. Data integrity will be verified by running test transactions against expected point calculations before handoff, alongside a short written operating guide for staff. Please share your current POS brand or system and any existing customer data file so the schema aligns correctly. Price: 18800 INR fixed · Timeline: 5 working days from access/brief Konrad
₹18,800 INR in 5 days
0.0
0.0

Working loyalty system for your pharmacy in 4 days — not a mockup: a points-based module where shoppers earn on repeat visits, balances and redemptions are tracked per customer, staff enrol new shoppers in seconds, and you see real-time dashboards of points earned, redeemed and outstanding liabilities, plus CSV export for your future marketing campaigns and a step-by-step handover doc your team runs without a developer. Points over tiers for a reason: they capture the purchase data your brief asks for in a clean transaction log, and scale into tiers later without rework for a single location. Milestones: (1) Data model — customers, point balances, transaction log; light web app, SQLite/PostgreSQL + responsive UI, zero paid licences. (2) Staff screens — enrolment, earn/redeem in seconds. (3) Dashboards + export. (4) Testing — scripted accuracy checks on point math and data-integrity tests, then handover doc. PROOF NOW: in the first 24 h you get the schema + enrolment-screen mockup to approve before I build the rest — no risk of a wrong direction. Full delivery day 4. Reply here and I start today. All communication written on Freelancer, no calls needed.
₹14,500 INR in 4 days
0.0
0.0

Hello Sir, I have experience working in a medical store in Maharashtra, India. I understand your pharmacy business very well - how customers come, repeat visits, and purchase data. I can make a complete loyalty solution for you in 2 steps: STEP 1 (Fast Start - In 2 Days): A simple Excel/Google Sheet system where your staff can enroll a new customer in 10 seconds (Name + Mobile). Points will auto-calculate: Rs 100 = 1 Point. 1 Point = Rs 1 discount. With dashboard showing points earned/redeemed. STEP 2 (Upgrade): I will convert this into a light web interface that works with your POS, with secure data storage and real-time reports. Why me? - I am not just a developer, I have real pharmacy counter experience. - I will give you a working sample in 1 day. - Staff-friendly, very simple to use. I can do this within your budget of Rs 12,500 - 37,500 INR. Can we start with the Excel version? I am ready now. Thank you.
₹15,000 INR in 7 days
0.0
0.0

Hello, Here is my plan for your pharmacy loyalty program. MODEL: points-based (e.g. 1 point per Rs.100, redeemable as a discount at a threshold). Simple for staff to explain and easy for you to budget; tiers can be added later without changing the data. STACK: PostgreSQL (Supabase, role-based access, automatic backups) plus a light web app that runs in any browser or tablet at the counter. Staff enrol a customer in seconds by phone number or QR/barcode card. POS link via CSV or API if your POS offers one. MILESTONES (14 days): 1) Days 1-3: requirements, data model, your approval. 2) Days 4-8: enrolment, lookup, earn and redeem screens. 3) Days 9-11: dashboards (earned, redeemed, outstanding liability) and marketing export with consent flag. 4) Days 12-14: testing, documentation, step-by-step hand-off, short staff training. ACCURACY: every earn/redeem is an immutable ledger entry and balances are always calculated from it, so nothing drifts. Automated tests for refunds, double redemption and rounding, a daily reconciliation report, and a test run with sample data before go-live. Personal data is stored securely with access roles and recorded consent. I am new on Freelancer, so no reviews yet: that is why I quote a fair fixed price and send a full plan up front. I build custom business web apps with databases and dashboards. Questions: Which POS do you use? About how many customers and daily transactions? Fixed price Rs.15,000, 14 days. Davide
₹15,000 INR in 14 days
0.0
0.0

Hello, I have 5 years of experience in full-stack web development, database management, and business application development. I can build a simple, staff-friendly pharmacy loyalty system with customer enrolment, points earning and redemption, secure customer records, and real-time dashboards. I’d recommend a points-based system initially because it is easy for staff to manage and customers to understand. My suggested stack is React, Node.js, and PostgreSQL, with POS integration depending on your existing system. I’ll include data validation, transaction accuracy checks, secure exports, and documentation with staff training. I’d first review your POS setup and loyalty rules, then define the data model, development milestones, and testing plan. Looking forward to discussing your requirements. Thanks
₹12,500 INR in 15 days
0.0
0.0

You want repeat customers rewarded and real purchase data captured, without your staff needing a developer to run it. I would build a small web app where staff find a customer by phone number, enter the bill and points post automatically. I recommend points rather than tiers: every visit earns something, staff can explain it in one sentence, and you always know your exact points liability. Tiers can sit on top later. Stack: ASP.NET Core and PostgreSQL. Every earn and redeem is stored as a permanent transaction, so balances can always be traced and checked. I test the points rules automatically, reconcile ledger totals against the dashboards daily, and do a trial run on your real sales before go-live. Milestones over 3 weeks: (1) customer enrolment and lookup, (2) earning, redeeming and expiry, (3) dashboards, export, user guide and handover. I have 11 years in database and business app development and built a custom CRM integrated with a client's ERP. Which POS system do you use today, and can it export sales?
₹29,000 INR in 21 days
0.0
0.0

I work daily on a live sales and invoicing system for a factory (customers, invoices, returns, cash ledger, reports), so a loyalty layer with a clean points ledger is familiar ground. Points, not tiers: staff can explain it in one sentence ("1 point per Rs X, 100 points = Rs Y off"), and points give you the liability figure directly. Tiers can sit on top of the same ledger later. Stack: React + TypeScript web app (counter PC or phone), Node.js API, PostgreSQL. - Data: customers keyed by phone with a consent flag, plus an append-only points ledger. Every earn, redeem, expiry and correction is a row with staff and time. Balances come from the ledger, never edited by hand, so they can always be audited. - Screens: enrol by phone in seconds; at checkout enter phone + bill, points added; redeem with one confirm. - POS: if yours exports sales or has an API I connect it; otherwise staff enter the bill total. - Dashboard: earned, redeemed, outstanding and liability in Rs, top customers. Excel export of consenting customers. - Staff logins with roles; phone numbers masked for non-admins; daily backups. Milestones: core screens day 4, dashboard and exports day 8, testing and hand-off guide day 10. Testing: automated tests replay thousands of random earn/redeem operations and check every balance equals its ledger sum and never goes negative, plus a reconciliation report you can run any time. Which POS do you use, and about how many customers a day?
₹20,000 INR in 10 days
0.0
0.0

Hi, a loyalty program only works if staff can enrol a customer in seconds and you can trust the numbers, so that is where I would put the effort. My recommendation: points, not tiers. Points are easy to explain at the counter and to audit; tiers can be added later without changing the data. Plan: 1. Days 1-3: customers, consent and a points ledger where every movement is recorded and the balance is always the sum of the ledger, never a number someone can overwrite. Enrolment by phone number in under 20 seconds. 2. Days 4-6: earn and redeem rules you configure; a balance can never go negative. If your POS exports sales (CSV or API) I connect it; if not, staff log the purchase on the same screen. 3. Days 7-8: live dashboard (earned, redeemed, outstanding liability) and CSV export of customers who opted in to marketing. Stack: Python (FastAPI) with PostgreSQL and a simple web screen for the counter PC or a tablet. Daily backups, personal data encrypted at rest, staff login. Which POS do you use, and does it export sales? How many customers do you expect in the first month? Claudio
₹21,000 INR in 10 days
0.0
0.0

Nellore, India
Member since Oct 14, 2026
₹600-1500 INR
$250-750 USD
$250-750 USD
₹12500-37500 INR
£20-250 GBP
$10 USD
₹1500-12500 INR
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
€12-18 EUR / hour
$250-750 USD
$8-15 USD / hour
$30-250 USD
$40-60 USD
€12-18 EUR / hour
$15-25 USD / hour
$15-25 USD / hour
₹600-1500 INR
min $50 USD / hour