Black Friday All Access $999 $399 lifetime or 30% off any plugin with Ends in -- See deals
View Categories

Order and Order Item Export Fields Reference

This reference lists every field available in the Orders and Orders Items sections of Export Products, Orders & Customers for WooCommerce, with each field’s ID. All fields are free except where marked Pro.

Select fields under WPFactory > Export (also reachable at WooCommerce > Settings > Export).

Export Orders fields #

Field Field ID Free/Pro
Order ID order-id Free
Order Number order-number Free
Order Status order-status Free
Order Date order-date Free
Order Time order-time Free
Order Item Count order-item-count Free
Order Items order-items Free
Order Product Input Fields order-product-input-fields Free
Order Currency order-currency Free
Order Total order-total Free
Order Total Tax order-total-tax Free
Order Shipping Total order-shipping-total Free
Order Payment Method order-payment-method Free
Order Notes order-notes Free
Customer ID customer-id Free
Shipping Method shipping-method Free
Billing fields (first/last name, company, address 1 and 2, city, state, postcode, country, phone, email) billing-first-name … billing-email Free
Shipping fields (first/last name, company, address 1 and 2, city, state, postcode, country) shipping-first-name … shipping-country Free
Backend Order Notes backend-order-notes Pro

Export Orders Items fields #

Each row is a single line item. The order-level fields repeat on every item row for context.

Field Field ID Free/Pro
Order context (ID, Number, Status, Date, Time, Item Count, Currency, Total, Total Tax, Shipping Total, Payment Method, Order Notes, billing and shipping fields) order-id … shipping-country Free
Item Id item-id Free
Item Name item-name Free
Item SKU item-sku Free
Item Product Input Fields item-product-input-fields Free
Item Meta item-meta Free
Item Variation Meta item-variation-meta Free
Item Quantity item-qty Free
Item Tax Class item-tax-class Free
Item Product ID item-product-id Free
Item Variation ID item-variation-id Free
Item Line Subtotal item-line-subtotal Free
Item Line Total item-line-total Free
Item Line Subtotal Tax item-line-subtotal-tax Free
Item Line Tax item-line-tax Free
Item Line Subtotal Plus Tax item-line-subtotal-plus-tax Free
Item Line Total Plus Tax item-line-total-plus-tax Free
Backend Order Notes backend-order-notes Pro

Tip: to include data not in these lists, add a custom column with the additional meta fields (see the meta-field how-to). On Order Items, each meta column can read from order meta or product meta.

wpf Products Order Customers export For woocommerce Icon

Export WooCommerce

Get more control

All standard order and item fields are free. Export Products, Orders & Customers for WooCommerce Pro adds the Backend Order Notes field and unlimited custom meta columns.