PORTFOLIO / 2026 // V2.6 ONLINE
← BACK TO ARCHIVE CASE STUDY // 05 — WEB

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.

+ PHP+ PostgreSQL+ SQL+ HTML5 & CSS3+ JavaScript+ E-Commerce & Cart Session Management+ Role-Based Admin Moderation
05 / PHP + POSTGRESQL / CAMPUS E-COMMERCE ORG // Pamantasan ng Lungsod ng San Pablo (PLSP)
PHP + POSTGRES
BACKEND
6 COLLEGES
DEPARTMENTS
B2C + P2P SELL
WORKFLOW
01 // THE CHALLENGE ROLE: Full-Stack PHP & PostgreSQL Developer

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.

02 // THE SOLUTION YEAR: 2022

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.
STORE 01 // CAMPUS MARKETPLACE LANDING PAGE ↗

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.
STORE 02 // ABOUT US & 6 COLLEGE DEPARTMENT CATEGORIES ↗

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.
STORE 03 // FEATURED DEPARTMENT MERCHANDISE ↗

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.
STORE 04 // PRODUCTS & BUY-AND-SELL CATALOG ↗

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.
STORE 05 // PRODUCT DETAIL — OFFICIAL UNIFORM ↗

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.
STORE 06 // PRODUCT DETAIL — COURSE TEXTBOOKS ↗

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.
STORE 07 // CHECKOUT & PAYMENT METHOD SELECTION ↗

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.
STORE 08 // ORDER CONFIRMATION RECEIPT ↗

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.
STORE 09 // STUDENT & ADMIN AUTHENTICATION ↗

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.
STORE 10 // NEWSLETTER & CAMPUS SUPPORT FOOTER ↗

Storefront newsletter subscription and quick navigation links for FAQs, shipping policy, and student Buy & Sell.

NEXT CASE STUDY // 01

AUDIT PORTAL

LARAVEL / ENTERPRISE INTERNAL PORTAL

VIEW NEXT PROJECT →