How do I add metafield, fulfillment and payment columns?
On this page
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
- In the app, open Templates.
- Click Create template, or use the edit action on one of your templates.
- Click Add column. The Add columns window opens.
- Type part of the column name in Search fields, for example
tracking,metafieldorrefund. - Click the field to add it, then click Done.
- 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.