Built an Online Store Supporting Over 100,000 Product SKUs for This E-Commerce Brand in WooCommerce

About RHR Swag

RHR Swag® is a truck products and accessories company known for selling popular brands like Access, Adarac, Fia, Leer, Lomax, Putco, and Shocker Hitch. With an estimated revenue of over $10 million and a team of around 40 employees, the company stands out for its diverse range of high-quality truck accessories.

Goal

• Optimize site speed by addressing the impact of large datasets across products and categories to enhance overall performance.
• Efficiently manage the Year Make Model (YMM) feature for over 100,000 SKU variations to ensure accurate price ranges are displayed on each product listing page.
• Streamline a complex environment involving multiple third-party integrations, vendors, and brands to ensure optimal performance on a high-performance enterprise-grade hosting platform.
• Strategically maintain RHRSwag and other small eCommerce stores to ensure continuous operation and stability.
• Consolidate data from all sites into a single multisite network by overcoming the limitations of conventional migration methods to ensure a unified platform.
• Minimize downtime during the migration of the e-commerce network to accommodate high daily traffic and maintain uninterrupted service.

Solution

• Extended WooCommerce custom product types, enabling each YMM product to handle over 5,000 variations and improve accuracy in ad targeting.
• Migrated the system to WP VIP hosting to efficiently manage complex queries across 100,000 product variations and allow for seamless product portfolio expansion.
• Simplified product management by configuring the YMM product type to function similarly to the WooCommerce standard variable product.
• Developed a custom migration strategy to consolidate all WooCommerce stores into a single multisite network.
• Enhanced site performance and stability by leveraging the strengths of WP VIP hosting, ensuring the website could handle high traffic volumes and complex operations with ease.

Results

The collaboration between RHR Swag and Multidots yielded remarkable outcomes. The average page load speed improved by 30%, significantly enhancing the user experience. The website saw a 58x increase in traffic, a 42% decrease in bounce rate, and a 145% boost in conversion rates. Additionally, website sales skyrocketed, increasing by 80 times. These impressive results were achieved by optimizing the site for over 100,000 SKUs, streamlining complex queries, and ensuring the site could efficiently handle the high volume of daily traffic.