Public HubPublic
Registry packagePublic

@pasar6987/shopify-orders

Shopify orders, refunds, abandonment, and fulfillment semantic model

OSISchema 1.0Domain ecommerceSource shopifyOwner @pasar6987

Native (downloadable) · Latest 0.1.0 published Mar 3, 2026 · 3 datasets / 5 measures in the latest preview · Updated Mar 11, 2026

Snapshot

Registry facts before deep inspection

Format, origin, ownership, and release context surface first so the package can be qualified quickly.

Format

OSI

Latest release

0.1.0Published Mar 3, 2026

Origin

Native (downloadable)Managed directly in rawctx

Installability

DownloadableDirect rawctx snapshot download

Domain

ecommerce

Owner

@pasar6987

Organization

Independent

License

Apache-2.0

Visibility

Public

Tags

shopifyecommerceordersrefundsabandonment

Schema preview

OSI 1.0

Model preview

Structure before documentation

Preview the package footprint first, then open the dedicated explorer if you need field-level inspection.

Models1
Datasets3
Measures5
Dimensions12
Relationships2
AI context1
models/shopifyOrders.osi.yamlAI context included
3 datasets5 measures12 dimensions2 relationships

Open the full preview to search datasets, fields, and OSI documents.

Open full preview

README

Package narrative and examples

Use documentation after the package qualifies on source, preview, and installability.

@pasar6987/shopify-orders

Shopify semantic package for order, refund, abandonment, and fulfillment analytics.

Included datasets

  • orders from shopify.Order
  • fulfillments from shopify.Fulfillment
  • abandonedCheckouts from shopify.AbandonedCheckout

Metrics

  • gmv: SUM(orders.currentTotalPriceAmount)
  • aov: SUM(orders.currentTotalPriceAmount) / NULLIF(COUNT(DISTINCT orders.id), 0)
  • refundRate: SUM(orders.totalRefundedAmount) / NULLIF(SUM(orders.currentTotalPriceAmount), 0)
  • cartAbandonmentRate: SUM(CASE WHEN abandonedCheckouts.completedAt IS NULL THEN 1 ELSE 0 END) / NULLIF(COUNT(*), 0)
  • fulfillmentTimeHours: average order-to-delivery hours using delivered fulfillments only

Key dimensions

  • salesChannel (orders.sourceName)
  • orderStatus (orders.displayFulfillmentStatus)
  • discountCode (orders.discountCode)
  • location (fulfillments.locationId)

Caveats

  • cartAbandonmentRate requires manage_abandoned_checkouts API access.
  • Without read_all_orders, order history may be limited by Shopify default window.
  • Money values are modeled as shop currency amounts. Multi-currency normalization is out of scope.
  • Fulfillment records with deliveredAt IS NULL are excluded from fulfillmentTimeHours.

Topology

Semantic graph

Use the graph last, once the package has already qualified on release state, preview, and documentation.

Semantic Graph

Datasets 0 / Measures 0 / Dimensions 0 / Relationships 0

Loading semantic graph...

PackageDatasetMeasureDimensionRelationship