fix(ui): Show git hash instead of version number in sidebar

🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
fix(ui): Remove Cleanup Stale button from Workers page
2025-12-11 08:09:06 -07:00 · 2025-12-11 01:29:25 -07:00 · 2025-12-11 01:19:02 -07:00 · 2025-12-11 01:14:25 -07:00 · 2025-12-11 00:45:08 -07:00 · 2025-12-11 07:21:02 +00:00
30 changed files with 1913 additions and 560 deletions
--- a/.woodpecker/.ci.yml
+++ b/.woodpecker/.ci.yml
@@ -1,6 +1,3 @@
-when:
-  - event: [push, pull_request]
-
 steps:
  # ===========================================
  # PR VALIDATION: Parallel type checks (PRs only)
@@ -163,7 +160,32 @@ steps:
      event: push

  # ===========================================
-  # STAGE 3: Deploy (after Docker builds)
+  # STAGE 3: Run Database Migrations (before deploy)
+  # ===========================================
+  migrate:
+    image: code.cannabrands.app/creationshop/dispensary-scraper:${CI_COMMIT_SHA:0:8}
+    environment:
+      CANNAIQ_DB_HOST:
+        from_secret: db_host
+      CANNAIQ_DB_PORT:
+        from_secret: db_port
+      CANNAIQ_DB_NAME:
+        from_secret: db_name
+      CANNAIQ_DB_USER:
+        from_secret: db_user
+      CANNAIQ_DB_PASS:
+        from_secret: db_pass
+    commands:
+      - cd /app
+      - node dist/db/migrate.js
+    depends_on:
+      - docker-backend
+    when:
+      branch: master
+      event: push
+
+  # ===========================================
+  # STAGE 4: Deploy (after migrations)
  # ===========================================
  deploy:
    image: bitnami/kubectl:latest
@@ -182,7 +204,7 @@ steps:
      - kubectl rollout status deployment/scraper -n dispensary-scraper --timeout=300s
      - kubectl rollout status deployment/cannaiq-frontend -n dispensary-scraper --timeout=120s
    depends_on:
-      - docker-backend
+      - migrate
      - docker-cannaiq
      - docker-findadispo
      - docker-findagram
--- a/backend/Dockerfile
+++ b/backend/Dockerfile
@@ -25,8 +25,9 @@ ENV APP_GIT_SHA=${APP_GIT_SHA}
 ENV APP_BUILD_TIME=${APP_BUILD_TIME}
 ENV CONTAINER_IMAGE_TAG=${CONTAINER_IMAGE_TAG}

-# Install Chromium dependencies
+# Install Chromium dependencies and curl for HTTP requests
 RUN apt-get update && apt-get install -y \
+    curl \
    chromium \
    fonts-liberation \
    libnss3 \
--- a/backend/migrations/082_proxy_notification_trigger.sql
+++ b/backend/migrations/082_proxy_notification_trigger.sql
@@ -0,0 +1,27 @@
+-- Migration: 082_proxy_notification_trigger
+-- Date: 2024-12-11
+-- Description: Add PostgreSQL NOTIFY trigger to alert workers when proxies are added
+
+-- Create function to notify workers when active proxy is added/activated
+CREATE OR REPLACE FUNCTION notify_proxy_added()
+RETURNS TRIGGER AS $$
+BEGIN
+  -- Only notify if proxy is active
+  IF NEW.active = true THEN
+    PERFORM pg_notify('proxy_added', NEW.id::text);
+  END IF;
+  RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+-- Drop existing trigger if any
+DROP TRIGGER IF EXISTS proxy_added_trigger ON proxies;
+
+-- Create trigger on insert and update of active column
+CREATE TRIGGER proxy_added_trigger
+AFTER INSERT OR UPDATE OF active ON proxies
+FOR EACH ROW
+EXECUTE FUNCTION notify_proxy_added();
+
+COMMENT ON FUNCTION notify_proxy_added() IS
+'Sends PostgreSQL NOTIFY to proxy_added channel when an active proxy is added or activated. Workers LISTEN on this channel to wake up immediately.';
--- a/backend/node_modules/.package-lock.json
+++ b/backend/node_modules/.package-lock.json
@@ -1,6 +1,6 @@
 {
  "name": "dutchie-menus-backend",
-  "version": "1.5.1",
+  "version": "1.6.0",
  "lockfileVersion": 3,
  "requires": true,
  "packages": {
@@ -46,6 +46,97 @@
      "resolved": "https://registry.npmjs.org/@ioredis/commands/-/commands-1.4.0.tgz",
      "integrity": "sha512-aFT2yemJJo+TZCmieA7qnYGQooOS7QfNmYrzGtsYd3g9j5iDP8AimYYAesf79ohjbLG12XxC4nG5DyEnC88AsQ=="
    },
+    "node_modules/@jsep-plugin/assignment": {
+      "version": "1.3.0",
+      "resolved": "https://registry.npmjs.org/@jsep-plugin/assignment/-/assignment-1.3.0.tgz",
+      "integrity": "sha512-VVgV+CXrhbMI3aSusQyclHkenWSAm95WaiKrMxRFam3JSUiIaQjoMIw2sEs/OX4XifnqeQUN4DYbJjlA8EfktQ==",
+      "engines": {
+        "node": ">= 10.16.0"
+      },
+      "peerDependencies": {
+        "jsep": "^0.4.0||^1.0.0"
+      }
+    },
+    "node_modules/@jsep-plugin/regex": {
+      "version": "1.0.4",
+      "resolved": "https://registry.npmjs.org/@jsep-plugin/regex/-/regex-1.0.4.tgz",
+      "integrity": "sha512-q7qL4Mgjs1vByCaTnDFcBnV9HS7GVPJX5vyVoCgZHNSC9rjwIlmbXG5sUuorR5ndfHAIlJ8pVStxvjXHbNvtUg==",
+      "engines": {
+        "node": ">= 10.16.0"
+      },
+      "peerDependencies": {
+        "jsep": "^0.4.0||^1.0.0"
+      }
+    },
+    "node_modules/@kubernetes/client-node": {
+      "version": "1.4.0",
+      "resolved": "https://registry.npmjs.org/@kubernetes/client-node/-/client-node-1.4.0.tgz",
+      "integrity": "sha512-Zge3YvF7DJi264dU1b3wb/GmzR99JhUpqTvp+VGHfwZT+g7EOOYNScDJNZwXy9cszyIGPIs0VHr+kk8e95qqrA==",
+      "dependencies": {
+        "@types/js-yaml": "^4.0.1",
+        "@types/node": "^24.0.0",
+        "@types/node-fetch": "^2.6.13",
+        "@types/stream-buffers": "^3.0.3",
+        "form-data": "^4.0.0",
+        "hpagent": "^1.2.0",
+        "isomorphic-ws": "^5.0.0",
+        "js-yaml": "^4.1.0",
+        "jsonpath-plus": "^10.3.0",
+        "node-fetch": "^2.7.0",
+        "openid-client": "^6.1.3",
+        "rfc4648": "^1.3.0",
+        "socks-proxy-agent": "^8.0.4",
+        "stream-buffers": "^3.0.2",
+        "tar-fs": "^3.0.9",
+        "ws": "^8.18.2"
+      }
+    },
+    "node_modules/@kubernetes/client-node/node_modules/@types/node": {
+      "version": "24.10.3",
+      "resolved": "https://registry.npmjs.org/@types/node/-/node-24.10.3.tgz",
+      "integrity": "sha512-gqkrWUsS8hcm0r44yn7/xZeV1ERva/nLgrLxFRUGb7aoNMIJfZJ3AC261zDQuOAKC7MiXai1WCpYc48jAHoShQ==",
+      "dependencies": {
+        "undici-types": "~7.16.0"
+      }
+    },
+    "node_modules/@kubernetes/client-node/node_modules/tar-fs": {
+      "version": "3.1.1",
+      "resolved": "https://registry.npmjs.org/tar-fs/-/tar-fs-3.1.1.tgz",
+      "integrity": "sha512-LZA0oaPOc2fVo82Txf3gw+AkEd38szODlptMYejQUhndHMLQ9M059uXR+AfS7DNo0NpINvSqDsvyaCrBVkptWg==",
+      "dependencies": {
+        "pump": "^3.0.0",
+        "tar-stream": "^3.1.5"
+      },
+      "optionalDependencies": {
+        "bare-fs": "^4.0.1",
+        "bare-path": "^3.0.0"
+      }
+    },
+    "node_modules/@kubernetes/client-node/node_modules/undici-types": {
+      "version": "7.16.0",
+      "resolved": "https://registry.npmjs.org/undici-types/-/undici-types-7.16.0.tgz",
+      "integrity": "sha512-Zz+aZWSj8LE6zoxD+xrjh4VfkIG8Ya6LvYkZqtUQGJPZjYl53ypCaUwWqo7eI0x66KBGeRo+mlBEkMSeSZ38Nw=="
+    },
+    "node_modules/@kubernetes/client-node/node_modules/ws": {
+      "version": "8.18.3",
+      "resolved": "https://registry.npmjs.org/ws/-/ws-8.18.3.tgz",
+      "integrity": "sha512-PEIGCY5tSlUt50cqyMXfCzX+oOPqN0vuGqWzbcJ2xvnkzkq46oOpz7dQaTDBdfICb4N14+GARUDw2XV2N4tvzg==",
+      "engines": {
+        "node": ">=10.0.0"
+      },
+      "peerDependencies": {
+        "bufferutil": "^4.0.1",
+        "utf-8-validate": ">=5.0.2"
+      },
+      "peerDependenciesMeta": {
+        "bufferutil": {
+          "optional": true
+        },
+        "utf-8-validate": {
+          "optional": true
+        }
+      }
+    },
    "node_modules/@mapbox/node-pre-gyp": {
      "version": "1.0.11",
      "resolved": "https://registry.npmjs.org/@mapbox/node-pre-gyp/-/node-pre-gyp-1.0.11.tgz",
@@ -251,6 +342,11 @@
      "integrity": "sha512-r8Tayk8HJnX0FztbZN7oVqGccWgw98T/0neJphO91KkmOzug1KkofZURD4UaD5uH8AqcFLfdPErnBod0u71/qg==",
      "dev": true
    },
+    "node_modules/@types/js-yaml": {
+      "version": "4.0.9",
+      "resolved": "https://registry.npmjs.org/@types/js-yaml/-/js-yaml-4.0.9.tgz",
+      "integrity": "sha512-k4MGaQl5TGo/iipqb2UDG2UwjXziSWkh0uysQelTlJpX1qGlpUZYm8PnO4DxG1qBomtJUdYJ6qR6xdIah10JLg=="
+    },
    "node_modules/@types/jsonwebtoken": {
      "version": "9.0.10",
      "resolved": "https://registry.npmjs.org/@types/jsonwebtoken/-/jsonwebtoken-9.0.10.tgz",
@@ -276,7 +372,6 @@
      "version": "20.19.25",
      "resolved": "https://registry.npmjs.org/@types/node/-/node-20.19.25.tgz",
      "integrity": "sha512-ZsJzA5thDQMSQO788d7IocwwQbI8B5OPzmqNvpf3NY/+MHDAS759Wo0gd2WQeXYt5AAAQjzcrTVC6SKCuYgoCQ==",
-      "devOptional": true,
      "dependencies": {
        "undici-types": "~6.21.0"
      }
@@ -287,6 +382,15 @@
      "integrity": "sha512-0ikrnug3/IyneSHqCBeslAhlK2aBfYek1fGo4bP4QnZPmiqSGRK+Oy7ZMisLWkesffJvQ1cqAcBnJC+8+nxIAg==",
      "dev": true
    },
+    "node_modules/@types/node-fetch": {
+      "version": "2.6.13",
+      "resolved": "https://registry.npmjs.org/@types/node-fetch/-/node-fetch-2.6.13.tgz",
+      "integrity": "sha512-QGpRVpzSaUs30JBSGPjOg4Uveu384erbHBoT1zeONvyCfwQxIkUshLAOqN/k9EjGviPRmWTTe6aH2qySWKTVSw==",
+      "dependencies": {
+        "@types/node": "*",
+        "form-data": "^4.0.4"
+      }
+    },
    "node_modules/@types/pg": {
      "version": "8.15.6",
      "resolved": "https://registry.npmjs.org/@types/pg/-/pg-8.15.6.tgz",
@@ -340,6 +444,14 @@
        "@types/node": "*"
      }
    },
+    "node_modules/@types/stream-buffers": {
+      "version": "3.0.8",
+      "resolved": "https://registry.npmjs.org/@types/stream-buffers/-/stream-buffers-3.0.8.tgz",
+      "integrity": "sha512-J+7VaHKNvlNPJPEJXX/fKa9DZtR/xPMwuIbe+yNOwp1YB+ApUOBv2aUpEoBJEi8nJgbgs1x8e73ttg0r1rSUdw==",
+      "dependencies": {
+        "@types/node": "*"
+      }
+    },
    "node_modules/@types/uuid": {
      "version": "9.0.8",
      "resolved": "https://registry.npmjs.org/@types/uuid/-/uuid-9.0.8.tgz",
@@ -520,6 +632,78 @@
        }
      }
    },
+    "node_modules/bare-fs": {
+      "version": "4.5.2",
+      "resolved": "https://registry.npmjs.org/bare-fs/-/bare-fs-4.5.2.tgz",
+      "integrity": "sha512-veTnRzkb6aPHOvSKIOy60KzURfBdUflr5VReI+NSaPL6xf+XLdONQgZgpYvUuZLVQ8dCqxpBAudaOM1+KpAUxw==",
+      "optional": true,
+      "dependencies": {
+        "bare-events": "^2.5.4",
+        "bare-path": "^3.0.0",
+        "bare-stream": "^2.6.4",
+        "bare-url": "^2.2.2",
+        "fast-fifo": "^1.3.2"
+      },
+      "engines": {
+        "bare": ">=1.16.0"
+      },
+      "peerDependencies": {
+        "bare-buffer": "*"
+      },
+      "peerDependenciesMeta": {
+        "bare-buffer": {
+          "optional": true
+        }
+      }
+    },
+    "node_modules/bare-os": {
+      "version": "3.6.2",
+      "resolved": "https://registry.npmjs.org/bare-os/-/bare-os-3.6.2.tgz",
+      "integrity": "sha512-T+V1+1srU2qYNBmJCXZkUY5vQ0B4FSlL3QDROnKQYOqeiQR8UbjNHlPa+TIbM4cuidiN9GaTaOZgSEgsvPbh5A==",
+      "optional": true,
+      "engines": {
+        "bare": ">=1.14.0"
+      }
+    },
+    "node_modules/bare-path": {
+      "version": "3.0.0",
+      "resolved": "https://registry.npmjs.org/bare-path/-/bare-path-3.0.0.tgz",
+      "integrity": "sha512-tyfW2cQcB5NN8Saijrhqn0Zh7AnFNsnczRcuWODH0eYAXBsJ5gVxAUuNr7tsHSC6IZ77cA0SitzT+s47kot8Mw==",
+      "optional": true,
+      "dependencies": {
+        "bare-os": "^3.0.1"
+      }
+    },
+    "node_modules/bare-stream": {
+      "version": "2.7.0",
+      "resolved": "https://registry.npmjs.org/bare-stream/-/bare-stream-2.7.0.tgz",
+      "integrity": "sha512-oyXQNicV1y8nc2aKffH+BUHFRXmx6VrPzlnaEvMhram0nPBrKcEdcyBg5r08D0i8VxngHFAiVyn1QKXpSG0B8A==",
+      "optional": true,
+      "dependencies": {
+        "streamx": "^2.21.0"
+      },
+      "peerDependencies": {
+        "bare-buffer": "*",
+        "bare-events": "*"
+      },
+      "peerDependenciesMeta": {
+        "bare-buffer": {
+          "optional": true
+        },
+        "bare-events": {
+          "optional": true
+        }
+      }
+    },
+    "node_modules/bare-url": {
+      "version": "2.3.2",
+      "resolved": "https://registry.npmjs.org/bare-url/-/bare-url-2.3.2.tgz",
+      "integrity": "sha512-ZMq4gd9ngV5aTMa5p9+UfY0b3skwhHELaDkhEHetMdX0LRkW9kzaym4oo/Eh+Ghm0CCDuMTsRIGM/ytUc1ZYmw==",
+      "optional": true,
+      "dependencies": {
+        "bare-path": "^3.0.0"
+      }
+    },
    "node_modules/base64-js": {
      "version": "1.5.1",
      "resolved": "https://registry.npmjs.org/base64-js/-/base64-js-1.5.1.tgz",
@@ -2019,6 +2203,14 @@
        "node": ">=16.0.0"
      }
    },
+    "node_modules/hpagent": {
+      "version": "1.2.0",
+      "resolved": "https://registry.npmjs.org/hpagent/-/hpagent-1.2.0.tgz",
+      "integrity": "sha512-A91dYTeIB6NoXG+PxTQpCCDDnfHsW9kc06Lvpu1TEe9gnd6ZFeiBoRO9JvzEv6xK7EX97/dUE8g/vBMTqTS3CA==",
+      "engines": {
+        "node": ">=14"
+      }
+    },
    "node_modules/htmlparser2": {
      "version": "10.0.0",
      "resolved": "https://registry.npmjs.org/htmlparser2/-/htmlparser2-10.0.0.tgz",
@@ -2382,6 +2574,22 @@
        "node": ">=0.10.0"
      }
    },
+    "node_modules/isomorphic-ws": {
+      "version": "5.0.0",
+      "resolved": "https://registry.npmjs.org/isomorphic-ws/-/isomorphic-ws-5.0.0.tgz",
+      "integrity": "sha512-muId7Zzn9ywDsyXgTIafTry2sV3nySZeUDe6YedVd1Hvuuep5AsIlqK+XefWpYTyJG5e503F2xIuT2lcU6rCSw==",
+      "peerDependencies": {
+        "ws": "*"
+      }
+    },
+    "node_modules/jose": {
+      "version": "6.1.3",
+      "resolved": "https://registry.npmjs.org/jose/-/jose-6.1.3.tgz",
+      "integrity": "sha512-0TpaTfihd4QMNwrz/ob2Bp7X04yuxJkjRGi4aKmOqwhov54i6u79oCv7T+C7lo70MKH6BesI3vscD1yb/yzKXQ==",
+      "funding": {
+        "url": "https://github.com/sponsors/panva"
+      }
+    },
    "node_modules/js-tokens": {
      "version": "4.0.0",
      "resolved": "https://registry.npmjs.org/js-tokens/-/js-tokens-4.0.0.tgz",
@@ -2398,6 +2606,14 @@
        "js-yaml": "bin/js-yaml.js"
      }
    },
