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

Plugin Settings

The Settings page is where you set defaults and save credentials once so you don't retype them on every job.

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

Page title: "Import/Export Settings"

The 7 Tabs

Click each tab at the top of the page to switch.

TabWhat It Controls
GeneralDefault mode, entity, format, batch size, separators
Email NotificationsEmail on success and failure
Notification ChannelsSlack, Teams, Telegram, WhatsApp, webhooks
Cloud Storage & APIGoogle, S3, Dropbox, OneDrive, FTP credentials
Image & MediaImage download, resize, watermark
Performance & AdvancedWorker count, batch size, retention
Third-Party Compatibility15 plugin integrations

Tab 1 — General

Settings — General tabSettings → General tab with default values.

Field Reference

#Field LabelWhat It Does
1Default Import ModePre-selects the mode on new import jobs (Create Only, Update Only, Create + Update, Delete, Replace)
2Default Entity TypePre-selects the entity (Products, Orders, Customers, etc.)
3Default File FormatPre-selects the format (CSV, XML, JSON, XLSX, ODS)
4Default Batch SizeHow many rows process per batch. Min 50, max 100,000
5Default Match KeyHow to find existing records: SKU, ID, Email, Slug, Order Number, Title, Coupon Code
6Default Export EntityPre-selects entity on Quick Export (Products, Orders, etc.)
7Default Export FormatPre-selects export format (CSV, JSON, XML)
8Category Level SeparatorSymbol for nested categories. Default: >
9Multiple Value SeparatorSymbol for multiple values in one cell. Default: |
10Empty Value ConstantString that means "clear the field." Default: __EMPTY__VALUE__
11Validation StrategyStrict, Lenient, Skip Errors, Stop on Error, or Force
12Max Allowed ErrorsStop after N errors. 0 = unlimited

Recommended Batch Sizes

Store SizeBatch Size
Under 10,000 products500
10,000 to 100,0001000
100,000 to 1 million2000
Over 1 million5000

Validation Strategy Options

StrategyWhat It Does
StrictFail the whole import if any row has errors
LenientLog warnings but import everything
Skip ErrorsSkip bad rows, continue with good ones
Stop on ErrorStop at the first error
ForceIgnore validation, import everything

Click Save Changes

The button at the bottom of the tab says Save Changes.

Tab 2 — Email Notifications

Settings — Email tabSettings → Email Notifications tab.

Field Reference

#Field LabelWhat It Does
1Email on Success (checkbox)Send email when a job completes successfully
2Email on Failure (checkbox)Send email when a job fails
3Recipient Email AddressesComma or newline-separated list. Empty = WP admin email
4CC Email AddressesCarbon-copy list
5BCC Email AddressesBlind copy list
6Custom Sender Name"From" name in emails
7Custom Sender Email"From" address. Must be valid for your server

Subject and Body Templates

Further down, you can customize email subject and body with these variables:

VariableValue
{job_title}Name of the job
{status}"Success" or "Failed"
{record_count}Total rows processed
{entity_type}"Products", "Orders", etc.
{error_count}Number of errors

Setting Up SMTP

WordPress's built-in mail is often broken. See Email Setup for configuring SMTP via WP Mail SMTP or SendGrid.

Tab 3 — Notification Channels

Settings — Notification Channels tabScreenshot: Slack, Microsoft Teams, Telegram, WhatsApp, and Custom Webhook channels.

For team notifications beyond email.

Slack Section

  • Slack Webhook URL — paste the webhook from your Slack app
  • Test Connection button

Microsoft Teams Section

  • Teams Webhook URL — from Teams connector
  • Test Connection button

Telegram Section

  • Bot Token — from @BotFather on Telegram
  • Chat ID — your chat or channel ID
  • Test Connection button

WhatsApp Section

  • API URL — your WhatsApp API endpoint
  • API Token — API token
  • Phone Number — with country code, e.g., +1234567890

Custom Webhook Section

  • Webhook URL — any URL that accepts POST
  • Secret Key — for validating the request
  • HTTP Method — POST or PUT

Tab 4 — Cloud Storage & API

Settings — Cloud Storage & API tabScreenshot: Google APIs, Dropbox, OneDrive / Azure AD, Amazon S3, FTP, and SFTP credentials in one place.

Credentials for remote sources and destinations.

Google APIs Section

FieldWhat It Does
Client IDOAuth Client ID from Google Cloud
Client SecretOAuth Client Secret
Google Sheets API KeyRead-only access to public sheets

Setup details: Google API Setup.

Dropbox Section

FieldWhat It Does
App KeyDropbox app key
App SecretDropbox app secret

