ShelfPilot

Run a smarter home-brand store from product test to repeat sale.

ShelfPilot is an operations-first e-commerce platform for a Bangladesh-based home and lifestyle brand selling compact utility products like organizers, storage items, cleaning tools, and travel accessories. It helps the team source, test, list, sell, verify, fulfill, support, and retarget customers from one workflow so they can scale winning products with better margins and less manual chaos.

Business Goals

  • Launch with 5–10 test SKUs and identify at least 2 winning products within 90 days.
  • Reach a monthly gross margin of 25–35% after ad spend, packaging, courier, and return losses within 6 months.
  • Reduce order processing time from order received to courier booking to under 15 minutes for 90% of confirmed orders within 3 months.
  • Improve repeat purchase rate to 20%+ within 6 months through post-purchase offers and remarketing.
  • Keep return rate below 8% and failed-delivery rate below 5% after the first 1000 orders.

User Goals

  • Let the team import, score, and launch products quickly without spreadsheets.
  • Automatically verify orders, detect duplicates, and flag incomplete addresses before dispatch.
  • Track stock, margin, ad performance, and courier status in one dashboard.
  • Capture customer history so support can answer faster and sales can target repeat buyers.
  • Help marketing run structured creative tests and quickly scale winners.

Non-Goals

  • Not building a full ERP or accounting replacement.
  • Not handling marketplace seller management for Daraz or other third-party marketplaces in v1.
  • Not building custom warehouse robotics or advanced route optimization.
  • Not supporting complex B2B invoicing, credit terms, or subscription commerce in v1.

Ops Lead Ayesha, 32 - Ayesha manages products, stock, and daily order flow for a small e-commerce brand. She needs a system that reduces mistakes and gives her a clear view of what is selling and what is blocking delivery.

Ops Lead Ayesha, 32

  • As an ops lead, I want to verify orders before confirming them, so that I avoid shipping wrong or incomplete orders.
  • As an ops lead, I want to see low-stock and dead-stock alerts, so that I can reorder or stop ads in time.
  • As an ops lead, I want to record courier status updates automatically, so that I can handle failed deliveries faster.

Growth Marketer Rafi, 28 - Rafi runs Facebook and TikTok campaigns for multiple products and needs fast feedback on creatives, audiences, and offers. He wants to know what converts before spending too much budget.

Growth Marketer Rafi, 28

  • As a marketer, I want to launch structured creative tests, so that I can compare hooks, videos, audiences, and offers cleanly.
  • As a marketer, I want to see ROAS and CPA by product, so that I can shift budget to winners.
  • As a marketer, I want retargeting audiences built from site and cart events, so that I can recover high-intent shoppers.

Support Agent Nila, 24 - Nila answers customer messages on Facebook and WhatsApp and needs quick access to order and product information. She often handles pricing questions, delivery tracking, complaints, and returns.

Support Agent Nila, 24

  • As a support agent, I want suggested replies for common questions, so that I can answer faster and consistently.
  • As a support agent, I want to look up a customer’s order history and delivery state, so that I can resolve issues without asking repetitive questions.
  • As a support agent, I want return requests routed into an approval flow, so that I can apply policy fairly and keep records.

Product Catalog and Scoring · High priority

  • Manage the product lifecycle from idea to test launch using a repeatable scorecard and product metadata.
  • Store product ID, name, SKU, purchase price, selling price, weight, supplier, packaging needs, images, and demo video links.
  • Allow manual or imported scoring across demand, competition, margin, quality, ad potential, and repeat purchase potential.
  • Flag products as test, high priority, winner, dead stock, or paused based on configurable score thresholds.
  • Support sample receipt, quality check, and content capture before product activation.
  • Show expected margin after courier, packaging, ads, and average return loss.

Order Capture and Verification · High priority

  • Collect and validate customer order details before an order is confirmed and packed.
  • Capture name, phone, address, product, quantity, selling price, source channel, and notes.
  • Detect duplicate phone numbers and surface previous orders and their statuses.
  • Validate address completeness and required fields before confirmation.
  • Check stock availability before confirming and alert support when stock is insufficient.
  • Support confirmed, cancelled, packed, booked, delivered, failed delivery, returned, and refunded states.