+    "node_modules/jsep": {
+      "version": "1.4.0",
+      "resolved": "https://registry.npmjs.org/jsep/-/jsep-1.4.0.tgz",
+      "integrity": "sha512-B7qPcEVE3NVkmSJbaYxvv4cHkVW7DQsZz13pUMrfS8z8Q/BuShN+gcTXrUlPiGqM2/t/EEaI030bpxMqY8gMlw==",
+      "engines": {
+        "node": ">= 10.16.0"
+      }
+    },
    "node_modules/json-parse-even-better-errors": {
      "version": "2.3.1",
      "resolved": "https://registry.npmjs.org/json-parse-even-better-errors/-/json-parse-even-better-errors-2.3.1.tgz",
@@ -2419,6 +2635,23 @@
        "graceful-fs": "^4.1.6"
      }
    },
+    "node_modules/jsonpath-plus": {
+      "version": "10.3.0",
+      "resolved": "https://registry.npmjs.org/jsonpath-plus/-/jsonpath-plus-10.3.0.tgz",
+      "integrity": "sha512-8TNmfeTCk2Le33A3vRRwtuworG/L5RrgMvdjhKZxvyShO+mBu2fP50OWUjRLNtvw344DdDarFh9buFAZs5ujeA==",
+      "dependencies": {
+        "@jsep-plugin/assignment": "^1.3.0",
+        "@jsep-plugin/regex": "^1.0.4",
+        "jsep": "^1.4.0"
+      },
+      "bin": {
+        "jsonpath": "bin/jsonpath-cli.js",
+        "jsonpath-plus": "bin/jsonpath-cli.js"
+      },
+      "engines": {
+        "node": ">=18.0.0"
+      }
+    },
    "node_modules/jsonwebtoken": {
      "version": "9.0.2",
      "resolved": "https://registry.npmjs.org/jsonwebtoken/-/jsonwebtoken-9.0.2.tgz",
@@ -2493,6 +2726,11 @@
      "resolved": "https://registry.npmjs.org/lodash/-/lodash-4.17.21.tgz",
      "integrity": "sha512-v2kDEe57lecTulaDIuNTPy3Ry4gLGJ6Z1O3vE1krgXZNrsQ+LFTGHVxVjcXPs17LhbZVGedAJv8XZ1tvj5FvSg=="
    },
+    "node_modules/lodash.clonedeep": {
+      "version": "4.5.0",
+      "resolved": "https://registry.npmjs.org/lodash.clonedeep/-/lodash.clonedeep-4.5.0.tgz",
+      "integrity": "sha512-H5ZhCF25riFd9uB5UCkVKo61m3S/xZk1x4wA6yp/L3RFP6Z/eHH1ymQcGLo7J3GMPfm0V/7m1tryHuGVxpqEBQ=="
+    },
    "node_modules/lodash.defaults": {
      "version": "4.2.0",
      "resolved": "https://registry.npmjs.org/lodash.defaults/-/lodash.defaults-4.2.0.tgz",
@@ -2942,6 +3180,14 @@
        "url": "https://github.com/fb55/nth-check?sponsor=1"
      }
    },
+    "node_modules/oauth4webapi": {
+      "version": "3.8.3",
+      "resolved": "https://registry.npmjs.org/oauth4webapi/-/oauth4webapi-3.8.3.tgz",
+      "integrity": "sha512-pQ5BsX3QRTgnt5HxgHwgunIRaDXBdkT23tf8dfzmtTIL2LTpdmxgbpbBm0VgFWAIDlezQvQCTgnVIUmHupXHxw==",
+      "funding": {
+        "url": "https://github.com/sponsors/panva"
+      }
+    },
    "node_modules/object-assign": {
      "version": "4.1.1",
      "resolved": "https://registry.npmjs.org/object-assign/-/object-assign-4.1.1.tgz",
@@ -2980,6 +3226,18 @@
        "wrappy": "1"
      }
    },
+    "node_modules/openid-client": {
+      "version": "6.8.1",
+      "resolved": "https://registry.npmjs.org/openid-client/-/openid-client-6.8.1.tgz",
+      "integrity": "sha512-VoYT6enBo6Vj2j3Q5Ec0AezS+9YGzQo1f5Xc42lreMGlfP4ljiXPKVDvCADh+XHCV/bqPu/wWSiCVXbJKvrODw==",
+      "dependencies": {
+        "jose": "^6.1.0",
+        "oauth4webapi": "^3.8.2"
+      },
+      "funding": {
+        "url": "https://github.com/sponsors/panva"
+      }
+    },
    "node_modules/pac-proxy-agent": {
      "version": "7.2.0",
      "resolved": "https://registry.npmjs.org/pac-proxy-agent/-/pac-proxy-agent-7.2.0.tgz",
@@ -3883,6 +4141,11 @@
        "url": "https://github.com/privatenumber/resolve-pkg-maps?sponsor=1"
      }
    },
+    "node_modules/rfc4648": {
+      "version": "1.5.4",
+      "resolved": "https://registry.npmjs.org/rfc4648/-/rfc4648-1.5.4.tgz",
+      "integrity": "sha512-rRg/6Lb+IGfJqO05HZkN50UtY7K/JhxJag1kP23+zyMfrvoB0B7RWv06MbOzoc79RgCdNTiUaNsTT1AJZ7Z+cg=="
+    },
    "node_modules/rimraf": {
      "version": "3.0.2",
      "resolved": "https://registry.npmjs.org/rimraf/-/rimraf-3.0.2.tgz",
@@ -4313,6 +4576,14 @@
        "node": ">= 0.8"
      }
    },
