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.

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. See what Pro unlocks.