Technical Contributions to MySkiTool

This page showcases the code I've written for the MySkiTool business, along with its corresponding output

Here is a brief explanation of my work:

My responsibility was to facilitate users in purchasing videos of their waterski lessons. I worked with two applications to establish the video sales platform: Shopify and FileFlare. Shopify serves as the front-end platform where users can access an online store, search for their desired videos, and make purchases. FileFlare functions as the back-end component, storing the links to the videos that become available to users upon purchase. Both Shopify and FileFlare require CSV files for importing data, albeit with differing information and formats.

I developed two PHP scripts to populate a shopify and fileflare table with the required data. These tables are subsequently converted into CSV files and imported into Shopify/FileFlare. Additionally, I enhanced functionality by creating two SQL functions: 'extractLake()' and 'extractSkierName()'. 'extractLake()' extracts the lake where the videos were filmed from a field in the items table, while 'extractSkierName()' extracts the name of the skier from another field in the items Table.

To view the SQL tables created for Shopify and Fileflare, please click on their respective links at the bottom of the page. (I recommend opening the files with Google Sheets, Excel, or a similar app to preserve the formatting).

To view the Shopify store, visit https://shop.myskitool.com.