# Blog & Insights Bulk Import Update

## Added
- Admin bulk importer at `admin/blog-import.php`.
- CSV and JSON file upload.
- Pasted JSON import.
- One-click bundled import of nine complete SEO-ready posts.
- Automatic category creation.
- Duplicate slug handling: skip or update.
- Automatic SEO fallbacks for meta title, meta description and focus keyword.
- Import limit of 500 posts and 5 MB per upload.
- Downloadable CSV and JSON templates.
- Reading-time estimates, view counts and topic tags on public articles.
- Sample posts are included in `database/schema.sql` for fresh installations.

## Existing Website Deployment
1. Upload and extract the updated files over the existing website.
2. Sign in to the admin dashboard.
3. Open **Blog & Insights → Bulk Import**.
4. Click **Import sample content** to add the bundled posts to an existing database.
5. Existing matching slugs are skipped by default, preventing duplicates.

## Accepted Import Fields
`title`, `slug`, `category`, `excerpt`, `body`, `featured_image`, `tags`, `status`, `published_at`, `meta_title`, `meta_description`, `focus_keyword`.

The `body` field accepts HTML. Featured images may use a local path such as `/img/photo.jpg` or a full HTTPS URL.
