"Having worked with many agencies in the digital sector over the past 10+ years, it's fair to say the relationship we have with The Pixel is one of the longest standing. This in itself is testament to their work quality and ethic, especially given the high growth of our business and the high expectations we place on any company we partner with. They are absolutely an asset to our business and a genuine "partner" in all ways we would hope for. The Pixel go above and beyond to do what's right and deliver the best possible outcome of a project or piece of work and customer satisfaction is clearly of utmost importance to them."


ADAM ROSSITER, FOUNDER & MANAGING DIRECTOR Bulk Powders

Project Results

32%
INCREASE IN PAGE LOAD SPEED
17.4%
INCREASE IN CONVERSIONS RATE

The task at hand...

Website migration

In 2018 the BULK POWDERS website underwent a major migration on to the latest version of the Magento ecommerce platform. The migration from Magento 1 to Magento 2 saw the website go through a vast transition of data and design.

The migration path consisted of 4 processes: Data Migration, Extensions, Themes, Customisations. For the data migration, the deployment of an Extraction, Transformation, Loading (ETL) process was performed to migrate settings of the original website, and all data and tables.

Delta Migration was used post data migration. This ensured that the data could be transferred incrementally and did not need to be performed whilst offline. The Delta Migration bridged the gap between the last data import and any new data that has been generated. I.e. only different data was then migrated (new orders, or customers, or product updates) between the newly built site and the original, live site. This allowed the active site to remain fully functional, whilst ensuring the development site was fully up to date at all times, ready to be launched without significant downtime necessary - avoiding hours of offline time.

What data to migrate was decided beforehand. Questions asked were: should we bring all of the data or just parts of the data? If so which parts? Based on creation date or product, customer or order? Should we clean the data at source or at destination? It was a brilliant opportunity to spring clean the client’s databases, and ensure that redundancy was reduced and relevance increased before transferring to the brand new site. With the help of The Pixel, BULK POWDERS successfully completed the transfer of tens of millions of records migrated from Magento 1 to Magento 2.

All existing Magento 1 themes (design) were refactored and rewritten from scratch to accommodate the Magento 2 platform. This also ensured that all themes were updated and built to the latest best practice, with an increase in speed performance, greater adherence to Google’s requirements and an overall increase in customer usability. All ERP integrations were also re-evaluated and regenerated for Magento 2 using The Pixel’s own ERP connector.

Overall, BULK POWDERS has seen a strong YoY (2017 - 2018) shift of conversions and page load since migrating to Magento 2. Page load time has decreased by -32% (from 9.12 to 6.2 sec) and conversion rate has increased in the UK by +17.4%. Internationally, the biggest changes in conversion rate have been in France (+17.58%) and Italy (+21.67%).

Deployment to Cloud

This year the BULK POWDERS website underwent a full migration to the Magento Commerce Cloud environment. Magento Cloud, launched in 2016, is a Platform-as-a-Service (PaaS) environment designed specifically for Magento 2 and runs on Amazon Web Services (AWS). It’s been built and designed to power innovative ecommerce websites.

One of the main advantages of Magento Cloud is its fully customisable, secure and scalable storefronts. BULK POWDERS now has the ability to offer highly differentiated customer experiences, simplified integration with their existing systems and the ability to respond rapidly to changing technology.

With the platform running on AWS, it ensures that the website has the agility to respond to a rapidly changing environment, continuously deploy innovations, and easily scale to meet unexpected demand. For example, the BULK POWDERS M2 cloud infrastructure has allowed the company to cater for significant peaks and bursts in traffic, keeping performance constant throughout, providing a fast experience regardless of visitor volume.

BULK POWDERS now benefits from a 32% (UK) increase in site speed during peak traffic periods.

Magento Cloud capabilities and flexibility has allowed BULK POWDERS to greatly reduce the implementation costs, compared to a multitenant SaaS (Software-as-a-Service) solutions (a single instance of software running on a server with multiple users). This is because much of the tailoring required with a SaaS Magento set-up is no longer required with the new PaaS cloud system.

The benefits of BULK POWDERS using the Cloud are numerous: scalability, high resilience, PCI compliance, global availability, automated patching. But in addition to this, using Magento’s already successful and established architecture (and global system of partners and developers) makes it a tried and tested, limited-risk venture.

Success: Largest Sports Supplement Retailer

Over the last year BULK POWDERS has expanded its operations to over 13 different countries. This global expansion resulted in revenue of £35m in 2017 (2015 the turnover was £10m) and is forecast to reach £100m by the end of 2018. The company’s success last year saw it placed No. 34 in The 2017 Sunday Times Virgin Fast Track 100. Very soon BULK POWDERS will be launching in America.

Technical & Functional Achievements

It was imperative when migrating from Magento 1 to Magento 2 that a new range of features to improve the success and functionality of the website were installed. The main challenge faced was to ensure that the new website worked seamlessly with the current order management system Sage 200. Magento needed to talk directly to Sage 200 if full order management and control of operations during a website migration was to be successful. Complex product stock inventory settings were integrated with Magento to ensure operational success. We used The Pixel Magento ERP Connector to achieve this.

Some of the technical and functional achievements of the new website:

  • Full migration from Magento 1 to Magento 2

  • Hosted in the Magento Cloud environment

  • Klarna Checkout

  • SLI Search

  • Import of all data from one of Europe’s biggers sports supplements brands, with tens of millions of records

  • Interactive AJAX Add to Cart features offers seamless browsing without page loads

  • Refined options for category pages using AJAX for super fast updates and multiple product options

  • Full integration into Sage 200 for comprehensive order management

  • Magento Commerce Rewards System

  • Enhanced Grouped Products

  • Complex product stock inventory settings integrated directly into Magento


BULK POWDERS Magento 2 Migration & Relaunch