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

Features — The Full Tour

This page lists every feature in the plugin. Use the table of contents on the left to jump to what you need.

Highlights

  • 14 entity types in the wizard — Products, Orders, Customers, Coupons, Reviews, Posts, Pages, Users, Categories, Tags, Attributes, and more
  • 11 import sources — File upload, Server path, URL, FTP, SFTP, Google Sheets, Google Drive, Dropbox, Amazon S3, REST API, WooCommerce REST API
  • 13 export destinations — File download, FTP, SFTP, server path, Amazon S3, Dropbox, Google Drive, Google Sheets, OneDrive, REST API, WC REST API, email
  • 5 import modes — Create Only, Update Only, Create + Update, Delete, Replace
  • 6 file formats — Auto-Detect, CSV, XML, JSON, XLSX, ODS (plus ZIP and TAR auto-extract)
  • 15 third-party plugins supported — Yoast, RankMath, AIOSEO, ACF, Meta Box, WPML, Polylang, Dokan, WCFM, WC Vendors, Product Bundles, Composite Products, Product Add-ons, Brands
  • 7 admin pages — Dashboard, Quick Import, Quick Export, Jobs, History, Settings, Health Check
  • 23 health checks with one-click auto-fix
  • Blazing fast — 10,000 products in seconds, 1 million in a few minutes
  • Scheduled jobs — every minute, hourly, daily, weekly, or custom cron
  • One-click rollback — undo any import instantly
  • REST API for programmatic control
  • WP-CLI commands for server-side automation

1. Admin Menu

Under Webkul WC Addons in your sidebar, you will find these 7 pages:

Menu SlugMenu Title
wkaieImport Export (Dashboard)
wkaie-importQuick Import
wkaie-exportQuick Export
wkaie-jobsJobs
wkaie-historyHistory
wkaie-settingsSettings
wkaie-health-checkHealth Check

All pages require the manage_woocommerce capability.


2. Entity Types (What You Can Import)

Entity dropdownScreenshot: Entity selector — Products, Orders, Customers, Categories, Tags, Attributes, Coupons, Reviews, Posts, Pages, Users.

EntityIn WizardNotes
ProductsYesSimple, variable, variation, grouped, external, virtual, downloadable
OrdersYesWith line items, addresses, payments
CustomersYesWith billing and shipping addresses
CategoriesYesWith full hierarchy
TagsYesProduct tags
AttributesYesColor, Size, Material, and their terms
CouponsYesDiscount codes
ReviewsYesProduct reviews with ratings
PostsYesWordPress blog posts
PagesYesWordPress pages
UsersYesAny WordPress user
SubscriptionsYes (if plugin active)WooCommerce Subscriptions
BookingsYes (if plugin active)WooCommerce Bookings
MembershipsYes (if plugin active)WooCommerce Memberships

3. File Formats

File format dropdownScreenshot: File format dropdown — Auto, CSV, XML, JSON, XLSX, ODS.

FormatNotes
Auto-DetectDefault — plugin figures it out
CSVMost common, auto-delimiter detection (comma, tab, semicolon, pipe)
XMLWith XSLT transformation support
JSONFlat and nested structures
XLSXExcel 2007+
ODSLibreOffice / OpenOffice

Plus auto-extraction for:

  • ZIP archives
  • TAR archives

Multi-byte character sets (UTF-8, UTF-16, Latin-1) are auto-detected and converted.


4. Import Sources

Import source radio group on wizard Step 1Screenshot: Wizard Step 1 — pick one of 11 sources (File Upload, Server Path, URL, FTP, SFTP, Google Sheets, Google Drive, Amazon S3, Dropbox, REST API, WC REST API).

SourceWhat It Does
File UploadDrag and drop a file from your computer
Server PathPick a file already on your server
URLDownload from any HTTPS link
FTPConnect to an FTP server
SFTPSecure FTP with SSH key support
Google SheetsPaste the sheet URL, plugin pulls as CSV
Google DriveConnect with Google account
Amazon S3Connect to your AWS bucket
DropboxPaste a shared link
REST APIPull from any REST endpoint
WooCommerce REST APISync from another WooCommerce store