+    "node_modules/stream-buffers": {
+      "version": "3.0.3",
+      "resolved": "https://registry.npmjs.org/stream-buffers/-/stream-buffers-3.0.3.tgz",
+      "integrity": "sha512-pqMqwQCso0PBJt2PQmDO0cFj0lyqmiwOMiMSkVtRokl7e+ZTRYgDHKnuZNbqjiJXgsg4nuqtD/zxuo9KqTp0Yw==",
+      "engines": {
+        "node": ">= 0.10.0"
+      }
+    },
    "node_modules/streamx": {
      "version": "2.23.0",
      "resolved": "https://registry.npmjs.org/streamx/-/streamx-2.23.0.tgz",
@@ -4532,8 +4803,7 @@
    "node_modules/undici-types": {
      "version": "6.21.0",
      "resolved": "https://registry.npmjs.org/undici-types/-/undici-types-6.21.0.tgz",
-      "integrity": "sha512-iwDZqg0QAGrg9Rav5H4n0M64c3mkR59cJ6wQp+7C4nI0gsmExaedaYLNO44eT4AtBBwjbTiGPMlt2Md0T9H9JQ==",
-      "devOptional": true
+      "integrity": "sha512-iwDZqg0QAGrg9Rav5H4n0M64c3mkR59cJ6wQp+7C4nI0gsmExaedaYLNO44eT4AtBBwjbTiGPMlt2Md0T9H9JQ=="
    },
    "node_modules/universalify": {
      "version": "2.0.1",
@@ -4556,6 +4826,14 @@
      "resolved": "https://registry.npmjs.org/urlpattern-polyfill/-/urlpattern-polyfill-10.0.0.tgz",
      "integrity": "sha512-H/A06tKD7sS1O1X2SshBVeA5FLycRpjqiBeqGKmBwBDBy28EnRjORxTNe269KSSr5un5qyWi1iL61wLxpd+ZOg=="
    },
+    "node_modules/user-agents": {
+      "version": "1.1.669",
+      "resolved": "https://registry.npmjs.org/user-agents/-/user-agents-1.1.669.tgz",
+      "integrity": "sha512-pbIzG+AOqCaIpySKJ4IAm1l0VyE4jMnK4y1thV8lm8PYxI+7X5uWcppOK7zY79TCKKTAnJH3/4gaVIZHsjrmJA==",
+      "dependencies": {
+        "lodash.clonedeep": "^4.5.0"
+      }
+    },
    "node_modules/util": {
      "version": "0.12.5",
      "resolved": "https://registry.npmjs.org/util/-/util-0.12.5.tgz",
--- a/backend/src/multi-state/state-query-service.ts
+++ b/backend/src/multi-state/state-query-service.ts
@@ -702,12 +702,10 @@ export class StateQueryService {
  async getNationalSummary(): Promise<NationalSummary> {
    const stateMetrics = await this.getAllStateMetrics();

+    // Get all states count and aggregate metrics
    const result = await this.pool.query(`
      SELECT
        COUNT(DISTINCT s.code) AS total_states,
-        COUNT(DISTINCT CASE WHEN EXISTS (
-          SELECT 1 FROM dispensaries d WHERE d.state = s.code AND d.menu_type IS NOT NULL
-        ) THEN s.code END) AS active_states,
        (SELECT COUNT(*) FROM dispensaries WHERE state IS NOT NULL) AS total_stores,
        (SELECT COUNT(*) FROM store_products sp
         JOIN dispensaries d ON sp.dispensary_id = d.id
@@ -725,7 +723,7 @@ export class StateQueryService {

    return {
      totalStates: parseInt(data.total_states),
-      activeStates: parseInt(data.active_states),
+      activeStates: parseInt(data.total_states), // Same as totalStates - all states shown
      totalStores: parseInt(data.total_stores),
      totalProducts: parseInt(data.total_products),
      totalBrands: parseInt(data.total_brands),
--- a/backend/src/routes/intelligence.ts
+++ b/backend/src/routes/intelligence.ts
@@ -14,13 +14,25 @@ router.use(authMiddleware);
 /**
 * GET /api/admin/intelligence/brands
 * List all brands with state presence, store counts, and pricing
+ * Query params:
+ *   - state: Filter by state (e.g., "AZ")
+ *   - limit: Max results (default 500)
+ *   - offset: Pagination offset
 */
 router.get('/brands', async (req: Request, res: Response) => {
  try {
-    const { limit = '500', offset = '0' } = req.query;
+    const { limit = '500', offset = '0', state } = req.query;
    const limitNum = Math.min(parseInt(limit as string, 10), 1000);
    const offsetNum = parseInt(offset as string, 10);

+    // Build WHERE clause based on state filter
+    let stateFilter = '';
+    const params: any[] = [limitNum, offsetNum];
+    if (state && state !== 'all') {
+      stateFilter = 'AND d.state = $3';
+      params.push(state);
+    }
+
    const { rows } = await pool.query(`
      SELECT
        sp.brand_name_raw as brand_name,
@@ -32,17 +44,26 @@ router.get('/brands', async (req: Request, res: Response) => {
      FROM store_products sp
      JOIN dispensaries d ON sp.dispensary_id = d.id
      WHERE sp.brand_name_raw IS NOT NULL AND sp.brand_name_raw != ''
+        ${stateFilter}
      GROUP BY sp.brand_name_raw
      ORDER BY store_count DESC, sku_count DESC
      LIMIT $1 OFFSET $2
-    `, [limitNum, offsetNum]);
+    `, params);

-    // Get total count
+    // Get total count with same state filter
+    const countParams: any[] = [];
+    let countStateFilter = '';
+    if (state && state !== 'all') {
+      countStateFilter = 'AND d.state = $1';
+      countParams.push(state);
+    }
    const { rows: countRows } = await pool.query(`
-      SELECT COUNT(DISTINCT brand_name_raw) as total
-      FROM store_products
-      WHERE brand_name_raw IS NOT NULL AND brand_name_raw != ''
-    `);
+      SELECT COUNT(DISTINCT sp.brand_name_raw) as total
+      FROM store_products sp
+      JOIN dispensaries d ON sp.dispensary_id = d.id
+      WHERE sp.brand_name_raw IS NOT NULL AND sp.brand_name_raw != ''
+        ${countStateFilter}
+    `, countParams);

    res.json({
      brands: rows.map((r: any) => ({
@@ -147,23 +168,58 @@ router.get('/brands/:brandName/penetration', async (req: Request, res: Response)
 /**
 * GET /api/admin/intelligence/pricing
 * Get pricing analytics by category
+ * Query params:
+ *   - state: Filter by state (e.g., "AZ")
 */
 router.get('/pricing', async (req: Request, res: Response) => {
  try {
-    const { rows: categoryRows } = await pool.query(`
-      SELECT
-        sp.category_raw as category,
-        ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
-        MIN(sp.price_rec) as min_price,
-        MAX(sp.price_rec) as max_price,
-        ROUND(PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY sp.price_rec)::numeric, 2) as median_price,
-        COUNT(*) as product_count
-      FROM store_products sp
-      WHERE sp.category_raw IS NOT NULL AND sp.price_rec > 0
-      GROUP BY sp.category_raw
-      ORDER BY product_count DESC
-    `);
+    const { state } = req.query;

+    // Build WHERE clause based on state filter
+    let stateFilter = '';
+    const categoryParams: any[] = [];
+    const stateQueryParams: any[] = [];
+    const overallParams: any[] = [];
+
+    if (state && state !== 'all') {
+      stateFilter = 'AND d.state = $1';
+      categoryParams.push(state);
+      overallParams.push(state);
+    }
+
+    // Category pricing with optional state filter
+    const categoryQuery = state && state !== 'all'
+      ? `
+        SELECT
+          sp.category_raw as category,
+          ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
+          MIN(sp.price_rec) as min_price,
+          MAX(sp.price_rec) as max_price,
+          ROUND(PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY sp.price_rec)::numeric, 2) as median_price,
+          COUNT(*) as product_count
+        FROM store_products sp
+        JOIN dispensaries d ON sp.dispensary_id = d.id
+        WHERE sp.category_raw IS NOT NULL AND sp.price_rec > 0 ${stateFilter}
+        GROUP BY sp.category_raw
+        ORDER BY product_count DESC
+      `
+      : `
+        SELECT
+          sp.category_raw as category,
+          ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
+          MIN(sp.price_rec) as min_price,
+          MAX(sp.price_rec) as max_price,
+          ROUND(PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY sp.price_rec)::numeric, 2) as median_price,
+          COUNT(*) as product_count
+        FROM store_products sp
+        WHERE sp.category_raw IS NOT NULL AND sp.price_rec > 0
+        GROUP BY sp.category_raw
+        ORDER BY product_count DESC
+      `;
+
+    const { rows: categoryRows } = await pool.query(categoryQuery, categoryParams);
+
+    // State pricing
    const { rows: stateRows } = await pool.query(`
      SELECT
        d.state,
@@ -178,6 +234,31 @@ router.get('/pricing', async (req: Request, res: Response) => {
      ORDER BY avg_price DESC
    `);

+    // Overall stats with optional state filter
+    const overallQuery = state && state !== 'all'
+      ? `
+        SELECT
+          ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
+          MIN(sp.price_rec) as min_price,
+          MAX(sp.price_rec) as max_price,
+          COUNT(*) as total_products
+        FROM store_products sp
+        JOIN dispensaries d ON sp.dispensary_id = d.id
+        WHERE sp.price_rec > 0 ${stateFilter}
+      `
+      : `
+        SELECT
+          ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
+          MIN(sp.price_rec) as min_price,
+          MAX(sp.price_rec) as max_price,
+          COUNT(*) as total_products
+        FROM store_products sp
+        WHERE sp.price_rec > 0
+      `;
+
+    const { rows: overallRows } = await pool.query(overallQuery, overallParams);
+    const overall = overallRows[0];
+
    res.json({
      byCategory: categoryRows.map((r: any) => ({
        category: r.category,
@@ -194,6 +275,12 @@ router.get('/pricing', async (req: Request, res: Response) => {
        maxPrice: r.max_price ? parseFloat(r.max_price) : null,
        productCount: parseInt(r.product_count, 10),
      })),
+      overall: {
+        avgPrice: overall?.avg_price ? parseFloat(overall.avg_price) : null,
+        minPrice: overall?.min_price ? parseFloat(overall.min_price) : null,
+        maxPrice: overall?.max_price ? parseFloat(overall.max_price) : null,
+        totalProducts: parseInt(overall?.total_products || '0', 10),
+      },
    });
  } catch (error: any) {
    console.error('[Intelligence] Error fetching pricing:', error.message);
@@ -204,9 +291,23 @@ router.get('/pricing', async (req: Request, res: Response) => {
 /**
 * GET /api/admin/intelligence/stores
 * Get store intelligence summary
+ * Query params:
+ *   - state: Filter by state (e.g., "AZ")
+ *   - limit: Max results (default 200)
 */
 router.get('/stores', async (req: Request, res: Response) => {
  try {
+    const { state, limit = '200' } = req.query;
+    const limitNum = Math.min(parseInt(limit as string, 10), 500);
+
+    // Build WHERE clause based on state filter
+    let stateFilter = '';
+    const params: any[] = [limitNum];
+    if (state && state !== 'all') {
+      stateFilter = 'AND d.state = $2';
+      params.push(state);
+    }
+
    const { rows: storeRows } = await pool.query(`
      SELECT
        d.id,
@@ -216,17 +317,22 @@ router.get('/stores', async (req: Request, res: Response) => {
        d.state,
        d.menu_type,
        d.crawl_enabled,
-        COUNT(DISTINCT sp.id) as product_count,
+        c.name as chain_name,
+        COUNT(DISTINCT sp.id) as sku_count,
        COUNT(DISTINCT sp.brand_name_raw) as brand_count,
        ROUND(AVG(sp.price_rec)::numeric, 2) as avg_price,
-        MAX(sp.updated_at) as last_product_update
+        MAX(sp.updated_at) as last_crawl,
+        (SELECT COUNT(*) FROM store_product_snapshots sps
+         WHERE sps.store_product_id IN (SELECT id FROM store_products WHERE dispensary_id = d.id)) as snapshot_count
      FROM dispensaries d
      LEFT JOIN store_products sp ON sp.dispensary_id = d.id
-      WHERE d.state IS NOT NULL
-      GROUP BY d.id, d.name, d.dba_name, d.city, d.state, d.menu_type, d.crawl_enabled
-      ORDER BY product_count DESC
-      LIMIT 200
-    `);
+      LEFT JOIN chains c ON d.chain_id = c.id
+      WHERE d.state IS NOT NULL AND d.crawl_enabled = true
+        ${stateFilter}
+      GROUP BY d.id, d.name, d.dba_name, d.city, d.state, d.menu_type, d.crawl_enabled, c.name
+      ORDER BY sku_count DESC
+      LIMIT $1
+    `, params);

    res.json({
      stores: storeRows.map((r: any) => ({
@@ -237,10 +343,13 @@ router.get('/stores', async (req: Request, res: Response) => {
        state: r.state,
        menuType: r.menu_type,
        crawlEnabled: r.crawl_enabled,
-        productCount: parseInt(r.product_count || '0', 10),
+        chainName: r.chain_name || null,
+        skuCount: parseInt(r.sku_count || '0', 10),
+        snapshotCount: parseInt(r.snapshot_count || '0', 10),
        brandCount: parseInt(r.brand_count || '0', 10),
        avgPrice: r.avg_price ? parseFloat(r.avg_price) : null,
-        lastProductUpdate: r.last_product_update,
+        lastCrawl: r.last_crawl,
+        crawlFrequencyHours: 4, // Default crawl frequency
      })),
      total: storeRows.length,
    });
--- a/backend/src/routes/markets.ts
+++ b/backend/src/routes/markets.ts
@@ -291,6 +291,107 @@ router.get('/stores/:id/summary', async (req: Request, res: Response) => {
  }
 });

+/**
+ * GET /api/markets/stores/:id/crawl-history
+ * Get crawl history for a specific store
+ */
+router.get('/stores/:id/crawl-history', async (req: Request, res: Response) => {
+  try {
+    const { id } = req.params;
+    const { limit = '50' } = req.query;
+    const dispensaryId = parseInt(id, 10);
+    const limitNum = Math.min(parseInt(limit as string, 10), 100);
+
+    // Get crawl history from crawl_orchestration_traces
+    const { rows: historyRows } = await pool.query(`
+      SELECT
+        id,
+        run_id,
+        profile_key,
+        crawler_module,
+        state_at_start,
+        state_at_end,
+        total_steps,
+        duration_ms,
+        success,
+        error_message,
+        products_found,
+        started_at,
+        completed_at
+      FROM crawl_orchestration_traces
+      WHERE dispensary_id = $1
+      ORDER BY started_at DESC
+      LIMIT $2
+    `, [dispensaryId, limitNum]);
+
+    // Get next scheduled crawl if available
+    const { rows: scheduleRows } = await pool.query(`
+      SELECT
+        js.id as schedule_id,
+        js.job_name,
+        js.enabled,
+        js.base_interval_minutes,
+        js.jitter_minutes,
+        js.next_run_at,
+        js.last_run_at,
+        js.last_status
+      FROM job_schedules js
+      WHERE js.enabled = true
+        AND js.job_config->>'dispensaryId' = $1::text
+      ORDER BY js.next_run_at
+      LIMIT 1
+    `, [dispensaryId.toString()]);
+
+    // Get dispensary info for slug
+    const { rows: dispRows } = await pool.query(`
+      SELECT
+        id,
+        name,
+        dba_name,
+        slug,
+        state,
+        city,
+        menu_type,
+        platform_dispensary_id,
+        last_menu_scrape
+      FROM dispensaries
+      WHERE id = $1
+    `, [dispensaryId]);
+
+    res.json({
+      dispensary: dispRows[0] || null,
+      history: historyRows.map(row => ({
+        id: row.id,
+        runId: row.run_id,
+        profileKey: row.profile_key,
+        crawlerModule: row.crawler_module,
+        stateAtStart: row.state_at_start,
+        stateAtEnd: row.state_at_end,
+        totalSteps: row.total_steps,
+        durationMs: row.duration_ms,
+        success: row.success,
+        errorMessage: row.error_message,
+        productsFound: row.products_found,
+        startedAt: row.started_at?.toISOString() || null,
+        completedAt: row.completed_at?.toISOString() || null,
+      })),
+      nextSchedule: scheduleRows[0] ? {
+        scheduleId: scheduleRows[0].schedule_id,
+        jobName: scheduleRows[0].job_name,
+        enabled: scheduleRows[0].enabled,
+        baseIntervalMinutes: scheduleRows[0].base_interval_minutes,
+        jitterMinutes: scheduleRows[0].jitter_minutes,
+        nextRunAt: scheduleRows[0].next_run_at?.toISOString() || null,
+        lastRunAt: scheduleRows[0].last_run_at?.toISOString() || null,
+        lastStatus: scheduleRows[0].last_status,
+      } : null,
+    });
+  } catch (error: any) {
+    console.error('[Markets] Error fetching crawl history:', error.message);
+    res.status(500).json({ error: error.message });
+  }
+});
+
 /**
 * GET /api/markets/stores/:id/products
 * Get products for a store with filtering and pagination
--- a/backend/src/routes/orchestrator-admin.ts
+++ b/backend/src/routes/orchestrator-admin.ts
@@ -78,14 +78,14 @@ router.get('/metrics', async (_req: Request, res: Response) => {

 /**
 * GET /api/admin/orchestrator/states
- * Returns array of states with at least one known dispensary
+ * Returns array of states with at least one crawl-enabled dispensary
 */
 router.get('/states', async (_req: Request, res: Response) => {
  try {
    const { rows } = await pool.query(`
      SELECT DISTINCT state, COUNT(*) as store_count
      FROM dispensaries
-      WHERE state IS NOT NULL
+      WHERE state IS NOT NULL AND crawl_enabled = true
      GROUP BY state
      ORDER BY state
    `);
--- a/backend/src/routes/tasks.ts
+++ b/backend/src/routes/tasks.ts
@@ -13,6 +13,12 @@ import {
  TaskFilter,
 } from '../tasks/task-service';
 import { pool } from '../db/pool';
+import {
+  isTaskPoolPaused,
+  pauseTaskPool,
+  resumeTaskPool,
+  getTaskPoolStatus,
+} from '../tasks/task-pool-state';

 const router = Router();

@@ -592,4 +598,42 @@ router.post('/migration/full-migrate', async (req: Request, res: Response) => {
  }
 });

+/**
+ * GET /api/tasks/pool/status
+ * Check if task pool is paused
+ */
+router.get('/pool/status', async (_req: Request, res: Response) => {
+  const status = getTaskPoolStatus();
+  res.json({
+    success: true,
+    ...status,
+  });
+});
+
+/**
+ * POST /api/tasks/pool/pause
+ * Pause the task pool - workers won't pick up new tasks
+ */
+router.post('/pool/pause', async (_req: Request, res: Response) => {
+  pauseTaskPool();
+  res.json({
+    success: true,
+    paused: true,
+    message: 'Task pool paused - workers will not pick up new tasks',
+  });
+});
+
+/**
+ * POST /api/tasks/pool/resume
+ * Resume the task pool - workers will pick up tasks again
+ */
+router.post('/pool/resume', async (_req: Request, res: Response) => {
+  resumeTaskPool();
+  res.json({
+    success: true,
+    paused: false,
+    message: 'Task pool resumed - workers will pick up new tasks',
+  });
+});
+
 export default router;
--- a/backend/src/tasks/handlers/store-discovery.ts
+++ b/backend/src/tasks/handlers/store-discovery.ts
@@ -25,7 +25,7 @@ export async function handleStoreDiscovery(ctx: TaskContext): Promise<TaskResult
  try {
    // Get states to discover
    const statesResult = await pool.query(`
-      SELECT code FROM states WHERE active = true ORDER BY code
+      SELECT code FROM states WHERE is_active = true ORDER BY code
    `);
    const stateCodes = statesResult.rows.map(r => r.code);

--- a/backend/src/tasks/task-pool-state.ts
+++ b/backend/src/tasks/task-pool-state.ts
@@ -0,0 +1,37 @@
+/**
+ * Task Pool State
+ *
+ * Shared state for task pool pause/resume functionality.
+ * This is kept separate to avoid circular dependencies between
+ * task-service.ts and routes/tasks.ts.
+ *
+ * State is in-memory and resets on server restart.
+ * By default, the pool is PAUSED (closed) - admin must explicitly start it.
+ * This prevents workers from immediately grabbing tasks on deploy before
+ * the system is ready.
+ */
+
+let taskPoolPaused = true;
+
+export function isTaskPoolPaused(): boolean {
+  return taskPoolPaused;
+}
+
+export function pauseTaskPool(): void {
+  taskPoolPaused = true;
+  console.log('[TaskPool] Task pool PAUSED - workers will not pick up new tasks');
+}
+
+export function resumeTaskPool(): void {
+  taskPoolPaused = false;
+  console.log('[TaskPool] Task pool RESUMED - workers can pick up tasks');
+}
+
+export function getTaskPoolStatus(): { paused: boolean; message: string } {
+  return {
+    paused: taskPoolPaused,
+    message: taskPoolPaused
+      ? 'Task pool is paused - workers will not pick up new tasks'
+      : 'Task pool is open - workers are picking up tasks',
+  };
+}
--- a/backend/src/tasks/task-service.ts
+++ b/backend/src/tasks/task-service.ts
@@ -9,6 +9,7 @@
 */

 import { pool } from '../db/pool';
+import { isTaskPoolPaused } from './task-pool-state';

 // Helper to check if a table exists
 async function tableExists(tableName: string): Promise<boolean> {
@@ -149,8 +150,14 @@ class TaskService {
  /**
   * Claim a task atomically for a worker
   * If role is null, claims ANY available task (role-agnostic worker)
+   * Returns null if task pool is paused.
   */
  async claimTask(role: TaskRole | null, workerId: string): Promise<WorkerTask | null> {
+    // Check if task pool is paused - don't claim any tasks
+    if (isTaskPoolPaused()) {
+      return null;
+    }
+
    if (role) {
      // Role-specific claiming - use the SQL function
      const result = await pool.query(
--- a/backend/src/tasks/task-worker.ts
+++ b/backend/src/tasks/task-worker.ts
@@ -117,40 +117,79 @@ export class TaskWorker {
   * Called once on worker startup before processing any tasks.
   *
   * IMPORTANT: Proxies are REQUIRED. Workers will wait until proxies are available.
+   * Workers listen for PostgreSQL NOTIFY 'proxy_added' to wake up immediately when proxies are added.
   */
  private async initializeStealth(): Promise<void> {
    const MAX_WAIT_MINUTES = 60;
-    const RETRY_INTERVAL_MS = 30000; // 30 seconds
-    const maxAttempts = (MAX_WAIT_MINUTES * 60 * 1000) / RETRY_INTERVAL_MS;
+    const POLL_INTERVAL_MS = 30000; // 30 seconds fallback polling
+    const maxAttempts = (MAX_WAIT_MINUTES * 60 * 1000) / POLL_INTERVAL_MS;
    let attempts = 0;
+    let notifyClient: any = null;

-    while (attempts < maxAttempts) {
-      try {
-        // Load proxies from database
-        await this.crawlRotator.initialize();
-
-        const stats = this.crawlRotator.proxy.getStats();
-        if (stats.activeProxies > 0) {
-          console.log(`[TaskWorker] Loaded ${stats.activeProxies} proxies (${stats.avgSuccessRate.toFixed(1)}% avg success rate)`);
-
-          // Wire rotator to Dutchie client - proxies will be used for ALL requests
-          setCrawlRotator(this.crawlRotator);
-
-          console.log(`[TaskWorker] Stealth initialized: ${this.crawlRotator.userAgent.getCount()} fingerprints, proxy REQUIRED for all requests`);
-          return;
-        }
-
-        attempts++;
-        console.log(`[TaskWorker] No active proxies available (attempt ${attempts}). Waiting ${RETRY_INTERVAL_MS / 1000}s for proxies to be added...`);
-        await this.sleep(RETRY_INTERVAL_MS);
-      } catch (error: any) {
-        attempts++;
-        console.log(`[TaskWorker] Error loading proxies (attempt ${attempts}): ${error.message}. Retrying in ${RETRY_INTERVAL_MS / 1000}s...`);
-        await this.sleep(RETRY_INTERVAL_MS);
-      }
+    // Set up PostgreSQL LISTEN for proxy notifications
+    try {
+      notifyClient = await this.pool.connect();
+      await notifyClient.query('LISTEN proxy_added');
+      console.log(`[TaskWorker] Listening for proxy_added notifications...`);
+    } catch (err: any) {
+      console.log(`[TaskWorker] Could not set up LISTEN (will poll): ${err.message}`);
    }

-    throw new Error(`No active proxies available after waiting ${MAX_WAIT_MINUTES} minutes. Add proxies to the database.`);
+    // Create a promise that resolves when notified
+    let notifyResolve: (() => void) | null = null;
+    if (notifyClient) {
+      notifyClient.on('notification', (msg: any) => {
+        if (msg.channel === 'proxy_added') {
+          console.log(`[TaskWorker] Received proxy_added notification!`);
+          if (notifyResolve) notifyResolve();
+        }
+      });
+    }
+
+    try {
+      while (attempts < maxAttempts) {
+        try {
+          // Load proxies from database
+          await this.crawlRotator.initialize();
+
+          const stats = this.crawlRotator.proxy.getStats();
+          if (stats.activeProxies > 0) {
+            console.log(`[TaskWorker] Loaded ${stats.activeProxies} proxies (${stats.avgSuccessRate.toFixed(1)}% avg success rate)`);
+
+            // Wire rotator to Dutchie client - proxies will be used for ALL requests
+            setCrawlRotator(this.crawlRotator);
+
+            console.log(`[TaskWorker] Stealth initialized: ${this.crawlRotator.userAgent.getCount()} fingerprints, proxy REQUIRED for all requests`);
+            return;
+          }
+
+          attempts++;
+          console.log(`[TaskWorker] No active proxies available (attempt ${attempts}). Waiting for proxies...`);
+
+          // Wait for either notification or timeout
+          await new Promise<void>((resolve) => {
+            notifyResolve = resolve;
+            setTimeout(resolve, POLL_INTERVAL_MS);
+          });
+        } catch (error: any) {
+          attempts++;
+          console.log(`[TaskWorker] Error loading proxies (attempt ${attempts}): ${error.message}. Retrying...`);
+          await this.sleep(POLL_INTERVAL_MS);
+        }
+      }
+
+      throw new Error(`No active proxies available after waiting ${MAX_WAIT_MINUTES} minutes. Add proxies to the database.`);
+    } finally {
+      // Clean up LISTEN connection
+      if (notifyClient) {
+        try {
+          await notifyClient.query('UNLISTEN proxy_added');
+          notifyClient.release();
+        } catch {
+          // Ignore cleanup errors
+        }
+      }
+    }
  }

  /**
--- a/cannaiq/dist/index.html
+++ b/cannaiq/dist/index.html
@@ -7,8 +7,8 @@
    <title>CannaIQ - Cannabis Menu Intelligence Platform</title>
    <meta name="description" content="CannaIQ provides real-time cannabis dispensary menu data, product tracking, and analytics for dispensaries across Arizona." />
    <meta name="keywords" content="cannabis, dispensary, menu, products, analytics, Arizona" />
-    <script type="module" crossorigin src="/assets/index-BML8-px1.js"></script>
-    <link rel="stylesheet" crossorigin href="/assets/index-B2gR-58G.css">
+    <script type="module" crossorigin src="/assets/index-Dq9S0rVi.js"></script>
+    <link rel="stylesheet" crossorigin href="/assets/index-DhM09B-d.css">
  </head>
  <body>
    <div id="root"></div>
--- a/cannaiq/src/App.tsx
+++ b/cannaiq/src/App.tsx
@@ -8,6 +8,7 @@ import { ProductDetail } from './pages/ProductDetail';
 import { Stores } from './pages/Stores';
 import { Dispensaries } from './pages/Dispensaries';
 import { DispensaryDetail } from './pages/DispensaryDetail';
+import { DispensarySchedule } from './pages/DispensarySchedule';
 import { StoreDetail } from './pages/StoreDetail';
 import { StoreBrands } from './pages/StoreBrands';
 import { StoreSpecials } from './pages/StoreSpecials';
@@ -66,6 +67,7 @@ export default function App() {
        <Route path="/stores" element={<PrivateRoute><Stores /></PrivateRoute>} />
        <Route path="/dispensaries" element={<PrivateRoute><Dispensaries /></PrivateRoute>} />
        <Route path="/dispensaries/:state/:city/:slug" element={<PrivateRoute><DispensaryDetail /></PrivateRoute>} />
+        <Route path="/dispensaries/:state/:city/:slug/schedule" element={<PrivateRoute><DispensarySchedule /></PrivateRoute>} />
        <Route path="/stores/:state/:storeName/:slug/brands" element={<PrivateRoute><StoreBrands /></PrivateRoute>} />
        <Route path="/stores/:state/:storeName/:slug/specials" element={<PrivateRoute><StoreSpecials /></PrivateRoute>} />
        <Route path="/stores/:state/:storeName/:slug" element={<PrivateRoute><StoreDetail /></PrivateRoute>} />
--- a/cannaiq/src/components/Layout.tsx
+++ b/cannaiq/src/components/Layout.tsx
@@ -131,7 +131,7 @@ export function Layout({ children }: LayoutProps) {
            <span className="text-lg font-bold text-gray-900">CannaIQ</span>
            {versionInfo && (
              <p className="text-xs text-gray-400">
-                v{versionInfo.version} ({versionInfo.git_sha}) {versionInfo.build_time !== 'unknown' && `- ${new Date(versionInfo.build_time).toLocaleDateString()}`}
+                {versionInfo.git_sha || 'dev'}
              </p>
            )}
          </div>
--- a/cannaiq/src/lib/api.ts
+++ b/cannaiq/src/lib/api.ts
@@ -983,6 +983,47 @@ class ApiClient {
    }>(`/api/markets/stores/${id}/categories`);
  }

+  async getStoreCrawlHistory(id: number, limit = 50) {
+    return this.request<{
+      dispensary: {
+        id: number;
+        name: string;
+        dba_name: string | null;
+        slug: string;
+        state: string;
+        city: string;
+        menu_type: string | null;
+        platform_dispensary_id: string | null;
+        last_menu_scrape: string | null;
+      } | null;
+      history: Array<{
+        id: number;
+        runId: string | null;
+        profileKey: string | null;
+        crawlerModule: string | null;
+        stateAtStart: string | null;
+        stateAtEnd: string | null;
+        totalSteps: number;
+        durationMs: number | null;
+        success: boolean;
+        errorMessage: string | null;
+        productsFound: number | null;
+        startedAt: string | null;
+        completedAt: string | null;
+      }>;
+      nextSchedule: {
+        scheduleId: number;
+        jobName: string;
+        enabled: boolean;
+        baseIntervalMinutes: number;
+        jitterMinutes: number;
+        nextRunAt: string | null;
+        lastRunAt: string | null;
+        lastStatus: string | null;
+      } | null;
+    }>(`/api/markets/stores/${id}/crawl-history?limit=${limit}`);
+  }
+
  // Global Brands/Categories (from v_brands/v_categories views)
  async getMarketBrands(params?: { limit?: number; offset?: number }) {
    const searchParams = new URLSearchParams();
@@ -1518,10 +1559,11 @@ class ApiClient {
  }

  // Intelligence API
-  async getIntelligenceBrands(params?: { limit?: number; offset?: number }) {
+  async getIntelligenceBrands(params?: { limit?: number; offset?: number; state?: string }) {
    const searchParams = new URLSearchParams();
    if (params?.limit) searchParams.append('limit', params.limit.toString());
    if (params?.offset) searchParams.append('offset', params.offset.toString());
+    if (params?.state) searchParams.append('state', params.state);
    const queryString = searchParams.toString() ? `?${searchParams.toString()}` : '';
    return this.request<{
      brands: Array<{
@@ -1536,7 +1578,10 @@ class ApiClient {
    }>(`/api/admin/intelligence/brands${queryString}`);
  }

-  async getIntelligencePricing() {
+  async getIntelligencePricing(params?: { state?: string }) {
+    const searchParams = new URLSearchParams();
+    if (params?.state) searchParams.append('state', params.state);
+    const queryString = searchParams.toString() ? `?${searchParams.toString()}` : '';
    return this.request<{
      byCategory: Array<{
        category: string;
@@ -1552,7 +1597,7 @@ class ApiClient {
        maxPrice: number;
        totalProducts: number;
      };
-    }>('/api/admin/intelligence/pricing');
+    }>(`/api/admin/intelligence/pricing${queryString}`);
  }

  async getIntelligenceStoreActivity(params?: { state?: string; chainId?: number; limit?: number }) {
@@ -2884,6 +2929,27 @@ class ApiClient {
      `/api/tasks/store/${dispensaryId}/active`
    );
  }
+
+  // Task Pool Control
+  async getTaskPoolStatus() {
+    return this.request<{ success: boolean; paused: boolean; message: string }>(
+      '/api/tasks/pool/status'
+    );
+  }
+
+  async pauseTaskPool() {
+    return this.request<{ success: boolean; paused: boolean; message: string }>(
+      '/api/tasks/pool/pause',
+      { method: 'POST' }
+    );
+  }
+
+  async resumeTaskPool() {
+    return this.request<{ success: boolean; paused: boolean; message: string }>(
+      '/api/tasks/pool/resume',
+      { method: 'POST' }
+    );
+  }
 }

 export const api = new ApiClient(API_URL);
--- a/cannaiq/src/pages/Dashboard.tsx
+++ b/cannaiq/src/pages/Dashboard.tsx
@@ -1,6 +1,5 @@
 import { useEffect, useState } from 'react';
 import { Layout } from '../components/Layout';
-import { HealthPanel } from '../components/HealthPanel';
 import { api } from '../lib/api';
 import { useNavigate } from 'react-router-dom';
 import {
@@ -42,7 +41,6 @@ export function Dashboard() {
  const [activity, setActivity] = useState<any>(null);
  const [nationalStats, setNationalStats] = useState<any>(null);
  const [loading, setLoading] = useState(true);
-  const [refreshing, setRefreshing] = useState(false);
  const [pendingChangesCount, setPendingChangesCount] = useState(0);
  const [showNotification, setShowNotification] = useState(false);
  const [taskCounts, setTaskCounts] = useState<Record<string, number> | null>(null);
@@ -93,10 +91,7 @@ export function Dashboard() {
    }
  };

-  const loadData = async (isRefresh = false) => {
-    if (isRefresh) {
-      setRefreshing(true);
-    }
+  const loadData = async () => {
    try {
      // Fetch dashboard data (primary data source)
      const dashboard = await api.getMarketDashboard();
@@ -158,7 +153,6 @@ export function Dashboard() {
      console.error('Failed to load dashboard:', error);
    } finally {
      setLoading(false);
-      setRefreshing(false);
    }
  };

@@ -271,24 +265,11 @@ export function Dashboard() {

      <div className="space-y-8">
        {/* Header */}
-        <div className="flex flex-col sm:flex-row sm:justify-between sm:items-center gap-4">
-          <div>
-            <h1 className="text-xl sm:text-2xl font-semibold text-gray-900">Dashboard</h1>
-            <p className="text-sm text-gray-500 mt-1">Monitor your dispensary data aggregation</p>
-          </div>
-          <button
-            onClick={() => loadData(true)}
-            disabled={refreshing}
-            className="inline-flex items-center justify-center gap-2 px-4 py-2 bg-white border border-gray-200 rounded-lg hover:bg-gray-50 transition-colors text-sm font-medium text-gray-700 self-start sm:self-auto disabled:opacity-50 disabled:cursor-not-allowed"
-          >
-            <RefreshCw className={`w-4 h-4 ${refreshing ? 'animate-spin' : ''}`} />
-            {refreshing ? 'Refreshing...' : 'Refresh'}
-          </button>
+        <div>
+          <h1 className="text-xl sm:text-2xl font-semibold text-gray-900">Dashboard</h1>
+          <p className="text-sm text-gray-500 mt-1">Monitor your dispensary data aggregation</p>
        </div>

-        {/* System Health */}
-        <HealthPanel showQueues={false} refreshInterval={60000} />
-
        {/* Stats Grid */}
        <div className="grid grid-cols-2 lg:grid-cols-3 gap-3 sm:gap-6">
          {/* Products */}
--- a/cannaiq/src/pages/Dispensaries.tsx
+++ b/cannaiq/src/pages/Dispensaries.tsx
@@ -161,23 +161,6 @@ export function Dispensaries() {
                ))}
              </select>
            </div>
-            <div>
-              <label className="block text-sm font-medium text-gray-700 mb-2">
-                Filter by Status
-              </label>
-              <select
-                value={filterStatus}
-                onChange={(e) => handleStatusFilter(e.target.value)}
-                className={`w-full px-3 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500 ${
-                  filterStatus === 'dropped' ? 'border-red-300 bg-red-50' : 'border-gray-300'
-                }`}
-              >
-                <option value="">All Statuses</option>
-                <option value="open">Open</option>
-                <option value="dropped">Dropped (Needs Review)</option>
-                <option value="closed">Closed</option>
-              </select>
-            </div>
          </div>
        </div>

--- a/cannaiq/src/pages/DispensaryDetail.tsx
+++ b/cannaiq/src/pages/DispensaryDetail.tsx
@@ -204,47 +204,6 @@ export function DispensaryDetail() {
            Back to Dispensaries
          </button>

-          {/* Update Dropdown */}
-          <div className="relative">
-            <button
-              onClick={() => setShowUpdateDropdown(!showUpdateDropdown)}
-              disabled={isUpdating}
-              className="flex items-center gap-2 px-4 py-2 text-sm font-medium text-white bg-blue-600 hover:bg-blue-700 rounded-lg disabled:opacity-50 disabled:cursor-not-allowed"
-            >
-              <RefreshCw className={`w-4 h-4 ${isUpdating ? 'animate-spin' : ''}`} />
-              {isUpdating ? 'Updating...' : 'Update'}
-              {!isUpdating && <ChevronDown className="w-4 h-4" />}
-            </button>
-
-            {showUpdateDropdown && !isUpdating && (
-              <div className="absolute right-0 mt-2 w-48 bg-white rounded-lg shadow-lg border border-gray-200 z-10">
-                <button
-                  onClick={() => handleUpdate('products')}
-                  className="w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-100 rounded-t-lg"
-                >
-                  Products
-                </button>
-                <button
-                  onClick={() => handleUpdate('brands')}
-                  className="w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-100"
-                >
-                  Brands
-                </button>
-                <button
-                  onClick={() => handleUpdate('specials')}
-                  className="w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-100"
-                >
-                  Specials
-                </button>
-                <button
-                  onClick={() => handleUpdate('all')}
-                  className="w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-100 rounded-b-lg border-t border-gray-200"
-                >
-                  All
-                </button>
-              </div>
-            )}
-          </div>
        </div>

        {/* Dispensary Header */}
@@ -266,7 +225,7 @@ export function DispensaryDetail() {
            <div className="flex items-center gap-2 text-sm text-gray-600 bg-gray-50 px-4 py-2 rounded-lg">
              <Calendar className="w-4 h-4" />
              <div>
-                <span className="font-medium">Last Crawl Date:</span>
+                <span className="font-medium">Last Updated:</span>
                <span className="ml-2">
                  {dispensary.last_menu_scrape
                    ? new Date(dispensary.last_menu_scrape).toLocaleDateString('en-US', {
@@ -331,7 +290,7 @@ export function DispensaryDetail() {
              </a>
            )}
            <Link
-              to="/schedule"
+              to={`/dispensaries/${state}/${city}/${slug}/schedule`}
              className="flex items-center gap-2 text-sm text-blue-600 hover:text-blue-800"
            >
              <Clock className="w-4 h-4" />
@@ -533,57 +492,31 @@ export function DispensaryDetail() {
                                `$${product.regular_price}`
                              ) : '-'}
                            </td>
-                            <td className="text-center whitespace-nowrap">
-                              {product.quantity != null ? (
-                                <span className={`badge badge-sm ${product.quantity > 0 ? 'badge-info' : 'badge-error'}`}>
-                                  {product.quantity}
-                                </span>
-                              ) : '-'}
+                            <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                              {product.quantity != null ? product.quantity : '-'}
                            </td>
-                            <td className="text-center whitespace-nowrap">
-                              {product.thc_percentage ? (
-                                <span className="badge badge-success badge-sm">{product.thc_percentage}%</span>
-                              ) : '-'}
+                            <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                              {product.thc_percentage ? `${product.thc_percentage}%` : '-'}
                            </td>
-                            <td className="text-center whitespace-nowrap">
-                              {product.cbd_percentage ? (
-                                <span className="badge badge-info badge-sm">{product.cbd_percentage}%</span>
-                              ) : '-'}
+                            <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                              {product.cbd_percentage ? `${product.cbd_percentage}%` : '-'}
                            </td>
-                            <td className="text-center whitespace-nowrap">
-                              {product.strain_type ? (
-                                <span className="badge badge-ghost badge-sm">{product.strain_type}</span>
-                              ) : '-'}
+                            <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                              {product.strain_type || '-'}
                            </td>
-                            <td className="text-center whitespace-nowrap">
-                              {product.in_stock ? (
-                                <span className="badge badge-success badge-sm">Yes</span>
-                              ) : product.in_stock === false ? (
-                                <span className="badge badge-error badge-sm">No</span>
-                              ) : '-'}
+                            <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                              {product.in_stock ? 'Yes' : product.in_stock === false ? 'No' : '-'}
                            </td>
                            <td className="whitespace-nowrap text-xs text-gray-500">
                              {product.updated_at ? formatDate(product.updated_at) : '-'}
                            </td>
                            <td>
-                              <div className="flex gap-1">
-                                {product.dutchie_url && (
-                                  <a
-                                    href={product.dutchie_url}
-                                    target="_blank"
-                                    rel="noopener noreferrer"
-                                    className="btn btn-xs btn-outline"
-                                  >
-                                    Dutchie
-                                  </a>
-                                )}
-                                <button
-                                  onClick={() => navigate(`/products/${product.id}`)}
-                                  className="btn btn-xs btn-primary"
-                                >
-                                  Details
-                                </button>
-                              </div>
+                              <button
+                                onClick={() => navigate(`/products/${product.id}`)}
+                                className="btn btn-xs btn-ghost text-gray-500 hover:text-gray-700"
+                              >
+                                Details
+                              </button>
                            </td>
                          </tr>
                        ))}
--- a/cannaiq/src/pages/DispensarySchedule.tsx
+++ b/cannaiq/src/pages/DispensarySchedule.tsx
@@ -0,0 +1,378 @@
+import { useEffect, useState } from 'react';
+import { useParams, useNavigate, Link } from 'react-router-dom';
+import { Layout } from '../components/Layout';
+import { api } from '../lib/api';
+import {
+  ArrowLeft,
+  Clock,
+  Calendar,
+  CheckCircle,
+  XCircle,
+  AlertCircle,
+  Package,
+  Timer,
+  Building2,
+} from 'lucide-react';
+
+interface CrawlHistoryItem {
+  id: number;
+  runId: string | null;
+  profileKey: string | null;
+  crawlerModule: string | null;
+  stateAtStart: string | null;
+  stateAtEnd: string | null;
+  totalSteps: number;
+  durationMs: number | null;
+  success: boolean;
+  errorMessage: string | null;
+  productsFound: number | null;
+  startedAt: string | null;
+  completedAt: string | null;
+}
+
+interface NextSchedule {
+  scheduleId: number;
+  jobName: string;
+  enabled: boolean;
+  baseIntervalMinutes: number;
+  jitterMinutes: number;
+  nextRunAt: string | null;
+  lastRunAt: string | null;
+  lastStatus: string | null;
+}
+
+interface Dispensary {
+  id: number;
+  name: string;
+  dba_name: string | null;
+  slug: string;
+  state: string;
+  city: string;
+  menu_type: string | null;
+  platform_dispensary_id: string | null;
+  last_menu_scrape: string | null;
+}
+
+export function DispensarySchedule() {
+  const { state, city, slug } = useParams();
+  const navigate = useNavigate();
+  const [dispensary, setDispensary] = useState<Dispensary | null>(null);
+  const [history, setHistory] = useState<CrawlHistoryItem[]>([]);
+  const [nextSchedule, setNextSchedule] = useState<NextSchedule | null>(null);
+  const [loading, setLoading] = useState(true);
+
+  useEffect(() => {
+    loadScheduleData();
+  }, [slug]);
+
+  const loadScheduleData = async () => {
+    setLoading(true);
+    try {
+      // First get the dispensary to get the ID
+      const dispData = await api.getDispensary(slug!);
+      if (dispData?.id) {
+        const data = await api.getStoreCrawlHistory(dispData.id);
+        setDispensary(data.dispensary);
+        setHistory(data.history || []);
+        setNextSchedule(data.nextSchedule);
+      }
+    } catch (error) {
+      console.error('Failed to load schedule data:', error);
+    } finally {
+      setLoading(false);
+    }
+  };
+
+  const formatDate = (dateStr: string | null) => {
+    if (!dateStr) return 'Never';
+    const date = new Date(dateStr);
+    return date.toLocaleDateString('en-US', {
+      year: 'numeric',
+      month: 'short',
+      day: 'numeric',
+      hour: '2-digit',
+      minute: '2-digit',
+    });
+  };
+
+  const formatTimeAgo = (dateStr: string | null) => {
+    if (!dateStr) return 'Never';
+    const date = new Date(dateStr);
+    const now = new Date();
+    const diffMs = now.getTime() - date.getTime();
+    const diffMinutes = Math.floor(diffMs / (1000 * 60));
+    const diffHours = Math.floor(diffMs / (1000 * 60 * 60));
+    const diffDays = Math.floor(diffMs / (1000 * 60 * 60 * 24));
+
+    if (diffMinutes < 1) return 'Just now';
+    if (diffMinutes < 60) return `${diffMinutes}m ago`;
+    if (diffHours < 24) return `${diffHours}h ago`;
+    if (diffDays === 1) return 'Yesterday';
+    if (diffDays < 7) return `${diffDays} days ago`;
+    return date.toLocaleDateString();
+  };
+
+  const formatTimeUntil = (dateStr: string | null) => {
+    if (!dateStr) return 'Not scheduled';
+    const date = new Date(dateStr);
+    const now = new Date();
+    const diffMs = date.getTime() - now.getTime();
+
+    if (diffMs < 0) return 'Overdue';
+
+    const diffMinutes = Math.floor(diffMs / (1000 * 60));
+    const diffHours = Math.floor(diffMinutes / 60);
+
+    if (diffMinutes < 60) return `in ${diffMinutes}m`;
+    return `in ${diffHours}h ${diffMinutes % 60}m`;
+  };
+
+  const formatDuration = (ms: number | null) => {
+    if (!ms) return '-';
+    if (ms < 1000) return `${ms}ms`;
+    const seconds = Math.floor(ms / 1000);
+    const minutes = Math.floor(seconds / 60);
+    if (minutes < 1) return `${seconds}s`;
+    return `${minutes}m ${seconds % 60}s`;
+  };
+
+  const formatInterval = (baseMinutes: number, jitterMinutes: number) => {
+    const hours = Math.floor(baseMinutes / 60);
+    const mins = baseMinutes % 60;
+    let base = hours > 0 ? `${hours}h` : '';
+    if (mins > 0) base += `${mins}m`;
+    return `Every ${base} (+/- ${jitterMinutes}m jitter)`;
+  };
+
+  if (loading) {
+    return (
+      <Layout>
+        <div className="text-center py-12">
+          <div className="inline-block animate-spin rounded-full h-8 w-8 border-4 border-gray-400 border-t-transparent"></div>
+          <p className="mt-2 text-sm text-gray-600">Loading schedule...</p>
+        </div>
+      </Layout>
+    );
+  }
+
+  if (!dispensary) {
+    return (
+      <Layout>
+        <div className="text-center py-12">
+          <p className="text-gray-600">Dispensary not found</p>
+        </div>
+      </Layout>
+    );
+  }
+
+  // Stats from history
+  const successCount = history.filter(h => h.success).length;
+  const failureCount = history.filter(h => !h.success).length;
+  const lastSuccess = history.find(h => h.success);
+  const avgDuration = history.length > 0
+    ? Math.round(history.reduce((sum, h) => sum + (h.durationMs || 0), 0) / history.length)
+    : 0;
+
+  return (
+    <Layout>
+      <div className="space-y-6">
+        {/* Header */}
+        <div className="flex items-center justify-between gap-4">
+          <button
+            onClick={() => navigate(`/dispensaries/${state}/${city}/${slug}`)}
+            className="flex items-center gap-2 text-sm text-gray-600 hover:text-gray-900"
+          >
+            <ArrowLeft className="w-4 h-4" />
+            Back to {dispensary.dba_name || dispensary.name}
+          </button>
+        </div>
+
+        {/* Dispensary Info */}
+        <div className="bg-white rounded-lg border border-gray-200 p-6">
+          <div className="flex items-start gap-4">
+            <div className="p-3 bg-blue-50 rounded-lg">
+              <Building2 className="w-8 h-8 text-blue-600" />
+            </div>
+            <div>
+              <h1 className="text-2xl font-bold text-gray-900">
+                {dispensary.dba_name || dispensary.name}
+              </h1>
+              <p className="text-sm text-gray-600 mt-1">
+                {dispensary.city}, {dispensary.state} - Crawl Schedule & History
+              </p>
+              <div className="flex items-center gap-4 mt-2 text-sm text-gray-500">
+                <span>Slug: {dispensary.slug}</span>
+                {dispensary.menu_type && (
+                  <span className="px-2 py-0.5 bg-gray-100 rounded text-xs">
+                    {dispensary.menu_type}
+                  </span>
+                )}
+              </div>
+            </div>
+          </div>
+        </div>
+
+        {/* Next Scheduled Crawl */}
+        {nextSchedule && (
+          <div className="bg-white rounded-lg border border-gray-200 p-6">
+            <h2 className="text-lg font-semibold text-gray-900 mb-4 flex items-center gap-2">
+              <Clock className="w-5 h-5 text-blue-500" />
+              Upcoming Schedule
+            </h2>
+            <div className="grid grid-cols-4 gap-6">
+              <div>
+                <p className="text-sm text-gray-500">Next Run</p>
+                <p className="text-xl font-semibold text-blue-600">
+                  {formatTimeUntil(nextSchedule.nextRunAt)}
+                </p>
+                <p className="text-xs text-gray-400">
+                  {formatDate(nextSchedule.nextRunAt)}
+                </p>
+              </div>
+              <div>
+                <p className="text-sm text-gray-500">Interval</p>
+                <p className="text-lg font-medium">
+                  {formatInterval(nextSchedule.baseIntervalMinutes, nextSchedule.jitterMinutes)}
+                </p>
+              </div>
+              <div>
+                <p className="text-sm text-gray-500">Last Run</p>
+                <p className="text-lg font-medium">
+                  {formatTimeAgo(nextSchedule.lastRunAt)}
+                </p>
+              </div>
+              <div>
+                <p className="text-sm text-gray-500">Last Status</p>
+                <p className={`text-lg font-medium ${
+                  nextSchedule.lastStatus === 'success' ? 'text-green-600' :
+                  nextSchedule.lastStatus === 'error' ? 'text-red-600' : 'text-gray-600'
+                }`}>
+                  {nextSchedule.lastStatus || '-'}
+                </p>
+              </div>
+            </div>
+          </div>
+        )}
+
+        {/* Stats Summary */}
+        <div className="grid grid-cols-4 gap-4">
+          <div className="bg-white rounded-lg border border-gray-200 p-4">
+            <div className="flex items-center gap-3">
+              <CheckCircle className="w-8 h-8 text-green-500" />
+              <div>
+                <p className="text-sm text-gray-500">Successful Runs</p>
+                <p className="text-2xl font-bold text-green-600">{successCount}</p>
+              </div>
+            </div>
+          </div>
+          <div className="bg-white rounded-lg border border-gray-200 p-4">
+            <div className="flex items-center gap-3">
+              <XCircle className="w-8 h-8 text-red-500" />
+              <div>
+                <p className="text-sm text-gray-500">Failed Runs</p>
+                <p className="text-2xl font-bold text-red-600">{failureCount}</p>
+              </div>
+            </div>
+          </div>
+          <div className="bg-white rounded-lg border border-gray-200 p-4">
+            <div className="flex items-center gap-3">
+              <Timer className="w-8 h-8 text-blue-500" />
+              <div>
+                <p className="text-sm text-gray-500">Avg Duration</p>
+                <p className="text-2xl font-bold">{formatDuration(avgDuration)}</p>
+              </div>
+            </div>
+          </div>
+          <div className="bg-white rounded-lg border border-gray-200 p-4">
+            <div className="flex items-center gap-3">
+              <Package className="w-8 h-8 text-purple-500" />
+              <div>
+                <p className="text-sm text-gray-500">Last Products Found</p>
+                <p className="text-2xl font-bold">
+                  {lastSuccess?.productsFound?.toLocaleString() || '-'}
+                </p>
+              </div>
+            </div>
+          </div>
+        </div>
+
+        {/* Crawl History Table */}
+        <div className="bg-white rounded-lg border border-gray-200">
+          <div className="p-4 border-b border-gray-200">
+            <h2 className="text-lg font-semibold text-gray-900 flex items-center gap-2">
+              <Calendar className="w-5 h-5 text-gray-500" />
+              Crawl History
+            </h2>
+          </div>
+          <div className="overflow-x-auto">
+            <table className="table table-sm w-full">
+              <thead className="bg-gray-50">
+                <tr>
+                  <th>Status</th>
+                  <th>Started</th>
+                  <th>Duration</th>
+                  <th className="text-right">Products</th>
+                  <th>State</th>
+                  <th>Error</th>
+                </tr>
+              </thead>
+              <tbody>
+                {history.length === 0 ? (
+                  <tr>
+                    <td colSpan={6} className="text-center py-8 text-gray-500">
+                      No crawl history available
+                    </td>
+                  </tr>
+                ) : (
+                  history.map((item) => (
+                    <tr key={item.id} className="hover:bg-gray-50">
+                      <td>
+                        <span className={`inline-flex items-center gap-1 px-2 py-1 rounded text-xs font-medium ${
+                          item.success
+                            ? 'bg-green-100 text-green-700'
+                            : 'bg-red-100 text-red-700'
+                        }`}>
+                          {item.success ? (
+                            <CheckCircle className="w-3 h-3" />
+                          ) : (
+                            <XCircle className="w-3 h-3" />
+                          )}
+                          {item.success ? 'Success' : 'Failed'}
+                        </span>
+                      </td>
+                      <td>
+                        <div className="text-sm">{formatDate(item.startedAt)}</div>
+                        <div className="text-xs text-gray-400">{formatTimeAgo(item.startedAt)}</div>
+                      </td>
+                      <td className="font-mono text-sm">
+                        {formatDuration(item.durationMs)}
+                      </td>
+                      <td className="text-right font-mono text-sm">
+                        {item.productsFound?.toLocaleString() || '-'}
+                      </td>
+                      <td className="text-sm text-gray-600">
+                        {item.stateAtEnd || item.stateAtStart || '-'}
+                      </td>
+                      <td className="max-w-[200px]">
+                        {item.errorMessage ? (
+                          <span
+                            className="text-xs text-red-600 truncate block cursor-help"
+                            title={item.errorMessage}
+                          >
+                            {item.errorMessage.substring(0, 50)}...
+                          </span>
+                        ) : '-'}
+                      </td>
+                    </tr>
+                  ))
+                )}
+              </tbody>
+            </table>
+          </div>
+        </div>
+      </div>
+    </Layout>
+  );
+}
+
+export default DispensarySchedule;
--- a/cannaiq/src/pages/IntelligenceBrands.tsx
+++ b/cannaiq/src/pages/IntelligenceBrands.tsx
@@ -3,15 +3,16 @@ import { useNavigate } from 'react-router-dom';
 import { Layout } from '../components/Layout';
 import { api } from '../lib/api';
 import { trackProductClick } from '../lib/analytics';
+import { useStateFilter } from '../hooks/useStateFilter';
 import {
  Building2,
  MapPin,
  Package,
  DollarSign,
-  RefreshCw,
  Search,
  TrendingUp,
  BarChart3,
+  ChevronDown,
 } from 'lucide-react';

 interface BrandData {
@@ -25,19 +26,28 @@ interface BrandData {

 export function IntelligenceBrands() {
  const navigate = useNavigate();
+  const { selectedState, setSelectedState, stateParam, stateLabel, isAllStates } = useStateFilter();
+  const [availableStates, setAvailableStates] = useState<string[]>([]);
  const [brands, setBrands] = useState<BrandData[]>([]);
  const [loading, setLoading] = useState(true);
  const [searchTerm, setSearchTerm] = useState('');
-  const [sortBy, setSortBy] = useState<'stores' | 'skus' | 'name'>('stores');
+  const [sortBy, setSortBy] = useState<'stores' | 'skus' | 'name' | 'states'>('stores');

  useEffect(() => {
    loadBrands();
+  }, [stateParam]);
+
+  useEffect(() => {
+    // Load available states
+    api.getOrchestratorStates().then(data => {
+      setAvailableStates(data.states?.map((s: any) => s.state) || []);
+    }).catch(console.error);
  }, []);

  const loadBrands = async () => {
    try {
      setLoading(true);
-      const data = await api.getIntelligenceBrands({ limit: 500 });
+      const data = await api.getIntelligenceBrands({ limit: 500, state: stateParam });
      setBrands(data.brands || []);
    } catch (error) {
      console.error('Failed to load brands:', error);
@@ -58,6 +68,8 @@ export function IntelligenceBrands() {
          return b.skuCount - a.skuCount;
        case 'name':
          return a.brandName.localeCompare(b.brandName);
+        case 'states':
+          return b.states.length - a.states.length;
        default:
          return 0;
      }
@@ -89,35 +101,60 @@ export function IntelligenceBrands() {
    <Layout>
      <div className="space-y-6">
        {/* Header */}
-        <div className="flex items-center justify-between">
+        <div className="flex flex-col gap-4 sm:flex-row sm:items-center sm:justify-between">
          <div>
            <h1 className="text-2xl font-bold text-gray-900">Brands Intelligence</h1>
            <p className="text-sm text-gray-600 mt-1">
              Brand penetration and pricing analytics across markets
            </p>
          </div>
-          <div className="flex gap-2">
-            <button
-              onClick={() => navigate('/admin/intelligence/pricing')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <DollarSign className="w-4 h-4" />
-              Pricing
-            </button>
-            <button
-              onClick={() => navigate('/admin/intelligence/stores')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <MapPin className="w-4 h-4" />
-              Stores
-            </button>
-            <button
-              onClick={loadBrands}
-              className="btn btn-sm btn-outline gap-2"
-            >
-              <RefreshCw className="w-4 h-4" />
-              Refresh
-            </button>
+          <div className="flex flex-wrap gap-2 items-center">
+            {/* State Selector */}
+            <div className="dropdown dropdown-end">
+              <button tabIndex={0} className="btn btn-sm gap-2 bg-emerald-50 border-emerald-200 hover:bg-emerald-100">
+                {stateLabel}
+                <ChevronDown className="w-4 h-4" />
+              </button>
+              <ul tabIndex={0} className="dropdown-content z-50 menu p-2 shadow-lg bg-white rounded-box w-44 max-h-60 overflow-y-auto border border-gray-200">
+                <li>
+                  <a onClick={() => setSelectedState(null)} className={isAllStates ? 'active bg-emerald-100' : ''}>
+                    All States
+                  </a>
+                </li>
+                <div className="divider my-1"></div>
+                {availableStates.map((state) => (
+                  <li key={state}>
+                    <a onClick={() => setSelectedState(state)} className={selectedState === state ? 'active bg-emerald-100' : ''}>
+                      {state}
+                    </a>
+                  </li>
+                ))}
+              </ul>
+            </div>
+
+            {/* Page Navigation */}
+            <div className="flex gap-1">
+              <button
+                className="btn btn-sm gap-1 bg-emerald-600 text-white hover:bg-emerald-700 border-emerald-600"
+              >
+                <Building2 className="w-4 h-4" />
+                <span>Brands</span>
+              </button>
+              <button
+                onClick={() => navigate('/admin/intelligence/stores')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <MapPin className="w-4 h-4" />
+                <span>Stores</span>
+              </button>
+              <button
+                onClick={() => navigate('/admin/intelligence/pricing')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <DollarSign className="w-4 h-4" />
+                <span>Pricing</span>
+              </button>
+            </div>
          </div>
        </div>

@@ -169,28 +206,32 @@ export function IntelligenceBrands() {

        {/* Top Brands Chart */}
        <div className="bg-white rounded-lg border border-gray-200 p-4">
-          <h3 className="text-lg font-semibold text-gray-900 mb-4 flex items-center gap-2">
-            <BarChart3 className="w-5 h-5 text-blue-500" />
+          <h3 className="text-lg font-semibold text-gray-900 flex items-center gap-2 mb-4">
+            <BarChart3 className="w-5 h-5 text-emerald-500" />
            Top 10 Brands by Store Count
          </h3>
          <div className="space-y-2">
-            {topBrands.map((brand, idx) => (
-              <div key={brand.brandName} className="flex items-center gap-3">
-                <span className="text-sm text-gray-500 w-6">{idx + 1}.</span>
-                <span className="text-sm font-medium w-40 truncate" title={brand.brandName}>
-                  {brand.brandName}
-                </span>
-                <div className="flex-1 bg-gray-100 rounded-full h-4 relative">
-                  <div
-                    className="bg-blue-500 rounded-full h-4"
-                    style={{ width: `${(brand.storeCount / maxStoreCount) * 100}%` }}
-                  />
+            {topBrands.map((brand) => {
+              const barWidth = Math.min((brand.storeCount / maxStoreCount) * 100, 100);
+              return (
+                <div key={brand.brandName} className="flex items-center gap-3">
+                  <span className="text-sm font-medium w-28 truncate shrink-0" title={brand.brandName}>
+                    {brand.brandName}
+                  </span>
+                  <div className="flex-1 min-w-0">
+                    <div className="bg-gray-100 rounded h-5 overflow-hidden">
+                      <div
+                        className="bg-gradient-to-r from-emerald-400 to-emerald-500 h-5 rounded transition-all"
+                        style={{ width: `${barWidth}%` }}
+                      />
+                    </div>
+                  </div>
+                  <span className="text-sm font-mono font-semibold text-emerald-600 w-16 text-right shrink-0">
+                    {brand.storeCount}
+                  </span>
                </div>
-                <span className="text-sm text-gray-600 w-16 text-right">
-                  {brand.storeCount} stores
-                </span>
-              </div>
-            ))}
+              );
+            })}
          </div>
        </div>

@@ -213,6 +254,7 @@ export function IntelligenceBrands() {
          >
            <option value="stores">Sort by Stores</option>
            <option value="skus">Sort by SKUs</option>
+            <option value="states">Sort by States</option>
            <option value="name">Sort by Name</option>
          </select>
          <span className="text-sm text-gray-500">
--- a/cannaiq/src/pages/IntelligencePricing.tsx
+++ b/cannaiq/src/pages/IntelligencePricing.tsx
@@ -2,15 +2,16 @@ import { useEffect, useState } from 'react';
 import { useNavigate } from 'react-router-dom';
 import { Layout } from '../components/Layout';
 import { api } from '../lib/api';
+import { useStateFilter } from '../hooks/useStateFilter';
 import {
  DollarSign,
  Building2,
  MapPin,
  Package,
-  RefreshCw,
  TrendingUp,
  TrendingDown,
  BarChart3,
+  ChevronDown,
 } from 'lucide-react';

 interface CategoryPricing {
@@ -31,18 +32,27 @@ interface OverallPricing {

 export function IntelligencePricing() {
  const navigate = useNavigate();
+  const { selectedState, setSelectedState, stateParam, stateLabel, isAllStates } = useStateFilter();
+  const [availableStates, setAvailableStates] = useState<string[]>([]);
  const [categories, setCategories] = useState<CategoryPricing[]>([]);
  const [overall, setOverall] = useState<OverallPricing | null>(null);
  const [loading, setLoading] = useState(true);

  useEffect(() => {
    loadPricing();
+  }, [stateParam]);
+
+  useEffect(() => {
+    // Load available states
+    api.getOrchestratorStates().then(data => {
+      setAvailableStates(data.states?.map((s: any) => s.state) || []);
+    }).catch(console.error);
  }, []);

  const loadPricing = async () => {
    try {
      setLoading(true);
-      const data = await api.getIntelligencePricing();
+      const data = await api.getIntelligencePricing({ state: stateParam });
      setCategories(data.byCategory || []);
      setOverall(data.overall || null);
    } catch (error) {
@@ -76,35 +86,60 @@ export function IntelligencePricing() {
    <Layout>
      <div className="space-y-6">
        {/* Header */}
-        <div className="flex items-center justify-between">
+        <div className="flex flex-col gap-4 sm:flex-row sm:items-center sm:justify-between">
          <div>
            <h1 className="text-2xl font-bold text-gray-900">Pricing Intelligence</h1>
            <p className="text-sm text-gray-600 mt-1">
              Price distribution and trends by category
            </p>
          </div>
-          <div className="flex gap-2">
-            <button
-              onClick={() => navigate('/admin/intelligence/brands')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <Building2 className="w-4 h-4" />
-              Brands
-            </button>
-            <button
-              onClick={() => navigate('/admin/intelligence/stores')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <MapPin className="w-4 h-4" />
-              Stores
-            </button>
-            <button
-              onClick={loadPricing}
-              className="btn btn-sm btn-outline gap-2"
-            >
-              <RefreshCw className="w-4 h-4" />
-              Refresh
-            </button>
+          <div className="flex flex-wrap gap-2 items-center">
+            {/* State Selector */}
+            <div className="dropdown dropdown-end">
+              <button tabIndex={0} className="btn btn-sm gap-2 bg-emerald-50 border-emerald-200 hover:bg-emerald-100">
+                {stateLabel}
+                <ChevronDown className="w-4 h-4" />
+              </button>
+              <ul tabIndex={0} className="dropdown-content z-50 menu p-2 shadow-lg bg-white rounded-box w-44 max-h-60 overflow-y-auto border border-gray-200">
+                <li>
+                  <a onClick={() => setSelectedState(null)} className={isAllStates ? 'active bg-emerald-100' : ''}>
+                    All States
+                  </a>
+                </li>
+                <div className="divider my-1"></div>
+                {availableStates.map((state) => (
+                  <li key={state}>
+                    <a onClick={() => setSelectedState(state)} className={selectedState === state ? 'active bg-emerald-100' : ''}>
+                      {state}
+                    </a>
+                  </li>
+                ))}
+              </ul>
+            </div>
+
+            {/* Page Navigation */}
+            <div className="flex gap-1">
+              <button
+                onClick={() => navigate('/admin/intelligence/brands')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <Building2 className="w-4 h-4" />
+                <span>Brands</span>
+              </button>
+              <button
+                onClick={() => navigate('/admin/intelligence/stores')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <MapPin className="w-4 h-4" />
+                <span>Stores</span>
+              </button>
+              <button
+                className="btn btn-sm gap-1 bg-emerald-600 text-white hover:bg-emerald-700 border-emerald-600"
+              >
+                <DollarSign className="w-4 h-4" />
+                <span>Pricing</span>
+              </button>
+            </div>
          </div>
        </div>

@@ -150,7 +185,7 @@ export function IntelligencePricing() {
                <div>
                  <p className="text-sm text-gray-500">Products Priced</p>
                  <p className="text-2xl font-bold">
-                    {overall.totalProducts.toLocaleString()}
+                    {(overall.totalProducts || 0).toLocaleString()}
                  </p>
                </div>
              </div>
@@ -164,43 +199,29 @@ export function IntelligencePricing() {
            <BarChart3 className="w-5 h-5 text-green-500" />
            Average Price by Category
          </h3>
-          <div className="space-y-3">
-            {sortedCategories.map((cat) => (
-              <div key={cat.category} className="flex items-center gap-3">
-                <span className="text-sm font-medium w-32 truncate" title={cat.category}>
-                  {cat.category || 'Unknown'}
-                </span>
-                <div className="flex-1 relative">
-                  {/* Price range bar */}
-                  <div className="bg-gray-100 rounded-full h-6 relative">
-                    {/* Min-Max range */}
-                    <div
-                      className="absolute top-0 h-6 bg-blue-100 rounded-full"
-                      style={{
-                        left: `${(cat.minPrice / (overall?.maxPrice || 100)) * 100}%`,
-                        width: `${((cat.maxPrice - cat.minPrice) / (overall?.maxPrice || 100)) * 100}%`,
-                      }}
-                    />
-                    {/* Average marker */}
-                    <div
-                      className="absolute top-0 h-6 w-1 bg-green-500 rounded"
-                      style={{ left: `${(cat.avgPrice / (overall?.maxPrice || 100)) * 100}%` }}
-                    />
+          <div className="space-y-2">
+            {sortedCategories.slice(0, 12).map((cat) => {
+              const maxPrice = Math.max(...sortedCategories.map(c => c.avgPrice || 0), 1);
+              const barWidth = Math.min(((cat.avgPrice || 0) / maxPrice) * 100, 100);
+              return (
+                <div key={cat.category} className="flex items-center gap-3">
+                  <span className="text-sm font-medium w-28 truncate shrink-0" title={cat.category}>
+                    {cat.category || 'Unknown'}
+                  </span>
+                  <div className="flex-1 min-w-0">
+                    <div className="bg-gray-100 rounded h-5 overflow-hidden">
+                      <div
+                        className="bg-gradient-to-r from-emerald-400 to-emerald-500 h-5 rounded transition-all"
+                        style={{ width: `${barWidth}%` }}
+                      />
+                    </div>
                  </div>
-                </div>
-                <div className="flex gap-4 text-xs w-48">
-                  <span className="text-gray-500">
-                    Min: <span className="text-blue-600 font-mono">{formatPrice(cat.minPrice)}</span>
-                  </span>
-                  <span className="text-gray-500">
-                    Avg: <span className="text-green-600 font-mono font-bold">{formatPrice(cat.avgPrice)}</span>
-                  </span>
-                  <span className="text-gray-500">
-                    Max: <span className="text-orange-600 font-mono">{formatPrice(cat.maxPrice)}</span>
+                  <span className="text-sm font-mono font-semibold text-emerald-600 w-16 text-right shrink-0">
+                    {formatPrice(cat.avgPrice)}
                  </span>
                </div>
-              </div>
-            ))}
+              );
+            })}
          </div>
        </div>

@@ -236,7 +257,7 @@ export function IntelligencePricing() {
                        <span className="font-medium">{cat.category || 'Unknown'}</span>
                      </td>
                      <td className="text-center">
-                        <span className="font-mono">{cat.productCount.toLocaleString()}</span>
+                        <span className="font-mono">{(cat.productCount || 0).toLocaleString()}</span>
                      </td>
                      <td className="text-right">
                        <span className="font-mono text-blue-600">{formatPrice(cat.minPrice)}</span>
--- a/cannaiq/src/pages/IntelligenceStores.tsx
+++ b/cannaiq/src/pages/IntelligenceStores.tsx
@@ -8,7 +8,6 @@ import {
  Building2,
  DollarSign,
  Package,
-  RefreshCw,
  Search,
  Clock,
  Activity,
@@ -34,12 +33,19 @@ export function IntelligenceStores() {
  const [stores, setStores] = useState<StoreActivity[]>([]);
  const [loading, setLoading] = useState(true);
  const [searchTerm, setSearchTerm] = useState('');
-  const [localStates, setLocalStates] = useState<string[]>([]);
+  const [availableStates, setAvailableStates] = useState<string[]>([]);

  useEffect(() => {
    loadStores();
  }, [selectedState]);

+  useEffect(() => {
+    // Load available states from orchestrator API
+    api.getOrchestratorStates().then(data => {
+      setAvailableStates(data.states?.map((s: any) => s.state) || []);
+    }).catch(console.error);
+  }, []);
+
  const loadStores = async () => {
    try {
      setLoading(true);
@@ -48,10 +54,6 @@ export function IntelligenceStores() {
        limit: 500,
      });
      setStores(data.stores || []);
-
-      // Extract unique states from response for dropdown counts
-      const uniqueStates = [...new Set(data.stores.map((s: StoreActivity) => s.state))].sort();
-      setLocalStates(uniqueStates);
    } catch (error) {
      console.error('Failed to load stores:', error);
    } finally {
@@ -97,47 +99,72 @@ export function IntelligenceStores() {
    );
  }

-  // Calculate stats
-  const totalSKUs = stores.reduce((sum, s) => sum + s.skuCount, 0);
-  const totalSnapshots = stores.reduce((sum, s) => sum + s.snapshotCount, 0);
-  const avgFrequency = stores.filter(s => s.crawlFrequencyHours).length > 0
-    ? stores.filter(s => s.crawlFrequencyHours).reduce((sum, s) => sum + (s.crawlFrequencyHours || 0), 0) /
-      stores.filter(s => s.crawlFrequencyHours).length
+  // Calculate stats with null safety
+  const totalSKUs = stores.reduce((sum, s) => sum + (s.skuCount || 0), 0);
+  const totalSnapshots = stores.reduce((sum, s) => sum + (s.snapshotCount || 0), 0);
+  const storesWithFrequency = stores.filter(s => s.crawlFrequencyHours != null);
+  const avgFrequency = storesWithFrequency.length > 0
+    ? storesWithFrequency.reduce((sum, s) => sum + (s.crawlFrequencyHours || 0), 0) / storesWithFrequency.length
    : 0;

  return (
    <Layout>
      <div className="space-y-6">
        {/* Header */}
-        <div className="flex items-center justify-between">
+        <div className="flex flex-col gap-4 sm:flex-row sm:items-center sm:justify-between">
          <div>
            <h1 className="text-2xl font-bold text-gray-900">Store Activity</h1>
            <p className="text-sm text-gray-600 mt-1">
              Per-store SKU counts, snapshots, and crawl frequency
            </p>
          </div>
-          <div className="flex gap-2">
-            <button
-              onClick={() => navigate('/admin/intelligence/brands')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <Building2 className="w-4 h-4" />
-              Brands
-            </button>
-            <button
-              onClick={() => navigate('/admin/intelligence/pricing')}
-              className="btn btn-sm btn-outline gap-1"
-            >
-              <DollarSign className="w-4 h-4" />
-              Pricing
-            </button>
-            <button
-              onClick={loadStores}
-              className="btn btn-sm btn-outline gap-2"
-            >
-              <RefreshCw className="w-4 h-4" />
-              Refresh
-            </button>
+          <div className="flex flex-wrap gap-2 items-center">
+            {/* State Selector */}
+            <div className="dropdown dropdown-end">
+              <button tabIndex={0} className="btn btn-sm gap-2 bg-emerald-50 border-emerald-200 hover:bg-emerald-100">
+                {stateLabel}
+                <ChevronDown className="w-4 h-4" />
+              </button>
+              <ul tabIndex={0} className="dropdown-content z-50 menu p-2 shadow-lg bg-white rounded-box w-44 max-h-60 overflow-y-auto border border-gray-200">
+                <li>
+                  <a onClick={() => setSelectedState(null)} className={isAllStates ? 'active bg-emerald-100' : ''}>
+                    All States
+                  </a>
+                </li>
+                <div className="divider my-1"></div>
+                {availableStates.map((state) => (
+                  <li key={state}>
+                    <a onClick={() => setSelectedState(state)} className={selectedState === state ? 'active bg-emerald-100' : ''}>
+                      {state}
+                    </a>
+                  </li>
+                ))}
+              </ul>
+            </div>
+
+            {/* Page Navigation */}
+            <div className="flex gap-1">
+              <button
+                onClick={() => navigate('/admin/intelligence/brands')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <Building2 className="w-4 h-4" />
+                <span>Brands</span>
+              </button>
+              <button
+                className="btn btn-sm gap-1 bg-emerald-600 text-white hover:bg-emerald-700 border-emerald-600"
+              >
+                <MapPin className="w-4 h-4" />
+                <span>Stores</span>
+              </button>
+              <button
+                onClick={() => navigate('/admin/intelligence/pricing')}
+                className="btn btn-sm gap-1 bg-white border-gray-300 text-gray-700 hover:bg-gray-100"
+              >
+                <DollarSign className="w-4 h-4" />
+                <span>Pricing</span>
+              </button>
+            </div>
          </div>
        </div>

@@ -193,26 +220,6 @@ export function IntelligenceStores() {
              className="input input-bordered input-sm w-full pl-10"
            />
          </div>
-          <div className="dropdown">
-            <button tabIndex={0} className="btn btn-sm btn-outline gap-2">
-              {stateLabel}
-              <ChevronDown className="w-4 h-4" />
-            </button>
-            <ul tabIndex={0} className="dropdown-content z-[1] menu p-2 shadow bg-base-100 rounded-box w-40 max-h-60 overflow-y-auto">
-              <li>
-                <a onClick={() => setSelectedState(null)} className={isAllStates ? 'active' : ''}>
-                  All States
-                </a>
-              </li>
-              {localStates.map(state => (
-                <li key={state}>
-                  <a onClick={() => setSelectedState(state)} className={selectedState === state ? 'active' : ''}>
-                    {state}
-                  </a>
-                </li>
-              ))}
-            </ul>
-          </div>
          <span className="text-sm text-gray-500">
            Showing {filteredStores.length} of {stores.length} stores
          </span>
@@ -246,7 +253,7 @@ export function IntelligenceStores() {
                    <tr
                      key={store.id}
                      className="hover:bg-gray-50 cursor-pointer"
-                      onClick={() => navigate(`/admin/orchestrator/stores?storeId=${store.id}`)}
+                      onClick={() => navigate(`/stores/list/${store.id}`)}
                    >
                      <td>
                        <span className="font-medium">{store.name}</span>
@@ -262,10 +269,10 @@ export function IntelligenceStores() {
                        )}
                      </td>
                      <td className="text-center">
-                        <span className="font-mono">{store.skuCount.toLocaleString()}</span>
+                        <span className="font-mono">{(store.skuCount || 0).toLocaleString()}</span>
                      </td>
                      <td className="text-center">
-                        <span className="font-mono">{store.snapshotCount.toLocaleString()}</span>
+                        <span className="font-mono">{(store.snapshotCount || 0).toLocaleString()}</span>
                      </td>
                      <td>
                        <span className={store.lastCrawl ? 'text-green-600' : 'text-gray-400'}>
--- a/cannaiq/src/pages/NationalDashboard.tsx
+++ b/cannaiq/src/pages/NationalDashboard.tsx
@@ -8,7 +8,6 @@
 import { useState, useEffect } from 'react';
 import { useNavigate } from 'react-router-dom';
 import { Layout } from '../components/Layout';
-import { StateBadge } from '../components/StateSelector';
 import { useStateStore } from '../store/stateStore';
 import { api } from '../lib/api';
 import {
@@ -21,7 +20,6 @@ import {
  DollarSign,
  MapPin,
  ArrowRight,
-  RefreshCw,
  AlertCircle
 } from 'lucide-react';

@@ -205,7 +203,6 @@ export default function NationalDashboard() {
  const [loading, setLoading] = useState(true);
  const [error, setError] = useState<string | null>(null);
  const [summary, setSummary] = useState<NationalSummary | null>(null);
-  const [refreshing, setRefreshing] = useState(false);

  const fetchData = async () => {
    setLoading(true);
@@ -230,18 +227,6 @@ export default function NationalDashboard() {
    fetchData();
  }, []);

-  const handleRefreshMetrics = async () => {
-    setRefreshing(true);
-    try {
-      await api.post('/api/admin/states/refresh-metrics');
-      await fetchData();
-    } catch (err) {
-      console.error('Failed to refresh metrics:', err);
-    } finally {
-      setRefreshing(false);
-    }
-  };
-
  const handleStateClick = (stateCode: string) => {
    setSelectedState(stateCode);
    navigate(`/national/state/${stateCode}`);
@@ -278,24 +263,11 @@ export default function NationalDashboard() {
    <Layout>
      <div className="space-y-6">
        {/* Header */}
-        <div className="flex items-center justify-between">
-          <div>
-            <h1 className="text-2xl font-bold text-gray-900">National Dashboard</h1>
-            <p className="text-gray-500 mt-1">
-              Multi-state cannabis market intelligence
-            </p>
-          </div>
-          <div className="flex items-center gap-3">
-            <StateBadge />
-            <button
-              onClick={handleRefreshMetrics}
-              disabled={refreshing}
-              className="flex items-center gap-2 px-3 py-2 text-sm text-gray-600 hover:text-gray-900 border border-gray-200 rounded-lg hover:bg-gray-50 disabled:opacity-50"
-            >
-              <RefreshCw className={`w-4 h-4 ${refreshing ? 'animate-spin' : ''}`} />
-              Refresh Metrics
-            </button>
-          </div>
+        <div>
+          <h1 className="text-2xl font-bold text-gray-900">National Dashboard</h1>
+          <p className="text-gray-500 mt-1">
+            Multi-state cannabis market intelligence
+          </p>
        </div>

        {/* Summary Cards */}
@@ -303,7 +275,7 @@ export default function NationalDashboard() {
          <>
            <div className="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-4">
              <MetricCard
-                title="Active States"
+                title="States"
                value={summary.activeStates}
                icon={Globe}
              />
--- a/cannaiq/src/pages/StoreDetailPage.tsx
+++ b/cannaiq/src/pages/StoreDetailPage.tsx
@@ -153,29 +153,6 @@ export function StoreDetailPage() {
            Back to Stores
          </button>

-          {/* Update Button */}
-          <div className="relative">
-            <button
-              onClick={() => setShowUpdateDropdown(!showUpdateDropdown)}
-              disabled={isUpdating}
-              className="flex items-center gap-2 px-4 py-2 text-sm font-medium text-white bg-blue-600 hover:bg-blue-700 rounded-lg disabled:opacity-50 disabled:cursor-not-allowed"
-            >
-              <RefreshCw className={`w-4 h-4 ${isUpdating ? 'animate-spin' : ''}`} />
-              {isUpdating ? 'Crawling...' : 'Crawl Now'}
-              {!isUpdating && <ChevronDown className="w-4 h-4" />}
-            </button>
-
-            {showUpdateDropdown && !isUpdating && (
-              <div className="absolute right-0 mt-2 w-48 bg-white rounded-lg shadow-lg border border-gray-200 z-10">
-                <button
-                  onClick={handleCrawl}
-                  className="w-full text-left px-4 py-2 text-sm text-gray-700 hover:bg-gray-100 rounded-lg"
-                >
-                  Start Full Crawl
-                </button>
-              </div>
-            )}
-          </div>
        </div>

        {/* Store Header */}
@@ -200,7 +177,7 @@ export function StoreDetailPage() {
            <div className="flex items-center gap-2 text-sm text-gray-600 bg-gray-50 px-4 py-2 rounded-lg">
              <Clock className="w-4 h-4" />
              <div>
-                <span className="font-medium">Last Crawl:</span>
+                <span className="font-medium">Last Updated:</span>
                <span className="ml-2">
                  {lastCrawl?.completed_at
                    ? new Date(lastCrawl.completed_at).toLocaleDateString('en-US', {
@@ -212,15 +189,6 @@ export function StoreDetailPage() {
                      })
                    : 'Never'}
                </span>
-                {lastCrawl?.status && (
-                  <span className={`ml-2 px-2 py-0.5 rounded text-xs ${
-                    lastCrawl.status === 'completed' ? 'bg-green-100 text-green-800' :
-                    lastCrawl.status === 'failed' ? 'bg-red-100 text-red-800' :
-                    'bg-yellow-100 text-yellow-800'
-                  }`}>
-                    {lastCrawl.status}
-                  </span>
-                )}
              </div>
            </div>
          </div>
@@ -282,8 +250,8 @@ export function StoreDetailPage() {
              setStockFilter('in_stock');
              setSearchQuery('');
            }}
-            className={`bg-white rounded-lg border p-4 hover:border-blue-300 hover:shadow-md transition-all cursor-pointer text-left ${
-              stockFilter === 'in_stock' ? 'border-blue-500' : 'border-gray-200'
+            className={`bg-white rounded-lg border p-4 hover:border-gray-300 hover:shadow-md transition-all cursor-pointer text-left ${
+              stockFilter === 'in_stock' ? 'border-gray-400' : 'border-gray-200'
            }`}
          >
            <div className="flex items-center gap-3">
@@ -303,8 +271,8 @@ export function StoreDetailPage() {
              setStockFilter('out_of_stock');
              setSearchQuery('');
            }}
-            className={`bg-white rounded-lg border p-4 hover:border-blue-300 hover:shadow-md transition-all cursor-pointer text-left ${
-              stockFilter === 'out_of_stock' ? 'border-blue-500' : 'border-gray-200'
+            className={`bg-white rounded-lg border p-4 hover:border-gray-300 hover:shadow-md transition-all cursor-pointer text-left ${
+              stockFilter === 'out_of_stock' ? 'border-gray-400' : 'border-gray-200'
            }`}
          >
            <div className="flex items-center gap-3">
@@ -320,8 +288,8 @@ export function StoreDetailPage() {

          <button
            onClick={() => setActiveTab('brands')}
-            className={`bg-white rounded-lg border p-4 hover:border-blue-300 hover:shadow-md transition-all cursor-pointer text-left ${
-              activeTab === 'brands' ? 'border-blue-500' : 'border-gray-200'
+            className={`bg-white rounded-lg border p-4 hover:border-gray-300 hover:shadow-md transition-all cursor-pointer text-left ${
+              activeTab === 'brands' ? 'border-gray-400' : 'border-gray-200'
            }`}
          >
            <div className="flex items-center gap-3">
@@ -337,8 +305,8 @@ export function StoreDetailPage() {

          <button
            onClick={() => setActiveTab('categories')}
-            className={`bg-white rounded-lg border p-4 hover:border-blue-300 hover:shadow-md transition-all cursor-pointer text-left ${
-              activeTab === 'categories' ? 'border-blue-500' : 'border-gray-200'
+            className={`bg-white rounded-lg border p-4 hover:border-gray-300 hover:shadow-md transition-all cursor-pointer text-left ${
+              activeTab === 'categories' ? 'border-gray-400' : 'border-gray-200'
            }`}
          >
            <div className="flex items-center gap-3">
@@ -364,7 +332,7 @@ export function StoreDetailPage() {
                }}
                className={`py-4 px-2 text-sm font-medium border-b-2 ${
                  activeTab === 'products'
-                    ? 'border-blue-600 text-blue-600'
+                    ? 'border-gray-800 text-gray-900'
                    : 'border-transparent text-gray-600 hover:text-gray-900'
                }`}
              >
@@ -374,7 +342,7 @@ export function StoreDetailPage() {
                onClick={() => setActiveTab('brands')}
                className={`py-4 px-2 text-sm font-medium border-b-2 ${
                  activeTab === 'brands'
-                    ? 'border-blue-600 text-blue-600'
+                    ? 'border-gray-800 text-gray-900'
                    : 'border-transparent text-gray-600 hover:text-gray-900'
                }`}
              >
@@ -384,7 +352,7 @@ export function StoreDetailPage() {
                onClick={() => setActiveTab('categories')}
                className={`py-4 px-2 text-sm font-medium border-b-2 ${
                  activeTab === 'categories'
-                    ? 'border-blue-600 text-blue-600'
+                    ? 'border-gray-800 text-gray-900'
                    : 'border-transparent text-gray-600 hover:text-gray-900'
                }`}
              >
@@ -433,7 +401,7 @@ export function StoreDetailPage() {

                {productsLoading ? (
                  <div className="text-center py-8">
-                    <div className="inline-block animate-spin rounded-full h-6 w-6 border-4 border-blue-500 border-t-transparent"></div>
+                    <div className="inline-block animate-spin rounded-full h-6 w-6 border-4 border-gray-400 border-t-transparent"></div>
                    <p className="mt-2 text-sm text-gray-600">Loading products...</p>
                  </div>
                ) : products.length === 0 ? (
@@ -485,9 +453,9 @@ export function StoreDetailPage() {
                                <div className="line-clamp-2" title={product.brand || '-'}>{product.brand || '-'}</div>
                              </td>
                              <td className="whitespace-nowrap">
-                                <span className="badge badge-ghost badge-sm">{product.type || '-'}</span>
+                                <span className="text-xs text-gray-500 bg-gray-100 px-1.5 py-0.5 rounded">{product.type || '-'}</span>
                                {product.subcategory && (
-                                  <span className="badge badge-ghost badge-sm ml-1">{product.subcategory}</span>
+                                  <span className="text-xs text-gray-500 bg-gray-100 px-1.5 py-0.5 rounded ml-1">{product.subcategory}</span>
                                )}
                              </td>
                              <td className="text-right font-semibold whitespace-nowrap">
@@ -500,21 +468,14 @@ export function StoreDetailPage() {
                                  `$${product.regular_price}`
                                ) : '-'}
                              </td>
-                              <td className="text-center whitespace-nowrap">
-                                {product.thc_percentage ? (
-                                  <span className="badge badge-success badge-sm">{product.thc_percentage}%</span>
-                                ) : '-'}
+                              <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                                {product.thc_percentage ? `${product.thc_percentage}%` : '-'}
                              </td>
-                              <td className="text-center whitespace-nowrap">
-                                {product.stock_status === 'in_stock' ? (
-                                  <span className="badge badge-success badge-sm">In Stock</span>
-                                ) : product.stock_status === 'out_of_stock' ? (
-                                  <span className="badge badge-error badge-sm">Out</span>
-                                ) : (
-                                  <span className="badge badge-warning badge-sm">Unknown</span>
-                                )}
+                              <td className="text-center whitespace-nowrap text-sm text-gray-700">
+                                {product.stock_status === 'in_stock' ? 'In Stock' :
+                                 product.stock_status === 'out_of_stock' ? 'Out' : '-'}
                              </td>
-                              <td className="text-center whitespace-nowrap">
+                              <td className="text-center whitespace-nowrap text-sm text-gray-700">
                                {product.total_quantity != null ? product.total_quantity : '-'}
                              </td>
                              <td className="whitespace-nowrap text-xs text-gray-500">
--- a/cannaiq/src/pages/TasksDashboard.tsx
+++ b/cannaiq/src/pages/TasksDashboard.tsx
@@ -14,8 +14,9 @@ import {
  ChevronUp,
  Gauge,
  Users,
-  Calendar,
-  Zap,
+  Power,
+  Play,
+  Square,
 } from 'lucide-react';

 interface Task {
@@ -82,6 +83,27 @@ const STATUS_COLORS: Record<string, string> = {
  stale: 'bg-gray-100 text-gray-800',
 };

+const getStatusIcon = (status: string, poolPaused: boolean): React.ReactNode => {
+  switch (status) {
+    case 'pending':
+      return <Clock className="w-4 h-4" />;
+    case 'claimed':
+      return <PlayCircle className="w-4 h-4" />;
+    case 'running':
+      // Don't spin when pool is paused
+      return <RefreshCw className={`w-4 h-4 ${!poolPaused ? 'animate-spin' : ''}`} />;
+    case 'completed':
+      return <CheckCircle2 className="w-4 h-4" />;
+    case 'failed':
+      return <XCircle className="w-4 h-4" />;
+    case 'stale':
+      return <AlertTriangle className="w-4 h-4" />;
+    default:
+      return null;
+  }
+};
+
+// Static version for summary cards (always shows animation)
 const STATUS_ICONS: Record<string, React.ReactNode> = {
  pending: <Clock className="w-4 h-4" />,
  claimed: <PlayCircle className="w-4 h-4" />,
@@ -116,6 +138,8 @@ export default function TasksDashboard() {
  const [capacity, setCapacity] = useState<CapacityMetric[]>([]);
  const [loading, setLoading] = useState(true);
  const [error, setError] = useState<string | null>(null);
+  const [poolPaused, setPoolPaused] = useState(false);
+  const [poolLoading, setPoolLoading] = useState(false);

  // Filters
  const [roleFilter, setRoleFilter] = useState<string>('');
@@ -123,13 +147,10 @@ export default function TasksDashboard() {
  const [searchQuery, setSearchQuery] = useState('');
  const [showCapacity, setShowCapacity] = useState(true);

-  // Actions
-  const [actionLoading, setActionLoading] = useState(false);
-  const [actionMessage, setActionMessage] = useState<string | null>(null);

  const fetchData = async () => {
    try {
-      const [tasksRes, countsRes, capacityRes] = await Promise.all([
+      const [tasksRes, countsRes, capacityRes, poolStatus] = await Promise.all([
        api.getTasks({
          role: roleFilter || undefined,
          status: statusFilter || undefined,
@@ -137,11 +158,13 @@ export default function TasksDashboard() {
        }),
        api.getTaskCounts(),
        api.getTaskCapacity(),
+        api.getTaskPoolStatus(),
      ]);

      setTasks(tasksRes.tasks || []);
      setCounts(countsRes);
      setCapacity(capacityRes.metrics || []);
+      setPoolPaused(poolStatus.paused);
      setError(null);
    } catch (err: any) {
      setError(err.message || 'Failed to load tasks');
@@ -150,40 +173,29 @@ export default function TasksDashboard() {
    }
  };

+  const togglePool = async () => {
+    setPoolLoading(true);
+    try {
+      if (poolPaused) {
+        await api.resumeTaskPool();
+        setPoolPaused(false);
+      } else {
+        await api.pauseTaskPool();
+        setPoolPaused(true);
+      }
+    } catch (err: any) {
+      setError(err.message || 'Failed to toggle pool');
+    } finally {
+      setPoolLoading(false);
+    }
+  };
+
  useEffect(() => {
    fetchData();
-    const interval = setInterval(fetchData, 10000); // Refresh every 10 seconds
+    const interval = setInterval(fetchData, 15000); // Auto-refresh every 15 seconds
    return () => clearInterval(interval);
  }, [roleFilter, statusFilter]);

-  const handleGenerateResync = async () => {
-    setActionLoading(true);
-    try {
-      const result = await api.generateResyncTasks();
-      setActionMessage(`Generated ${result.tasks_created} resync tasks`);
-      fetchData();
-    } catch (err: any) {
-      setActionMessage(`Error: ${err.message}`);
-    } finally {
-      setActionLoading(false);
-      setTimeout(() => setActionMessage(null), 5000);
-    }
-  };
-
-  const handleRecoverStale = async () => {
-    setActionLoading(true);
-    try {
-      const result = await api.recoverStaleTasks();
-      setActionMessage(`Recovered ${result.tasks_recovered} stale tasks`);
-      fetchData();
-    } catch (err: any) {
-      setActionMessage(`Error: ${err.message}`);
-    } finally {
-      setActionLoading(false);
-      setTimeout(() => setActionMessage(null), 5000);
-    }
-  };
-
  const filteredTasks = tasks.filter((task) => {
    if (searchQuery) {
      const query = searchQuery.toLowerCase();
@@ -225,46 +237,33 @@ export default function TasksDashboard() {
            </p>
          </div>

-          <div className="flex gap-2">
+          <div className="flex items-center gap-4">
+            {/* Pool Toggle */}
            <button
-              onClick={handleGenerateResync}
-              disabled={actionLoading}
-              className="flex items-center gap-2 px-4 py-2 bg-emerald-600 text-white rounded-lg hover:bg-emerald-700 disabled:opacity-50"
+              onClick={togglePool}
+              disabled={poolLoading}
+              className={`flex items-center gap-2 px-4 py-2 rounded-lg font-medium transition-colors ${
+                poolPaused
+                  ? 'bg-emerald-100 text-emerald-700 hover:bg-emerald-200'
+                  : 'bg-red-100 text-red-700 hover:bg-red-200'
+              }`}
            >
-              <Calendar className="w-4 h-4" />
-              Generate Resync
-            </button>
-            <button
-              onClick={handleRecoverStale}
-              disabled={actionLoading}
-              className="flex items-center gap-2 px-4 py-2 bg-gray-600 text-white rounded-lg hover:bg-gray-700 disabled:opacity-50"
-            >
-              <Zap className="w-4 h-4" />
-              Recover Stale
-            </button>
-            <button
-              onClick={fetchData}
-              className="flex items-center gap-2 px-4 py-2 bg-gray-100 text-gray-700 rounded-lg hover:bg-gray-200"
-            >
-              <RefreshCw className="w-4 h-4" />
-              Refresh
+              {poolPaused ? (
+                <>
+                  <Play className={`w-5 h-5 ${poolLoading ? 'animate-pulse' : ''}`} />
+                  Start Pool
+                </>
+              ) : (
+                <>
+                  <Square className={`w-5 h-5 ${poolLoading ? 'animate-pulse' : ''}`} />
+                  Stop Pool
+                </>
+              )}
            </button>
+            <span className="text-sm text-gray-400">Auto-refreshes every 15s</span>
          </div>
        </div>

-        {/* Action Message */}
-        {actionMessage && (
-          <div
-            className={`p-4 rounded-lg ${
-              actionMessage.startsWith('Error')
-                ? 'bg-red-50 text-red-700'
-                : 'bg-green-50 text-green-700'
-            }`}
-          >
-            {actionMessage}
-          </div>
-        )}
-
        {error && (
          <div className="p-4 bg-red-50 text-red-700 rounded-lg">{error}</div>
        )}
@@ -281,7 +280,7 @@ export default function TasksDashboard() {
            >
              <div className="flex items-center gap-2 mb-2">
                <span className={`p-1.5 rounded ${STATUS_COLORS[status]}`}>
-                  {STATUS_ICONS[status]}
+                  {getStatusIcon(status, poolPaused)}
                </span>
                <span className="text-sm font-medium text-gray-600 capitalize">{status}</span>
              </div>
@@ -496,7 +495,7 @@ export default function TasksDashboard() {
                            STATUS_COLORS[task.status]
                          }`}
                        >
-                          {STATUS_ICONS[task.status]}
+                          {getStatusIcon(task.status, poolPaused)}
                          {task.status}
                        </span>
                      </td>
--- a/cannaiq/src/pages/WorkersDashboard.tsx
+++ b/cannaiq/src/pages/WorkersDashboard.tsx
@@ -292,16 +292,6 @@ export function WorkersDashboard() {
    }
  }, []);

-  // Cleanup stale workers
-  const handleCleanupStale = async () => {
-    try {
-      await api.post('/api/worker-registry/cleanup', { stale_threshold_minutes: 2 });
-      fetchData();
-    } catch (err: any) {
-      console.error('Cleanup error:', err);
-    }
-  };
-
  // Remove a single worker
  const handleRemoveWorker = async (workerId: string) => {
    if (!confirm('Remove this worker from the registry?')) return;
@@ -364,23 +354,13 @@ export function WorkersDashboard() {
              {workers.length} registered workers ({busyWorkers.length} busy, {idleWorkers.length} idle)
            </p>
          </div>
-          <div className="flex items-center gap-2">
-            <button
-              onClick={handleCleanupStale}
-              className="flex items-center gap-2 px-4 py-2 bg-gray-100 text-gray-700 rounded-lg hover:bg-gray-200 transition-colors"
-              title="Mark stale workers (no heartbeat > 2 min) as offline"
-            >
-              <Trash2 className="w-4 h-4" />
-              Cleanup Stale
-            </button>
-            <button
-              onClick={() => fetchData()}
-              className="flex items-center gap-2 px-4 py-2 bg-emerald-600 text-white rounded-lg hover:bg-emerald-700 transition-colors"
-            >
-              <RefreshCw className="w-4 h-4" />
-              Refresh
-            </button>
-          </div>
+          <button
+            onClick={() => fetchData()}
+            className="flex items-center gap-2 px-4 py-2 bg-emerald-600 text-white rounded-lg hover:bg-emerald-700 transition-colors"
+          >
+            <RefreshCw className="w-4 h-4" />
+            Refresh
+          </button>
        </div>

        {error && (
--- a/k8s/scraper-worker.yaml
+++ b/k8s/scraper-worker.yaml
@@ -12,7 +12,7 @@ metadata:
  name: scraper-worker
  namespace: dispensary-scraper
 spec:
-  replicas: 5
+  replicas: 25
  selector:
    matchLabels:
      app: scraper-worker
--- a/workflow-12102025.md
+++ b/workflow-12102025.md
@@ -0,0 +1,365 @@
+# Workflow Documentation - December 10, 2025
+
+## Purpose
+
+This document captures the intended behavior for the CannaiQ crawl system, specifically around proxy rotation, fingerprinting, and anti-detection.
+
+---
+
+## Stealth & Anti-Detection Requirements
+
+### 1. Task Determines Work, Proxy Determines Identity
+
+The task payload contains:
+- `dispensary_id` - which store to crawl
+- `role` - what type of work (product_resync, entry_point_discovery, etc.)
+
+The **proxy** determines the session identity:
+- Proxy location (city, state, timezone) → sets Accept-Language and timezone headers
+- Language is always English (`en-US`)
+
+**Flow:**
+```
+Task claimed
+    │
+    └─► Get proxy from rotation
+            │
+            └─► Proxy has location (city, state, timezone)
+                    │
+                    └─► Build headers using proxy's timezone
+                            - Accept-Language: en-US,en;q=0.9
+                            - Timezone-consistent behavior
+```
+
+### 2. On 403 Block - Immediate Backoff
+
+When a 403 is received:
+
+1. **Immediately** stop using current IP
+2. Get a new proxy (new IP)
+3. Get a new UA/fingerprint
+4. Retry the request
+
+**Per-proxy failure tracking:**
+- Track UA rotation attempts per proxy
+- After 3 UA/fingerprint rotations on the same proxy → disable that proxy
+- This means: if we rotate UA 3 times and still get 403, the proxy is burned
+
+### 3. Fingerprint Rotation Rules
+
+Each request uses:
+- Proxy (IP)
+- User-Agent
+- sec-ch-ua headers (Client Hints)
+- Accept-Language (from proxy location)
+
+On 403:
+1. Record failure on current proxy
+2. Rotate to new proxy
+3. Pick new random fingerprint
+4. If same proxy fails 3 times with different fingerprints → disable proxy
+
+### 4. Proxy Table Schema
+
+```sql
+CREATE TABLE proxies (
+  id SERIAL PRIMARY KEY,
+  host VARCHAR(255) NOT NULL,
+  port INTEGER NOT NULL,
+  username VARCHAR(100),
+  password VARCHAR(100),
+  protocol VARCHAR(10) DEFAULT 'http',
+  active BOOLEAN DEFAULT true,
+
+  -- Location (determines session headers)
+  city VARCHAR(100),
+  state VARCHAR(50),
+  country VARCHAR(100),
+  country_code VARCHAR(10),
+  timezone VARCHAR(50),
+
+  -- Health tracking
+  failure_count INTEGER DEFAULT 0,
+  consecutive_403_count INTEGER DEFAULT 0,  -- Track 403s specifically
+  last_used_at TIMESTAMPTZ,
+  last_failure_at TIMESTAMPTZ,
+  last_error TEXT,
+
+  -- Performance
+  response_time_ms INTEGER,
+  max_connections INTEGER DEFAULT 1
+);
+```
+
+### 5. Failure Threshold
+
+- **3 consecutive 403s** with different fingerprints → disable proxy
+- Reset `consecutive_403_count` to 0 on successful request
+- General `failure_count` tracks all errors (timeouts, connection errors, etc.)
+
+---
+
+## Implementation Status
+
+### COMPLETED - December 10, 2025
+
+All code changes have been implemented per this specification:
+
+#### 1. crawl-rotator.ts ✅
+
+- [x] Added `consecutive403Count` to Proxy interface
+- [x] Added `markBlocked()` method that increments `consecutive_403_count` and disables proxy at 3
+- [x] Added `getProxyTimezone()` to return current proxy's timezone
+- [x] `markSuccess()` now resets `consecutive_403_count` to 0
+- [x] Replaced hardcoded UA list with `intoli/user-agents` library for realistic fingerprints
+- [x] `BrowserFingerprint` interface includes full fingerprint data (UA, platform, screen size, viewport, sec-ch-ua headers)
+
+#### 2. client.ts ✅
+
+- [x] `startSession()` no longer takes state/timezone params
+- [x] `startSession()` gets identity from proxy via `crawlRotator.getProxyLocation()`
+- [x] Added `handle403Block()` that:
+  - Calls `crawlRotator.recordBlock()` (tracks consecutive 403s)
+  - Immediately rotates both proxy and fingerprint via `rotateBoth()`
+  - Returns false if no more proxies available
+- [x] `executeGraphQL()` calls `handle403Block()` on 403 (not `rotateProxyOn403`)
+- [x] `fetchPage()` uses same 403 handling
+- [x] 500ms backoff after rotation (not linear delay)
+
+#### 3. Task Handlers ✅
+
+- [x] `entry-point-discovery.ts`: `startSession()` called with no params
+- [x] `product-refresh.ts`: `startSession()` called with no params
+
+#### 4. Dependencies ✅
+
+- [x] Added `user-agents` npm package for realistic UA generation
+
+---
+
+## Files Changed
+
+| File | Changes |
+|------|---------|
+| `backend/src/services/crawl-rotator.ts` | Complete rewrite with `consecutive403Count`, `markBlocked()`, `intoli/user-agents` |
+| `backend/src/platforms/dutchie/client.ts` | `startSession()` uses proxy location, `handle403Block()` for 403 handling |
+| `backend/src/tasks/handlers/entry-point-discovery.ts` | `startSession()` no params |
+| `backend/src/tasks/handlers/product-refresh.ts` | `startSession()` no params |
+| `backend/package.json` | Added `user-agents` dependency |
+
+---
+
+## Migration Required
+
+The `proxies` table needs `consecutive_403_count` column if not already present:
+
+```sql
+ALTER TABLE proxies ADD COLUMN IF NOT EXISTS consecutive_403_count INTEGER DEFAULT 0;
+```
+
+---
+
+## Key Behaviors Summary
+
+| Behavior | Implementation |
+|----------|----------------|
+| Session identity | From proxy location (`getProxyLocation()`) |
+| Language | Always `en-US,en;q=0.9` |
+| 403 handling | `handle403Block()` → `recordBlock()` → `rotateBoth()` |
+| Proxy disable | After 3 consecutive 403s (`consecutive403Count >= 3`) |
+| Success reset | `markSuccess()` resets `consecutive403Count` to 0 |
+| UA generation | `intoli/user-agents` library (daily updated, realistic fingerprints) |
+| Fingerprint data | Full: UA, platform, screen size, viewport, sec-ch-ua headers |
+
+---
+
+## User-Agent Generation
+
+### Data Source
+
+The `intoli/user-agents` npm library provides daily-updated market share data collected from Intoli's residential proxy network (millions of real users). The package auto-releases new versions daily to npm.
+
+### Device Category Distribution (hardcoded)
+
+| Category | Share |
+|----------|-------|
+| Mobile | 62% |
+| Desktop | 36% |
+| Tablet | 2% |
+
+### Browser Filter (whitelist only)
+
+Only these browsers are allowed:
+- Chrome (67%)
+- Safari (20%)
+- Edge (6%)
+- Firefox (3%)
+
+Samsung Internet, Opera, and other niche browsers are filtered out.
+
+### Desktop OS Distribution (from library)
+
+| OS | Share |
+|----|-------|
+| Windows | 72% |
+| macOS | 17% |
+| Linux | 4% |
+
+### UA Lifecycle
+
+1. **Session start** (new proxy IP obtained) → Roll device category (62/36/2) → Generate UA filtered to device + top 4 browsers → Store on session
+2. **UA sticks** until IP rotates (403 block or manual rotation)
+3. **IP rotation** triggers new UA generation
+
+### Failure Handling
+
+- If UA generation fails → Alert admin dashboard, **stop crawl immediately**
+- No fallback to static UA list
+- This forces investigation rather than silent degradation
+
+### Session Logging
+
+Each session logs:
+- Device category (mobile/desktop/tablet)
+- Full UA string
+- Browser name (Chrome/Safari/Edge/Firefox)
+- IP address (from proxy)
+- Session start timestamp
+
+Logs are rotated monthly.
+
+### Implementation
+
+Located in `backend/src/services/crawl-rotator.ts`:
+
+```typescript
+// Per workflow-12102025.md: Device category distribution
+const DEVICE_WEIGHTS = { mobile: 62, desktop: 36, tablet: 2 };
+
+// Per workflow-12102025.md: Browser whitelist
+const ALLOWED_BROWSERS = ['Chrome', 'Safari', 'Edge', 'Firefox'];
+```
+
+---
+
+## HTTP Fingerprinting
+
+### Goal
+
+Make HTTP requests indistinguishable from real browser traffic. No repeatable footprint.
+
+### Components
+
+1. **Full Header Set** - All headers a real browser sends
+2. **Header Ordering** - Browser-specific order (Chrome vs Firefox vs Safari)
+3. **TLS Fingerprint** - Use `curl-impersonate` to match browser TLS signature
+4. **Dynamic Referer** - Set per dispensary being crawled
+5. **Natural Randomization** - Vary optional headers like real users
+
+### Required Headers
+
+| Header | Chrome | Firefox | Safari | Notes |
+|--------|--------|---------|--------|-------|
+| `User-Agent` | ✅ | ✅ | ✅ | From UA generation |
+| `Accept` | ✅ | ✅ | ✅ | Content types |
+| `Accept-Language` | ✅ | ✅ | ✅ | Always `en-US,en;q=0.9` |
+| `Accept-Encoding` | ✅ | ✅ | ✅ | `gzip, deflate, br` |
+| `Connection` | ✅ | ✅ | ✅ | `keep-alive` |
+| `Origin` | ✅ | ✅ | ✅ | `https://dutchie.com` (POST only) |
+| `Referer` | ✅ | ✅ | ✅ | Dynamic per dispensary |
+| `sec-ch-ua` | ✅ | ❌ | ❌ | Chromium only |
+| `sec-ch-ua-mobile` | ✅ | ❌ | ❌ | Chromium only |
+| `sec-ch-ua-platform` | ✅ | ❌ | ❌ | Chromium only |
+| `sec-fetch-dest` | ✅ | ✅ | ❌ | `empty` for XHR |
+| `sec-fetch-mode` | ✅ | ✅ | ❌ | `cors` for XHR |
+| `sec-fetch-site` | ✅ | ✅ | ❌ | `same-origin` |
+| `Upgrade-Insecure-Requests` | ✅ | ✅ | ✅ | `1` (page loads only) |
+| `DNT` | ~30% | ~30% | ~30% | Randomized per session |
+
+### Header Ordering
+
+Each browser sends headers in a specific order. Fingerprinting services detect mismatches.
+
+**Chrome order (GraphQL request):**
+1. Host
+2. Connection
+3. Content-Length (POST)
+4. sec-ch-ua
+5. DNT (if enabled)
+6. sec-ch-ua-mobile
+7. User-Agent
+8. sec-ch-ua-platform
+9. Content-Type (POST)
+10. Accept
+11. Origin (POST)
+12. sec-fetch-site
+13. sec-fetch-mode
+14. sec-fetch-dest
+15. Referer
+16. Accept-Encoding
+17. Accept-Language
+
+**Firefox order (GraphQL request):**
+1. Host
+2. User-Agent
+3. Accept
+4. Accept-Language
+5. Accept-Encoding
+6. Content-Type (POST)
+7. Content-Length (POST)
+8. Origin (POST)
+9. DNT (if enabled)
+10. Connection
+11. Referer
+12. sec-fetch-dest
+13. sec-fetch-mode
+14. sec-fetch-site
+
+**Safari order (GraphQL request):**
+1. Host
+2. Connection
+3. Content-Length (POST)
+4. Accept
+5. User-Agent
+6. Content-Type (POST)
+7. Origin (POST)
+8. Referer
+9. Accept-Encoding
+10. Accept-Language
+
+### TLS Fingerprinting
+
+Use `curl-impersonate` instead of standard curl:
+- `curl_chrome131` - Mimics Chrome 131 TLS handshake
+- `curl_ff133` - Mimics Firefox 133 TLS handshake
+- `curl_safari17` - Mimics Safari 17 TLS handshake
+
+Match TLS binary to browser in UA.
+
+### Dynamic Referer
+
+Set Referer to the dispensary's actual page URL:
+
+```
+Crawling "harvest-of-tempe" → Referer: https://dutchie.com/dispensary/harvest-of-tempe
+Crawling "zen-leaf-mesa" → Referer: https://dutchie.com/dispensary/zen-leaf-mesa
+```
+
+Derived from dispensary's `menu_url` field.
+
+### Natural Randomization
+
+Per-session randomization (set once when session starts, consistent for session):
+
+| Feature | Distribution | Implementation |
+|---------|--------------|----------------|
+| DNT header | 30% have it | `Math.random() < 0.30` |
+| Accept quality values | Slight variation | `q=0.9` vs `q=0.8` |
+
+### Implementation Files
+
+| File | Purpose |
+|------|---------|
+| `src/services/crawl-rotator.ts` | `BrowserFingerprint` includes full header config |
+| `src/platforms/dutchie/client.ts` | Build headers from fingerprint, use curl-impersonate |
+| `src/services/http-fingerprint.ts` | Header ordering per browser (NEW) |
Author	SHA1	Message	Date
Kelly	cdab44c757	fix(ui): Show git hash instead of version number in sidebar 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 08:09:06 -07:00
Kelly	d6c602c567	fix(ui): Remove Cleanup Stale button from Workers page 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 01:29:25 -07:00
Kelly	a252a7fefd	feat(tasks): 25 workers, pool starts paused by default - Increase worker replicas from 5 to 25 - Task pool now starts PAUSED on deploy, admin must click Start Pool - Prevents workers from grabbing tasks before system is ready 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 01:19:02 -07:00
Kelly	83b06c21cc	fix(tasks): Stop spinner in status cards when pool is paused 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 01:14:25 -07:00
Kelly	e3d4dd0127	fix(ci): Fix Woodpecker config - remove invalid top-level when 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 00:45:08 -07:00
kelly	d0ee0d72f5	Merge pull request 'feat(tasks): Add task pool start/stop toggle' (#29 ) from feat/task-pool-toggle into master Reviewed-on: https://code.cannabrands.app/Creationshop/dispensary-scraper/pulls/29	2025-12-11 07:21:02 +00:00
kelly	521f0550cd	Merge pull request 'feat: Admin UI cleanup and dispensary schedule page' (#28 ) from fix/worker-proxy-wait into master Reviewed-on: https://code.cannabrands.app/Creationshop/dispensary-scraper/pulls/28	2025-12-11 07:08:03 +00:00
Kelly	8a09691e91	feat(tasks): Add task pool start/stop toggle - Add task-pool-state.ts for shared pause/resume state - Add /api/tasks/pool/status, pause, resume endpoints - Add Start/Stop Pool toggle button to TasksDashboard - Spinner stops when pool is closed - Fix is_active column name in store-discovery.ts - Fix missing active column in task-service.ts claimTask - Auto-refresh every 15 seconds 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-11 00:07:14 -07:00
Kelly	459ad7d9c9	fix(tasks): Fix missing column errors in task queries - Change 'active' to 'is_active' in states table query (store-discovery.ts) - Remove non-existent 'active' column check from worker_tasks query (task-service.ts) 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:54:28 -07:00
Kelly	d102d27731	feat(admin): Dispensary schedule page and UI cleanup - Add DispensarySchedule page showing crawl history and upcoming schedule - Add /dispensaries/:state/:city/:slug/schedule route - Add API endpoint for store crawl history - Update View Schedule link to use dispensary-specific route - Remove colored badges from DispensaryDetail product table (plain text) - Make Details button ghost style in product table - Add "Sort by States" option to IntelligenceBrands - Remove status filter dropdown from Dispensaries page 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:50:47 -07:00
kelly	01810c40a1	Merge pull request 'fix(worker): Wait for proxies instead of crashing' (#27 ) from fix/worker-proxy-wait into master Reviewed-on: https://code.cannabrands.app/Creationshop/dispensary-scraper/pulls/27	2025-12-11 06:43:29 +00:00
Kelly	b7d33e1cbf	fix(admin): Clean up store detail and intelligence pages - Remove Update dropdown from DispensaryDetail page - Remove Crawl Now button from StoreDetailPage - Change "Last Crawl" to "Last Updated" on both detail pages - Tone down emerald colors on StoreDetailPage (use gray borders/tabs) - Simplify THC/CBD/Stock badges to plain text - Remove duplicate state dropdown from IntelligenceStores filters - Make store rows clickable in IntelligenceStores 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:42:50 -07:00
Kelly	5b34b5a78c	fix(admin): Consistent navigation across Intelligence pages - Add state selector dropdown to all three Intelligence pages (Brands, Stores, Pricing) - Use consistent emerald-styled page navigation badges with current page highlighted - Remove Refresh buttons from all Intelligence pages - Update chart styling to use emerald gradient bars (matching Pricing page) - Load all available states from orchestrator API instead of extracting from local data - Fix z-index and styling on state dropdown for better visibility 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:32:57 -07:00
Kelly	c091d2316b	fix(dashboard): Remove refresh button and HealthPanel - Removed refresh button and refreshing state from Dashboard - Removed HealthPanel component (deploy status auto-refresh) - Simplified header layout 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:28:18 -07:00
Kelly	e8862b8a8b	fix(national): Remove Refresh Metrics button Removed unused refresh button and related state/handlers from National Dashboard. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:27:01 -07:00
Kelly	1b46ab699d	fix(national): Show all states count, not filtered "active" states The "Active States" metric was arbitrary and confusing. Changed to show total states count - all states in the system regardless of whether they have data or not. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:25:50 -07:00
Kelly	ac1995f63f	fix(pricing): Simplify category chart to prevent overflow - Replace complex price range bars with simple horizontal bars - Use overflow-hidden to prevent bars extending beyond container - Calculate bar width as percentage of max avg price - Limit to top 12 categories for cleaner display - Fixed-width labels prevent layout shift 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:24:31 -07:00
Kelly	de93669652	fix(national): Count active states by product data, not crawl status Active states should count states with actual product data, not just states where crawling is enabled. A state can have historical data even if crawling is currently disabled. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:23:20 -07:00
Kelly	dffc124920	fix(national): Fix active states count and remove StateBadge - Change active_states to count states with crawl_enabled=true dispensaries - Filter all national summary queries by crawl_enabled=true - Remove unused StateBadge from National Dashboard header - StateBadge was showing "Arizona" with no way to change it 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:22:19 -07:00
Kelly	932ceb0287	feat(intelligence): Add state filter to all Intelligence pages - Add state filter to Intelligence Brands API and frontend - Add state filter to Intelligence Pricing API and frontend - Add state filter to Intelligence Stores API and frontend - Fix null safety issues with toLocaleString() calls - Update backend /stores endpoint to return skuCount, snapshotCount, chainName - Add overall stats to pricing endpoint 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:19:54 -07:00
Kelly	824d48fd85	fix: Add curl to Docker, add active flag to worker_tasks - Install curl in Docker container for Dutchie HTTP requests - Add 'active' column to worker_tasks (default false) to prevent accidental task execution on startup - Update task-service to only claim tasks where active=true 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:12:09 -07:00
Kelly	47fdab0382	fix: Filter orchestrator states by crawl_enabled The states dropdown was showing count of ALL dispensaries instead of just crawl-enabled ones. Now correctly filters to match the actual stores that would be displayed. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:09:04 -07:00
Kelly	ed7ddc6375	ci: Add database migration step to deploy pipeline Migrations now run automatically before deployments: 1. Build new Docker image 2. Run migrations using the new image 3. Deploy to Kubernetes Requires new secrets: db_host, db_port, db_name, db_user, db_pass 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 23:07:25 -07:00
Kelly	cf06f4a8c0	feat(worker): Listen for proxy_added notifications - Workers now use PostgreSQL LISTEN/NOTIFY to wake up immediately when proxies are added - Added trigger on proxies table to NOTIFY 'proxy_added' when active proxy inserted/updated - Falls back to 30s polling if LISTEN fails 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2025-12-10 22:58:00 -07:00
kelly	61e915968f	Merge pull request 'feat(tasks): Refactor task workflow with payload/refresh separation' (#26 ) from feat/task-workflow-refactor into master	2025-12-11 05:24:11 +00:00
kelly	a4338669a9	Merge pull request 'fix(auth): Prioritize JWT token over trusted origin bypass' (#24 ) from fix/auth-token-priority into master Reviewed-on: https://code.cannabrands.app/Creationshop/dispensary-scraper/pulls/24	2025-12-11 01:34:10 +00:00