Shopify Operations for Multi-Location Health and Wellness Retail Store

How a health and wellness retailer connected forecasting, purchasing, transfers, stock adjustments, expiry tracking, and daily store operations.
Free Demo/Setup
Book a call and let us set up AnyDB for you. Free of charge!
  • Company

    Health and wellness retailer

  • Team

    1–10 employees

  • Industry

    E-commerce and retail operations

  • Scale

    2,000 SKUs, hundreds of suppliers, and two locations

This Toronto-based retailer offers healthier food, snacks, home goods, wellness essentials, and café products through Shopify and two retail locations.

Its catalog includes around 2,000 SKUs, with many products requiring close attention to stock availability, suppliers, ingredients, quality, and expiry dates.

The team relied on Stocky for purchase orders, transfers, stock adjustments, sales-based forecasting, and suggested ordering. Expiry tracking and shift handoffs remained in separate tools.

Result: One Shopify-connected system for stock control, forecasting, purchasing, transfers, expiry dates, vendors, reporting, and daily retail operations.

Operational Objective

Replace Stocky with a customizable system that connects Shopify inventory with the workflows behind daily retail operations.

In practice, that meant:

  • Preserve purchase orders, transfers, and stock adjustments
  • Track around 2,000 SKUs across two retail locations
  • Support sales-based forecasting and suggested ordering
  • Identify low-stock products and vendor reorder needs
  • Manage purchasing across hundreds of suppliers
  • Track expiry dates for food products and café goods
  • Connect Shopify data with reporting and local delivery workflows
  • Expand into broader store operations over time

What They Tried at First

The company used Shopify with Stocky to manage purchase orders, stock transfers, stock adjustments, sales-based forecasting, and suggested orders based on sales and low-stock products.

Stocky remained important to daily operations, and its discontinuation created an immediate need for a replacement. The company also used a separate tool for expiry tracking, leaving essential food inventory information outside its main stock workflows.

The team evaluated other inventory and retail management systems, including options priced around $600 per month. These alternatives were too expensive, too rigid, or poorly aligned with how the two stores operated.

Where the Operation Broke Down

Stock, purchasing, expiry dates, reporting, and store communication depended on separate tools and manual coordination.

What broke?

  • Expiry dates were managed outside Shopify and Stocky
  • Multiple expiry dates lacked clear product-level visibility
  • Shift handoffs and daily reporting relied on Excel sheets
  • Stock and expiry information lived in separate systems
  • Purchasing and transfer workflows needed more flexible logic

Operational Impact

  • Store teams checked multiple places for inventory information
  • Stock, expiry dates, and transfers required extra coordination
  • Perishable inventory needed stronger expiry control
  • Purchasing was harder to manage consistently across suppliers
  • Daily reporting remained disconnected from store operations

The Operating Model Designed in AnyDB

A Shopify-connected system where inventory data drives purchasing, transfers, expiry tracking, and daily store operations.

Shopify-connected stock management

Products, inventory levels, locations, and order activity connect with operational workflows, giving the team one structure for managing stock across both stores.

Forecasting and suggested ordering

Sales and stock activity help identify low-stock products, vendor reorder needs, and purchase orders that should be created. Ordering logic can evolve with the business.

Expiry dates inside product workflows

Product records include expiry dates, alerts, and perishable inventory details, giving the team clearer visibility without maintaining a separate expiry tracking tool.

Connected purchasing and suppliers

Purchase orders connect suppliers, products, quantities, statuses, and receiving activity, making purchasing easier to manage across hundreds of vendors.

Traceable transfers and adjustments

Location-based quantities, transfers, and stock adjustments stay connected, giving teams a clear record of what changed, where products moved, and why.

What Changed in Daily Work?

  • Store teams manage inventory through a flexible Shopify-connected system
  • Purchase orders connect products, suppliers, quantities, and receiving
  • Transfers between both locations are easier to track
  • Stock adjustments stay attached to the same operational records
  • Sales and stock data support forecasting and suggested ordering
  • Food products and café goods include expiry date visibility
  • Daily reporting and shift handoffs can move out of Excel
  • The system can expand into local delivery and broader store operations

Operational Outcomes

Inventory, purchasing, transfers, expiry dates, and reporting connected in one system

Stronger visibility into perishable inventory and product expiry dates

Clearer purchase order workflows across hundreds of suppliers

More structured and traceable transfers between both retail locations

Reduced reliance on Excel for daily reporting and shift handoffs

Better alignment between Shopify data and internal store operations

Result: Stock, expiry tracking, purchasing, transfers, reporting, and communication move toward one connected operational system around Shopify.

Why This Works and Scales

The company can begin with the Stocky workflows that matter most and expand the same connected structure as its retail operations evolve.

  • Sales and stock activity support forecasting and suggested ordering
  • Purchase orders stay connected to suppliers, products, and receiving
  • Expiry and transfer logic can adapt to changing store requirements
  • Additional locations, products, suppliers, and operational users can be added
  • Reporting, handoffs, local delivery, and internal workflows can use the same system

Run Shopify Operations From One Connected System

Manage stock control, purchase orders, transfers, stock adjustments, expiry tracking, and store operations with AnyDB