PR #167, PR #172 include the following updates:
Schema/Data Changes
4 total changes • 0 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
shopify_gql__orders, shopify_gql__daily_shop
| Column value | gross_sales / net_sales = Σ quantity² × unit_price
| gross_sales / net_sales = Σ quantity × unit_price
| Fixes a bug where GraphQL orders with any line quantity > 1 had sales figures inflated quadratically. Orders where every line has quantity = 1 are unaffected.
|
shopify_gql__line_item_enhanced
| Column value | total_amount = quantity² × unit_price; unit_amount = line total, then a quantity-derived unit price
| total_amount = quantity × unit_price; unit_amount = Shopify's own reported unit price
| The quantity double-count is fixed as before. unit_amount now reads the real per-unit price directly from the source instead of back-deriving it by dividing the line total by quantity, avoiding rounding/edge-case drift (e.g. quantity = 0).
|
stg_shopify_gql__metafield
| Deduplication logic and unique_key value
| Deduplicated on id only; unique_key hashed on metafield_id and source_relation
| Deduplicated on id, owner_id, and owner_resource; unique_key hashed on metafield_id, owner_resource_id, owner_resource, and source_relation
| Shopify changed the underlying METAFIELD table's primary key to a composite of owner_id and owner_resource to fix cross-entity ID collisions. This change does not affect any downstream shopify_gql__*_metafields models, since unique_key is never selected from stg_shopify_gql__metafield into those outputs.
|
stg_shopify_gql__order_line
| New columns | unit_price_shop_amount, unit_price_shop_currency_code
| Exposes Shopify's own per-unit price field (originalUnitPriceSet), synced by the connector but not previously mapped in this package.
|
Contributors
Full Changelog: v1.9.2...v1.10.0