PLSPCART
2022
An online campus marketplace and e-commerce platform built in 2022 using PHP and PostgreSQL for the students of Pamantasan ng Lungsod ng San Pablo (PLSP)—connecting students to official college uniforms, department shirts, textbooks, and a moderated student-to-student Buy & Sell marketplace.
PROBLEM & GOAL
Students needed a centralized, trustworthy campus platform to purchase official college merchandise (across CNAHS, CAS, CBA, CCST, COA, and COE departments), find course textbooks, and safely buy or sell pre-loved school essentials with fellow students without relying on scattered social media groups.
END-TO-END EXECUTION
Engineered PLSPCart from the ground up using PHP and a relational PostgreSQL database. Built a dual-mode e-commerce experience featuring department category filtering, a student Buy & Sell listing workflow, shopping cart and checkout supporting both Cash on Delivery and School Counter Pick-Up, and a full Admin Portal for managing inventory, processing student orders, and moderating user registrations and peer-to-peer product listings.
- Full-Stack PHP E-Commerce Storefront & Shopping Cart
- PostgreSQL Relational Database Schema (Products, Orders, Users, Seller Requests)
- College Department Catalog Filtering (CNAHS, CAS, CBA, CCST, COA, COE)
- Checkout Engine (Cash on Delivery & School Counter Pick-Up) & Order Tracking
- Peer-to-Peer Student Buy & Sell Marketplace with Admin Sell Approval
- Admin Dashboard for Inventory CRUD, Order Fulfillment & User Verification
ROLE MODULE 01 // STUDENT CAMPUS STOREFRONT & CHECKOUT (10 SCREENS)
Campus Storefront
& checkout.
Student-facing marketplace for browsing department uniforms, shirts, pins, and textbooks across 6 colleges, complete with search/category filtering, cart checkout, and order confirmation.
PLSPCart hero banner ("Your campus marketplace, anytime, anywhere") with value highlights for Hot Deals, Real-Time Order Updates, Hassle-Free Checkouts, and Student Savings.
Mission overview and quick-filter cards for the 6 university colleges: CNAHS, CAS, CBA, CCST, COA, and COE.
Featured campus items including CHK, CAS, and COE Department Shirts and CBA Pin Sets.
Full product catalog with Products / Buy & Sell mode switcher, keyword search, college category filter, and sorting.
Detailed item view for the CNAHS Nursing Uniform showing pricing, seller contact information, description, and related department items.
Product listing for Nursing Books Set 1 with seller details and recommended course materials.
Order summary and checkout form supporting Cash on Delivery and Pay on the Counter (School Pick Up), plus shipping address and order notes.
Post-checkout confirmation screen displaying Order Number, Payment Method, Pending status, itemized breakdown, and delivery instructions.
Sign-in gateway for registered PLSP students, peer sellers, and marketplace administrators.
Storefront newsletter subscription and quick navigation links for FAQs, shipping policy, and student Buy & Sell.
ROLE MODULE 02 // ADMIN & SELLER MODERATION PORTAL (7 SCREENS)
Admin & Seller
moderation.
Back-office administration suite for monitoring store revenue, adding/editing products, fulfilling student orders, and approving student accounts and peer-to-peer Buy & Sell product listings.
Overview of Total Products, Total Orders, Total Users, Total Revenue (₱), Recent Orders table, and quick-action navigation.
Admin catalog view with instant Edit and Delete controls on every product card across all college categories.
In-place modal editor for updating product name, price, description, college category, and product photo.
Product creation form with Name, Description, Price (₱), Stock quantity, Category selector, Featured toggle, and image upload.
Detailed order management screen with search/status/date filters, customer details, ordered item cards, and live order status updates.
Moderation queue for reviewing Sell Approval requests and student-submitted products pending approval before they go live.
User verification queue allowing administrators to Approve or Reject newly registered campus accounts.