Shopify Admin Low Inventory Restock

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
• 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 | | dryrun | bool | no | false | Preview operations without executing mutations | | threshold | integer | no | 10 | Variants at or below this quantity are included | | locationid | string | no | — | GID of a specific location to filter by (optional; if omitted, uses inventoryQuantity across all locations) | | includezerostock | bool | no | true | Include variants with 0 quantity |

Workflow Steps

1. OPERATION: productVariants — query

Inputs: first: 250, query: "inventory_quantity:", 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:                        ║
║  Started:              ║
╚══════════════════════════════════════════════╝

After each step, emit:

[N/TOTAL]   
          → Params: 
          → Result: 

On completion, emit:

For format: human (default):

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

For format: json, emit:

{
  "skill": "low-inventory-restock",
  "store": "",
  "started_at": "",
  "completed_at": "",
  "dry_run": false,
  "steps": [
    { "step": 1, "operation": "LowInventoryVariants", "type": "query", "params_summary": "threshold  variants", "skipped": false }
  ],
  "outcome": {
    "variants_below_threshold": 0,
    "unique_products": 0,
    "vendors": 0,
    "errors": 0,
    "output_file": "restock_list_.csv"
  }
}

Output Format

CSV file restock_list_.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.

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: 40RTY-ai
• Source: 40RTY-ai/shopify-admin-skills
• License: MIT
• Homepage: http://skills.40rty.ai

Install and usage instructions live in the source repository linked above.