WordPress Batch Import Guide

Comprehensive guide for the WordPress batch import orchestrator script.

Overview

The wp-batch-import.sh script is a master orchestrator that manages the complete WordPress product import workflow with safety checks, rollback capability, and detailed reporting.

Features

Safety First: Automatic backups before any changes
Interactive Mode: Step-by-step confirmations
Dry-Run Mode: Test without making actual changes
Rollback Capability: Restore from backups if needed
Progress Tracking: Real-time progress with ETA
Detailed Logging: Console and file logging
Email Notifications: Optional email reports
Error Handling: Comprehensive error handling and recovery

Prerequisites

WP-CLI installed
Node.js and npm
WordPress installation
WooCommerce REST API keys
CSV product file

Installation

Clone or download scripts to /scripts/ directory:

cd /Users/tannguyen/Documents/fullstack/triseo.drmanhlinhmd.com/scripts
chmod +x wp-batch-import.sh
chmod +x wp-import-config.sh

Configure environment in .env file:

# WordPress Configuration
WP_PATH="/path/to/wordpress"
WP_USER="admin"
SITE_URL="https://drmanhlinhmd.com"

# WooCommerce API
ck=ck_your_consumer_key
cs=cs_your_consumer_secret

# Import Options
DRY_RUN=false
SKIP_DOWNLOADS=false
VERIFY=true

Quick Start

Basic Usage

# Interactive mode with confirmations
./scripts/wp-batch-import.sh

# Dry-run mode (test without changes)
./scripts/wp-batch-import.sh --dry-run

# Automated mode (no confirmations)
./scripts/wp-batch-import.sh --non-interactive

# Full automated with email notification
./scripts/wp-batch-import.sh --non-interactive --email

Configuration Helper

# Show current configuration
./scripts/wp-import-config.sh show

# Validate configuration
./scripts/wp-import-config.sh validate

# Interactive setup
./scripts/wp-import-config.sh setup

# Export configuration
./scripts/wp-import-config.sh export > import-config.sh

Workflow Steps

The script executes the following steps in order:

1. Pre-check

Verify WP-CLI installation
Check WordPress path
Validate CSV file
Test database connection
Check required dependencies

2. Backup

Export WordPress database
Backup uploads metadata
Store backup with timestamp
Save backup location for rollback

3. Download Images

Extract image URLs from CSV
Download images to temp directory
Skip existing images
Track download statistics

Analyze product data
Generate meta descriptions
Create SEO-friendly titles
Optimize product descriptions

5. Update Products

Match existing products by SKU
Update product metadata
Update prices and stock
Preserve existing data

6. Create Products

Create new product posts
Set product categories
Assign product attributes
Link product images

7. Verify Import

Count imported products
Validate product data
Check for errors
Generate import report

Command Line Options

Option	Description
`--dry-run`	Run without making actual changes
`--skip-downloads`	Skip image downloads
`--no-verify`	Skip import verification
`--non-interactive`	Run without confirmations
`--email`	Send email notification
`--help`	Show help message

Environment Variables

Variable	Description	Default
`WP_PATH`	WordPress installation path	`/path/to/wordpress`
`WP_USER`	WordPress username	`admin`
`SITE_URL`	Site URL	`https://drmanhlinhmd.com`
`DRY_RUN`	Enable dry run mode	`false`
`SKIP_DOWNLOADS`	Skip image downloads	`false`
`VERIFY`	Enable verification	`true`
`INTERACTIVE`	Enable confirmations	`true`
`EMAIL_NOTIFY`	Enable email	`false`
`EMAIL_TO`	Email recipient	`admin@example.com`

Examples

Test Run (Recommended First Step)

# Load config and do a dry run
source scripts/wp-import-config.sh export
./scripts/wp-batch-import.sh --dry-run

Production Import

# Interactive import with confirmations
./scripts/wp-batch-import.sh