See Import Sources for setup of each.


5. Export Destinations

Quick Export page with engine, entity, format, preview and runScreenshot: Quick Export page — pick engine, entity, format; Preview shows row/column counts; Run Export produces a download link or pushes to the destination.

DestinationWhat It Does
File DownloadDownload the file in your browser
Server PathSave to a folder on the server
FTPPush to an FTP server
SFTPSecure FTP push
Amazon S3Upload to S3 bucket
DropboxUpload to Dropbox
Google DriveUpload to Drive
Google SheetsWrite rows to a Google Sheet
OneDriveUpload to Microsoft OneDrive
REST APIPOST to any endpoint
WooCommerce REST APIPush to another WooCommerce store
EmailSend as attachment

See Export Destinations.


6. Import Modes

Import mode dropdownScreenshot: Import mode selector — Create Only, Update Only, Create + Update, Delete, Replace.

ModeWhat It Does
Create OnlyAdd new records, skip existing
Update OnlyUpdate existing, skip new
Create + Update (default)Add new AND update existing
DeleteDelete records in the file
ReplaceWipe everything, then import

See Import Modes.


7. Record Matching (for Updates)

Job editor with match-key optionsScreenshot: Job Editor — pick the match key (SKU, ID, Email, Order Number, Slug, or a custom meta field) used to find existing records before update.

To know which record is "existing," the plugin uses a match key.

Match KeyDefault For
SKUProducts
IDAny entity
EmailCustomers, Users
Order NumberOrders
SlugCategories, Tags, Posts, Pages
Custom meta fieldAny entity

Pick in wizard Step 1 or in the job editor.


8. Column Mapping

Wizard Step 2 — Column MappingScreenshot: Step 2 — source columns on the left, target WooCommerce fields on the right, current mappings listed below.

Step 2 of the wizard is the column mapper.

  • Drag-and-drop visual interface
  • Auto-match by column name
  • Add columns not in the file (with default values)
  • "Use only mapped fields" option
  • Save mapping as reusable preset
  • Load a saved preset
  • Preview mapped data before import

Target-field select expanded showing all mappable WooCommerce fieldsScreenshot: Pick any target field from the full list — every WooCommerce column is selectable per source column.

See Column Mapping.


9. Transformations

Change values during import.

TransformationExample
Find and Replacerouge → red
Regex Replace\d+% → [PERCENT]
Case changecotton shirt → Cotton Shirt
Trim whitespace Shirt → Shirt
Strip HTML<b>Red</b> → Red
Prepend / Append001 → WK-001
Number format9.999 → 10.00
Date format14/04/2026 → 2026-04-14
Split multi-valueRed,Blue → array
ConcatenateJohn + Doe → John Doe
Math (add, subtract, multiply, divide, round)10 → 12 (20% markup)
Custom PHPWrite your own snippet

Plus a dedicated Price Rules section for price markups, rounding, and currency conversion.

See Transformations.


10. Migration Presets

Migration preset dropdownScreenshot: Migration preset selector — Shopify, Magento, BigCommerce, PrestaShop, OpenCart, and more.

Pre-built mappings for popular platforms:

  • WooCommerce (default)
  • Shopify
  • Magento 1 and 2
  • BigCommerce
  • PrestaShop
  • OpenCart
  • Amazon Seller
  • eBay File Exchange
  • Google Shopping feed
  • Custom (save your own)

See Migration Presets.


11. Preview / Dry Run (Step 3)

Wizard Step 3 — Preview / Dry RunScreenshot: Step 3 — CREATE / UPDATE / SKIP / FAIL counts, sample row diff, and any validation errors surfaced before any DB write.

Step 3 of the wizard runs a dry run before committing.

  • Run without writing to the database
  • Show counts: CREATE, UPDATE, SKIP, FAIL
  • Preview of first rows
  • Exact error messages per row
  • "Proceed" or "Back" buttons

