We’re making behind-the-scenes improvements to how Better Reports structures Shopify data. These updates will make your reports more accurate, more flexible, and better aligned with Shopify’s modern data model — without changing your existing report structure.
These enhancements will roll out gradually, with careful testing at each step to ensure a smooth transition.
⭐ Quick Summary (What You Need to Know)
- Your existing reports will continue to work — no changes to your data or results.
- The current Order lines table is being renamed to “Agreement lines.”
- Two new tables — Order lines and Refund lines — will be added to more closely match Shopify’s data model.
- You’ll notice updated table names, new tables, and some new built-in reports.
- These changes provide more accurate mapping, higher granularity, and easier relationships between Shopify entities.
- Rollout will happen in phases ensuring data accuracy and with no anticipated impact on your reporting.
Why We’re Making These Changes
Shopify’s data model has become more detailed and complex over time. To stay aligned — and to continue providing accurate, flexible reporting — we’re updating our internal structure to reflect Shopify’s modern API.
These improvements will allow Better Reports to:
1. More accurately reflect Shopify’s structure
Data in Better Reports will now mirror Shopify’s own records more closely, improving clarity and consistency.
2. Provide higher granularity
New tables like Order lines and Refund lines let you dive deeper into item-level sales, adjustments, and refunds.
3. Enable clearer relationships between data
Splitting older, combined tables into focused ones makes joins between discounts, taxes, fulfillments, and line items much easier.
4. Increase transparency and long-term flexibility
With a cleaner foundation, we can adapt more quickly as Shopify continues to evolve — and advanced users can build more precise custom reports.
What’s Changing?
The Order Lines table is becoming “Agreement lines”
The current Order lines table combines multiple types of sales-related data. To better reflect Shopify’s model, it will be renamed to:
- Order lines → Agreement lines
Your existing reports will automatically update to reference the new name. No action required.
New tables
We are introducing two new API-aligned tables:
- Order lines (new) — Represents Shopify’s true line-item data
- Refund lines (new) — Provides item-level refund details
These allow for clearer relationships and more detailed reporting.
Updated table relationships
Some tables that previously linked to the old Order lines table will now link to the new Order lines table, including:
- Fulfillment lines
- Discounts
- Taxes
- Other line-level Shopify entities
No data is being removed — this is strictly a restructuring for accuracy.
What Stays the Same?
- Your reports, formulas, and custom fields will continue to work. Any required updates (such as renaming references) will happen automatically.
- Your numbers won’t change. We’re only adding new structure, not altering historical data.
- Agreement lines will remain your primary table for most sales-based reports, just as the old Order lines table was.
Where You’ll Notice Changes
As this rollout progresses, you may notice:
- Updated table names in the table selector
- New labels in the homepage report list
- Updated table names inside reports
- Newly added tables for advanced reporting
- New built-in reports that use the enhanced structure
All terminology will be aligned with Shopify’s own API for easier interpretation.
Rollout Timeline
We’re releasing these updates in thoughtful phases:
- Renaming Order lines to Agreement lines
- Background data reimport to populate the new tables
- Introducing the new Order lines and Refund lines tables once verified
This phased approach ensures accuracy and minimal disruption.
See the Exact Shopify Field Mapping
You can use the “Open documentation” button beside any persisted field to view the exact Shopify API field it corresponds to. With the new structure, this mapping becomes even clearer.
Need more support?
If you get stuck or have additional questions, you can contact our team directly through the Help widget in the bottom-right corner of the app — we typically respond within one business day.