--- title: store_credit_summaries description: >- Reference for the ShopifyQL `store_credit_summaries` table. Every metric and dimension, paired with worked example queries. api_version: 2026-07 source_url: html: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/store_credit_summaries md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/store_credit_summaries.md api_name: shopifyql --- # store\_​credit\_​summaries The `store_credit_summaries` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures store credit balances as point-in-time snapshots. It's the summary view that pairs with the transaction-level store credit data, and it's best for tracking balances over a period. ### Use cases * **Period balances**: Show [`starting_store_credit_balance`](#storecreditsummariesmetric-propertydetail-startingstorecreditbalance) and [`ending_store_credit_balance`](#storecreditsummariesmetric-propertydetail-endingstorecreditbalance) by day or month to track outstanding store credit liability over time. * **Movement by currency**: Group [`store_credit_balance_net_change`](#storecreditsummariesmetric-propertydetail-storecreditbalancenetchange) by [`store_credit_currency`](#storecreditsummariesdimension-propertydetail-storecreditcurrency) to see which currencies drive changes in credit balance. Examples ### Examples * #### ##### Description Split the \`ending\_store\_credit\_balance\` your store owes over the last seven days by currency. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a total beside the per-currency breakdown. ##### ShopifyQL ```shopifyql FROM store_credit_summaries SHOW ending_store_credit_balance GROUP BY store_credit_currency WITH TOTALS SINCE -7d UNTIL today ORDER BY ending_store_credit_balance DESC VISUALIZE ending_store_credit_balance TYPE donut ``` * #### ##### Description Compare monthly \`store\_credit\_balance\_net\_change\` for the year to date against the same months last year. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add the year-to-date total net change beside the monthly bars. ##### ShopifyQL ```shopifyql FROM store_credit_summaries SHOW store_credit_balance_net_change TIMESERIES month WITH TOTALS DURING this_year COMPARE TO previous_year ORDER BY month ASC VISUALIZE store_credit_balance_net_change TYPE bar ``` * #### ##### Description Track monthly \`starting\_store\_credit\_balance\` this year as a running total. This example uses \[\`CUMULATIVE\_VALUES\`]\(/docs/api/shopifyql/latest/syntax/with#cumulative-values) to carry each month's balance forward into a year-to-date running total. ##### ShopifyQL ```shopifyql FROM store_credit_summaries SHOW starting_store_credit_balance TIMESERIES month WITH CUMULATIVE_VALUES, TOTALS DURING this_year ORDER BY month ASC VISUALIZE starting_store_credit_balance TYPE line ``` * #### ##### Description Rank the 10 \`store\_credit\_currency\` values with the highest \`starting\_store\_credit\_balance\` last month. This example pairs \[\`ORDER BY\`]\(/docs/api/shopifyql/latest/syntax/order-by) \`starting\_store\_credit\_balance DESC\` with \`LIMIT 10\`, so the sort decides which 10 currencies survive the cut. ##### ShopifyQL ```shopifyql FROM store_credit_summaries SHOW starting_store_credit_balance GROUP BY store_credit_currency WITH TOTALS DURING last_month ORDER BY starting_store_credit_balance DESC LIMIT 10 VISUALIZE starting_store_credit_balance TYPE horizontal_bar ``` *** ## Metrics Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried. Metrics you can use when querying `FROM store_credit_summaries`. * **ending\_​store\_​credit\_​balance** **MONEY** The store credit balance at the end of the selected period, in the currency shown by [`store_credit_currency`](#storecreditsummariesdimension-propertydetail-storecreditcurrency). * **starting\_​store\_​credit\_​balance** **MONEY** The store credit balance at the beginning of the selected period, in the currency shown by [`store_credit_currency`](#storecreditsummariesdimension-propertydetail-storecreditcurrency). * **store\_​credit\_​balance\_​net\_​change** **MONEY** The store credit balance change for the selected period, in the currency shown by [`store_credit_currency`](#storecreditsummariesdimension-propertydetail-storecreditcurrency). `Store credit balance net change = ending store credit balance – starting store credit balance` ### MONEY A monetary amount representing currency values such as prices, revenue, costs, and discounts. ```ts ``` *** ## Dimensions Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns. Dimensions you can use when querying `FROM store_credit_summaries`. * **day** **DAY\_TIMESTAMP** Day (timestamp) the data was recorded * **month** **MONTH\_TIMESTAMP** Month (timestamp) the data was recorded * **quarter** **QUARTER\_TIMESTAMP** Quarter (timestamp) the data was recorded * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#storecreditsummariesdimension-propertydetail-shopid) with [`shop_name`](#storecreditsummariesdimension-propertydetail-shopname) to show readable store labels. * **store\_​credit\_​currency** **STRING** Values are currency codes such as USD, EUR, GBP, and CAD. * **week** **WEEK\_TIMESTAMP** Week (timestamp) the data was recorded * **year** **YEAR\_TIMESTAMP** Year (timestamp) the data was recorded * **shop\_​name** **STRING** Name of your store ### DAY\_TIMESTAMP A date value truncated to day precision. ```ts ``` ### MONTH\_TIMESTAMP A date value representing the start of a month. ```ts ``` ### QUARTER\_TIMESTAMP A date value representing the start of a fiscal quarter. ```ts ``` ### IDENTITY A unique identifier for a Shopify resource such as a customer, product, or order. ```ts ``` ### STRING A sequence of characters representing text data. ```ts ``` ### WEEK\_TIMESTAMP A date value representing the start of a week. ```ts ``` ### YEAR\_TIMESTAMP A date value representing the start of a year. ```ts ``` *** ## Related schemas * [`store_credit_transactions`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/store_credit_transactions): Individual credit and debit events that drive these balances. * [`payments`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/payments): Transaction data when you want to see how store credit is used at checkout. * [`payouts`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/payouts): Payout amounts alongside store-credit liability for a full cash picture. ***