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

Dashboard

The Dashboard is the first page you land on when clicking Webkul WC Addons → Import Export in your sidebar. It shows stats, recent activity, quick action buttons, and a system info check.

Page URL: /wp-admin/admin.php?page=wkaie

Page title at the top: "Advance Import Export" (with a database import icon)

Subtitle: "Import & export millions of WooCommerce products, orders, customers, and more."

Dashboard top sectionDashboard — stat cards, quick actions, and recent activity.

The 4 Stat Cards

Four cards sit at the top in a grid.

#Card TitleWhat It ShowsIcon
1Total JobsAll saved jobs (enabled + disabled)List icon, blue
2Active SchedulesJobs with cron schedule turned onClock icon, green
3Failed (Last 24h)Runs that failed in the past 24 hoursWarning icon, red if > 0
4Total Records ImportedLifetime total recordsDatabase import icon, orange

Click Failed (Last 24h) to jump to History filtered by failed status.

Quick Actions Card

Heading: "Quick Actions" (with a performance icon)

Three buttons in a horizontal row:

ButtonGoes To
New Import (blue primary button)Quick Import Wizard
New Export (gray secondary button)Quick Export page
Run Health Check (gray secondary button)Health Check page

Recent Activity Card

Heading: "Recent Activity" (with a backup icon)

Shows the last 10 runs. If no runs yet:

"No import/export activity yet. Start your first import above."

When runs exist, you see a table with these columns:

ColumnWhat It Shows
StatusGreen check (success) / red X (failed) / orange clock (running)
Job TitleName of the job, or "Quick Import" if run from wizard
Entity TypeProducts, Orders, etc.
RecordsCreated / Updated / Failed counts
DurationHow long the run took
Time Ago"5 min ago", "2 hours ago", etc.

Click any row to open the full run in the History page.

At the bottom of the card: View Full History button.

"Run did not start" in the Records column

If a run crashed before processing any rows (e.g., file not found), the Records column shows "Run did not start" instead of "0 / 0 / 0". Click for full error details.

System Information Card

The most important card — it checks every server requirement.

System Information cardSystem Info — green good, yellow warning, red needs attention.

Status Banner at Top

The banner summarizes:

BannerMeaning
Green: "All system requirements met. Your server is fully optimized for high-speed imports."Everything works
Yellow: "X performance warnings."Works but slower than possible
Red: "X critical issues detected."Fix these first
Yellow + Red: "X critical issue(s) and Y warning(s) detected. Expand each row below for fix instructions."Mixed

What's Checked

#RowMinimumWhat It Means
1PHP Version8.1Your PHP version
2MySQL Version8.0Your MySQL/MariaDB
3WordPress Version6.0Your WordPress
4WooCommerce Version8.0Your WooCommerce
5pcntl ExtensionRecommendedEnables parallel processing (10x speed)
6posix ExtensionRecommendedEnables FIFO pipes
7LOAD DATA LOCAL INFILERequiredMySQL flag for fastest bulk insert
8MyISAM EngineOptional2x speed boost for staging
9PHP Memory Limit256M+Memory per PHP process
10PHP Max Execution Time300s+Max script run time

Each Row Shows

  • Name on the left
  • Value in the middle (your current value)
  • Status on the right:
    • Green checkmark + "Available" (good)
    • Red X + "Not Available" (need to fix)
    • Yellow warning icon (suboptimal)

"How to Fix This" Sections

Any row with a red X or yellow warning has an expandable section labeled How to fix this.

Click to expand. The plugin auto-detects your server OS and shows the right commands:

For pcntl missing on Ubuntu:

sudo apt-get install php8.3-pcntl
sudo systemctl restart php8.3-fpm

For pcntl missing on CentOS / RHEL:

sudo dnf install php-process
sudo systemctl restart php-fpm

For pcntl missing on macOS:

brew install [email protected]

For Windows:

"pcntl is not supported on Windows. Use WSL2 or a Linux server."

For LOAD DATA LOCAL INFILE disabled, three options:

Option 1 — SQL as admin:

SET GLOBAL local_infile = 1;

Option 2 — Permanent in my.cnf:

[mysqld]
local_infile = 1

Then restart MySQL.

Option 3 — Ask your host:

Copy-paste this message: "Please enable LOAD DATA LOCAL INFILE for my MySQL user. The plugin requires this for bulk imports."

Buttons at the Bottom

ButtonWhat It Does
Expand all fix instructionsOpens every "How to fix" box at once
Copy system info for supportCopies the whole system info table to your clipboard

Use Copy system info for support when opening a support ticket.

Troubleshooting the Dashboard

ProblemFix
All stat cards show 0You have not run any imports yet. Click New Import
Dashboard takes a long time to loadYour database may be slow. Clean old history: wp wkaie history cleanup --older-than=30d
"Failed (Last 24h)" shows a high numberOpen History, inspect each failed run for the error message
System info shows pcntl "Not Available"Expand "How to fix this" for install commands
"PHP Memory Limit" shows yellowAdd define('WP_MEMORY_LIMIT', '512M'); to wp-config.php
"LOAD DATA LOCAL INFILE" shows redRun the SQL or ask your host

Related Pages

  • Installation — Initial setup
  • First-Time Setup — Step-by-step checklist
  • Quick Import Wizard — Start importing
  • History — Full run history
  • Health Check — Find and fix data issues
  • Settings — Change defaults
  • PHP Configuration — Fix PHP limits
Next
Quick Import Wizard — 5 Steps to Import Any File