HandiRamp Family | AI-Assisted Operational Ontology

Executive Summary

This is not a single pilot. It is an emerging operational ontology: a practical data-and-workflow layer that ties ERP, CRM, ecommerce, production, ETD, advertising, reporting, content, and governance into one usable management picture.

62
items

27 Ontology, operations, dashboards, and syncs

9 Customer service and internal tools

17 CRM, sales, marketing, and content assets

9 Infrastructure and governance assets

The ontology value

The strongest gains come from creating a layer of truth across fragmented systems: WooCommerce, Genius ERP, Zoho CRM, Veeqo, FreightPop, ETD and production schedule data, GA4, Google Ads, Search Console, Semrush, SalesIQ, CallRail, Vonage, WordPress, and internal tools. This is the Palantir-style move: connect siloed facts, define the relationships between them, then expose new insights and actionable next steps.

A connected truth layer

Production, rental, order, inventory, BOL, shipment, customer, and campaign context is becoming connected instead of scattered across tabs and tribal memory.

Action from reconciliation

Backfills, daily syncs, lookup portals, categorization passes, and reporting workflows do more than reduce busywork; they expose mismatches, missing data, and next-best actions.

Reusable operating model

The same ontology layer supports future improvements across HandiRamp, HandiTreads, PetStep, GetBiggies, CargoVanRamps, and related HPI properties.

HandiRamp

YR Rental

HandiTreads

PetStep

CargoVanRamps

GetBiggies

StopTheSlip

IndustrialToolz

Fleming Trailers

HandiProducts

ramps.org

lastmileramps

API Connections And Data Sources

The ontology is valuable because it connects operational systems that used to answer only their own narrow questions. These are the major source systems now represented in the management layer.

12
sources

Genius ERP REST API

Authoritative order, invoice, customer, item, inventory, production-job, and shipping entities.

Operational spine

Zoho CRM API and Deluge

Sales orders, Contacts, Leads, Products, SalesIQ enrichment, lead attribution, and Contact note writeback.

CRM truth layer

WooCommerce REST/API

Storefront order, customer-email, source-order, product, coupon, and ecommerce status context across HPI storefronts.

Commerce source

Veeqo API

Marketplace and Woo fulfillment index for HandiTreads and GetBiggies, with package, tracking, and dimension context where Veeqo shipped the order.

Fulfillment bridge

FreightPop REST API

Shipment-history lookup for carriers, tracking numbers, BOL context, shipping status, and Genius reference fields.

Shipping source

ETD and production schedule feed

Estimated ready-to-ship dates, order-entered dates, production state, and missed-date signals tied back to Genius SOs.

Production timing layer

Semrush API

Organic keyword, traffic, and competitive-search signals for executive web-performance reporting.

SEO source

GA4 Data API

Ecommerce revenue, sessions, conversion behavior, and channel-quality reporting.

Analytics source

Google Ads API

Spend, clicks, campaign structure, search pressure, and conversion-health context.

Paid-media source

Google Search Console API

Query, page, click, and impression visibility for the organic-search layer.

Search visibility source

CallRail and Vonage call data

Account-wide call volume, inbound queue handling, tracked-source attribution, rep ownership, business-hours, and lead-quality signals for top-of-funnel analysis.

Call source

Zoho SalesIQ chat data

Chat operator, visitor, and opportunity-outcome data so web chat participates in the same lead-quality model.

Chat source

Operations, Dashboards, And Syncs

Recurring systems that keep operational truth current, connected, and close to the people acting on it.

14
items

Zoho to Genius SO daily sync

Creates a CRM-to-ERP truth bridge so customer service and reporting can resolve sales orders across systems.

Live daily sync

Veeqo to Genius order cross-reference

Maps marketplace and Woo fulfillment activity back to Genius ERP, making order identity portable across channels.

Live daily sync

CVR/SDR production tracking sync

Keeps cargo-van and sliding-door ramp production status visible inside the order lookup workflow.

Live 15-minute refresh

Production Schedule 3.0 weekly tracker

Turns the production sheet into a dollar-first revenue and shop-status tracker.

Live dashboard

Production 3.0 ship-month revenue forecaster

Forecasts invoiceable revenue by ready-to-ship month, including CVR chunk-level proration.

Built and verified workflow

HandiRamp web performance reporting

Consolidates analytics, ad, search, and SEO data into one executive web-performance report.

July report published

YR Rental v2 dashboards

