Help CenterContact support
All Columna: Order Export & Sheets articles

How do I add metafield, fulfillment and payment columns?

Updated

On this page
  1. Steps
  2. Verify it worked
  3. Metafield columns
  4. Fulfillment and shipping columns
  5. Payment columns
  6. Refund, tax and currency columns
  7. Troubleshooting

Add metafields, tracking numbers, line item fulfillment status, payment and refund details to an export template. This lists the columns and where to find them.

Steps

  1. In the app, open Templates.
  2. Click Create template, or use the edit action on one of your templates.
  3. Click Add column. The Add columns window opens.
  4. Type part of the column name in Search fields, for example tracking, metafield or refund.
  5. Click the field to add it, then click Done.
  6. Click Save.

Verify it worked

  • The new column appears in the template’s column list.
  • The preview shows the first rows with values from your orders.

Metafield columns

The Order metafields, Product metafields and Variant metafields groups list the metafield definitions of your store, sorted by name. Metafields without a definition in Shopify are not listed.

Group Default column name Rows
Order metafields Metafield: and the definition name One value per order
Product metafields Product metafield: and the definition name One value per line item, from the item’s product
Variant metafields Variant metafield: and the definition name One value per line item, from the item’s variant

Product and variant metafields belong to a line item. Use One row per line item in Rows to give each item its own value.

Fulfillment and shipping columns

Column Group What it shows
Fulfillment status Order The order’s fulfillment status.
Fulfilled at Order Every fulfillment date of the order.
Tracking number, Tracking company, Tracking URL Shipping address The tracking details of the order’s fulfillments. Several values are joined with a comma.
Shipping method Shipping address The shipping method of the order.
Unfulfilled quantity, Fulfilled quantity Line item How many units of the item are still to ship and how many shipped.
Line item fulfillment status Line item Fulfilled, Partially fulfilled, Unfulfilled or Removed.
Current quantity Line item The quantity after items were removed or refunded.
Requires shipping Line item Whether the item needs shipping.

With One row per unit, each unit row shows Fulfilled or Unfulfilled. Fulfilled units come first.

Payment columns

Column Group What it shows
Financial status Order The order’s payment status.
Payment gateways Order The payment methods used on the order.
Amount to collect Order The amount still due on the order, for example for cash on delivery.
Paid at Accounting When the order was paid, read from the order’s first 10 transactions.
Transaction gateways, Transaction kinds, Transaction statuses, Transaction amounts, Transaction dates Accounting The details of the order’s transactions.

Refund, tax and currency columns

All in the Accounting group:

Column What it shows
Refund dates, Refund notes The date and note of each refund.
Tax lines The tax lines of the order.
Total weight (g) The order weight in grams.
Presentment currency, Presentment total The currency the customer paid in and the total in that currency.
Item tax lines, Item tax The tax lines and tax amount of a line item.
Item discount allocated The discount given on a line item.
Item refunded quantity, Item refunded amount How much of a line item was refunded.

Refund columns read up to 5 refunds per order, with up to 10 refunded items each.

The Order group also has Subtotal, Shipping, Taxes, Discounts, Total, Refunded and Net total after refunds (the total after refunds and returns; Total stays the amount the order was placed for), and the Line item group has Unit price, Compare-at price and Discounted total.

Troubleshooting

A metafield is missing from the list. Only metafields with a definition are listed. Add a definition for it in Shopify admin under Settings > Custom data, then open the template again.

You see “{name} is already added”. That field is already a column in the template.

A product or variant metafield column is empty on some rows. The product or variant of that item has no value for the metafield.

Built and supported by StoreFleet, Shopify app developers since 2021.