Warehouse and Fulfillment · High priority

  • Support receiving, storage, pick-pack, and courier handoff with strong error checking.
  • Record inbound stock receipt, count, quality check, and storage location.
  • Generate packing slips and invoice references for each order.
  • Require a final checklist for correct product, quantity, customer, phone, address, and price before courier booking.
  • Track package weight and packaging requirement for courier selection.
  • Log failed picks, missing items, and damaged goods as exceptions.

Marketing and Retargeting · Medium priority

  • Help the team run organic and paid campaigns and convert interested users into customers.
  • Track content assets by product, hook, format, and channel for Facebook, TikTok, YouTube Shorts, and Instagram.
  • Support paid test matrix planning using video, hook, audience, and offer combinations.
  • Build retargeting audiences from site visits, product views, add-to-cart, messages, and abandoned checkouts.
  • Record campaign spend, CPA, ROAS, conversion rate, and winning creatives by product.
  • Surface post-purchase upsell and repeat purchase recommendations from prior orders.

Customer Support and Returns · Medium priority

  • Centralize customer conversations and automate common support paths, including returns.
  • Route incoming messages into categories such as pricing, product details, order placement, tracking, complaint, and return.
  • Provide canned responses and AI-assisted drafts for common questions.
  • Create a return request with reason, policy check, approval, pickup, inspection, and refund or replacement outcome.
  • Link every support ticket to a customer profile and order history.
  • Escalate unresolved issues and mark SLA breaches.

First-Time Setup

  • Create the business profile and select country, currency, courier partners, and support channels.
  • Import 5–10 starting products or create them manually with prices, weights, and supplier details.
  • Upload product photos, sample videos, and packaging requirements.
  • Connect Facebook pixel, website checkout, and WhatsApp or Messenger inbox.
  • Set order verification rules, return policy, and stock thresholds.
  • Begin taking orders within 1 business day, with first usable dashboard views in under 30 minutes.

1. Score and launch products

  • The team adds a product idea, runs the scorecard, and marks it as test or high priority based on threshold.
  • Scores are editable by category and saved with notes.
  • Products below threshold remain in draft and cannot be promoted to live.
  • If required data such as price or weight is missing, the product is blocked from launch.

2. Receive stock and publish content

  • Stock is received, checked, photographed, and entered into inventory before sales start.
  • Count mismatch or damaged items create an exception record.
  • The system prompts for images, short demo video, and packaging notes.
  • Each SKU gets an internal product ID and stock location.

3. Capture and verify orders

  • Incoming orders from website, Facebook, or manual entry are validated before confirmation.
  • Duplicate phone numbers show prior orders and status history.
  • Incomplete addresses trigger a call or message task.
  • Out-of-stock orders are held, backordered, or rejected based on policy.

4. Pack, book, and track delivery

  • Confirmed orders move through picking, packing, invoice generation, courier booking, and tracking updates.
  • A final checklist must be completed before dispatch.
  • Courier booking stores AWB number, status, and delivery estimate.
  • Failed delivery creates a follow-up task with reason and reattempt outcome.

5. Measure profit and repeat sales

  • The dashboard calculates true profit and helps the team target repeat purchases.
  • Profit includes product cost, packaging, courier, ad spend, and expected return loss.
  • Customers with delivered orders can be segmented into follow-up campaigns.
  • Winning products are surfaced by margin, volume, and conversion performance.

Power Features and Edge Cases

  • Rule-based automation for order confirmation, stock alerts, and failed delivery retries.
  • Audience segmentation by first-time buyers, repeat buyers, high-value customers, and return-prone customers.
  • Creative testing dashboard with winning hook, audience, and offer combinations.
  • Manual override for COD risk, suspicious duplicate orders, and address verification failures.
  • Bulk order import and bulk courier manifest generation.
  • AI-assisted support replies that read customer intent and suggest the next workflow step.

