How to Integrate Replit with Yoast SEO (for WordPress)

1// test-wp-auth.js — Test WordPress REST API authentication
2const axios = require('axios');
3
4const WP_URL = process.env.WP_URL;
5const WP_USERNAME = process.env.WP_USERNAME;
6const WP_APP_PASSWORD = process.env.WP_APP_PASSWORD;
7
8if (!WP_URL || !WP_USERNAME || !WP_APP_PASSWORD) {
9  console.error('Missing secrets. Add WP_URL, WP_USERNAME, WP_APP_PASSWORD to Replit Secrets (lock icon 🔒).');
10  process.exit(1);
11}
12
13// Create base64-encoded Basic Auth header
14const authToken = Buffer.from(`${WP_USERNAME}:${WP_APP_PASSWORD}`).toString('base64');
15
16const wpClient = axios.create({
17  baseURL: `${WP_URL}/wp-json/wp/v2`,
18  headers: { 'Authorization': `Basic ${authToken}` }
19});
20
21async function testAuth() {
22  // Fetch current user to verify authentication
23  const resp = await wpClient.get('/users/me');
24  console.log('WordPress auth OK');
25  console.log('Authenticated as:', resp.data.name);
26  console.log('Roles:', resp.data.roles?.join(', '));
27}
28
29testAuth().catch(err => {
30  console.error('Auth failed:', err.response?.status, err.response?.data?.message || err.message);
31});

1# fetch_yoast.py — Fetch WordPress posts with Yoast SEO data (Python)
2import os
3import base64
4import requests
5from flask import Flask, jsonify, request
6
7WP_URL = os.environ['WP_URL']
8WP_USERNAME = os.environ['WP_USERNAME']
9WP_APP_PASSWORD = os.environ['WP_APP_PASSWORD']
10
11# Construct Basic Auth header
12credentials = base64.b64encode(f'{WP_USERNAME}:{WP_APP_PASSWORD}'.encode()).decode()
13HEADERS = {'Authorization': f'Basic {credentials}'}
14API_BASE = f'{WP_URL}/wp-json/wp/v2'
15
16def get_posts_with_seo(page=1, per_page=20, post_type='posts'):
17    """Fetch posts with Yoast SEO fields."""
18    resp = requests.get(
19        f'{API_BASE}/{post_type}',
20        headers=HEADERS,
21        params={
22            'page': page,
23            'per_page': per_page,
24            '_fields': 'id,title,link,status,yoast_head_json'
25        }
26    )
27    resp.raise_for_status()
28    total_pages = int(resp.headers.get('X-WP-TotalPages', 1))
29    total_posts = int(resp.headers.get('X-WP-Total', 0))
30    return resp.json(), total_pages, total_posts
31
32def extract_seo_summary(post):
33    """Extract key Yoast SEO fields into a clean dict."""
34    yoast = post.get('yoast_head_json', {}) or {}
35    return {
36        'id': post.get('id'),
37        'title': post.get('title', {}).get('rendered', ''),
38        'url': post.get('link', ''),
39        'seo_title': yoast.get('title', ''),
40        'meta_description': yoast.get('description', ''),
41        'canonical': yoast.get('canonical', ''),
42        'og_image': yoast.get('og_image', [{}])[0].get('url', '') if yoast.get('og_image') else '',
43        'robots': yoast.get('robots', {}),
44        'has_schema': bool(yoast.get('schema'))
45    }
46
47app = Flask(__name__)
48
49@app.route('/api/posts/seo')
50def posts_with_seo():
51    page = int(request.args.get('page', 1))
52    posts, total_pages, total = get_posts_with_seo(page=page)
53    return jsonify({
54        'page': page,
55        'total_pages': total_pages,
56        'total_posts': total,
57        'posts': [extract_seo_summary(p) for p in posts]
58    })
59
60if __name__ == '__main__':
61    app.run(host='0.0.0.0', port=3000)

