OfflineMart

PWA shop that works 100% offline for Malian retailers

Score: 8.0/10MLMedium BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Malian retailers cannot fulfill customer demand for online ordering platforms due to severely limited internet access at only 25%.

Solution

Installable PWA app for customers to browse/order offline via QR/Bluetooth share. Retailer PWA dashboard manages everything locally, auto-syncs orders/inventory when internet flickers on. Perfect for spotty 25% coverage.

Target Audience

Retailers operating in Mali with limited or no reliable internet access

Differentiator

Fully offline PWA—no SMS costs, rich UI catalogs, peer-to-peer sharing via NFC/QR

Brand Voice

supportive

Features

Offline Catalog

must-have12h

Customers browse full shop offline

PWA Order Queue

must-have10h

Orders queue locally, sync on connect

QR Share Links

must-have6h

Share shop QR for instant install

Retailer Dashboard

must-have15h

Offline inventory/pricing edits

Push Notifications

must-have8h

Order alerts when online

Photo Uploads

nice-to-have7h

Add product images offline

Loyalty Points

nice-to-have9h

Offline point tracking

Export Reports

nice-to-have6h

CSV download offline

Total Build Time: 73 hours

Database Schema

shops

ColumnTypeNullable
iduuidNo
user_iduuidNo
qr_codetextNo
nametextNo

Relationships:

  • one-to-many products, orders

products

ColumnTypeNullable
iduuidNo
shop_iduuidNo
nametextNo
priceintNo
stockintNo
image_urltextYes

Relationships:

  • foreign key shop_id -> shops.id

orders

ColumnTypeNullable
iduuidNo
shop_iduuidNo
customer_idtextNo
itemstextNo
syncedboolNo
created_attimestampNo

Relationships:

  • foreign key shop_id -> shops.id

API Endpoints

POST
/api/sync-orders

Bulk sync offline orders

🔒 Auth Required
GET
/api/products

Fetch shop catalog

PUT
/api/inventory

Update stock

🔒 Auth Required
GET
/api/qr

Generate shop QR

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + TanStack Query + IndexedDB
Backend
Next.js API
Database
Supabase
Auth
Clerk
Payments
Stripe
Hosting
Vercel
Additional Tools
Workbox for PWAqrcode.react

Build Timeline

Week 1: PWA core

20h
  • Offline browsing
  • Service worker

Week 2: Sync logic

25h
  • Order queue
  • DB sync

Week 3: Dashboard

20h
  • Inventory UI
  • QR gen

Week 4: Auth & payments

18h
  • Clerk
  • Stripe
Total Timeline: 4 weeks • 95 hours

Pricing Tiers

Free

$0/mo

Basic catalog

  • 1 shop
  • 100 orders/mo

Pro

$30/mo
  • Unlimited
  • Push alerts
  • Images

Team

$69/mo
  • All Pro
  • Multi-user
  • Advanced reports

Revenue Projections

MonthUsersConversionMRRARR
Month 12518%$135$1,620
Month 620023%$1,380$16,560

Unit Economics

$12
CAC
$350
LTV
4%
Churn
90%
Margin
LTV:CAC Ratio: 29.2xExcellent!

Landing Page Copy

Offline-First PWA Shops for Mali

Shop & sell without internet. Install once, use forever.

Feature Highlights

Full offline orders
QR sharing
Auto-sync
Rich photos
Push alerts

Social Proof (Placeholders)

"'Works in dead zones!' - Rural Seller"
"'Easy for customers too.' - Urban Retailer"

First Three Customers

Post QR demo in Mali WhatsApp retailer chats, offer custom shop setup for first 3 via video call, target from Instagram local markets.

Launch Channels

Product Huntr/indiehackersTwitter #PWAFacebook Marketplace Mali

SEO Keywords

offline pwa shop malino internet ecommerce africapwa retail app

Competitive Analysis

Glide Apps

glideapps.com
$25+/mo
Strength

No-code PWAs

Weakness

Online-first, no Mali focus

Our Advantage

Retail-specific offline orders

🏰 Moat Strategy

Offline data hoarding + PWA install stickiness

⏰ Why Now?

PWA adoption rising, Mali smartphone growth despite net limits

Risks & Mitigation

technicalmedium severity

Sync conflicts

Mitigation

Versioning + manual resolve

marketmedium severity

PWA install friction

Mitigation

QR + NFC

legallow severity

Data privacy

Mitigation

GDPR-like compliance

Validation Roadmap

pre-build7 days

PWA prototype share

Success: 20 installs

mvp14 days

Closed beta

Success: 70% offline usage

launch10 days

App store alt listings

Success: 100 users

Pivot Options

  • Native Android wrapper
  • B2C marketplace
  • Hardware QR kiosks

Quick Stats

Build Time
95h
Target MRR (6 mo)
$1,200
Market Size
$3.0M
Features
8
Database Tables
3
API Endpoints
4