Interface Principles

  • Dashboard-first layout with Today, Orders, Products, Marketing, and Support sections.
  • Fast, mobile-friendly screens for ops staff using low-end devices.
  • Clear status colors for order lifecycle, stock levels, and campaign results.
  • Large tap targets and readable typography for Bangla and English support.
  • Performance target of under 2 seconds for dashboard load on average broadband.
  • Accessible forms with inline validation, error summaries, and keyboard navigation.

Ayesha runs a small home-goods brand and used to manage products, stock, and orders in spreadsheets and chat threads. Orders were often delayed because addresses were incomplete, stock numbers were wrong, and the team could not easily tell which products were profitable after ad spend and courier costs.

With ShelfPilot, she scores new products, receives stock into inventory, and verifies orders before confirming them. The team sees duplicates, low stock, and failed delivery reasons in one place, while support gets quick access to customer history and canned responses.

After a few weeks, Ayesha can identify winning products, cut dead stock, and focus ad spend on products with real margin. Repeat customers get targeted follow-up offers, turning one-time buyers into a more efficient growth engine for the business.

User-Centric Metrics

  • 90% of confirmed orders verified within 15 minutes.
  • Address completeness errors reduced by 60% within 3 months.
  • Average support first-response time under 5 minutes during business hours.
  • Return rate maintained below 8% of delivered orders.
  • Repeat purchase rate reaches 20% within 6 months.

Business Metrics

  • Gross margin after ads and fulfillment reaches 25% to 35% on winning SKUs.
  • ROAS above 2.5 on scaled campaigns for at least 3 products.
  • Monthly order volume grows by 15% quarter over quarter after launch.
  • Cart-to-purchase conversion improves by 10% after verification and retargeting.
  • Dead-stock share stays below 20% of active inventory.

Technical Metrics

  • 99.9% uptime for core order and dashboard services.
  • API and dashboard p95 latency under 500 ms for common reads.
  • Zero critical data loss incidents with daily backups and restore testing.
  • Role-based access enforced for admin, ops, support, and marketing users.

Tracking Plan

  • product_created
  • product_scored
  • stock_received
  • order_created
  • order_verified
  • order_confirmed
  • order_failed_delivery
  • return_requested
  • campaign_launched
  • campaign_won
  • customer_repeat_purchase

Technical Needs

  • Web app built with Next.js and TypeScript for the admin and operations console.
  • Backend API built with NestJS or Next.js API routes for order, product, and support workflows.
  • PostgreSQL for relational data including customers, orders, inventory, and returns.
  • Redis for job queues, caching, and status refresh tasks.
  • Object storage such as AWS S3 for product images, videos, invoices, and packing slips.
  • Background jobs using BullMQ or similar for delivery sync, reminders, and retargeting audience updates.
  • Audit log tables for all manual overrides, price edits, and status changes.

Integration Points

  • Meta Ads and Facebook Pixel for campaign tracking and retargeting.
  • WhatsApp Business API or Messenger for order verification and support.
  • Courier APIs such as Paperfly, Pathao, Steadfast, eCourier, or RedX depending on availability.
  • Email and SMS provider such as SendGrid and Twilio or a local SMS gateway.
  • Stripe or local payment links only if online prepayment is enabled later.

Data Storage & Privacy

  • Store customer phone, address, and order history with role-based access controls.
  • Encrypt sensitive data at rest and enforce TLS in transit.
  • Keep a clear consent trail for marketing messages and retargeting where required.
  • Support export and deletion requests for privacy compliance such as GDPR-style requests where applicable.
  • Separate operational logs from customer personal data where possible and retain only as long as needed.

Scalability & Performance

  • Use read replicas or caching for dashboard-heavy views as order count grows.
  • Design status sync as asynchronous jobs so courier updates do not block order handling.
  • Optimize image and video delivery through CDN-backed storage.
  • Partition or archive old orders and logs after a defined retention period.

