In this captivating case study, we delve into the dynamic and enduring relationship between Hansen Wholesale, a thriving online retailer based in the United States, and Sigma Infosolutions, a leading provider of eCommerce solutions. 

Over the past seven years, we have not only weathered challenges but also harnessed the power of collaboration, innovation, and strategic thinking to achieve remarkable growth in the ever-evolving landscape of eCommerce. Initially, the client had been working with a US agency for their eCommerce needs. However, they were not entirely satisfied with the services provided and decided it was time for a change. They embarked on a journey to find a new partner, eventually settling on an offshore agency that showed promise and potential.

This case study takes you on a journey, revealing the key factors that have contributed to our long and trusted partnership while highlighting shared successes and a commitment to driving sustainable growth.

Client Background

Hansen Wholesale, an established and esteemed online retailer, specializes in an extensive range of home decor products, ranging from exquisite lighting fixtures to elegant ceiling fans and fireplace accessories. With a diverse customer base and dedication to delivering exceptional service, Hansen Wholesale set out to expand its online presence and elevate the overall customer experience. Howeve’r, they faced numerous challenges due to their outdated Magento 1 platform, including security concerns, limited feature enhancements, and suboptimal hosting solutions.

Initial Engagement

Recognizing the imminent end of life for Magento 1 and the associated hurdles faced by Hansen Wholesale, Sigma seized the opportunity to form a partnership aimed at addressing these pain points head-on. Our shared vision and commitment to excellence paved the way for an ambitious undertaking: migrating the client’s eCommerce platform to the robust and cutting-edge Magento 2. The initial goals were clear: to enhance search functionality, optimize hosting solutions, and integrate a marketing automation system, among other critical requirements.

Tailored Solution Implementation

Drawing on expertise and unwavering dedication, our Adobe-certified experts embarked on a journey of customization to meet the specific needs of Hansen Wholesale. By developing a custom tab and attribute set system, we ensured seamless management and presentation of product information. The implementation of Ajax Wishlist and Ajax Compare features elevated the user experience to new heights, while custom inventory sync with third-party vendors streamlined operations. Additionally, our team crafted a customized bundle product list, transformed subcategory pages into captivating landing pages, and meticulously tailored a theme that harmonized with Hansen Wholesale’s unique brand identity.

Ongoing Support and Optimization

At Sigma Infosolutions, our commitment to deliver to the client extends far beyond the initial implementation. Our eCommerce experts provided outstanding support and maintenance to ensure optimal performance and sustained growth for Hansen Wholesale. Proactive monitoring, troubleshooting, and meticulous scalability planning became second nature. Leveraging Magento 2’s advanced security features; we safeguarded the platform against threats while optimizing the hosting infrastructure to ensure seamless operations even during periods of high traffic. By implementing master-slave database technology, we alleviated the strain on servers, offering a consistently smooth customer experience.

Innovation and Expansion

Innovation is the lifeblood of eCommerce success, and Sigma embraced this truth wholeheartedly. Leveraging our extensive knowledge of the eCommerce ecosystem and numerous strategic partnerships, we confidently recommended Hansen Wholesale the ideal vendor for the hosting and search functionalities, perfectly aligned with their business requirements. We elevated the search functionality of Hansen Wholesale’s website by integrating the powerful Mirasvit Magento 2 Elasticsearch. This enhancement ensured lightning-fast, precise search results, empowering customers to find their desired products effortlessly. Recognizing the power of marketing automation, we seamlessly integrated Klaviyo, a cutting-edge marketing automation system. This integration brought forth a surge in sales and customer engagement, thanks to tailored campaigns and personalized experiences. Also, by skillfully bridging the gap between Hansen Wholesale’s Magento platform and their Netsuite ERP system, our expert team synchronized product and shipping information, fostering streamlined operations and efficient data transfer. With our customized modules, we empowered Hansen Wholesale to scale its operations and achieve sustainable growth in the competitive online market.

Measurable Results and Achievements

Performance of Hansen Wholesale

The partnership between Sigma and Hansen Wholesale yielded tangible and compelling results. The migration to Magento 2 instilled a renewed sense of security, as the platform boasts comprehensive security features, providing peace of mind for Hansen Wholesale and its customers. The improved website performance and streamlined checkout process elevated the overall customer experience, fostering loyalty and trust. Harnessing the power of master-slave database technology enabled Sigma to tackle heavy traffic periods with ease, ensuring a consistently smooth shopping experience. With Klaviyo’s integration, Hansen Wholesale witnessed a remarkable 12% increase in average order value over a two-year period. The enhanced search functionality propelled conversion rates skyward while providing customers with faster, more accurate results. Furthermore, by seamlessly integrating Netsuite ERP with Magento, Sigma enabled accurate product availability information, empowering customers to make informed purchasing decisions.


Trust and collaboration form the foundation of the strong and enduring partnership between Sigma and Hansen Wholesale. Both companies prioritize open lines of communication, transparent decision-making processes, and joint problem-solving. This proactive communication approach with daily & weekly updates and taking full ownership including deliverables and dependencies with the other partner ecosystem strengthens our relationship and allows for effective collaboration on various projects. By profoundly understanding Hansen Wholesale’s specific needs and challenges, Sigma builds trust and credibility, enabling them to provide tailor-made solutions that go beyond expectations. This level of trust fosters a productive and mutually beneficial partnership, ensuring that Sigma continues to deliver exceptional results for Hansen Wholesale.


In the dynamic and ever-evolving eCommerce landscape, the partnership between Sigma and Hansen Wholesale serves as a catalyst for exploration, innovation, and growth. Both companies share a common vision and commitment to continuously push boundaries and adapt to emerging trends and technologies. With a collaborative mindset, we aim to uncover new opportunities and overcome future challenges together. The primary focus remains on driving sustainable growth, enriching the customer experience, and staying ahead in the highly competitive eCommerce industry. By leveraging Sigma’s expertise in PIM integration to enhance operational efficiency, new mobile-friendly payment gateway integration i.e. Apple Pay, and a culture of continuous improvement & Magento version upgrade, Hansen Wholesale strives to stay at the forefront of eCommerce innovation.

Tools & Technologies

Get in touch with us, let's create value together.

Connect with us