Custom Properties
How to Add Order Line Item Properties to Your Report
Order line item properties are extra details a customer adds to a product when they buy it, such as engraving text, a gift message, or a custom size. The easiest way to add them to your report is with Custom Properties. You pick the property type, choose the key you want, give the column a name, and save. No formula is needed.
Add line item properties with Custom Properties
Open your report in the report viewer.
Click Add Column.
Find the Custom Column category.
Click Custom Properties, then click Add +.
In the Add Custom Properties pop-up, choose Line-item properties as the property type.
Enter a name for your column.
Choose the key for the property you want to show, such as “Engraving” or “Gift message.”
Click Save.
Your report now shows the line item property for each order line.

Example
If you choose the key “Engraving” and name the column Engraving Text, your report will look like this:
#1001
Engraved Bracelet
Priya
#1002
Engraved Bracelet
Rahul
#1003
Coffee Mug
(empty)
Line items with no value for that key show an empty cell.
Other custom properties you can add
The same Add Custom Properties pop-up also lets you add metafields and note attributes. Choose the property type that holds the data you need:
Line-item properties
Details a customer adds to one product in an order
Engraving text, custom size
Note attributes
Details added to the whole order, often at the cart
Delivery date, gift wrap request
Metafields
Extra fields you or your apps save in Shopify
Product material, customer birthday
Metafield types
If you choose Metafields, pick where the metafield is saved in Shopify:
Order metafields
Product metafields
Customer metafields
Variant metafields
Collection metafields
Then enter a column name, choose the key, and save, the same as for line item properties.
Another way: use a calculated column
Before Custom Properties, line item properties were added with a calculated column and a formula. This method still works, but we suggest Custom Properties since it is faster and needs no formula.
Add the Line Item ID column to your report.
Click Add Columns, then click Calculated Columns.
Enter Order Line Item Properties as the field name.
In the formula box, paste this formula:
Save the column.
The formula uses the Line Item ID to find the properties for each line. Keep ::bigint and 5 in the formula exactly as shown, or it will not work.
If the column does not show any data
Check these common problems:
The wrong property type is selected. Line item properties, note attributes, and metafields are saved in different places. Make sure you chose the type that holds your data.
The key is wrong. Check the key name in one of your Shopify orders and pick the same one.
The orders have no properties. Not every product collects properties. Check one order in Shopify to confirm it has them.
Frequently asked questions
What is the difference between line item properties and note attributes? Line item properties belong to one product in the order, such as engraving on a bracelet. Note attributes belong to the whole order, such as a requested delivery date.
Can I filter or sort by these columns? Yes. Once the column is in your report, you can filter and sort it like any other column. To learn more, see How to Filter a Report in Data Export.
Last updated