Europe Sims

Build with: NodeJS, Express, SQLite3 and Pug.

This site was one of the first projects I made! During this time I was doing the Hardvard's CS50 - Introduction to Computer Science online course. I used it as the final project.

Europe SIMs was a SIM distribution channel for Tubular Systems. We sold SIMs to help tourists save on data roaming costs.

A screenshot of the landing page.

Europe SIM's Management Tool

We would receive batches of CSV spreadsheets from a SIM card supplier and these spreadsheets would contain hundreds of SIM numbers. Often we needed to check if customers that were requesting top-ups were in fact from our batch. As a SIM that wasn't registered to us, we would lose any top-up bonus. Before we had to search through many separate CSV sheets just to lookup phone numbers. This is very time consuming!

So I made a tool that allowed us to upload the CSVs straight from the supplier and store them in a SQLite3 database. We now could lookup batches of numbers or individual numbers to see if they were indeed our SIM cards!

A screenshot of the dashboard where you can lookup or add the CSV spreadsheet.

Full Screenshot

Full page screenshot of SIM Cards London, which was used before Europe SIMs.