---
id: change/bcapps/10619
type: change
title: "#10619 [Shopify] Index Has Order State Error to fix slow Shopify Activities cue"
summary: A database index is added to the Shopify Order Header table on the "Has Order State Error" field to improve the performance of the Activities cue, which was consuming significant server resources during slow counts.
tier: official
language: en
tags:
  - performance
  - main
  - bc30
  - table shpfy order header
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:07:15.614Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: e3c00690e0b5284ac6f1c01c980c0d3cba8735a4
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10619
    title: "microsoft/BCApps#10619: [Shopify] Index Has Order State Error to fix slow Shopify Activities cue"
    date: "2026-08-28"
    commit: e3c00690e0b5284ac6f1c01c980c0d3cba8735a4
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/table/30118
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10619
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10619
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-28T10:51:12Z"
author: onbuyuka
author_type: User
community_contribution: false
labels:
  - "AL: Apps (W1)"
  - "Team: Integrations"
change_class: code
change_kind: performance
behavior_change: false
breaking: false
files:
  count: 1
  additions: 3
  deletions: 0
  al: 1
apps:
  - Shopify
objects_touched:
  - key: table/30118
    page: table/30118
    type: table
    id: 30118
    name: Shpfy Order Header
    app: Shopify
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 647742
systems:
  - integration
quote: null
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #10619 [Shopify] Index Has Order State Error to fix slow Shopify Activities cue

> A database index is added to the Shopify Order Header table on the "Has Order State Error" field to improve the performance of the Activities cue, which was consuming significant server resources during slow counts.

[Pull request](https://github.com/microsoft/BCApps/pull/10619) · merged into `main` (BC30) on 2026-08-28 by onbuyuka · 1 file (+3 -0), 1 AL · performance · tier official · reviewed (checked by Opus)

## What changed

- New key added to Shpfy Order Header table to support filtering on Has Order State Error field
- Addresses performance bottleneck in Shopify Activities cue that was running full table scans
- Index enables SQL to seek narrow index instead of scanning the wide ~100-column table
- Expected to reduce CPU time from ~16.5s to near-instant for the Unprocessed Order Updates count

## AL objects touched

- [Table 30118 "Shpfy Order Header"](../../objects/table/30118.md), Shopify: modified

## Context

- Work items: AB#647742
- Labels: AL: Apps (W1), Team: Integrations
- Systems: integration

Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).