Query all tracked product variants below a stock threshold

Purpose

Queries all tracked product variants at or below a configurable stock threshold and exports a restock CSV grouped by vendor. By pulling live inventory counts directly from the Shopify Admin API and sorting results by vendor name, this skill gives procurement teams an immediately actionable reorder list without manual exports from the Shopify admin inventory view.

Prerequisites

• Authenticated Shopify CLI session: shopify auth login --store <domain>
• API scopes: read_products, read_inventory

Parameters

Parameter	Type	Required	Default	Description
store	string	yes	—	Store domain (e.g., mystore.myshopify.com)
format	string	no	human	Output format: human or json
dry_run	bool	no	false	Preview operations without executing mutations
threshold	integer	no	10	Variants at or below this quantity are included
location_id	string	no	—	GID of a specific location to filter by (optional; if omitted, uses inventoryQuantity across all locations)
include_zero_stock	bool	no	true	Include variants with 0 quantity

Workflow Steps

1. OPERATION: productVariants — query Inputs: first: 250, query: "inventory_quantity:<= <threshold>", pagination cursor Expected output: List of variant objects with inventoryQuantity, product title, vendor, SKU; paginate until hasNextPage: false

GraphQL Operations

# productVariants:query — validated against api_version 2025-01
query LowInventoryVariants($first: Int!, $after: String, $query: String) {
  productVariants(first: $first, after: $after, query: $query) {
    edges {
      node {
        id
        title
        sku
        inventoryQuantity
        product {
          id
          title
          vendor
        }
        inventoryItem {
          id
          tracked
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

Session Tracking

Claude MUST emit the following output at each stage. This is mandatory.

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: low-inventory-restock                ║
║  Store: <store domain>                       ║
║  Started: <YYYY-MM-DD HH:MM UTC>             ║
╚══════════════════════════════════════════════╝

After each step, emit:

[N/TOTAL] <QUERY|MUTATION>  <OperationName>
          → Params: <brief summary of key inputs>
          → Result: <count or outcome>

On completion, emit:

For format: human (default):

══════════════════════════════════════════════
OUTCOME SUMMARY
  Variants below threshold:  <n>
  Unique products:            <n>
  Vendors:                    <n>
  Errors:                     0
  Output:                     restock_list_<date>.csv
══════════════════════════════════════════════

For format: json, emit:

{
  "skill": "low-inventory-restock",
  "store": "<domain>",
  "started_at": "<ISO8601>",
  "completed_at": "<ISO8601>",
  "dry_run": false,
  "steps": [
    { "step": 1, "operation": "LowInventoryVariants", "type": "query", "params_summary": "threshold <= 10, all locations", "result_summary": "<n> variants", "skipped": false }
  ],
  "outcome": {
    "variants_below_threshold": 0,
    "unique_products": 0,
    "vendors": 0,
    "errors": 0,
    "output_file": "restock_list_<date>.csv"
  }
}

Output Format

CSV file restock_list_<YYYY-MM-DD>.csv grouped by vendor, sorted by vendor name then product title. Columns: vendor, product_title, variant_title, sku, current_stock.

Error Handling

Error	Cause	Recovery
No variants returned	All variants are above threshold or inventory not tracked	Lower threshold or verify inventoryItem.tracked: true
location_id not found	Invalid location GID	Retrieve valid location IDs via Shopify admin
Rate limit (429)	Too many paginated requests	Reduce first to 100 and retry

Best Practices

1. Run without location_id first to get store-wide low stock; then filter by location if you operate multiple warehouses.
2. Only variants with inventoryItem.tracked: true have meaningful stock counts — untracked variants always appear as 0.
3. The restock CSV is sorted by vendor — share the vendor-grouped output directly with your procurement team without reformatting.
4. Set include_zero_stock: false to skip variants already on back-order to focus on nearly-depleted items.
5. Schedule this skill to run weekly via cron and pipe the CSV to your purchasing workflow.