Skip to main content

​
Store Business Unit

Status: Documentation Complete ✅
Owner: Jeff Liu
Shopify Store: y0nrcb-2y.myshopify.com
Domain: trendingsociety.com

​
What Store Does

Store is the e-commerce layer - physical products, digital products, and affiliate offerings tied to content verticals. Inventory-free commerce through dropship partners with automated fulfillment routing. 
┌─────────────────────────────────────────────────────────────────────────┐
│                          STORE ARCHITECTURE                              │
├─────────────────────────────────────────────────────────────────────────┤
│                                                                          │
│   TRAFFIC SOURCES                                                        │
│   ┌──────────┐  ┌──────────┐  ┌──────────┐  ┌──────────┐               │
│   │Publisher │  │  Paid    │  │  Social  │  │  Direct  │               │
│   │ Content  │  │   Ads    │  │  Media   │  │ Traffic  │               │
│   └────┬─────┘  └────┬─────┘  └────┬─────┘  └────┬─────┘               │
│        └─────────────┴─────────────┴─────────────┘                      │
│                              │                                           │
│                              ▼                                           │
│   ┌─────────────────────────────────────────────────────────────────┐   │
│   │                    TRENDINGSOCIETY.COM                           │   │
│   │                    (Shopify Storefront)                          │   │
│   │                                                                  │   │
│   │   Vertical Collections → Product Pages → Cart → Checkout        │   │
│   └─────────────────────────────────────────────────────────────────┘   │
│                              │                                           │
│              ┌───────────────┼───────────────┬───────────────┐          │
│              ▼               ▼               ▼               ▼          │
│   ┌──────────────┐  ┌──────────────┐  ┌──────────────┐  ┌─────────┐    │
│   │   SUPLIFUL   │  │  COLLECTIVE  │  │   DIGITAL    │  │ MANUAL  │    │
│   │  White-label │  │   Curated    │  │   Products   │  │ Custom  │    │
│   │  40-60% margin│ │  15-30%      │  │   90%+       │  │ varies  │    │
│   └──────────────┘  └──────────────┘  └──────────────┘  └─────────┘    │
│                                                                          │
└─────────────────────────────────────────────────────────────────────────┘

​
Revenue Streams

SourceModelMarginBest For
SuplifulWhite-label dropship40-60%Supplements, wellness, CBD
Shopify CollectiveCurated products15-30%Trending products, apparel
Digital ProductsInstant delivery90%+Courses, templates, guides
AffiliateCommission5-15%External products (via Publisher)

​
How Store Uses the Intelligence Layer

Store connects products to content for attribution and recommendations.
Intelligence FeatureStore Use Case
Content AnalysisMatch products to content topics
Audience ProfilesProduct recommendations by user
WTP ScoringDynamic pricing/discounts
Micro-SegmentationCollection personalization
AttributionTrack revenue source (which post/campaign)

​
Key Tables

TablePurpose
shopify_productsProduct catalog mirror with enrichment
shopify_ordersOrder records with attribution
shopify_customersCustomer records linked to audience profiles
shopify_fulfillmentsShopify fulfillment tracking
vertical_collectionsProducts grouped by content vertical
product_collectionsProduct ↔ collection relationships
post_product_recommendationsContent → product matching
supliful_productsSupliful-specific product data
supliful_fulfillmentsSupliful order tracking
collective_productsCollective-specific product data
digital_productsDigital product configuration
digital_deliveriesDigital product delivery tracking
order_fulfillmentsUnified fulfillment records
fulfillment_eventsTracking event log
fulfillment_notificationsCustomer notification log

​
Deep-Dive Documentation

DocumentPurpose
shopify-sync.mdProduct/order synchronization, webhooks, inventory
dropship-network.mdSupliful, Collective, digital product integration
vertical-collections.mdProduct-content matching, smart collections
fulfillment.mdOrder routing, tracking, customer notifications

​
Key Workflows

​
Order Lifecycle

Customer Purchase
       │
       ▼
┌─────────────────┐
│ Shopify Webhook │
│ orders/create   │
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Supabase Sync   │
│ + Attribution   │
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│  Fulfillment    │
│    Router       │
└────────┬────────┘
         │
    ┌────┴────┬────────────┬───────────┐
    ▼         ▼            ▼           ▼
Supliful  Collective   Digital    Manual
  API       (auto)     (instant)  (flagged)
    │         │            │           │
    └─────────┴────────────┴───────────┘
                    │
                    ▼
           Customer Notification
           (shipped, delivered)

​
Content → Commerce Flow

Publisher Post
       │
       ▼
┌─────────────────┐
│ Content Analysis│
│ (keywords, topics)
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Product Matching│
│ (keyword + AI)  │
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│  Recommendations│
│  (sidebar, inline)
└────────┬────────┘
         │
         ▼
   Customer Click
         │
         ▼
   Product Page
   (utm tracking)
         │
         ▼
   Purchase
   (attribution recorded)

​
Integration Points

​
Publisher Integration

  • Posts feature products via post_product_recommendations
  • Affiliate links tracked with attribution
  • Vertical collections match content verticals

​
Platform Integration

  • Platform licenses sold as Shopify products
  • Customer identity linked via audience_profiles

​
Agency Integration

  • Agency packages sold as Shopify products
  • Client onboarding triggered by purchase

​
Key Metrics

MetricQuery Location
Revenue by sourceshopify-sync.md
Revenue by verticalshopify-sync.md
Margin by product typedropship-network.md
Recommendation CTRvertical-collections.md
Fulfillment performancefulfillment.md
DocumentWhat It Covers
SCHEMA.mdAll table definitions
SCHEMA_CONCEPTS.mdIntelligence layer architecture
docs/publisher/OVERVIEW.mdPublisher (drives traffic)
docs/platform/OVERVIEW.mdPlatform (shared customer data)
docs/agency/OVERVIEW.mdAgency (packages sold via Store)