Mattress Warehouse, a large mattress retailer with hundreds of brick‑and‑mortar locations, needed its digital systems to keep pace with modern ecommerce and in‑store expectations. The company’s existing Shopify store was poorly aligned with its STORIS ERP data, creating catalog inconsistencies, brittle integrations, and a frustrating product discovery experience for shoppers and staff.
Endertech partnered with Mattress Warehouse to redesign and reengineer their entire ecommerce stack: a new headless Shopify Hydrogen storefront, a custom middleware layer that bridges Shopify and STORIS, and an in‑store tablet Sales Rep App that ties store‑floor consultations directly into the online channel and marketing systems.
Headless Shopify Hydrogen storefront for Mattress Warehouse, backed by a custom middleware bridge to STORIS.
Client Context
Mattress Warehouse operates a large physical retail footprint, with 300+ stores and a catalog of thousands of SKUs (5,000+ SKUs referenced in prior portfolio materials). The business depends on accurate product information, inventory visibility, and smooth coordination between in‑store consultations and online purchasing.
Their operational backbone is STORIS, an ERP used for product data, inventory, pricing, orders, and fulfillment across locations. Prior to this engagement, Mattress Warehouse also ran a Shopify store, but the implementation was not robust enough to serve as a reliable ecommerce hub for such a complex operation.
The Challenge
When Mattress Warehouse first approached Endertech, the primary ask was to integrate their existing Shopify store with their STORIS backend. Early discovery quickly revealed deeper structural problems that made a simple integration risky and fragile:
Catalog and SKU mismatches: SKUs in Shopify did not reliably match STORIS SKUs, causing sync errors, incorrect listings, and manual work for the client’s team.
Weak product metadata: Product metafields and standardized product types were not consistently defined, limiting filtering, search, and guided selling opportunities.
Disconnected systems: Inventory, pricing, orders, and fulfillment needed to stay in sync across hundreds of stores and Shopify, but there was no robust middleware or queueing strategy to manage this complexity.
Underperforming frontend: The legacy storefront suffered from poor product discovery, performance issues, and accessibility and Core Web Vitals problems documented in Lighthouse tasks.
Marketing constraints: The team needed a more flexible content and landing page system via a headless CMS, rather than being locked into rigid theme templates.
In‑store workflow gaps: Store associates lacked a dedicated, integrated tablet app for capturing leads, building carts, and pushing data into STORIS and the online channel.
The Opportunity
Solving these issues offered Mattress Warehouse the chance to create a strong, unified digital foundation:
A single, reliable source of truth for product and catalog data between STORIS and Shopify.
Improved product discovery through rich metafields, standardized types, and better PLP/PDP experiences.
More accurate inventory, pricing, and order flows across ecommerce and 300+ physical locations.
Faster, more flexible marketing capabilities through a headless CMS and Hydrogen‑based frontend.
An in‑store Sales Rep App that connects showroom interactions, BedMatch consultations, and follow‑up reminders directly to the ecommerce channel.
Endertech’s Role
Endertech served as Mattress Warehouse’s strategic technical partner for:
Re‑architecting the ecommerce stack around a headless Shopify Hydrogen storefront.
Designing and building a middleware / CMS bridge that normalizes STORIS data and feeds Shopify.
Developing an in‑store Sales Rep App (RSA) for tablets, deeply integrated with Shopify, STORIS, and marketing tools.
Ongoing maintenance and enhancement of both the website and Sales Rep App over multiple years.
Our Approach
1. Middleware & Catalog Normalization
Instead of trying to force a direct, brittle connection between STORIS and the old Shopify implementation, Endertech designed a dedicated Middleware / CMS Bridge layer. This middleware became the canonical manager of product and catalog data and the central integration point between STORIS, Shopify, and the headless CMS.
Key elements included:
STORIS product import: Middleware tasks such as “The Middleware / CMS Bridge can Import a Product from STORIS” defined robust import flows to pull ERP data into a normalized model.
Metafield and product type modeling: A substantial Metafields epic established standardized metafields (e.g., available to try in‑store, best seller flags) and standardized product types, aligning ERP data with the needs of modern filtering and search.
Admin import queues & review tools: The middleware exposes list views for items queued for import, ignored SKUs, and manual actions like “Create Product on Queued for Import.” This gives Mattress Warehouse staff control to review and reconcile catalog entries before they become live Shopify products.
Complex update rules: Middleware rules handle variant creation, status codes, and nuanced behaviors around when to update, ignore, or archive products based on ERP signals.
2. Headless Shopify Hydrogen Storefront
On top of this normalized catalog, Endertech delivered a headless storefront built with Shopify Hydrogen, React, Tailwind CSS, and Flowbite. Hydrogen 2 migration epics show how existing pages and components were converted to the newer Hydrogen app structure, improving performance and maintainability.
The frontend work focused on:
Modern PLP and PDP experiences: Enhanced product listing and detail pages, driven by rich metafields, enabling better filters, highlights (e.g., “Available to Try”), and merchandising.
Improved performance and accessibility: Dedicated tasks addressed Lighthouse accessibility issues and key Core Web Vitals metrics, including CLS improvements on both PLP and PDP.
Headless CMS integration: A Contentful integration supports both preview and published modes, enabling marketing teams to create and preview content‑driven pages and campaigns without developer intervention.
Hydrogen PDP leveraging normalized metafields for richer product storytelling and guided selection.
3. In‑Store Sales Rep App for Omnichannel Workflows
Parallel to the ecommerce rebuild, Endertech implemented an in‑store Sales Rep App (RSA) to support sales associates on the showroom floor. This tablet‑optimized app connects in‑person consultations with the online shopping journey.
Capabilities include:
Draft Orders & carts: Sales reps can browse the normalized catalog, add products to Draft Orders, and adjust carts during in‑person consultations.
Quote creation in STORIS: Middleware endpoints allow the app to create STORIS quotes directly from these Draft Orders, tying store visits into the ERP and later fulfillment.
Lead capture & reminders: The app supports capturing customer contact details and sending follow‑up reminders via email and SMS, implemented with careful attention to double opt‑in and responsible messaging via providers such as Twilio and Klaviyo.
BedMatch integration: The RSA integrates Mattress Warehouse’s BedMatch profile system, including local entities, profile search, product import and matching, and UI elements to present personalized recommendations and favorites.
4. Order, Fulfillment & Reviews Integrations
Beyond catalog and storefront, Endertech implemented and refined a range of supporting integrations and edge‑case flows:
Order and fulfillment sync: Middleware logic coordinates order insert behaviors, deposit handling, warranty line items, and partially fulfilled orders, aligning Shopify’s model with STORIS workflows.
Inventory and pricing synchronization: Tasks ensure regular updates of inventory and price data from STORIS into the middleware and then into Shopify, reducing mismatch risk across locations.
Reviews and third‑party data: PowerReviews feeds and product ID migrations were implemented to carry forward existing reviews into the new Shopify product IDs.
Category listing page showing thousands of SKUs organized through normalized product types and metafields.
Complexity Handled
This engagement went far beyond a visual redesign. Endertech successfully navigated:
ERP data normalization: Mapping STORIS product data to Shopify‑friendly metafields and standardized product types across thousands of SKUs.
Middleware orchestration: Building import queues, ignored SKU workflows, variant creation routines, and update rules keyed to ERP status codes.
Headless migration: Converting the site to a Hydrogen‑based headless architecture, including multiple page types and server components.
Omnichannel workflows: Creating the Sales Rep App with Draft Orders, quote insertion, BedMatch integration, and reminder flows that bridge store visits and online purchases.
Performance & accessibility: Systematic remediation of Lighthouse issues and Core Web Vitals problems on key ecommerce pages.
Complex fulfillment logic: Handling deposits, warranties, and partial fulfillment states consistently between Shopify, middleware, and STORIS.
Results & Business Impact
Since adopting the new headless ecommerce platform, middleware integration, and in‑store Sales Rep App, Mattress Warehouse has seen substantial growth in its online channel compared to its previous site. While specific revenue figures are confidential, the client has reported that online sales today are significantly higher than before Endertech took over the platform.
Beyond revenue, the project delivered several durable operational and customer‑experience benefits:
Higher catalog quality: Systematic metafield definitions and standardized product types improved product discovery, filtering, and internal catalog management.
Reliable data synchronization: Inventory, pricing, orders, and fulfillment now flow more predictably between Shopify and STORIS, reducing manual reconciliation.
More flexible marketing: Contentful‑powered pages and Hydrogen’s component architecture give marketing teams greater control over landing pages and campaigns.
Improved customer experience: Faster, more accessible PLPs and PDPs, combined with reviews and recommendation tools like BedMatch, support more confident buying decisions.
Stronger omnichannel connection: The Sales Rep App ties showroom interactions, quotes, and reminders into Shopify and STORIS, helping store associates support customers throughout their buying journey.
Stable platform for ongoing improvement: With clear separation between middleware, storefront, and CMS, Mattress Warehouse and Endertech can continue to extend and refine the system over time.
Why This Work Matters
This project demonstrates how Endertech helps large, multi‑location retailers move beyond basic ecommerce themes to a purpose‑built digital platform shaped around real operational complexity. By combining ERP integration, catalog normalization, headless storefront development, and in‑store tooling, we helped Mattress Warehouse create a scalable foundation for future growth.
For organizations facing similar challenges—messy ERP data, underperforming ecommerce, and disjointed in‑store workflows—this case shows that a carefully designed middleware layer and headless architecture can turn complexity into a competitive advantage.
Related Services & Technologies
Services: Ecommerce development, custom middleware and systems integration, headless Shopify development, API design, in‑store app development, performance and accessibility optimization, ongoing support and enhancements.
Technologies: Shopify & Shopify Hydrogen, React, Tailwind CSS, Flowbite, Contentful, STORIS, custom Node/TypeScript middleware, integrations with PowerReviews, BedMatch, Twilio, Klaviyo, and other marketing and messaging tools.
Planning a Similar Project?
If you operate a complex retail or ecommerce business and are struggling with disconnected systems, catalog quality issues, or underperforming customer experiences, Endertech can help. We design and build headless ecommerce platforms, middleware integrations, and in‑store tools that turn fragmented workflows into a cohesive digital ecosystem.