Package control recordPublished package

@pasar6987/shopify-orders

Name: Semantic model package @pasar6987/shopify-orders
Creator: pasar6987

Shopify orders, refunds, abandonment, and fulfillment semantic model

OSISchema 0.1.1Domain ecommerce Source Shopify

Published package · Latest published 0.1.0 Mar 3, 2026 · 3 datasets / 5 measures in the latest review · Updated Apr 28, 2026

Release path

0.1.0Published Mar 3, 2026

Publisher

@pasar6987Published Mar 3, 2026

Structure snapshot

3 datasets5 measures · 12 dimensions

Reference context

Secondary package facts stay compact

Updated: Apr 28, 2026
Visibility: Public hub listing
License: Apache-2.0
Created: Mar 3, 2026

Reference facts

Secondary package facts after the usage path is clear

Licensing, categorization, ownership, and linked metadata stay below the runnable path so the page reads in the right order.

Format

OSI

Upstream

Repository

Domain

Source

Owner

@pasar6987

Organization

Independent

License

Apache-2.0

Visibility

Public hub listing

Publisher

@pasar6987Published Mar 3, 2026

Latest published version

0.1.0Published Mar 3, 2026

Use this package in code and AI

After structure review, move straight into typed reads with load() or compact LLM context with to_prompt().

Python SDK

Python example for @pasar6987/shopify-orders

This example uses the current package ref and, when preview data is available, fills in real dataset names from the published summary.

import rawctx

model = rawctx.load("@pasar6987/shopify-orders")
prompt = rawctx.to_prompt(
    "@pasar6987/shopify-orders",
    datasets=["orders", "fulfillments"],
    max_tokens=2000,
)

print(model.datasets)        # ["orders", "fulfillments", "abandonedCheckouts"]
print(model.measures)        # [Measure(name="gmv", ...), Measure(name="aov", ...), Measure(name="refundRate", ...)]
print(model.dimensions)      # [Dimension(name="createdAt", ...), Dimension(name="displayFinancialStatus", ...), Dimension(name="displayFulfillmentStatus", ...)]
print(model.relationships)   # [Relationship(name='...', ...)]
print(prompt)

See Python docs

README

Package narrative and examples

Use documentation after the package clears provenance, ownership, and runnable-path checks.

@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.

Structure review

Inspect package structure after the usage path is clear

Use the structural review when you need the package footprint, field counts, and model paths before a deeper explorer pass.

Models1

Datasets3

Measures5

Dimensions12

Relationships2

AI context1

models/shopifyOrders.osi.yamlAI context included

3 datasets5 measures12 dimensions2 relationships

Topology

Semantic graph

Use the graph last, once provenance, documentation, and the runnable path are already clear.

Semantic Graph

Topology counts appear after the graph loads.

Loading graph

Semantic topology is still loading

Counts and graph nodes appear after the latest published summary has been fetched.