Pawn Shop Customer History Tool
Budget: $30 – $250 USD
I need an efficient way to pull a customer’s history from my pawn-shop database in Texas by simply typing a name. The only information I care about is the list of items that person has ever pawned or purchased—nothing else.
Scope of work
• Build a small script, query, or lightweight front-end that lets me enter a partial or full name and instantly returns the customer’s previous transactions.
• The result set must show item description, ticket number, and the date each item was pawned or bought, sorted with the most recent first.
• Export to CSV or Excel with one click.
• Solution has to run against our existing database (MySQL; I can supply schema and sample data) without requiring paid third-party services.
Acceptance criteria
• Search is case-insensitive and works with partial matches.
• Results display in under two seconds on a dataset of 50 000+ records.
• All fields match the live data exactly; no missing or additional columns.
Hand-off deliverables
1. Source code or SQL script.
2. Brief setup notes so I can deploy it on a Windows machine running XAMPP.
Scope of work
• Build a small script, query, or lightweight front-end that lets me enter a partial or full name and instantly returns the customer’s previous transactions.
• The result set must show item description, ticket number, and the date each item was pawned or bought, sorted with the most recent first.
• Export to CSV or Excel with one click.
• Solution has to run against our existing database (MySQL; I can supply schema and sample data) without requiring paid third-party services.
Acceptance criteria
• Search is case-insensitive and works with partial matches.
• Results display in under two seconds on a dataset of 50 000+ records.
• All fields match the live data exactly; no missing or additional columns.
Hand-off deliverables
1. Source code or SQL script.
2. Brief setup notes so I can deploy it on a Windows machine running XAMPP.