Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Custom Column in Data Export

How to Create a Custom Column in Data Export

A custom column is a field you create yourself when the built-in fields in a report type do not have the data you need. You give the column a name, choose what kind of data it holds, and add it to your report. There are two kinds of custom columns: calculated columns and static columns.

Steps to create a custom column

  1. Open your report and click the custom column button.

  2. Enter a name for your column.

  3. Choose the data format the column will hold.

  4. Save the column to add it to your report.

Choose a data format for your custom column

The format tells Data Export what kind of data the column holds. Pick the one that matches the data you plan to add.

Format
What it holds
Example

String

Letters, numbers, or a mix of both

Supplier name, product code like CSBK-01

Number

Numbers you can add up or compare

Cost price, shipping weight

Boolean

True or false, shown as 1 for True and 0 for False

Is the product on sale: 1 or 0

Date & Time

A date, day, or time

Restock date, launch date

String or Number: which one to pick

Choose Number if you want to do math with the column, such as add totals, sort from smallest to largest, or use Greater than and Lesser than filters. Numbers stored in a String column are treated as text, so they cannot be used for any calculation.

Types of custom columns

Data Export has two kinds of custom columns:

To see a full example, read how to add metafields to your report with a custom column.

Frequently asked questions

When do I need a custom column? Use a custom column when none of the built-in fields in your report type has the data you want. For example, you may want to show your Shopify metafields or a profit value that you work out from other columns.

Can I change the format after I create the column? Check the column settings in the app. If you cannot change it, delete the column and create a new one with the right format.

Custom Calculated ColumnStatic Column

Last updated