# HostTiller SEO Deployment Checklist
Run these steps in order on your cPanel server. Tick each box as you finish.

## PART 1 — Upload files to cPanel

Your files are on the PC at: `G:\hosttiller.com`

### 1.1 Build folder (most important)
- [ ] Delete the OLD `build` folder on the server (`public_html/build`)
- [ ] Upload `G:\hosttiller.com\public\build` to `public_html/build`
- [ ] Verify `public_html/build/manifest.json` exists after upload

### 1.2 Self-hosted fonts (new folder)
- [ ] Upload `G:\hosttiller.com\public\fonts` to `public_html/fonts`
- [ ] Verify you can open this in a browser (shows content): `https://www.hosttiller.com/fonts/Inter-var.woff2`
- [ ] Confirm all 7 files uploaded: Inter-var.woff2 + Poppins-400/500/600/700/800/900.woff2

### 1.3 robots.txt
- [ ] Upload `G:\hosttiller.com\public\robots.txt` to `public_html/robots.txt` (overwrite if exists)

### 1.4 Blade view (removes Google Fonts, adds font preload)
- [ ] Upload `G:\hosttiller.com\resources\views\app.blade.php` to your app's `resources/views/app.blade.php`

### 1.5 Routes file (activates sitemap + one-time updater)
- [ ] Upload `G:\hosttiller.com\routes\web.php` to your app's `routes/web.php`

> Where is "your app's resources/routes"? It is the Laravel folder on the server that contains
> folders like `app/`, `config/`, `routes/`. This is normally OUTSIDE `public_html` (one level up),
> or `public_html` itself in some one-folder setups. If your site already works, find the folder
> that contains `routes/web.php` and overwrite the same file there.

## PART 2 — Run the SQL file in phpMyAdmin

- [ ] Log in to cPanel → phpMyAdmin
- [ ] Left sidebar: click your site database (e.g. `user_hosttiller`)
- [ ] Top menu → **Import** tab
- [ ] Import `G:\hosttiller.com\database\phase2_seo_pages.sql` → **Go**
- [ ] Wait for "Import has been successfully finished"
- [ ] Repeat the same import steps for:
  - [ ] `phase2_contact_bd.sql`
  - [ ] `phase2_articles.sql`

> If imports are too large for your hosting limit, first upload the .sql files with cPanel
> File Manager into `public_html`, then in phpMyAdmin Import choose "Browse" and select the
> uploaded file from the server.

## PART 3 — One-time SEO updater (alternative to the pages SQL)
- [ ] Only if the `phase2_seo_pages.sql` import above failed.
- [ ] Open this URL once in a browser:
      `https://www.hosttiller.com/run-seo-upgrade?token=95bac40bf3b1d121bc4af1473bd40b57`
- [ ] You should see: "Done - Updated 15 page row(s). This updater is now locked."
- [ ] Any later visit shows 404 (that is correct - it ran once).

## PART 4 — Verify everything

- [ ] Open `https://www.hosttiller.com` (hard refresh: Ctrl+Shift+R)
- [ ] DevTools (F12) → Network: confirm NO request to `fonts.googleapis.com` or `fonts.gstatic.com`
- [ ] Open `https://www.hosttiller.com/sitemap.xml` → shows XML of all pages
- [ ] Open `https://www.hosttiller.com/pricing` → ৳ BDT prices + the blue "Pay in Taka, your way" strip
- [ ] Open `https://www.hosttiller.com/blog` → 4 new articles listed
   - best-web-hosting-bangladesh-2026
   - start-reseller-hosting-business-bangladesh
   - web-hosting-vs-vps-bangladesh
   - choose-right-web-hosting-bangladesh
- [ ] Open one article → links to /pricing, /vps, /reseller, /contact work
- [ ] Open `https://www.hosttiller.com/about-us` → "Made in Bangladesh" contact band near top of story
- [ ] Footer → address shows "Dhaka, Bangladesh", phone shows +880 1911336699

## PART 5 — Still to do by you (not code)

- [ ] Admin → Settings → Contact: set your REAL street address in the "Address" field
  (street is currently empty on purpose; city is Dhaka, Bangladesh)
- [ ] Admin → Settings → Pricing: check `bdt_rate` is near the real USD-to-BDT rate
- [ ] Admin → Settings → SEO: confirm `og_image` is set (social sharing image)
- [ ] Confirm the phone +880 1911336699 is your real contact number, or edit it in
  Admin → Settings → Contact (it is used in the footer, /about-us and /contact)
- [ ] Google Search Console: submit `sitemap.xml` (if not already)
- [ ] Google Business Profile: create listing with name "HostTiller", website,
  city Dhaka, and the SAME phone/address as your site (NAP consistency)