Skip to content
Appifire
Docs
Delete All Existing Code and DB Tables (Boilerplate Cleanup)

Delete All Existing Code and DB Tables (Boilerplate Cleanup)

Inventory of S-AI-CHAT code and Prisma models to remove or replace when using this repo as a boilerplate for the Video Testimonial Collector app.

Delete All Existing Code and DB Tables

Section titled “Delete All Existing Code and DB Tables”

This plan assumes you are forking or cloning the current S-AI-CHAT repository and want a slim Shopify app boilerplate aligned with:

  • 01-Post-Purchase-Video-Testimonial-Collector-Plan.md
  • 02-Implementation-Blueprint.md

Goal: delete AI chat, RAG / knowledge, and chat widget storefront code/tables that the testimonial product does not need. Keep Shopify session/auth patterns, core Shop tenancy (trimmed for chat-only fields), admin Settings, Promo module, and Support module (feature requests, tickets, roadmap — adapt copy and any chat-specific metrics later). Keep billing primitives you can repurpose, product mirror (optional but recommended for PDP/home widgets and admin pickers), and mandatory compliance webhooks (update their handlers after schema changes).

This document is a checklist, not an executed migration. Perform deletions in a dedicated git branch; generate new Prisma migrations after editing schema.prisma (do not hand-edit production DB without a migration).

1) What the testimonial app still needs (keep conceptually)

Section titled “1) What the testimonial app still needs (keep conceptually)”
AreaWhy keep
Session modelShopify OAuth session storage (template standard).
Shop model (slimmed)Multi-tenant root; testimonial campaigns, submissions, media, billing.
Product / ProductVariant (optional)Local catalog mirror helps admin UI, campaign product pickers, and validating shopifyProductId for PDP/home APIs. If you drop these, you must load product titles via Admin API only.
ShopSubscription / ShopOneTimeChargeSubscription and one-time purchase patterns from Phase 5; remap limits to testimonial metrics (storage, requests, published clips).
Product webhooks (products/create, update, delete)Keeps product mirror in sync if you keep Product tables.
app/uninstalled, app/scopes_update, app_subscriptions/updateStandard app lifecycle / billing.
webhooks/complianceRequired for GDPR topics; must be updated after removing tables so redact jobs do not reference missing models.
Email utility (app/lib/email.server.js pattern)Request/reminder emails for testimonial collection.
Admin shell (app/routes/app.jsx, auth routes)Embedded app framing; replace nav items.
Settings (app.settings.jsx + Shop fields you add for testimonial)Merchant config: contacts, branding, integrations, testimonial toggles (extend per 02-Implementation-Blueprint.md).
Promo models + admin/send/redeem routesIncentives (e.g. discount codes for submitting a testimonial per blueprint); repurpose fields if today they are chat-reply-specific (see §2.1).
Support models + app.support.jsxIn-app support desk, feature voting, roadmap — keep; remove only UI copy/logic that assumes “AI Chat” product.

2) Prisma models to remove entirely

Section titled “2) Prisma models to remove entirely”

These tables exist only for AI chat, RAG, or chat analytics. For a testimonial-focused boilerplate, drop the models and delete all code that imports them.

Do not remove promo or support tables if you are keeping those modules (see §2.1).

RAG / embeddings / ingestion

  • KnowledgeSource
  • KnowledgeDocument
  • KnowledgeChunk
  • Embedding (pgvector column — after removal you may switch Postgres provider without vector extension)
  • IngestionJob
  • RetrievedChunk

Chat

  • ChatThread
  • ChatSession
  • ChatMessage

LLM usage logging (chat + embeddings)

  • OpenRouterCall

RAG “data sync” mirror (not required for testimonial MVP unless you repurpose)

  • ShopSyncState
  • Collection
  • Blog
  • Article
  • InventoryLevel

2.1) Keep: Promo and Support (repurpose, do not drop)

Section titled “2.1) Keep: Promo and Support (repurpose, do not drop)”

