Skip to main content

​
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

  1. 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
  1. 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

​
4. Generate SEO Content

  • 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

OptionDescription
--dry-runRun without making actual changes
--skip-downloadsSkip image downloads
--no-verifySkip import verification
--non-interactiveRun without confirmations
--emailSend email notification
--helpShow help message

​
Environment Variables

VariableDescriptionDefault
WP_PATHWordPress installation path/path/to/wordpress
WP_USERWordPress usernameadmin
SITE_URLSite URLhttps://drmanhlinhmd.com
DRY_RUNEnable dry run modefalse
SKIP_DOWNLOADSSkip image downloadsfalse
VERIFYEnable verificationtrue
INTERACTIVEEnable confirmationstrue
EMAIL_NOTIFYEnable emailfalse
EMAIL_TOEmail recipient[email protected]

​
Examples

# 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

  1. Always test with dry-run first
  2. Keep regular backups
  3. Monitor logs for errors
  4. Verify imports in WordPress admin
  5. Use non-interactive mode for automation
  6. Enable email notifications for production
  7. 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.