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
Open your report and click the custom column button.
Enter a name for your column.
Choose the data format the column will hold.
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.
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:
Calculated columns use a formula to work out a new value from other columns in your report.
Static columns hold a fixed value that you enter yourself.
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 ColumnLast updated