These are retained for the Video Testimonial Collector app.

Promo

  • PromoCode, PromoRedemption, PromoCodeSendLog
  • Note: Current PromoCode.freeReplies and related naming target chat reply credits. Plan a small migration + UI rename when you map promos to testimonial incentives (e.g. “bonus video requests”, “extra published slots”, or generic “credit units”). Until then, keep the tables and routes; only remove references to deleted chat billing (limits.server.js, freeCreditsUsed, etc.) when wiring redemptions.

Support

  • SupportFeatureRequest, SupportFeatureVote, SupportRoadmapItem, SupportTicket, SupportTicketMessage
  • Note: Compliance redact flows must continue to respect customer data in tickets when you extend GDPR handling for testimonial submissions.

Chat-centric install / churn analytics snapshots

  • ShopsInstalledStats (or replace later with testimonial-specific stats)
  • ShopsUninstalled (or replace with a slimmer uninstall archive that does not reference chat counts)

Migration note: remove relations from Shop pointing at the above models before dropping Shop fields that only served chat (see section 3). Use onDelete: Cascade awareness: drop child tables first in SQL if you bypass Prisma migrate.

3) Shop model: fields to remove (chat / RAG / widget / AI credits)

Section titled “3) Shop model: fields to remove (chat / RAG / widget / AI credits)”

After removing relations, delete columns that are only for the AI chat widget and RAG pipeline. Grouped for clarity.

Chat widget & appearance

  • widgetTitle, welcomeMessage, brandColor, bubblePosition, chatbotAvatarPreset, widgetBubbleAnimation, widgetIconInsetPx, widgetEnabled, widgetShowOnAllPages
  • preChatFormEnabled, guestChatAllowed

AI model / knowledge

  • aiModel
  • knowledgeDomainUrl, websiteKnowledge

OpenRouter / reply limits / low-balance alerts tied to chat

  • dailySpendLimitCents, emailAlertOnMinBalance, minBalanceForAlertReplies, minBalanceForAlertCents, lastLowBalanceAlertAt
  • creditBalance, lastPaidIncludedCreditsPeriodEnd, suppressIncludedCreditsAfterSubscriptionLapse
  • freeCreditLimit, freeCreditsUsed

Retain (likely still useful for testimonial app)

  • Identity: shopifyShopId, shopDomain, accessToken, shopName, shopEmail, shopPhone
  • Optional contacts: supportWhatsappNumber, supportEmail (if you still want merchant-configured support — otherwise drop)
  • plan, status, timestamps
  • Billing linkage: subscriptionId, subscriptionLineItemId
  • Email flags: welcomeEmailSent, uninstallEmailSent, welcomeEmailSentAt, uninstallEmailSentAt, welcomeEmailError, uninstallEmailError (repurpose copy from “AI Chat” to testimonial branding)

Replace later with testimonial config (per blueprint; add in a future migration, not in this deletion doc):

  • Widget layout/colors for video testimonial storefront blocks
  • testimonialEnabled, moderation flags, consent version, etc.

4) Routes (app/routes/) — remove or replace

Section titled “4) Routes (app/routes/) — remove or replace”

4.1 Delete (chat / RAG / chat widget / chat-only billing helpers)

Section titled “4.1 Delete (chat / RAG / chat widget / chat-only billing helpers)”
FileReason
api.chat.jsxChat API entry.
api.chat.history.jsxChat history for widget.
api.widget-settings.jsxPublic chat widget settings (appearance).
api.widget-settings-sync.jsxChat widget sync helper.
api.cron.reset-free-plan-replies.jsxFree-plan reply counter reset; testimonial app needs different cron jobs (e.g. send scheduled requests).
app.chat-logs.jsxAdmin chat logs.
app.knowledge.jsxKnowledge Hub UI.
app.data-sync.jsxRAG data sync UI.
app.appearance.jsxChat widget appearance admin.

4.1b Keep (adapt for testimonial product)