Commercial dashboard suite for yard-ramp rental activity, opportunities, sales orders, reps, and contacts.

Live nightly refresh pattern

YR Equipment BOL tracking

Tracks physical ramp movement, delivery, return, location, and service state in Zoho.

Field layer live; workflow test needed

Zoho lead-attribution enrichment

Improves lead routing by enriching product interest, medium, and communication tool after SalesIQ data arrives.

Live scheduled enrichment

FreightPop shipment lookup

Brings carrier and shipment facts into the same order/BOL ontology used by service and operations.

Integrated reference layer

Genius Sales lookup and API reference

Reusable ERP truth layer for order, invoice, shipping, inventory, production, and customer tools.

Field-verified reference

DAM image pipeline

AI-assisted product-photo tagging, deduplication, and review for HPI product images.

PetStep complete; HR/HT imports pending

PetStep Shopping spend review

Active review of bid, budget, ROAS, and conversion tracking for paid Shopping performance.

Ongoing review cadence

Alex Inventory process diagrams

Documents manual and AI-assisted inventory workflows for warehouse operations and reconciliation.

Live process hub

Internal Tools And Customer Service Workflows

Tools that reduce lookup time, prevent wrong-order handling, and make cross-system relationships visible to the team.

9
items

Universal Order Lookup

One operational view across WooCommerce, Genius, FreightPop, Zoho, and email search.

Live internal tool

Tracking-email preview workflow

Prepares brand-correct tracking emails from live order and shipping data without sending automatically.

Preview-only MVP

FG/SA Inventory Lookup

Searchable Genius-backed inventory view for finished goods and sales-assembly items.

Live verified lookup

Customer Service Hub

Unified internal landing page for customer-service tools.

Live hub

Genius hub reorganization

Separates working apps from documentation and reference pages so internal users find tools faster.

Live navigation cleanup

Order-data field-link map

Visualizes how WooCommerce, Genius, FreightPop, and Zoho IDs connect.

Live field diagram

Genius multi-match picker

Prevents wrong-order selection when multiple Genius SOs match one customer or order search.

Built into lookup behavior

Genius order-number/customer-code map

Documents how web, Amazon, EDI, and inside-sales orders are represented in Genius.

39,505-row audit

Order workflow diagrams

Explains order-entry-to-invoice, ASC, and WooCommerce routing across HPI brands.

HTML flowcharts built

CRM, Sales, And Product Data

Data cleanup and sales-process work that strengthens the ontology: cleaner identifiers, better product meaning, stronger customer value context, and more reliable handoffs.

7
items

Zoho-Genius historical SO backfill

Filled missing Genius order numbers on CRM sales orders so older records can participate in the same truth layer.

26,660 scanned; 4,090 updated

Zoho product categorization

Adds structured product meaning to CRM records for reporting, segmentation, and better downstream decisions.

6,969 categorized

HandiTreads lifetime-spend analysis

Connects ecommerce purchase history to CRM contacts so high-value customer relationships are visible.

386 high-value customers found

Genius-to-Zoho lifetime-spend architecture

Design for pushing authoritative ERP customer value into CRM as a durable customer-value layer.

Designed; not implemented

Zoho SO billing-instructions auto-note

Proposed automation to turn PDF instructions into structured CRM context on the right sales order.

Documented; verify before presenting as live

YR Rental automated email sequence

Structured lead nurture and follow-up cadence for yard-ramp rental leads.

Built/documented; confirm live state

YR Rental CS ownership transition

Operational handoff with CRM fields, diagrams, and process changes for rental fleet ownership.

Transition documented

Marketing, Advertising, And Content

Reporting, creative, content, and paid-media work that connects marketing activity to clearer performance signals and reusable market intelligence.

10
items

HandiRamp Google Ads conversion audit

Found broken conversion paths that were weakening the link between ad spend, lead quality, and revenue truth.

Audit complete

HandiRamp Ads structure and keyword work

Organizes campaign, keyword, and negative-keyword logic into a cleaner acquisition map.

Documented project work

HandiRamp web-performance report v1

First consolidated executive view across analytics, ads, search, and SEO signals.

Published July edition

PetStep Shopping campaign optimization

Turns spend, bid, budget, ROAS, and conversion-quality signals into paid-media decisions.

Ongoing review series

AI-generated yard-ramp image workflow

Structured image lab for producing better yard-ramp visuals from reference photos.

Workflow documented

ITZ content strategy and GEO drafts

