SBartsch Logo

Home / Portfolio / Programming

Lumber Slideshow

About

Lumber prices fluctuate frequently, and the hardware store previously updated them manually in both the point-of-sale system and a spreadsheet, which was displayed on a customer-facing kiosk. This manual process often led to pricing errors. I developed a streamlined solution: pricing is now exported directly from the point-of-sale system, while a user-uploaded spreadsheet automatically updates the slideshow without manual input.

Features

  • Publicly displays up-to-date lumber prices for customers.
  • Effortlessly upload an auto-generated spreadsheet through a secure webpage form.
  • Version 2 supports file submissions via custom software integrated with the Google API.
  • The web server automatically generates and updates slideshow images using custom templates.
  • Currently in use across two kiosks.
  • Includes software update capabilities with forced updates when necessary.

Languages

HTML CSS Javascript PHP

Data/Database

Excel JSON MySQL

Framework

WordPress slideshow-gallery-plugin spreadsheet-reader html2canvas

API

Google