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

Migration Presets

Moving from another platform? The plugin has built-in templates for the most popular ones. No manual column mapping needed.

Migration preset dropdown expandedScreenshot: Migration Preset dropdown — Shopify, Magento 1/2, BigCommerce, PrestaShop, OpenCart, Amazon, eBay, Google Shopping, and more.

Available Presets

PresetFor Files Exported From
WooCommerceDefault WooCommerce CSV format
ShopifyShopify product CSV export
Magento 1Magento 1.x CSV export
Magento 2Magento 2.x CSV export
BigCommerceBigCommerce product export
PrestaShopPrestaShop CSV export
OpenCartOpenCart export
Amazon SellerAmazon flat file
eBayeBay File Exchange
Google ShoppingGoogle product feed XML
CustomSave your own mapping as a preset

How to Use a Preset

Step 1 — Export from the Old Platform

Export your data from the source platform as CSV (or XML for Google Shopping).

  • Shopify: Admin → Products → Export → All products → CSV
  • Magento 2: System → Data Transfer → Export → Products → CSV
  • BigCommerce: Products → Export → Bulk Edit
  • PrestaShop: Catalog → Products → Export
  • Amazon: Seller Central → Inventory → Add Products via Upload

Step 2 — Upload to This Plugin

  1. Open the Quick Import Wizard
  2. Pick Products as entity
  3. Pick File Upload as source
  4. Pick CSV as format
  5. Upload your exported file

Step 3 — Select the Preset

On the same Step 1, find the Migration Preset dropdown.

Migration preset dropdownMigration preset — pick your source platform.

Select the preset that matches your source (e.g., Shopify).

Step 4 — Click Next

The plugin auto-configures:

  • Column mapping (Shopify column names → WooCommerce fields)
  • Value translations (Shopify values → WooCommerce values)
  • Transformations (date format, price format)
  • Category separator
  • Special fields handling

Step 5 — Review and Import

You can still tweak the mapping in Step 2 if needed. Most presets get 95%+ columns right out of the box.

What Each Preset Does

Shopify

Maps these Shopify columns to WooCommerce:

ShopifyWooCommerce
HandleSlug
TitleName
Body (HTML)Description
VendorBrand (if brands plugin active)
TypeProduct type
TagsTags
PublishedStatus
Option1 NameAttribute 1 name
Option1 ValueAttribute 1 values
Variant SKUSKU
Variant GramsWeight (converted to kg)
Variant Inventory QtyStock quantity
Variant PriceRegular price
Variant Compare At PriceRegular price (if "Variant Price" becomes sale price)
Image SrcFeatured image + gallery

Magento 1 and 2

Both Magento presets map these common columns:

MagentoWooCommerce
skuSKU
nameName
descriptionDescription
short_descriptionShort description
priceRegular price
special_priceSale price
qtyStock quantity
categoriesCategories (with / separator)
visibilityVisibility (enum mapped)
statusStatus
weightWeight
base_imageFeatured image
additional_imagesGallery images

Magento's visibility values are translated:

MagentoWooCommerce
Catalog, Searchvisible
Not Visible Individuallyhidden
Catalogcatalog
Searchsearch

BigCommerce

BigCommerceWooCommerce
Product NameName
Product SKUSKU
Product TypeProduct type
Product DescriptionDescription
PriceRegular price
Sale PriceSale price
Current Stock LevelStock
CategoryCategories
Brand NameBrand
Product WeightWeight
Product Image ID - 1Featured image
Product Image ID - 2..NGallery

PrestaShop

PrestaShopWooCommerce
Product IDID
Active (0/1)Status
NameName
Categories (x,y,z...)Categories
Price tax excludedRegular price
Tax rules IDTax class
Wholesale price(ignored)
Reference #SKU
Stock quantityStock
Short descriptionShort description
DescriptionDescription
Image URLs (x,y,z...)Images

OpenCart

OpenCartWooCommerce
product_idID
skuSKU
nameName
descriptionDescription
priceRegular price
quantityStock
statusStatus
categoriesCategories
imageFeatured image
additional_imagesGallery

Amazon Seller (Flat File)

Maps Amazon's flat file columns:

AmazonWooCommerce
seller-skuSKU
item-nameName
item-descriptionDescription
product-id(used for match key)
standard-priceRegular price
quantityStock
main-image-urlFeatured image
other-image-url1..NGallery

Google Shopping

For XML feeds exported from Google Merchant Center.

Handles:

  • Product ID → SKU
  • Title → Name
  • Description → Description
  • Link → External URL
  • Image link → Featured image
  • Additional image link → Gallery
  • Brand → Brand
  • Condition → (custom meta)
  • Availability → Stock status
  • Price → Regular price

Create a Custom Preset

Already did a mapping you want to reuse? Save it.

  1. Finish the Step 2 column mapper
  2. Click Save Mapping at the top of Step 2
  3. Give it a name (e.g., "My Supplier X Format")
  4. Click Save

Share Presets Across Sites

  1. Go to Settings → Presets
  2. Click Export next to a preset
  3. Download the JSON file
  4. On another site, Settings → Presets → Import and upload the JSON

Post-Migration Checklist

After importing from another platform, verify:

  • [ ] Product count matches (use Health Check)
  • [ ] Prices look right (spot-check 10 products)
  • [ ] Images downloaded (check Media Library)
  • [ ] Categories have the right hierarchy
  • [ ] Variable products have their variations
  • [ ] SEO data imported (if using compat plugins)
  • [ ] Reviews imported (if you did a separate review export)
  • [ ] Customers and orders (if you want history)

Multi-Step Migration

Big migrations usually go in this order:

  1. Customers first — so orders can link to them
  2. Categories and tags — so products can assign them
  3. Attributes and terms — same reason
  4. Products — the main step
  5. Orders — historical orders
  6. Reviews — after products exist

Each step is a separate import. You can save each as a job for easy re-runs.

Common Migration Gotchas

Shopify Handles Become Slugs

Shopify's "Handle" column becomes the WooCommerce slug. If you want to keep URLs the same, make sure slugs match.

Magento Category Hierarchy

Magento exports categories as Category 1/Subcategory/Sub-subcategory. We convert / to > automatically, but check Step 2 → Separators to confirm.

BigCommerce Product Type

BigCommerce uses custom product types. Our preset maps common ones (Physical, Digital). Custom types need manual mapping.

Variable Products From Shopify

Shopify doesn't have a "variable product" concept — each variation is a row. Our preset auto-groups variants by Handle.

Images on a Different Domain

When images are on the old platform's CDN, the plugin downloads them to your Media Library. This can take time for 10,000+ products. Turn on Deferred Image Import in Settings for speed.

Troubleshooting

ProblemFix
Preset dropdown is emptyPresets load only when entity is "Products"
Categories all imported as one big stringCheck Step 2 → Separators → Category hierarchy
Shopify variants did not groupMake sure your CSV has the Handle column
Prices show as 0Check the decimal separator (European uses ,, US uses .)
Images failed to downloadSource domain might block hotlinking. Download locally first
Wrong tax classMagento tax rules do not translate 1:1 — map manually

Related Pages

  • Column Mapping — Tweak auto-mappings
  • Transformations — Change values during import
  • Quick Import Wizard — Run the migration
  • Health Check — Verify after migration
Prev
Transformations — Change Values During Import
Next
Delta Import — Skip Unchanged Rows