Setup details: Dropbox Setup.

OneDrive / Azure AD Section

FieldWhat It Does
Tenant IDAzure AD tenant ID
Client IDAzure AD app client ID
Client SecretAzure AD app client secret

Amazon S3 Section

FieldWhat It Does
Access KeyAWS IAM Access Key ID
Secret KeyAWS IAM Secret Access Key
Default RegionDropdown with all AWS regions
Default BucketBucket name

Setup details: Amazon S3 Setup.

FTP Section (Default Credentials)

FieldExample
Hostftp.example.com
Port21
Usernameyour user
Password(hidden)
Passive ModeCheckbox

SFTP Section (Default Credentials)

FieldExample
Hostsftp.example.com
Port22
Usernameyour user
Password(hidden)
Key PathPath to SSH private key

Tab 5 — Image & Media

Settings — Image & Media tabScreenshot: Image handling controls — download, resize, watermark, and media library rules.

Field Reference

FieldWhat It Does
Download ImagesDownload product images to Media Library during import
Use External URLsSkip download, use URLs directly
Deferred Image ImportFinish import first, download images in background
Resize ImagesResize after download
Max Image WidthMaximum width in pixels
Max Image HeightMaximum height in pixels
Apply WatermarkAdd watermark to imported images
Watermark TypeText or Image
Watermark TextYour watermark text
Watermark Image URLURL of watermark image (e.g., logo)
Watermark PositionTop-left, Top-right, Bottom-left, Bottom-right, Center
Watermark Opacity0 (invisible) to 100 (solid)
Delete Source on ImportDelete the image file from FTP/SFTP after import

Details: Image Handling.

Tab 6 — Performance & Advanced

Settings — Performance & Advanced tabScreenshot: Delta / Incremental Import, RabbitMQ, and tuning knobs for large-scale runs.

Settings for server-level performance.

FieldWhat It Does
Worker CountNumber of parallel workers. 0 = auto-detect CPU cores
Grain Size (MB)File chunk size per worker. Default 8
Disable Indexes During ImportSpeed boost. Default on
Disable Foreign Key ChecksSpeed boost. Default on
Use MyISAM Staging2x faster staging. Default on
Staging Table RetentionHow long to keep staging after failed import
Log LevelError / Warning / Info (default) / Debug
Log Retention (Days)Auto-delete logs after N days
Rollback Retention (Days)Auto-delete rollback snapshots after N days
Max Log Size per Run (MB)Cap log file size

Advanced Buttons (Bottom of Tab)

  • Export Settings — download JSON backup of all settings
  • Import Settings — restore from JSON backup
  • Reset Plugin — wipe everything and start fresh

Reset is final

Reset wipes jobs, history, mappings, settings. Cannot be undone. Use only when you really want a clean slate.

Tab 7 — Third-Party Compatibility

Turn on integration with 15 popular plugins.

Settings — Compatibility tabCompatibility tab — each plugin with detection badge and toggle.

For each plugin, a status badge appears:

  • Detected: Active (green) — plugin is installed and active
  • Installed but inactive (yellow) — activate the plugin
  • Not installed (gray) — install it first

Check the box next to each plugin you want to support.

The 15 plugins supported:

  • Yoast SEO
  • RankMath SEO
  • All in One SEO
  • Advanced Custom Fields (ACF)
  • Meta Box
  • WPML
  • Polylang
  • Dokan
  • WCFM Marketplace
  • WC Vendors
  • WooCommerce Brands
  • WooCommerce Product Bundles
  • WooCommerce Composite Products
  • WooCommerce Product Add-ons

Full details: Compatibility.

Save Changes

Every tab has a Save Changes button at the bottom. Click after editing.

Troubleshooting

ProblemFix
"Save Changes" does nothingCheck your user role has manage_options capability
Tab does not switchClear browser cache. JS may be stuck
Google API key works but OAuth failsRedirect URI in OAuth app must match your site URL exactly
S3 credentials test failsCheck IAM permissions. Need s3:GetObject and s3:ListBucket at minimum
FTP test passes but import failsFTP server may block passive mode. Try SFTP or Active mode
Email notifications never arriveWordPress mail is often broken. See Email Setup
Compat plugin shows "Not installed"Main plugin file path may differ. Install the exact plugin

Related Pages

  • Compatibility — Third-party plugin integrations
  • Import Sources — Use saved credentials
  • Email Setup — Make email actually work
  • Google API Setup
  • Amazon S3 Setup
  • Dropbox Setup
Prev
Quick Export — One-Page Export Tool
Next
Compatibility — Third-Party Plugin Support