What Is the Line Item Properties Report?
The Line Item Properties report brings ordered products and the custom details attached to them into one export. Review engraving text, monogram initials, chosen fonts, custom measurements or uploaded-file references beside the order, customer, product, variant and quantity.
Use the report to prepare a production sheet, check personalization instructions and share item details with the people making or packing an order. The reporting period follows the order dates you select. An item with several properties may appear across multiple rows; check the output layout before totaling quantities.
Report Overview
- Report type
- Sales & Orders; ordered items with their attached properties.
- Report period
- Your selected order date range. Order Date is not a promised delivery or production date.
- Data included
- Order and customer details, product and variant, quantity, property name and property value.
- Best use and formats
- Production checks and personalized order exports in Excel, CSV or PDF.
- Automation
- Schedule delivery by email or to a supported Google Sheets or Google Drive destination, subject to your configuration.
What Can You Learn from Line Item Properties?
1. What each item needs before production
Read the property label and value alongside the product and variant to identify the instructions attached to each item.
Example: For example, a pendant has Engraving set to “Always, Mia”.
What you can do: Keep the text exactly as entered when preparing the production sheet.
2. Which recorded details need checking
Review the displayed values for unclear wording or measurements that need clarification. A property that is absent from the output is not proof that every required detail was supplied.
Example: For example, a curtain measurement is saved as “120” without a unit.
What you can do: Confirm the unit with the customer before cutting.
3. Which personalization options appear most often
Summarize a consistent property, such as Font, in Excel or Google Sheets to compare selections. Use a counting method that accounts for repeated rows and item quantities.
Example: For example, Script appears more often than Block in the Font values.
What you can do: Use the pattern to plan materials or review the options you feature.
What Should You Check First in This Report?
Check the details that could change what your team makes or how it interprets the export.
- Order and item context: Keep the order reference, product and variant with every property so instructions stay attached to the correct item.
- Property values: Review spelling, units and incomplete-looking entries before production. Confirm uncertain instructions with the customer.
- Quantity and row layout: Check whether one item repeats for each property before adding quantities or counting jobs.
- File references: Where a property contains a file link or reference, check access separately. The report is not a guarantee that file contents are embedded.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing engraving or monogram jobs | Keeps the saved text beside the product, variant and order reference. |
| Sending personalization details to a print partner | Provides the item instructions and any saved design references in one export. |
| Checking custom measurements before production | Makes recorded sizes easier to review together before material is cut. |
| Organizing bakery personalization requests | Lists cake messages or recorded choices by order; a separate date field is needed to plan pickup days. |
| Reviewing popular personalization choices | Supports summaries of consistent property values in a spreadsheet. |
How to Create This Report in Data Export
Start with the premade report and review its output before sharing it with production.
- Open Data Export and go to Prebuilt Reports. Find Line Item Properties.
- Open the report and review the order, product, quantity and property columns.
- Choose your order date range. Use the available product or property filters where supported by your report configuration.
- Generate a preview, check a few orders against their recorded instructions, and save the report.
- Export in your preferred format or configure scheduled delivery. Choose an available hourly, daily, weekly or monthly schedule and review the destination and recipients.
Make the Most of This Report
Use these checks to keep the export practical for daily production.
01 / PERIOD
Choose the right dates: Order Date helps prioritize older orders. Add a confirmed delivery or production date field for deadline planning.
02 / COUNTING
Check repeated quantities: Inspect one item with several properties before summing Quantity or counting personalization jobs.
03 / SHARING
Share only what is needed: Remove unnecessary customer details before sending a production sheet to an external partner.
04 / LAYOUT
Keep instructions readable: Use Excel or CSV for sorting. Check wrapping and column widths before printing a PDF worksheet.
Frequently Asked Questions
What are line item properties?
They are extra details saved against an individual ordered item, such as engraving text, a chosen font or a custom measurement. The report displays the recorded property names and values.
How are line item properties different from note attributes?
Line item properties belong to a particular item. Note attributes hold additional information at order level. This report includes item properties; combining both requires a tailored report.
Can I export uploaded photos or designs?
If the saved property value contains a file reference or link, that value can appear in the export. This does not mean the export downloads or embeds the original file; check the reference and access before sharing it.
Can I make a sheet with one column per property or only unfulfilled items?
Ask Data Export support to configure the layout or additional fields you need. Fulfillment status is not among the eight default columns, so this export alone does not identify unfinished jobs.
Can I schedule the report for my production team?
Yes. Configure a supported schedule and destination, then review the date range and recipients. A scheduled order-date export can repeat earlier items and should not be treated as a list of new or unfulfilled work without suitable filters.