Section titled “4.1b Keep (adapt for testimonial product)”
FileAction
app.settings.jsxKeep. Remove or relocate chat-only Shop fields from the form; add testimonial settings per 02-Implementation-Blueprint.md (widget, moderation, campaigns, etc.). Same route and shell.
app.support.jsxKeep. Update strings and any dashboard links that reference “AI Chat”; ensure loaders/actions do not depend on removed chat models.
app.promo-codes.jsx, app.promo-send.jsx, app.promo-redeem.jsxKeep. Repurpose labels and redemption wiring from “free chat replies” to testimonial incentive semantics when you change PromoCode meaning.

4.2 Replace later (keep file name only if you want continuity)

Section titled “4.2 Replace later (keep file name only if you want continuity)”
FileAction
app._index.jsxRewrite dashboard for testimonial KPIs (requests, submissions, moderation queue). Current file queries chatSession, chatMessage, openRouterCall, chunk counts.
app.billing.jsx, app.billing.confirm.jsx, app.billing.buy-credits.jsx, app.billing.buy-credits.confirm.jsxRepurpose for testimonial plans/usage; remove imports of chat credit / free-reply logic (limits.server.js, openRouterCall, etc.).

4.3 Public marketing site

Section titled “4.3 Public marketing site”
FileAction
_index/route.jsx, _index/styles.module.cssRebrand copy and links; remove AI chat positioning.

4.4 Webhooks — delete handlers only if topics removed from shopify.app.toml

Section titled “4.4 Webhooks — delete handlers only if topics removed from shopify.app.toml”

Current product webhooks feed product mirror used by RAG. For testimonial:

  • Keep webhooks.products.create.jsx, webhooks.products.update.jsx, webhooks.products.delete.jsx if you keep Product / ProductVariant.
  • Keep webhooks.compliance.jsx, webhooks.app.uninstalled.jsx, webhooks.app.scopes_update.jsx, webhooks.app_subscriptions.update.jsx — but edit compliance + uninstall code paths that aggregate chat/RAG metrics or delete child rows that no longer exist.

Add later (testimonial blueprint):

  • webhooks.orders.paid.jsx and/or webhooks.orders.fulfilled.jsx (campaign triggers)

5) Library code (app/lib/) — delete list

Section titled “5) Library code (app/lib/) — delete list”

Remove modules that only serve chat/RAG/widget/AI billing. After deletion, run rg (ripgrep) for each basename to fix broken imports.

FileRole
rag.server.jsRAG orchestration.
prompt-builder.server.jsChat system prompt.
chat.server.jsOpenRouter chat.
embeddings.server.jsEmbeddings.
vector-search.server.jspgvector search.
chunker.server.jsChunking for RAG.
ingestion.server.jsKnowledge ingestion.
website-knowledge.server.jsWebsite knowledge fetch.
order-lookup.server.jsShopify order lookup for chat.
limits.server.jsFree reply cap + credit wallet for chat.
paid-plan-included-credits.server.jsIncluded USD credits for chat.
low-balance.server.js, low-balance.jsChat balance alerts.
widget-appearance.server.js, widget-appearance.jsChat widget appearance normalization.
theme-widget.server.jsChat theme asset helpers.
shop-analytics-snapshot.server.jsLikely chat/RAG heavy — review; remove or replace with testimonial snapshot.
shops-installed-stats.server.jsChat-centric install stats — remove or rewrite.
shops-uninstalled-archive.server.jsUninstall archive — rewrite to stop querying dropped models.
product-sync.server.jsOnly if you remove product mirror; keep if you still sync products for testimonial admin.
collection-sync.server.js, blog-sync.server.js, inventory-sync.server.js, sync-state.server.jsRAG sync — remove if you drop those tables.
plans.server.jsRepurpose for testimonial pricing; remove chat reply constants.

Keep (promo + support)

  • promo.server.js, promo.shared.js — promo access rules and shared helpers; update naming/semantics when promos mean testimonial incentives, not chat replies.
  • Support logic lives mainly in app.support.jsx and Prisma models; no dedicated support.server.js in current tree — keep those routes when trimming imports.

