Advance Import and Export for WooCommerce DocumentationAdvance Import and Export for WooCommerce Documentation
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
Buy Now
View Demo
  • Getting Started

    • Introduction
    • Quick Start
    • Features
    • Installation
    • First-Time Setup
    • CSV Preparation
    • Sample Files
    • Use Cases
    • Common Mistakes
  • Tutorials

    • Google Sheets Live Sync
    • Shopify Migration
    • Daily Backup to S3
    • Multi-Store Sync
  • Using the Plugin

    • Dashboard
    • Quick Import Wizard
    • Quick Export
    • Settings
    • Compatibility
  • Import In Detail

    • Import Sources
    • Import Modes
    • Column Mapping
    • Transformations
    • Migration Presets
    • Delta Import
  • Export In Detail

    • Export Features
    • Export Destinations
    • Browser Download
    • Server Path (REST / CLI)
  • Data Types

    • Products
    • Variable Products
    • Orders
    • Customers
    • Categories & Tags
    • Coupons
    • Reviews
    • Posts
    • Pages
    • Users
    • Subscriptions
    • Bookings
    • Memberships
    • Menus
  • Automation

    • Scheduled Jobs
    • History & Logs
    • Rollback
    • Health Check
  • Cloud Service Setup

    • Google API Setup
    • Amazon S3 Setup
    • Dropbox Setup
    • Email / SMTP Setup
  • Server Configuration

    • PHP Configuration
    • Server Cron Setup
    • Image Handling
  • Developer

    • REST API
    • WP-CLI Commands
  • Compare

    • vs WP All Import
    • vs Product Import Export (WebToffee)
  • Help

    • Troubleshooting
    • FAQ
    • Glossary
    • Security
    • Changelog
Support
  • Getting Started

    • Introduction
    • Quick Start — Your First Import in 5 Minutes
    • Features — Full Tour
    • Installation — Full Setup Guide
    • First-Time Setup — Complete Checklist
    • CSV Preparation — How to Make a Good Import File
    • Sample Files — Download Ready-to-Use Templates
    • Use Cases — "I Want To..." Quick Reference
    • Common Mistakes — Things To Watch Out For
  • Tutorials

    • Tutorial — Google Sheets Live Sync
    • Tutorial — Migrate from Shopify to WooCommerce
    • Tutorial — Daily Backup to Amazon S3
    • Tutorial — Sync Between Two WooCommerce Stores
  • Using the Plugin

    • Dashboard — What You See First
    • Quick Import Wizard — 5 Steps to Import Any File
    • Quick Export — One-Page Export Tool
    • Settings — Every Option Explained
    • Compatibility — Third-Party Plugin Support
  • Import In Detail

    • Import Sources — 11 Ways to Pull Data In
    • Import Modes — Create, Update, Delete, Replace
    • Column Mapping — Connect Your Columns to WooCommerce
    • Transformations — Change Values During Import
    • Migration Presets — Move From Shopify, Magento, BigCommerce
    • Delta Import — Skip Unchanged Rows
  • Export In Detail

    • Export Features
    • Export Destinations — Where Your Files Go
    • Export Download — One-Click Browser Download
    • Export to Server Path — WP-CLI
  • Data Types

    • Products Import — Full Field Reference
    • Variable Products — The Complete Guide
    • Orders Import — Historical Orders and Line Items
    • Customers Import — With Addresses and Notes
    • Categories and Tags Import
    • Coupons Import — Discount Codes
    • Reviews Import — Product Reviews and Ratings
    • Posts Import — WordPress Blog Posts
    • Pages Import — WordPress Pages
    • Users Import — WordPress User Accounts
    • Subscriptions Import — WooCommerce Subscriptions
    • Bookings Import — WooCommerce Bookings
    • Memberships Import — WooCommerce Memberships
    • Menus Import — WordPress Navigation Menus
  • Automation

    • Jobs — Saved and Scheduled Imports and Exports
    • History — Every Run You Have Ever Done
    • Rollback — Undo Any Import in One Click
    • Health Check — Data Integrity Checks With Auto-Fix
  • Cloud Service Setup

    • Google API Setup — Sheets, Drive, OAuth
    • Amazon S3 Setup — IAM User and Bucket Permissions
    • Dropbox Setup — API Token for Private Files
    • Email Setup — Making Notifications Actually Work
  • Server Configuration

    • PHP Configuration — Memory, Execution Time, Upload Size
    • Server Cron Setup — Reliable Scheduled Imports
    • Image Handling — Download, Resize, Watermark
  • Developer

    • REST API — Developer Reference
    • WP-CLI Commands — Command Line Automation
  • Compare

    • Advance Import and Export vs WP All Import
    • Advance Import and Export vs Product Import Export for WooCommerce
  • Help

    • Troubleshooting — Fix Common Problems
    • FAQ — Common Questions
    • Glossary — Every Term Explained
    • Security — How Your Data Is Protected
    • Changelog — What Changed