# Automated import
./scripts/wp-batch-import.sh --non-interactive

# Import with email notification
./scripts/wp-batch-import.sh --non-interactive --email

Skip Image Downloads

# If images are already downloaded
./scripts/wp-batch-import.sh --skip-downloads

Custom Configuration

# Set custom WP path
WP_PATH="/var/www/html" ./scripts/wp-batch-import.sh

# Multiple options
SKIP_DOWNLOADS=true VERIFY=false ./scripts/wp-batch-import.sh --non-interactive

Output and Logs

Console Output

The script provides colored console output:

🟢 Green: Success messages
🔴 Red: Error messages
🟡 Yellow: Warnings
🔵 Blue: Information
🟣 Purple: Debug messages

Log Files

Logs are saved to /logs/ directory:

logs/
├── import-20240110-143022.log      # Main log file
└── import-report-20240110-143520.txt  # Final report

Statistics Report

The final report includes:

Products processed/updated/created/failed
Images downloaded/failed
Total errors
Execution time
Backup location

Rollback

If the import fails or you need to undo changes:

# The script will prompt for rollback on failure
# Or manually rollback from backup:

# Find latest backup
cat backups/latest.txt

# Restore database
wp db import backups/backup-20240110-143022/database.sql --path=/path/to/wp

Troubleshooting

WP-CLI Not Found

# Install WP-CLI
curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
chmod +x wp-cli.phar
sudo mv wp-cli.phar /usr/local/bin/wp

Permission Denied

# Make scripts executable
chmod +x scripts/wp-batch-import.sh
chmod +x scripts/wp-import-config.sh

Database Connection Error

# Check WordPress config
cat /path/to/wordpress/wp-config.php

# Test WP-CLI
wp core version --path=/path/to/wordpress

Image Download Failures

# Check image URLs in CSV
cat docs/bruno_vassari_wp_products.csv | awk -F',' '{print $NF}'

# Test manual download
curl -I <image_url>

WooCommerce API Errors

# Verify API keys in .env
grep -E "^(ck|cs)=" .env

# Regenerate keys in WordPress admin:
# WooCommerce > Settings > Advanced > REST API

CSV File Format

Expected CSV structure:

sku,name,description,price,stock,category,image_url
BV001,"Product Name","Description",99.99,10,"Category","https://example.com/image.jpg"

Best Practices

Always test with dry-run first
Keep regular backups
Monitor logs for errors
Verify imports in WordPress admin
Use non-interactive mode for automation
Enable email notifications for production
Keep CSV file validated and clean

Automation

Cron Job

# Add to crontab (crontab -e)
0 2 * * * cd /path/to/project && ./scripts/wp-batch-import.sh --non-interactive --email

CI/CD Pipeline

# Example for GitHub Actions
- name: Run WordPress Import
  run: |
    ./scripts/wp-batch-import.sh --non-interactive

Support

For issues or questions:

Check log files in /logs/
Review configuration with wp-import-config.sh validate
Test with --dry-run first
Check WordPress and WooCommerce requirements

License

MIT License - See project root for details.

​WordPress Batch Import Guide

​Overview

​Features

​Prerequisites

​Installation

​Quick Start

​Basic Usage

​Configuration Helper

​Workflow Steps

​1. Pre-check

​2. Backup

​3. Download Images

​4. Generate SEO Content

​5. Update Products

​6. Create Products

​7. Verify Import

​Command Line Options

​Environment Variables

​Examples

​Test Run (Recommended First Step)

​Production Import

​Skip Image Downloads

​Custom Configuration

​Output and Logs

​Console Output

​Log Files

​Statistics Report

​Rollback

​Troubleshooting

​WP-CLI Not Found

​Permission Denied

​Database Connection Error

​Image Download Failures

​WooCommerce API Errors

​CSV File Format

​Best Practices

​Automation

​Cron Job

​CI/CD Pipeline

​Support

​License