This reference lists the settings and the Excel fields used by All In One WooCommerce Migration: Import & Export to Excel. Settings are in WPFactory > Store Migration > Settings; fields appear on each import mapping screen after you upload an .xlsx file.
Settings #
| Label | Option ID | Type | Default | Free/Pro |
|---|---|---|---|---|
| Import/Export Product Custom Fields | eshopMigrationWooCommerceProproductCustomFields |
Select (Select.., Yes, No) | Empty (custom fields off) | Pro (paid plugin) |
With Yes, product import and export list the non-underscore meta keys found on your existing products (ACF fields, for example). When Yoast SEO is active, _yoast_wpseo_title, _yoast_wpseo_metadesc and _yoast_wpseo_focuskw are added. If no custom fields show, create a test product with a title, publish it, and reload the screen.
How Auto Match Columns works #
Auto match compares each Excel header with the field name in upper case, with underscores shown as spaces and a leading underscore removed. So post_title matches POST TITLE, _sku matches SKU and _regular_price matches REGULAR PRICE. Headers must match exactly, including spaces.
Product fields #
| Excel header for auto match | Field | Notes |
|---|---|---|
| ID | ID |
For updates only. |
| POST TITLE | post_title |
Product name; used to find existing products. |
| POST AUTHOR | post_author |
User ID. |
| POST NAME | post_name |
Shown as URL/SLUG. |
| POST STATUS | post_status |
publish if empty. |
| POST CONTENT / POST EXCERPT | post_content, post_excerpt |
HTML allowed; script tags are removed. |
| SKU, WEIGHT, LENGTH, WIDTH, HEIGHT | _sku, _weight, _length, _width, _height |
|
| REGULAR PRICE / SALE PRICE | _regular_price, _sale_price |
Numbers only. |
| STOCK / STOCK STATUS | _stock, _stock_status |
0 or outofstock sets out of stock. |
| VARIATION DESCRIPTION | _variation_description |
Variable products. |
| DOWNLOADABLE, DOWNLOAD NAME, DOWNLOAD FILE, DOWNLOAD LIMIT, DOWNLOAD EXPIRY | _downloadable, download_name, download_file, _download_limit, _download_expiry |
Names and files comma separated, in the same order. |
| VIRTUAL, PURCHASE NOTE, SOLD INDIVIDUALLY, BACKORDERS, FEATURED | _virtual, _purchase_note, _sold_individually, _backorders, _featured |
Use WooCommerce values such as yes/no. |
| UPSELL IDS / CROSSSELL IDS | _upsell_ids, _crosssell_ids |
Comma separated product IDs. |
| TAX STATUS / TAX CLASS | _tax_status, _tax_class |
|
| MENU ORDER | menu_order |
|
| PRODUCT URL / BUTTON TEXT | _product_url, _button_text |
External/Affiliate products. |
| SUBSCRIPTION PRICE, PERIOD INTERVAL, PERIOD, LENGTH, SIGN UP FEE, TRIAL LENGTH, TRIAL PERIOD, LIMIT, ONE TIME SHIPPING | _subscription_* |
WooCommerce Subscriptions products. |
| IMAGE / IMAGE GALLERY | image, _product_image_gallery |
URL or Media Library name; gallery comma separated. |
| PRODUCT CAT, PRODUCT TAG, PA COLOR … | Taxonomy names | Comma separated terms; missing terms are created. |
Order fields #
order_date, order_pay_date, order_status, product_ids, quantities, first_name, last_name, company, email, phone, address_1, address_2, city, state, postcode, country, shipping_method, shipping_amount, payment_method, coupon_code. Details: How to import WooCommerce orders from Excel.
Customer, coupon and review fields #
| Import | Fields |
|---|---|
| Customers | EMAIL, USERNAME, PASSWORD, URL – WEBSITE, plus user meta keys from your admin profile. |
| Coupons | coupon_code, coupon_amount, coupon_description, status, author, discount_type, individual_use, product_ids, exclude_product_ids, usage_limit, expiry_date, apply_before_tax, free_shipping |
| Reviews | comment_post_ID (product ID or title), comment_approved, comment_author, comment_author_email, comment_author_url, comment_content, comment_type, comment_parent, user_id, comment_author_IP, comment_agent, comment_date, rating |
| Terms (fixed columns) | A name, B description, C slug, D parent, E YITH value, F YITH tooltip |
Developers #
Version 3.0.2 has no public filters or actions for customizing imports or exports.

Store Migration
Get more from Store Migration
See every feature and the pricing on the Store Migration plugin page.
Need a hand? Our team answers every ticket on the Store Migration support forum.