Website Development for a Wine & Spirit Wholesale Platform

A website for a US-based organization that sells imported wines and spirits to retailers and restaurants around the country and provides expert reviews, cocktail recipes, and pairing tips.

SolutionsDevelopment
Technologies
Ajax, Drupal 8, HTML5, Jenkins, JQuery, MySQL, Redis
Country United States

Challenge

The client has already had a website that missed half of the essential functionality, showed very poor performance, and had major issues with data storage and processing. Therefore, we were required to fix all the issues on the existing website before we could start the development of the requested new features. Our main priorities were to rework the geolocation system and the wholesale network databases, optimize the codebase to improve the website’s overall performance, and create the tools necessary for efficient administration and convenient product browsing.

Project Duration

2 months

Team Composition

Developer – 1

Solutions

To create a future-proof, high-performing website, we chose to rebuild it using mobile responsive design as well as Drupal 8 and HTML5 as our main technologies. First thing we did was rework the very architecture of data processing and set up continuous deployment using Jenkins.

Considering it’s a very content-heavy, database-driven website, we needed it to be able to process huge amounts of data without suffering any performance issues or downtime. To achieve that goal, we chose MySQL that works perfectly with Drupal and boasts time-proven reliability. We also used Varnish for external data caching and Redis as our internal data solution. We further improved the website’s usability and performance with Ajax and jQuery.

We integrated the distribution and manufacturers geolocation system with Google Maps and automated it to update databases once a month while leaving the option to manually choose data entries and control the process. We also created an advanced browsing system with intuitive filters and powerful sorting tools for easy and enjoyable browsing through a massive range of imported goods.

Results

By means of thorough planning and well-established development processes, our Drupal development team has successfully delivered on the client’s requirements despite the tight terms. We optimized the existing codebase, fixed all the data processing issues, and significantly improved the overall performance of the platform. We also equipped the platform with powerful systems and tools that ensure great usability for both the platform owners and their clients. Now the retailers and restaurants around the U.S. can easily access a remarkable network of wholesale companies and comfortably choose from a comprehensive portfolio of imported wines and spirits with all the related information, reviews, and expert advice.

87%

Satisfaction rate

57%

Conversion of mobile app

7%

Bounce rate decrease

Related projects

View all

We Help With

Your tech partner needs to be well versed in all kinds of software-related services. As the software development process involves different stages and cycles, the most natural solution is to have them all performed by the same team of experts. That’s exactly what our diverse range of services is for.

The choice of technology for your software project is one of the defining factors of its success. Here at QArea, we have hands-on experience with dozens of popular front-end, back-end, and mobile technologies for creating robust software solutions.

In-depth familiarity and practical experience with key technologies are one of the cornerstones of successful software development and QA. But it also takes specific knowledge of the industry to develop a solution that meets the expectations of the stakeholders and propels its owner to success.

Services

Technologies

Industries