Potential Challenges

  • Courier status updates may be delayed or inconsistent; mitigate with polling, manual override, and reconciliation jobs.
  • Manual order entry can introduce errors; mitigate with validation, duplicate detection, and required-field checks.
  • Creative fatigue can reduce ad performance; mitigate with structured testing and automatic winner tracking.
  • Inventory mismatches can cause cancelled orders; mitigate with receiving counts, stock reservations, and low-stock alerts.
  • High return or COD failure rates can hurt profit; mitigate with order verification, customer profiling, and risk-based confirmation.

Team & resourcing - Small team - 2 engineers, 1 designer, part-time PM, and one ops lead as domain owner.

Phase 1: MVP order and inventory backbone · Weeks 1–4

  • Product catalog with scoring fields
  • Inventory receive/count workflow
  • Manual order creation and verification
  • Basic dashboard for orders, stock, and profit
  • Role-based login for admin, ops, and support

Phase 2: Fulfillment and support workflows · Weeks 5–8

  • Packing checklist and invoice generation
  • Courier status tracking and failed delivery handling
  • Customer profile and order history
  • Support inbox with canned responses
  • Return request workflow with approval states

Phase 3: Marketing and retargeting intelligence · Weeks 9–12

  • Campaign and creative tracking
  • Audience segmentation for retargeting
  • ROAS, CPA, and conversion dashboards
  • Repeat purchase offer tagging
  • Event tracking for product views, carts, and purchases

Phase 4: Automation and scale readiness · Weeks 13–16

  • Rule-based automations for stock, order, and support alerts
  • AI-assisted reply suggestions
  • Advanced profitability and cohort reports
  • Bulk imports and exports
  • Audit logs and retention controls

Paste this into Cursor, Bolt, Lovable, or v0 to start building.

Build a SaaS web app called ShelfPilot for a Bangladesh-based home and lifestyle e-commerce brand.

Goal: help a small team manage product selection, inventory, order verification, packing, courier tracking, customer support, returns, marketing performance, and repeat sales from one admin dashboard.

Use Next.js 14, TypeScript, Tailwind CSS, PostgreSQL, Prisma, and a lightweight backend architecture that can be deployed on Vercel with managed Postgres. Include role-based auth for Admin, Ops, Support, and Marketing.

Core screens and flows:
1. Login and role-based dashboard
2. Product management with product scoring (demand, competition, margin, quality, ad potential, repeat purchase), SKUs, supplier info, pricing, images, video links, packaging requirements, and status labels like draft, test, high priority, winner, dead stock
3. Inventory receiving flow with count, quality check, storage location, and low-stock alerts
4. Order intake flow supporting manual order creation and later API/webhook import, with duplicate phone detection, address validation, stock check, and order verification states
5. Packing and dispatch flow with checklist, invoice/packing slip, courier booking reference, and delivery status timeline
6. Customer profile page showing total orders, total spent, last order, favourite products, delivered orders, returned orders, and support history
7. Support inbox with ticket categories for pricing, product info, order tracking, complaint, and return request; include canned replies and AI suggestion placeholder
8. Marketing dashboard with campaign spend, CPA, ROAS, conversion rate, creative tests, audience tags, and retargeting segments
9. Finance dashboard calculating true profit per order after product cost, packaging, courier, ad cost allocation, and return loss allocation
10. Admin settings for courier partners, return policy, stock thresholds, notification channels, and permissions

Data model should include: User, Role, Product, Supplier, InventoryLot, StockMovement, Customer, Order, OrderItem, CourierShipment, SupportTicket, ReturnRequest, Campaign, CreativeTest, AudienceSegment, AuditLog.

Important workflows:
- Order verification should block confirmation when address is incomplete, stock is unavailable, or duplicate risk is high.
- Packing should require a final checklist before courier booking.
- Delivery updates should move through booked, picked up, in transit, out for delivery, delivered, failed delivery.
- Returns should go through requested, policy check, approved/rejected, received, refunded/replaced.
- Dashboard should surface today’s totals: orders, confirmed, cancelled, delivered, returned, revenue, ad spend, profit, best seller, low stock, dead stock, highest profit product.

Build with clean component architecture, responsive mobile-first UI, reusable tables, filters, status badges, and strong empty/error/loading states. Seed demo data for 5 to 10 products and sample orders. Add analytics event hooks for product_created, product_scored, stock_received, order_created, order_verified, order_confirmed, order_failed_delivery, return_requested, campaign_launched, campaign_won, customer_repeat_purchase.