12. Rollback

Every import saves a snapshot. Undo any import with one click.

  • One-click rollback from History page
  • Selective rollback (undo specific records only)
  • Rollback retention (default 30 days, configurable)
  • Rollback via REST API or WP-CLI

See Rollback.


13. Delta / Incremental Import

Settings — Performance & Advanced tab showing Delta / Incremental optionsScreenshot: Performance & Advanced tab — configure Delta / Incremental Import, hash columns, and watermark skipping.

For stores that re-import the same data often.

  • SHA-256 hash per row
  • Skip rows that did not change
  • Configurable hash columns
  • Optional watermark-based skipping

See Delta Import.


14. Automation and Scheduling

Job Editor — Schedule tabScreenshot: Schedule tab — pick frequency, custom cron, event triggers, delta import.

Cron Schedules

  • Every minute
  • Every 5, 15, or 30 minutes
  • Every hour
  • Every 6 hours
  • Daily at chosen time
  • Weekly on chosen day
  • Monthly on chosen date
  • Custom cron expression

Event Triggers

  • Product saved
  • New order
  • Order status changed
  • Customer registered
  • Stock changed
  • Checkout completed
  • Any custom WordPress hook

Job Chaining

Run multiple jobs in sequence. See Jobs.


15. Quick Export Page

Quick Export page — engine, entity, format, preview, runScreenshot: Quick Export — pick one of 3 engines, 15 entities, 3 formats, preview before running.

Three engines to pick from:

  • Plugin pipeline — the plugin's fast export engine
  • WordPress native — built-in WP exporter (WXR format)
  • WooCommerce native — built-in WC exporter (Products only)

15 entities exportable. 3 formats (CSV, JSON, XML), plus WXR for WP native.

One-click preview to see row counts before running.


16. Health Check

Health Check report with 23 checksScreenshot: Health Check report — 23 data integrity checks with counts, auto-fix, and CSV export.

23 data integrity checks with auto-fix:

  1. Product Count
  2. Product Post Status
  3. Meta Completeness (SKU, Price, Stock)
  4. Product Type Term
  5. Orphaned Term Relationships
  6. Category Assignment
  7. Variable Product Integrity
  8. Variation Parent Linkage
  9. Grouped Product Integrity
  10. Product Image Validity
  11. Price Consistency
  12. Stock Status Consistency
  13. Variable Product Price Range
  14. Upsell Links (SKU resolution)
  15. Upsell Links (ID validity)
  16. Cross-sell Links (SKU resolution)
  17. Cross-sell Links (ID validity)
  18. Product Image URLs
  19. WooCommerce Lookup Table Sync
  20. Orphaned Post Meta
  21. Duplicate SKU Check
  22. Variable Product Attributes
  23. Add to Cart Validation

One-click auto-fix for fixable issues. Export issues as CSV.

See Health Check.


17. History

History page — run log with filters and rollbackScreenshot: History — every run logged with counts, duration, rollback, and downloadable log.

Complete log of every run.

  • Run ID, Job title, Entity, Status, Records (created / updated / skipped / failed), Duration, Images, Date
  • Filters: Status, Entity, Date range, Search
  • Download log file per run
  • Rollback button per run
  • Bulk cleanup of old runs

See History.


18. Dashboard

Dashboard — stat cards, quick actions, recent activityScreenshot: Dashboard top — 4 stat cards, Quick Action buttons, Recent Activity.

Dashboard — System Information cardScreenshot: System Information card — OS detection and fix guides.

4 stat cards:

  • Total Jobs
  • Active Schedules
  • Failed (Last 24h)
  • Total Records Imported

Plus:

  • Quick Action buttons (New Import, New Export, Run Health Check)
  • Recent Activity table (last 10 runs)
  • System Information card with OS detection and "How to fix this" boxes

See Dashboard.


19. Third-Party Plugin Compatibility

Settings — Third-Party Compatibility tabScreenshot: Compatibility tab — flip a switch per plugin, detection badges show what is installed.

