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.
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.
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.
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.
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.
Team & resourcing - Small team - 2 engineers, 1 designer, part-time PM, and one ops lead as domain owner.
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.
অবশ্যই। আমি তোমাকে একটা বাস্তবসম্মত বড় 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, এবং লাভের হিসাব** থাকবে।
Design by The Resonance | Powered by GPC – The AI Transformation Company