Return a working app scaffold with navigation, pages, forms, API routes or server actions, Prisma schema, and sample dashboard widgets.

Business Idea

অবশ্যই। আমি তোমাকে একটা বাস্তবসম্মত বড় e-commerce business idea দিচ্ছি, যেখানে শুরু থেকে কাস্টমার পাওয়া, পণ্য সংগ্রহ, marketing, order handling, delivery, customer support, হিসাব—সব ধাপ থাকবে। Business Idea: Smart Home & Lifestyle E-commerce Brand মূল ধারণা: বাংলাদেশের মধ্যবিত্ত পরিবারের জন্য ছোট ছোট কিন্তু কাজে লাগে এমন Home & Lifestyle Products বিক্রি করা—যেমন kitchen organizer, cleaning tools, storage products, desk accessories, travel products ইত্যাদি। 1. Business Model Supplier → আমাদের Warehouse → Facebook/Website → Customer Order → Order Verification → Courier → Customer → After-sales প্রথমে ৫–১০টি product দিয়ে শুরু করা হবে। যেটা বেশি বিক্রি হবে, সেটাকেই ধীরে ধীরে নিজস্ব brand/product হিসেবে তৈরি করা হবে। --- 2. Product Selection Algorithm প্রতিটি নতুন product নেওয়ার আগে: Product → Demand Check → Competition Check → Cost Check → Profit Check → Test প্রতিটি product-এর জন্য score: বিষয় Score Market demand /10 Competition /10 Profit margin /10 Product quality /10 Video/Ad potential /10 Repeat purchase /10 40+/60 হলে → Test Product 50+/60 হলে → High Priority Product --- 3. Product Handling Supplier থেকে product আসার পর: Receive → Count → Quality Check → Photograph/Video → SKU তৈরি → Stock Entry → Storage প্রতিটি product-এর জন্য: Product ID Product name Purchase price Selling price Current stock Supplier Product images Video Weight Packaging requirement রাখা হবে। --- 4. Marketing System Marketing-কে ৩ ভাগে ভাগ করব। A. Organic Marketing প্রতিদিন: Facebook Reels TikTok YouTube Shorts Product demonstration Problem → Solution video Customer review Before/After যেখানে প্রযোজ্য Educational content উদাহরণ: Problem: রান্নাঘরে জায়গা কম ↓ Solution: আমাদের organizer ↓ Demonstration ↓ CTA: Order Now --- B. Paid Marketing Facebook/Instagram Ads: Creative Testing একটি product-এর জন্য: 3 ভিডিও 3 hooks 2 audiences 2 offers = 36 combinations প্রথমে ছোট budget দিয়ে test করা হবে। যে creative ভালো result দেয়: Winner → More Budget যে creative কাজ করে না: Stop --- C. Retargeting যারা: Website visit করেছে Product দেখেছে Cart করেছে Message করেছে কিন্তু order করেনি তাদের আবার বিজ্ঞাপন দেখানো হবে। Cold Audience → Interested → Cart → Purchase → Repeat Customer --- 5. Customer Order System Customer order করলে: Order Received ↓ Automatic Information Collection Name Phone Address Product Quantity Price ↓ Duplicate Order Check ↓ Order Verification ↓ Confirmed ↓ Packing ↓ Courier ↓ Delivered --- 6. Order Verification Algorithm ধরো customer order দিল। System প্রথমে check করবে: Phone number আগে order করেছে? যদি করে থাকে: → Previous order status check যদি না করে: → New customer তারপর: Address complete? না → Customer-কে message/call হ্যাঁ → পরবর্তী ধাপ। তারপর: Product stock আছে? না → customerকে জানানো আছে → Confirm --- 7. Packaging System প্রতিটি order: Product Pick → Quality Check → Invoice → Packaging → Final Check → Courier Final Check-এর আগে: ☑ Correct product ☑ Correct quantity ☑ Correct customer ☑ Correct phone ☑ Correct address ☑ Correct price তারপর courier। --- 8. Delivery System Courier থেকে status আসবে: Booked ↓ Picked Up ↓ In Transit ↓ Out for Delivery ↓ Delivered অথবা Failed Delivery Failed হলে: Reason → Customer Contact → Reattempt / Return --- 9. Customer Support Customer message করলে AI/Support system প্রথমে বুঝবে: Price? → Price reply Product details? → Details Order করতে চায়? → Order flow Order কোথায়? → Tracking Complaint? → Support ticket Return? → Return policy এখানে ধীরে ধীরে AI automation যোগ করা যাবে। --- 10. Return Management Return request: Customer Request ↓ Reason Check ↓ Policy Check ↓ Approved / Rejected ↓ Approved হলে: Pickup → Receive → Quality Check তারপর: Refund / Replacement --- 11. Customer Database প্রতিটি customer-এর তথ্য রাখা হবে: Customer ├── Name ├── Phone ├── Address ├── Total Orders ├── Total Spent ├── Last Order ├── Favourite Products ├── Delivered Orders └── Returned Orders এতে পরে বুঝতে পারবে কে high-value customer। --- 12. Repeat Customer System একজন customer একবার কিনলেই কাজ শেষ না। Flow: Purchase ↓ Delivery ↓ Feedback ↓ Review ↓ Related Product Offer ↓ Repeat Purchase উদাহরণ: Customer kitchen organizer কিনেছে। কিছুদিন পরে তাকে দেখানো হলো: Kitchen Storage Set এতে customer acquisition cost কমে আসবে। --- 13. Finance System প্রতিটি order-এর জন্য: Selling Price − Product Cost − Packaging − Courier Cost − Ad Cost − Return/Loss Cost = Actual Profit ধরো: Selling price = ৳800 Product cost = ৳300 Packaging = ৳30 Courier = ৳100 Average ad cost = ৳150 Return loss allocation = ৳40 Actual profit = ৳180 শুধু selling price − product cost দেখে profit হিসাব করা যাবে না। --- 14. Business Dashboard একটা dashboard থাকবে: Today Total Orders Confirmed Cancelled Delivered Returned Revenue Ad Spend Profit Product Best Seller Low Stock Dead Stock Highest Profit Product Marketing Ad Spend Orders CPA ROAS Conversion Rate --- 15. পুরো Business Algorithm সবশেষে পুরো system হবে: IDEA ↓ MARKET RESEARCH ↓ PRODUCT SELECTION ↓ SUPPLIER ↓ SAMPLE ↓ QUALITY CHECK ↓ PRODUCT CONTENT ↓ WEBSITE + SOCIAL MEDIA ↓ AD TESTING ↓ CUSTOMER ↓ ORDER ↓ DUPLICATE CHECK ↓ ORDER VERIFICATION ↓ CONFIRM ↓ PACKING ↓ COURIER ↓ DELIVERY ↓ CUSTOMER FEEDBACK ↓ REVIEW ↓ RETARGETING ↓ REPEAT PURCHASE ↓ PROFIT ANALYSIS ↓ SCALE WINNING PRODUCTS 🚀 এরপর Business Scale Stage 1: 5–10 products ↓ Stage 2: Winning products identify ↓ Stage 3: Increase ads ↓ Stage 4: Warehouse ↓ Stage 5: Own packaging/brand ↓ Stage 6: Private-label products ↓ Stage 7: Multiple product categories ↓ Stage 8: National-scale e-commerce brand এটাই আসলে “Business Idea → Algorithm → Operations → Marketing → Automation → Scale” কাঠামো। তুমি চাইলে আমি পরের ধাপে এটাকে আরও **প্রফেশনাল ২০–৩০ পৃষ্ঠার Business Blueprint-এর মতো** বানিয়ে দিতে পারি—যেখানে **প্রতিটি department, employee role, exact workflow, automation, database, marketing funnel, KPI, এবং লাভের হিসাব** থাকবে।

Make My PRD

Design by The Resonance | Powered by GPC – The AI Transformation Company