1 of 5

WEB PURCHASING TOOL & INVENTORY MANAGEMENT

SOA Fabrication Shop Seeking Web App for student purchasing and shop inventory tracking.

​

Supervised Kiosk-Style purchasing system

SQL Backend

Help Fabrication Shop Manager

FINALLY ABANDON MS ACCESS

2 of 5

REQUIREMENTS

Techniques for connecting

    • Quantity limits calculated on items in Stock
    • Daily purchasing limit per material/per student
    • RPI ID Card Swipe at kiosk
    • Use live polls or surveys to gather audience opinions, promoting engagement
    • Reports
      • Consolidate student purchases and output to a FIXED-WIDTH .TXT report.
      • Daily inventory reports

2

3 of 5

THE POWER OF COMMUNICATION

4 of 5

Required Fields

• Student Name

o First & Last? Concatenate for reports?

o Moodle and purchasing system may have different names.

• RIN

o Key index Field.

o Name is for Bursar issues and Shop staff purposes, not critical

• COST Summed per

• RPI Semester processed

o Example for 4/19/2025 202505

5 of 5

GOALS, FUTURE INTEGRATIONS

GOALS

Basic working system by FALL 25

      • Contained on CAMPUS VM
      • Pricing report to be visible in MOODLE.
      • Inventory Reports
      • Staff confirm purchases NOT students.
      • Use Sound to notify staff of interaction
      • Output daily report to Bursar via shared folder.

​

FUTURE

MOODLE API integration for Fabricaiton Safety Training

      • Tie Safety Training to purchasing
      • Add on for student Check in Using SIMON
      • Machine access control via R pi
      • Control your expressions

5