Set up fields to export

The “Set up fields to export” block allows you to configure any fields for export.

To add fields to the report, you need to drag & drop the required fields from the right block. All fields are divided into categories.

The difference between the “Product” category and the “Product order items” category is that the “Product” category fields refer directly to the product characteristics in WooCommerce, while the “Product order items” category fields refer to the characteristics of the order items.

You can create custom fields to display in the report. To do this, go to the desired category and click on the “Add field” button. You need to select the “Meta key” value, add the value to the “Column name” and “Field format” fields (string only for XLS), and press the “Confirm” button.

Or click on the “Add static field” button. Enter a value in the “Column name” field, you can fill in the “Value” field or leave it empty, select the value of the “Field format” field and click the “Confirm” button”.

To delete all selected fields, click the “Remove all fields” button.

To delete a single field, click the icon .

In this block, you can place the fields as convenient. For xml and json formats, you can group fields by products and coupons.

You can add the following fields:

Common:

  • Line number
  • Order ID
  • Order Number
  • Order Status
  • Order Date
  • Modification Date
  • Transaction ID
  • Currency
  • Completed Date
  • Paid Date
  • Date of first refund
  • Customer Note
  • Order Notes
  • Link to edit order

Customer:

  • Customer IP address
  • Customer User ID
  • Customer Username
  • User Website
  • Customer User Email
  • Customer Role
  • Customer Total Orders
  • Customer Total Spent
  • Customer first order date
  • Customer last order date

Billing Address:

  • First Name (Billing)
  • Last Name (Billing)
  • Full Name (Billing)
  • Company (Billing)
  • Address 1&2 (Billing)
  • Address 1 (Billing)
  • Address 2 (Billing)
  • City (Billing)
  • State Code (Billing)
  • City, State, Zip (Billing)
  • City, State Zip (Billing)
  • State Name (Billing)
  • Postcode (Billing)
  • Country Code (Billing)
  • Country Name (Billing)
  • Email (Billing)
  • Phone (Billing)

Shipping Address:

  • First Name (Shipping)
  • Last Name (Shipping)
  • Full Name (Shipping)
  • Company (Shipping)
  • Address 1&2 (Shipping)
  • Address 1 (Shipping)
  • Address 2 (Shipping)
  • City (Shipping)
  • State Code (Shipping)
  • City, State, Zip (Shipping)
  • City, State Zip (Shipping)
  • State Name (Shipping)
  • Postcode (Shipping)
  • Country Code (Shipping)
  • Country Name (Shipping)

Products:

  • SKU
  • SKU (parent)
  • Product Id
  • Product Name
  • Product Name (main)
  • Product Variation
  • Variation Id
  • Product Seller
  • Product Current Price
  • Type
  • Category
  • Tags
  • Width
  • Length
  • Height
  • Weight
  • Stock Status
  • Stock Quantity
  • Product URL
  • Download URL
  • Image URL
  • Product Shipping Class
  • Description
  • Short Description
  • Full names for categories
  • Non variation attributes
  • Embedded Product Image

Product order items:

  • Item ID
  • Item #
  • Item Name
  • Quantity
  • Quantity (- Refund)
  • Item Cost
  • Item Cost (inc. tax)
  • Item Cost Before Discount
  • Order Line (w/o tax)
  • Order Line Tax
  • Order Line Tax Refunded
  • Order Line Tax (- Refund)
  • Order Line Subtotal
  • Order Line Subtotal Tax
  • Order Line Total
  • Order Line Total (include tax)
  • Order Line Total Refunded
  • Order Line Total (- Refund)
  • Item Discount Amount
  • Item Tax Rate
  • Item download URL
  • Order Item Metadata
  • Item Discount Tax
  • Item Discount Amount + Tax

Product totals:

  • Total weight
  • Total items
  • Exported items
  • Total products

Coupons:

  • Coupon Code
  • Discount Amount
  • Discount Amount Tax
  • Discount Amount + Tax
  • Coupon Description
  • Coupon Type
  • Coupon Amount

Cart:

  • Payment Method Title
  • Payment Method
  • Number of coupons used
  • Cart Discount Amount
  • Cart Discount Amount Tax
  • Order Subtotal Amount
  • Order Subtotal Amount + Cart Tax
  • Order Subtotal – Cart Discount
  • Order Subtotal Amount Refunded
  • Order Subtotal Amount (- Refund)
  • Cart Tax Amount

Shipping:

  • Shipping Method Title
  • Shipping Method
  • Shipping Method (no id)
  • Shipping Zone
  • Order Shipping Amount
  • Order Shipping + Tax Amount
  • Order Shipping Amount Refunded
  • Order Shipping Amount (- Refund)
  • Order Shipping Tax Amount
  • Order Shipping Tax Refunded
  • Order Shipping Tax Amount (- Refund)

Totals:

  • Order Total Fee
  • Order Refund Amount
  • Order Total Amount (- Refund)
  • Order Total Amount
  • Order Total Amount without Tax
  • Order Total Tax Amount
  • Order Total Tax Amount Refunded
  • Order Total Tax Amount (- Refund)