PR #147 includes the following updates:
Schema/Data Changes
21 total changes • 9 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
| shopify__refund_lines or shopify_gql__refund_lines | New model | New final model at the refund line item grain. Exposes per-line refund financials, product context, and restock classification. | ||
| shopify__refunds or shopify_gql__refunds | New model | New final model at the refund transaction grain. Aggregates line item financials and includes discrepancy adjustments for accurate reconciliation. | ||
| shopify__daily_shop or shopify_gql__daily_shop | Data change | refund_subtotal, refund_total_tax, and count_orders_with_refunds bucketed by order creation date
| Now bucketed by refund creation date | Possible breaking change: New refund metrics now likely to change values. Aligns with Shopify Finance report behavior, which attributes refunds to the date the refund was issued. |
| shopify__customers and shopify__customer_emails or shopify_gql__customers and shopify_gql__customer_emails | Data change | lifetime_total_discount and avg_discount_per_order sourced from order_line.total_discount
| Now sourced from discount_allocation
| Possible breaking change: New discount metrics now likely to change values. discount_allocation is the more reliable source for order line discount values.
|
| shopify__products or shopify_gql__products | Data change | product_total_discount and product_avg_discount_per_order_line sourced from order_line.total_discount
| Now sourced from discount_allocation
| Possible breaking change: New discount metrics now likely to change values. discount_allocation is the more reliable source for order line discount values. Additionally, order lines with no discounts could return null for these fields; they now return 0.
|
| stg_shopify_gql__order_line_refund | New columns | price_pres_amount, price_pres_currency_code, price_shop_amount, price_shop_currency_code, is_restocked
| Possible breaking change: Users with order_line_refund_pass_through_columns configured may encounter duplicate column errors if any passthrough columns overlap with the new columns.
| |
| shopify__daily_shop or shopify_gql__daily_shop | New columns | gross_sales, discounts, returns, net_sales
| New finance metrics providing a daily view of gross sales, applied discounts, returns, and net sales. | |
| shopify__orders or shopify_gql__orders | New columns | gross_sales, discounts, returns, net_sales
| New finance metrics providing an order-level view of gross sales, applied discounts, returns, and net sales. | |
| stg_shopify_gql__refund | New column | updated_at
| Timestamp of the last update to the refund record. | |
| stg_shopify_gql__return, stg_shopify_gql__return_line_item, stg_shopify_gql__return_shipping_fee | New models | Opt-in GraphQL staging models for return data. Can be enabled/disabled using shopify_gql_using_return variable--see README on how to use. When enabled, shopify_gql__refund_lines is enriched with return lifecycle and return line item detail columns, and shopify_gql__refunds is enriched with return context and return shipping fee columns.
|
Under the Hood
- Adds YAML documentation for new models and columns.
- Updates seed files to reflect corrected column names and new columns.
- Removes DECISIONLOG entry for aggregating returns on order date to reflect that returns are now correctly applied on the refund date, matching Shopify finance report behavior.
Contributors
Full Changelog: v1.5.2...v1.6.0