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

Posts Import

Import WordPress blog posts from a CSV, XML, or JSON file.

Quick Import wizard step 1 — upload and configureStep 1 of the Quick Import wizard: pick Posts, upload your blog export, and choose how to match against existing posts (title, slug, or ID).

When to Use

  • Migrating from another CMS (Shopify blog, Squarespace, WordPress.com)
  • Bulk publishing pre-written content
  • Restoring posts from a backup

Match Keys

The plugin finds existing posts by these keys:

  • title (default)
  • slug
  • id (WordPress post ID)

Pick the match key in Step 1 of the wizard.

Column Reference

ColumnRequiredExample
idNo42 (for updates)
titleYes5 Tips for Cotton Care
contentNo<p>Here are five tips...</p> (HTML allowed)
excerptNoLearn how to care for cotton products
statusNo (default publish)publish, draft, pending, private, future, trash
authorNoLogin name, email, or user ID
dateNo2026-04-14 10:30:00
slugNocotton-care-tips
categoriesNoNews, Guides (comma-separated names or IDs)
tagsNocotton, care, tips
featured_imageNohttps://example.com/image.jpg
formatNostandard, aside, gallery, image, link, quote, status, video, audio, chat
comment_statusNoopen or closed
ping_statusNoopen or closed

Example CSV

title,content,status,author,categories,tags,featured_image
5 Tips for Cotton Care,<p>Cotton is a great fabric...</p>,publish,admin,"Guides","cotton, care",https://example.com/cotton.jpg
Summer Collection Launch,<p>Our summer collection...</p>,publish,editor,"News","summer, launch",https://example.com/summer.jpg

Handling Authors

The author column accepts:

  • Login name (e.g., admin)
  • Email (e.g., [email protected])
  • User ID (e.g., 1)

If the author does not exist, the post falls back to the current user running the import.

Handling Categories and Tags

  • Categories and tags that do not exist are auto-created
  • Use commas to separate multiple values

For nested categories:

categories
"Blog > News > 2026"

Separator is > by default. Change in Step 2 → Separators.

Featured Image

Provide an image URL. The plugin:

  1. Downloads the image
  2. Adds it to Media Library
  3. Sets as the post's featured image

Images are cached — the same URL downloads only once even if used by many posts.

Post Status

StatusMeaning
publishLive on the site
draftSaved but not live
pendingAwaiting review
privateVisible only to admins and editors
futureScheduled for a future date
trashSoft-deleted

Post Formats

WordPress supports 9 post formats. Your theme must support them to display differently.

FormatTypical Use
standardRegular blog post
asideShort note
galleryImage gallery
imageSingle image
linkExternal link
quotePulled quote
statusShort status update
videoVideo post
audioAudio post
chatChat transcript

Troubleshooting

ProblemFix
Category not auto-createdCheck "Auto-create categories" in Step 3 of the wizard
Featured image missingCheck Settings → Image & Media → Download Images is on
Date shows 1970Use format Y-m-d H:i:s (e.g., 2026-04-14 10:30:00)
HTML shows as textCheck your CSV properly escapes HTML inside quotes
Author shows as adminThe author in your file does not exist. Create the user first

Wizard step 5 — import results summaryResults screen confirms new posts published, existing posts updated, featured images downloaded, and any authors that fell back to the current user.

Related Pages

  • Pages Import — Import WordPress pages
  • Categories Import — Create categories first
  • Users Import — Create authors first
  • Quick Import Wizard — How to run the import
Prev
Reviews Import — Product Reviews and Ratings
Next
Pages Import — WordPress Pages