Keep (generic)

  • cors.server.js — still useful for public storefront APIs (testimonial widget read, upload URLs).
  • email.server.js — reuse for testimonial request emails.
  • date-format.server.js — generic.

6) Theme extension — remove chat widget

Section titled “6) Theme extension — remove chat widget”

Delete the entire workspace:

  • extensions/appifire-chat/ (blocks, chat-widget.js, shopify.extension.toml, locales)

Replace with a new extension per 02-Implementation-Blueprint.md (testimonial-widget-home.liquid, testimonial-widget-pdp.liquid, shared JS).

Update root shopify.app.toml (or multi-env TOMLs) so [extensions] / Shopify CLI discovers the new extension name.

7) Configuration and environment

Section titled “7) Configuration and environment”

7.1 shopify.app.toml

Section titled “7.1 shopify.app.toml”
  • Rename app name, application_url, redirect_urls, and client_id to the new Partner app when you create it.
  • Scopes: testimonial MVP needs at least orders (read or appropriate access for post-purchase triggers), products (read; write only if you still use template metafields), themes (if publishing app blocks), and compliance. Remove scopes that existed only for metaobject demos if unused.
  • Remove [product.metafields.app.demo_info] and [metaobjects.app.example] if they are template noise.

7.2 .env.sample — remove chat/RAG variables

Section titled “7.2 .env.sample — remove chat/RAG variables”

Remove or strike through:

  • OPENROUTER_API_KEY, WEBSITE_KNOWLEDGE_MODEL
  • EMBEDDING_MARKUP_FACTOR, CHAT_MARKUP_FACTOR
  • ORDER_LOOKUP_DEBUG, CHAT_HISTORY_MESSAGES
  • LLM_MODEL_FREE, LLM_MODEL_PAID
  • Free-reply / chat credit vars tied to limits.server.js (FREE_PLAN_REPLIES_CAP, paid included credits, low balance USD thresholds) — replace with testimonial-specific limits when you define billing.

Keep:

  • SHOPIFY_*, DATABASE_URL, DIRECT_URL, SCOPES
  • Brevo (or your mail provider) keys — update product name in from/reply-to copy
  • Optional VITE_GA_MEASUREMENT_ID

7.3 package.json

Section titled “7.3 package.json”
  • Rename name from appifire-ai-chat to your new package slug.
  • Dependencies: no OpenRouter SDK in package.json currently; after code removal, if nothing uses marked / @toast-ui/editor / recharts, consider removing them only after grep confirms zero imports.

8) Database / Postgres

Section titled “8) Database / Postgres”
  • If you remove Embedding and no other extension uses vector, you may drop the pgvector extension in a migration to simplify hosting (optional).
  • Regenerate Prisma client: npx prisma generate.
  • Apply a single coherent migration that:
    1. Drops foreign keys / tables for removed models.
    2. Alters shops to drop chat columns.
    3. Updates any views or indexes you maintain manually (if applicable).

9) Compliance and uninstall — mandatory follow-ups

Section titled “9) Compliance and uninstall — mandatory follow-ups”

webhooks/compliance.jsx and webhooks/app/uninstalled.jsx (and any helper they call) likely:

  • Copy metrics into ShopsUninstalled / stats tables
  • Delete tenant rows

After schema deletion, update these routes so they:

  • Do not reference ChatMessage, KnowledgeChunk, etc.
  • Still satisfy Shopify’s redact expectations for new testimonial tables (e.g. delete TestimonialSubmission by customer email when you build that schema)

Until handlers are updated, deploying a half-migrated schema can cause runtime errors on compliance webhooks.

10) Suggested execution order (safe refactor sequence)

