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

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

  1. Open your report in the report viewer.

  2. Click Add Column.

  3. Find the Custom Column category.

  4. Click Custom Properties, then click Add +.

  5. In the Add Custom Properties pop-up, choose Line-item properties as the property type.

  6. Enter a name for your column.

  7. Choose the key for the property you want to show, such as “Engraving” or “Gift message.”

  8. 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:

Order
Product
Engraving Text

#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:

Property type
What it is
Example

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.

  1. Add the Line Item ID column to your report.

  2. Click Add Columns, then click Calculated Columns.

  3. Enter Order Line Item Properties as the field name.

  4. In the formula box, paste this formula:

  1. 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