Turn on support for 15 plugins in Settings → Compatibility:

SEO

  • Yoast SEO
  • RankMath SEO
  • All in One SEO

Custom Fields

  • Advanced Custom Fields (ACF)
  • Meta Box

Multi-Language

  • Polylang
  • WPML (with sitepress-multilingual-cms OR woocommerce-multilingual)

Multi-Vendor

  • Dokan
  • WCFM Marketplace
  • WC Vendors

WooCommerce Add-ons

  • WooCommerce Product Bundles
  • WooCommerce Composite Products
  • WooCommerce Product Add-ons
  • WooCommerce Brands (also works with Perfect WooCommerce Brands)

See Compatibility.


20. REST API

16 REST endpoints for programmatic control:

Jobs

  • GET /jobs — list
  • POST /jobs — create
  • GET /jobs/{id} — get one
  • PUT /jobs/{id} — update
  • DELETE /jobs/{id} — delete
  • POST /jobs/{id}/run — run
  • POST /jobs/{id}/validate — validate
  • GET /jobs/{id}/progress — live progress
  • POST /jobs/{id}/cancel — cancel

History

  • GET /history — list
  • GET /history/{id} — get one
  • POST /history/{id}/rollback — rollback

Direct

  • POST /import — direct import (no job)
  • POST /export — direct export
  • GET /export/preview?entity=X — preview
  • POST /webhook/{job_id} — webhook receiver

See REST API.


21. WP-CLI Commands

8 command groups:

CommandPurpose
wp wkaie run <job_id>Run a saved job
wp wkaie run-chain <chain_id>Run a chain of jobs
wp wkaie validate <job_id>Validate a job
wp wkaie preview <job_id>Preview a job
wp wkaie jobCreate / list / enable / disable / delete jobs
wp wkaie historyList history, show run details
wp wkaie rollback <run_id>Rollback a run
wp wkaie presetManage mapping presets
wp wkaie-exportDirect export from CLI

See WP-CLI.


22. Speed

The plugin is fast:

  • 10,000 products in seconds
  • 1 million products in a few minutes
  • Multiple imports can run at the same time without slowing each other down
  • Very large files stream without using huge amounts of memory
  • Repeated syncs skip rows that did not change

No more sitting and waiting for a big catalog to finish.


23. Security

  • WordPress capability check (manage_woocommerce required)
  • Nonce verification on every form and AJAX request
  • SQL injection protection (prepared statements)
  • File upload validation
  • Directory traversal protection
  • Customer passwords hashed on import
  • Sensitive fields (API keys, passwords) encrypted with AES-256
  • Credentials never logged
  • Uploaded files deleted after import

24. Licensing

  • One-time purchase, lifetime license
  • No recurring fees
  • 100% open code (no encryption)
  • Free install support
  • 30-day money-back guarantee

Quick Comparison

How the plugin stacks up against common alternatives:

FeatureThis PluginStock WooCommerce ImportOther Popular Importers
14 entity typesYesProducts only5-8 entities
Variable productsYesLimitedYes
Google Sheets live syncYesNoSome
Drag-drop column mappingYesNoYes
Value transformations12 typesBasic3-5 types
Migration presets8 platformsNone2-3 platforms
Import modes523-4
One-click rollbackYesNoRare
Delta / incremental importYesNoNo
Scheduled jobsYesNoSome
Job chainingYesNoNo
Health check (23 checks)YesNoNo
REST API16 endpointsNoLimited
WP-CLI8 command groupsNoSome
Third-party compatibility15 pluginsNone3-5 plugins
PricingOne-timeFreeSubscription

System Requirements

ItemMinimumRecommended
PHP8.18.3
WordPress6.06.9
WooCommerce8.010.6
MySQL8.08.4
Memory256M1G
Max execution time300s0 (unlimited)
pcntl extensionOptionalRequired for speed
posix extensionOptionalRequired for FIFO

See Installation.

Prev
Quick Start — Your First Import in 5 Minutes
Next
Installation — Full Setup Guide