Section titled “10) Suggested execution order (safe refactor sequence)”
  1. Create branch chore/testimonial-boilerplate-cleanup.
  2. Remove theme extension appifire-chat and all storefront references.
  3. Delete route files listed in §4.1 only; keep §4.1b (settings, support, promos); fix router/build errors.
  4. Delete app/lib modules listed in §5 (not promo); fix imports.
  5. Edit prisma/schema.prisma: remove chat/RAG models + trim Shop; retain promo/support tables; run prisma migrate dev locally.
  6. Rewrite compliance + uninstall handlers.
  7. Update app.jsx nav (add testimonial entries later); keep Settings, Support, Promo links; adapt dashboard — do not remove the settings route.
  8. Update shopify.app.toml, .env.sample, and marketing _index.
  9. Full-text search: rg "chatMessage|KnowledgeChunk|OpenRouter|rag\.server|api/chat" until clean.

11) Explicit non-goals (for this cleanup pass)

Section titled “11) Explicit non-goals (for this cleanup pass)”
  • Implementing testimonial tables (TestimonialCampaign, TestimonialSubmission, …) — that belongs in implementation migrations per 02-Implementation-Blueprint.md.
  • Choosing final billing meter (storage minutes vs request count) — only remove chat-specific credit fields now; add testimonial fields when product pricing is fixed.

12) Traceability to future sub-plans

Section titled “12) Traceability to future sub-plans”

When you split work into per-topic markdown plans, map cleanup to:

Sub-planContents
SP-CLEAN-01Prisma: drop chat/RAG models only; trim Shop chat fields; keep promo + support models (optional migration to rename promo fields).
SP-CLEAN-02Remove chat/RAG routes + app/lib modules; keep settings, support, promo routes; fix build.
SP-CLEAN-03Remove extensions/appifire-chat; update shopify.app.toml.
SP-CLEAN-04Rewrite GDPR uninstall + compliance handlers for new schema.
SP-CLEAN-05Rebrand env sample, package name, public index, admin nav shell.

This file is 04-Delete All Existing Code and DB Tables.md in the Video Testimonial Collector doc set.

Home

01 Overview

AppiFire AI Chat — Product Plan & Architecture Options (A, B, C) Technology Overview & High-Level Tasks

01 Platform Foundation

Prerequisites (Detailed Plan) Shopify Setup — Partner Account, CLI, App, and Extension Shopify App Skeleton & Database (Detailed Plan)

02 Knowledge and RAG

Database Schema for RAG Product Sync & Ingestion RAG & Chat API RAG Data Sync (Products, Collections, Inventory, Blog Posts) + Order Lookup How the Codebase Uses Vector Information to Answer Users in Chat Website Knowledge from Web (GPT-4o Mini Search)

03 Billing and Usage

Billing & Usage Billing & Usage — Remaining Tasks Credits wallet: one-time purchases & subscription included credits Free Plan: Reply Cap and Monthly Reset Promo code functionality Shopify App Billing and Payments Tasks

04 Admin and Storefront

Admin Settings & Chat Widget Admin UI Design Plan — Bigger Font, Different Font, More Spacing, Styled Buttons AI Chats / Logs Screen Billing Screen Restructure Plan (Sales + Marketing Focus) Dashboard Plan — AppiFire AI Chat Design Guidelines and Styling System (Polaris + Tailwind Plan) Theme & Design System Timezone & Time Display Plan (Admin + Widget)

05 Chat Experience and Safety

Chat Guardrails Inspection Full Conversation History in OpenRouter Chat Order Lookup Reliability Guide Order Status Conversational Chat Flow Pre-Chat User Identity Form

06 Merchant Lifecycle

Register / Identify App Users (Paying Merchants) Uninstall: Record & Goodbye Email

07 Ops and Release

Deploy: Cloudflare Tunnel + Your Domain & App to appifire-ai-chat.appifire.com Launch & Publishing Guide Links Scheduled jobs, privacy & shop analytics Testing Up to Phase 2 (Product Sync & Ingestion)

08 Research and Ideas

App Names 20 Paid Feature Gaps — AppiFire AI Chat Roadmap Templates Shortlisted Top 30 Shopify App Ideas — High Demand, Buildable, Revenue Potential

