Price Fix Action Plan

Run this script on your Desktop

The file sooty_step1_hide_plans.js is in your Sooty folder. It sets show_store_screen: false on all 139 plans in Firebase.

# In Terminal — from the folder with sooty-service-account.json
node sooty_step1_hide_plans.js

# Expected output:
✅ Hidden: Zimbabwe 20GB (was $1265.99)
✅ Hidden: Zimbabwe 10GB (was $633.99)
... (139 lines)
=== DONE: 139 hidden, 0 failed ===

Manual alternative (Firebase Console)

1. Go to console.firebase.google.com → Project sooty-1a5db → Firestore
2. Open the plans collection
3. For each plan below, find by doc_id and set show_store_screen = false

Top 20 Plans to Hide (worst losses first)

Web Admin Access

1. Log into sooty.ai/dashboard with your Addevice account
2. Go to Packages → sooty.ai/admin/packages
3. For each mismatch in the Sooty Price Audit Web vs App 2026 0528.xlsx file (tab: ❌ Mismatches) — find the package and update the price

Edit URL pattern

https://sooty.ai/packages/edit/{id}
# Package IDs go from 1 to 1131
# Example: https://sooty.ai/packages/edit/1 = "Afghanistan 1 GB"

Fields to update in edit form

• Find the package by country + GB size using the country filter dropdown
• Update the price field to match the app price (Firebase)
• Click Save. That's it.

Priority countries to fix first (highest traffic)

Run the reprice script

node sooty_step3_reprice_plans.js

# This updates price_usd AND sets show_store_screen: true
# Expected output:
✅ Zimbabwe 20GB: $1265.99 → $4402.99
✅ Zimbabwe 10GB: $633.99 → $2201.99
... (139 lines)
=== DONE: 139 updated, 0 failed ===

Note on extreme-cost countries

Some countries (Zimbabwe, Ecuador, Monaco, Niger) have very high wholesale costs. Their repriced prices will be much higher. Consider whether to keep these visible at all — even at correct prices they won't sell at volume. Jay to decide which to keep.

Sample repriced plans

Implementation

1. Verify all 5 regional plans exist in Firebase — check type == "regional" with correct GB + price
2. Make sure the web admin has matching prices for these 5 plans
3. Deploy Sooty Hero Packages 2026.html to Cloudflare Pages (drag & drop)
4. Link from the sooty.ai homepage → "Our Best Deals" section
5. Update App Store listing description with Europe Explorer ($7.99) as lead hook

Architecture

Worker code (pseudocode)

// Cloudflare Worker — sooty-prices.js
export default {
  async fetch(request) {
    const url = new URL(request.url);
    const country = url.searchParams.get('country');

    // Call Firebase REST API
    const firestoreUrl = `https://firestore.googleapis.com/v1/projects/sooty-1a5db/databases/(default)/documents/plans`;
    const res = await fetch(firestoreUrl + `?where=title=${country}&where=show_store_screen=true`);
    const data = await res.json();

    return new Response(JSON.stringify(data), {
      headers: { 'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*' }
    });
  }
};

Once worker is deployed

1. Update sooty.ai country pages to fetch prices from the worker instead of the Laravel database
2. Prices on website always mirror Firebase — zero manual sync needed
3. When Viacheslav sends new cost file, update Firebase only — website auto-updates