Project Description
In late 2016, a client I had worked extensively with approached me for a vinyl brokerage he was opening. As we talked through the website features and the overall potential of the business, we were both full of ideas and excitement, and ended up partnering to create Merchant Vinyl.
Through our experiences playing in bands, we knew that vinyl was both expensive and extremely complicated to produce. Our goal was to take the complexity and create a company that made the process easy and accessible, and through automating processes and keeping expenses low, we hoped to lower the cost to the buyer and make vinyl accessible to smaller artists.
I spent the following months branding Merchant Vinyl. Initially creating a MVP that could serve as a site where new customers could submit their order information for quotes, and get their artwork templates and forms needed for submission.
Custom Quoting System
The biggest challenge we found was how to quote each order. There were endless combinations of record colours, packaging types, paper stocks, and other small details. Our supplier's pricing system had thousands of variations all with different conditions. Due to the complexity, we had to email our supplier for each quote, who in turn crunched the numbers and generated a quote, usually meaning days of delay.
There had to be a better way?!. Over a few weeks, using PHP, MySQL, Ajax, and thousands of lines of conditional code, I developed a system that took all quote parameters into account, and instantly generated the cost, recommended a price and profit margin, and when finalized, genearted a branded PDF with a quote and price breakdown. Now when a user submitted a quote, we had it back to them almost instantly.
This turned a process that took days into one that took minutes, and we were able to properly track all incoming quotes for proper followups.
Download Codes
Another inital headache we had was paying for digital downloads that come with the records, and then paying to host them. Within a week, I developed a system where we could upload music, artwork, and select how many codes we'd like to generate. Cards would be included with each record, and then could be redeemed on an area of the website, with trackable analystics on how many were redeemed.