09 Archive

100 AI Questions User Can Ask App Embed Settings Plan Chat Thread Identity and History Plan Plan: Free reply monthly reset & paid included credits delivery Future Todo List Promo Code Module Plan Reorganize Documents Support Feature Plan Talk to Human Flow Plan Welcome Email Plan (Brevo API)

10 Marketing and SEO

Article Writing Prompt Appifire SEO Topical Map Topical Map Prompt Appifire VS Pages VS Pages Prompt

11 Video Testimonial Collector

Post-Purchase Video Testimonial Collector — Detailed Product Plan Video Testimonial Collector - Implementation Blueprint Video Testimonial Collector - Pricing & Billing Options Delete All Existing Code and DB Tables (Boilerplate Cleanup) 05 — Storefront Widgets + Public Read API (Screen 8 & 8.1) 06 — Public Submission Page (Screen 13, `/t/:token`) 07 — Email/SMS Request Delivery Pipeline (Blueprint §4) 08 — Security, Compliance & Privacy (Blueprint §8) 09 — Submissions Inbox (Screen 5, `/app/testimonials`) 10 — Submission Detail & Moderation (Screen 6, `/app/testimonials/:id`) 11 — Published Content Manager (Screen 7, `/app/testimonials/published`) 12 — Moderation Settings (Screen 9, `/app/testimonials/moderation`) 13 — Requests Log (Blueprint Screen 10, `/app/testimonials/requests`) 14 — Analytics (Blueprint Screen 11, `/app/testimonials/analytics`) 15 — Billing & Usage (Blueprint Screen 12, `/app/testimonials/billing`) 16 — Templates (Screen 4, `/app/testimonial-templates`) 17 — Campaigns List (Screen 2, `/app/testimonial-campaigns`) 18 — Campaign Create/Edit (Screen 3, `/app/testimonial-campaigns/:id`) 19 — Dashboard (Screen 1, `/app`) 20 — Database Design & Migrations (Blueprint §5) 21 — Route & File Map Execution Plan (Blueprint §6) 22 — Integration & Processing Orchestration (Blueprint §7) 23 — Release Plan & Milestones (Blueprint §9) 24 — Build Notes Execution Standards (Blueprint §10) 25 — Core Modules Breakdown (Blueprint §2.2) 26 — Project Conventions Execution Guide (Blueprint §2.1) 27 — Product Scope Recommendation Execution (Blueprint §1) 28 — Admin Screens Information Architecture (Blueprint §3) 29 — Milestone 1 Delivery Plan (Blueprint §9.1) 30 — Milestone 2 Delivery Plan (Blueprint §9.2) 31 — Milestone 3 Delivery Plan (Blueprint §9.3) 32 — Email/SMS Operational Detail (Blueprint §4) 33 — TestimonialModerationLog Model & Audit Workflow (Blueprint §5.10) 34 — TestimonialDailyAnalytics Model & Rollup Jobs (Blueprint §5.11) 35 — TestimonialProductLink Model & Multi-Product Merchandising (Blueprint §5.9) 36 — TestimonialMediaAsset Model & Processing Pipeline (Blueprint §5.8) 37 — TestimonialSubmission Model & Lifecycle (Blueprint §5.7) 38 — TestimonialRequestEvent Model & Delivery Event Stream (Blueprint §5.6) 39 — TestimonialRequest Model & Scheduling Lifecycle (Blueprint §5.5) 40 — TestimonialTemplate Model & Resolution Rules (Blueprint §5.4) 41 — TestimonialCampaignProduct Model & Targeting Rules (Blueprint §5.3) 42 — TestimonialCampaign Model & Automation Rules (Blueprint §5.2) 43 — Shop Model Extension for Testimonials (Blueprint §5.1) 44 — Per-Product Collection Rule (Required) Implementation Plan 45 — Two Storefront Widgets (v1 Requirement, Screen 8.1)