Positions IndustrialToolz around custom engineering and "Engineering the Never Been Done Before."

Strategy and drafts captured

House-Hasson / HandiTreads social campaign

Produced trade-show social creative and published through HandiProducts channels.

LinkedIn and Facebook published

HandiProducts Facebook page creation

Established parent-brand social presence separate from HandiRamp.

Page created and configured

HPI social publisher workflow

Approval-gated process for brand-routed social posting.

Workflow available

Fleming Trailers marketing and ads audit

Extends the HPI marketing-intelligence layer to Fleming Trailers.

Audit and strategy documented

Websites, Infrastructure, And Governance

Deployment, site, analytics, and governance work that makes the ontology safer to operate, easier to extend, and more auditable over time.

9
items

ramps.org / rampsnew build

New educational ramp website foundation.

Built; not DNS-live

HandiTreads testimonial carousel fix

Restored broken homepage testimonial images and protected a visual customer-proof section.

Production fix verified

HandiTreads deploy pipeline

Safer repeatable deployment path to WP Engine.

GitHub Actions pipeline

HandiRamp / CargoVanRamps deploy pipeline

Repeatable deployment path for internal tools and web-performance pages.

Used for static deployments

Heatmap Lite

Self-hosted behavior data layer for ecommerce and website insight.

Live on HandiTreads; expansion planned

WordPress deployment governance

Standardizes safer update, deployment, and audit practices across managed web properties.

Governance layer

WordPress fleet monitoring evaluation

Assesses a change-history layer for knowing what changed before a site broke.

Benchmark stage

HandiTreads inquiry knowledge base

Improves consistency and safety of customer-service replies.

Canonical knowledge captured

HandiRamp employee confidentiality boundary

Governance rule protecting HPI-only conversations from unrelated client or internal-system leakage.

Live rule

Additional Source-Evidenced Ontology Work

Source folders and recurring operational workflows surfaced earlier work that was undercounted in memory: taxonomy design, categorized invoice history, call/chat analysis, account-industry enrichment, Woo-to-Genius export tooling, finance reconciliation, and inbox triage.

13
found

HPI product hierarchy and taxonomy design

Built the master product hierarchy used to classify HPI products by primary category, subcategory, product type, specs, and tag structure.

1,798 recommendation rows

HandiRamp web-page categorization

Classified GA4 landing pages into product and content categories so web traffic can connect back to the product ontology.

826 classified pages

Categorized invoice line-item history

Mapped 2024-2026 invoice line items into category structure, creating a sales-history truth layer by product family.

42,219 line items

Power BI sales category reports

Produced category/month and SKU-level sales workbooks for material handling, accessibility, fall prevention, home/pet, trailers, and service lines.

13 category sheets

Accessibility vendor analysis

Joined QuickBooks, Genius, and Zoho product data to analyze accessibility/mobility sales, vendors, product types, notable orders, and SafePath detail.

13,454 sales rows

Top-of-funnel sales funnel report

Analyzed HandiRamp pipeline opportunities from Nov 2025 through Mar 2026 as an early sales-funnel view.

47 opportunity rows

CallRail and Vonage call analysis

Mapped account-wide Vonage volume, 10,958 inbound calls, HRT1 queue handling, CallRail tracked calls by rep/source, business-hours patterns, and downstream routing limits so phone demand can be understood beyond the marketing-tracked slice.

21,831 calls analyzed

SalesIQ chat-to-opportunity analysis

Analyzed chat operator performance and opportunity outcomes so inbound chat can become part of the lead-quality truth layer.

Operator and opportunity workbooks

Zoho account-industry enrichment

Normalized account industry values, prioritized enrichment, web-searched top accounts, and prepared import candidates for better CRM segmentation.

77,135 accounts reviewed

WooCommerce XML to Genius export bridge

Built and tested workbook tooling to transform WooCommerce order data into Genius-ready order/XML structures across HPI stores.

14,706 order-history rows

Genius customer master reference

Captured a Genius customer export for customer-code, account, address, and customer-identity reference across downstream matching work.

2,894 customer records

Ramp card reconciliation workflow

Reviewed corporate card expense rows, standardized accounting categories, company coding, memos, receipts, and PO-field handling so finance cleanup is repeatable and auditable.

144 expense rows reviewed

Email inbox scan workflow

Established a repeatable live inbox sweep that filters routine notifications, preserves actionable customer and operations mail, names skipped mailboxes, and verifies remaining inbox state.

10 inbox sweep pattern