WP-CLI Commands

For developers and server admins, every plugin feature is available on the command line.

Requirements

  • WP-CLI 2.0 or higher
  • SSH access to the server

Command Prefix

Most commands live under wp wkaie. The export command uses wp wkaie-export.

8 Command Groups

1. Run a Saved Job

wp wkaie run 42

Where 42 is the job ID.

Options:

  • --async — run in background via WP scheduled event
  • --quiet — less output

2. Run a Job Chain

wp wkaie run-chain <chain_id>

Runs a chain of jobs in order.

3. Validate a Job

Check if a job is configured correctly without running it.

wp wkaie validate 42

Output:

Job: Daily Products Import
Source: https://docs.google.com/spreadsheets/d/... (accessible)
Rows: 10000
Columns: 42
✅ All required columns present
⚠️  12 rows have empty descriptions
✅ Mapping is valid

4. Preview / Dry Run

Run a job without committing changes.

wp wkaie preview 42 --limit=10

Shows the first 10 rows as they will be imported.

5. Job Management

Saved jobs gridThe same saved jobs listed in the UI are what wp wkaie job list returns on the CLI.

# List all jobs
wp wkaie job list

# Create a new job
wp wkaie job create --name="Daily Import" --type=import --entity=products

Job Editor with six tabsA CLI-created job opens the same six-tab Job Editor in the admin UI for further tuning.


# Enable or disable a job
wp wkaie job enable 42
wp wkaie job disable 42

# Delete a job
wp wkaie job delete 42 --yes

The --yes flag confirms deletion (no prompt).

6. History

# List recent runs
wp wkaie history list

# Filter by job
wp wkaie history list --job_id=42

# Show a specific run
wp wkaie history show 123

7. Rollback

# Rollback a run
wp wkaie rollback 123 --yes

8. Presets

# List mapping presets
wp wkaie preset list

# Export a preset to a file
wp wkaie preset export my-preset --file=preset.json

# Import a preset from a file
wp wkaie preset import --file=preset.json

Direct Export Command

Separate command for one-off exports:

# Export products as CSV
wp wkaie-export products --format=csv

# Export with filter
wp wkaie-export orders --format=csv --filter='{"status":"completed"}'

# Run a saved export job
wp wkaie-export run 42

Automation Examples

Nightly Full Sync

System cron to run every night at 2 AM:

0 2 * * * cd /var/www/html && wp wkaie run 42 >> /var/log/wkaie.log 2>&1

Hourly Health Check with Email on Failure

Create a script:

#!/bin/bash
if ! wp wkaie validate 42 --quiet; then
  echo "Validation failed on $(hostname)" | mail -s "WooCommerce Job Validation Failed" [email protected]
fi

Add to cron:

0 * * * * /path/to/health-check.sh

Deploy Pipeline Health Gate

For CI/CD after every deploy:

#!/bin/bash
set -e

# Validate critical jobs
wp wkaie validate 42
wp wkaie validate 43

echo "✅ All post-deploy checks passed"

Output Formats

Most commands support these formats:

  • --format=table (default)
  • --format=csv
  • --format=json
  • --format=yaml
  • --format=count (just show count)
  • --format=ids (just show IDs)

Good for piping into other tools:

wp wkaie history list --format=ids --status=failed | xargs -I {} wp wkaie rollback {} --yes

Getting Help

Every command has --help:

wp wkaie --help
wp wkaie run --help
wp wkaie job list --help

Troubleshooting

ProblemFix
wp: command not foundWP-CLI is not installed. Install from wp-cli.org
Error: The site you have requested is not installedRun commands from the WordPress root directory
Fatal error: Class WooCommerce not foundWooCommerce is not active. Activate it first
Commands are slowCache may be stale. Run wp cache flush first

Related Pages

  • REST API — Alternative to WP-CLI
  • Jobs — Jobs run via cron or WP-CLI
  • Rollback — Undo runs via CLI
Prev
REST API — Developer Reference