1// seo-audit.js — Yoast SEO content audit for WordPress (Node.js)
2const axios = require('axios');
3const fs = require('fs');
4
5const WP_URL = process.env.WP_URL;
6const auth = Buffer.from(`${process.env.WP_USERNAME}:${process.env.WP_APP_PASSWORD}`).toString('base64');
7
8const wp = axios.create({
9  baseURL: `${WP_URL}/wp-json/wp/v2`,
10  headers: { 'Authorization': `Basic ${auth}` }
11});
12
13async function getAllPosts() {
14  let page = 1;
15  let totalPages = 1;
16  const allPosts = [];
17
18  while (page <= totalPages) {
19    const resp = await wp.get('/posts', {
20      params: { page, per_page: 100, _fields: 'id,title,link,yoast_head_json', status: 'publish' }
21    });
22    totalPages = parseInt(resp.headers['x-wp-totalpages'] || '1');
23    allPosts.push(...resp.data);
24    console.log(`Fetched page ${page}/${totalPages} (${allPosts.length} posts so far)`);
25    page++;
26    if (page <= totalPages) await new Promise(r => setTimeout(r, 500)); // Be polite to WP server
27  }
28  return allPosts;
29}
30
31function auditPost(post) {
32  const yoast = post.yoast_head_json || {};
33  const issues = [];
34  const title = yoast.title || '';
35  const desc = yoast.description || '';
36
37  if (!desc) issues.push('missing_meta_description');
38  else if (desc.length > 155) issues.push('meta_description_too_long');
39  else if (desc.length < 50) issues.push('meta_description_too_short');
40
41  if (!title) issues.push('missing_seo_title');
42  else if (title.length > 60) issues.push('seo_title_too_long');
43  else if (title.length < 30) issues.push('seo_title_too_short');
44
45  if (yoast.robots?.index === 'noindex') issues.push('noindex_set');
46  if (!yoast.og_image || yoast.og_image.length === 0) issues.push('missing_og_image');
47
48  return {
49    id: post.id,
50    title: post.title?.rendered || '',
51    url: post.link,
52    seo_title_length: title.length,
53    meta_desc_length: desc.length,
54    issues: issues.join('; ') || 'none',
55    needs_attention: issues.length > 0
56  };
57}
58
59async function runAudit() {
60  console.log('Starting Yoast SEO audit...');
61  const posts = await getAllPosts();
62  const results = posts.map(auditPost);
63  const withIssues = results.filter(r => r.needs_attention);
64
65  console.log(`\nAudit complete: ${posts.length} posts checked`);
66  console.log(`Posts needing attention: ${withIssues.length}`);
67
68  const csv = [
69    'ID,Title,URL,Issues,SEO Title Length,Meta Desc Length',
70    ...withIssues.map(r =>
71      `${r.id},"${r.title.replace(/"/g, '""')}",${r.url},"${r.issues}",${r.seo_title_length},${r.meta_desc_length}`
72    )
73  ].join('\n');
74
75  fs.writeFileSync('seo-audit.csv', csv);
76  console.log('Report saved to seo-audit.csv');
77}
78
79runAudit().catch(console.error);

1# update_yoast_meta.py — Bulk-update Yoast SEO meta via WordPress REST API (Python)
2import os
3import base64
4import time
5import requests
6import csv
7
8WP_URL = os.environ['WP_URL']
9credentials = base64.b64encode(
10    f"{os.environ['WP_USERNAME']}:{os.environ['WP_APP_PASSWORD']}".encode()
11).decode()
12HEADERS = {
13    'Authorization': f'Basic {credentials}',
14    'Content-Type': 'application/json'
15}
16API_BASE = f'{WP_URL}/wp-json/wp/v2'
17
18def update_post_seo(post_id: int, meta_description: str = None, focus_keyword: str = None, seo_title: str = None):
19    """Update Yoast SEO fields on a specific post."""
20    meta = {}
21    if meta_description is not None:
22        meta['_yoast_wpseo_metadesc'] = meta_description
23    if focus_keyword is not None:
24        meta['_yoast_wpseo_focuskw'] = focus_keyword
25    if seo_title is not None:
26        meta['_yoast_wpseo_title'] = seo_title
27
28    if not meta:
29        raise ValueError('At least one SEO field must be provided')
30
31    resp = requests.post(
32        f'{API_BASE}/posts/{post_id}',
33        headers=HEADERS,
34        json={'meta': meta}
35    )
36    if resp.status_code == 403:
37        raise PermissionError(f'Permission denied for post {post_id}. Check user role and Yoast REST permissions.')
38    resp.raise_for_status()
39    return resp.json()
40
41def bulk_update_from_csv(csv_path: str, dry_run: bool = True):
42    """Read post ID and meta descriptions from CSV and apply updates."""
43    with open(csv_path, 'r') as f:
44        reader = csv.DictReader(f)  # Expects columns: post_id, meta_description
45        rows = list(reader)
46
47    print(f'Processing {len(rows)} posts. Dry run: {dry_run}')
48    for row in rows:
49        post_id = int(row['post_id'])
50        meta_desc = row.get('meta_description', '').strip()
51
52        if not meta_desc:
53            print(f'  Skipping post {post_id}: empty meta description')
54            continue
55        if len(meta_desc) > 155:
56            print(f'  WARNING post {post_id}: meta description exceeds 155 chars ({len(meta_desc)})')
57
58        if dry_run:
59            print(f'  [DRY RUN] Would update post {post_id}: "{meta_desc[:60]}..."')
60        else:
61            try:
62                update_post_seo(post_id, meta_description=meta_desc)
63                print(f'  Updated post {post_id}')
64                time.sleep(0.3)  # Gentle rate limiting
65            except Exception as e:
66                print(f'  ERROR post {post_id}: {e}')
67
68if __name__ == '__main__':
69    # Usage: set dry_run=False to actually update
70    bulk_update_from_csv('updates.csv', dry_run=True)