Heine Propane

Publish Cadence

Queue Status

Required SQL — Run First

Run this in the Supabase SQL Editor before using Backfill or Fetch Photos.

ALTER TABLE public.points_of_propane
  ADD COLUMN IF NOT EXISTS jobber_id text,
  ADD COLUMN IF NOT EXISTS jobber_job_number text;

CREATE UNIQUE INDEX IF NOT EXISTS pop_jobber_id_unique
  ON public.points_of_propane (jobber_id)
  WHERE jobber_id IS NOT NULL;

Backfill Jobber IDs

Fetches all jobs from Jobber and matches them to existing Supabase records by job number, writing the Jobber node ID into the jobber_id column. Run this once to enable the photo fetcher on pre-existing records.

Debug DB

Fetches the first 5 rows from points_of_propane and shows raw JSON — id, description, jobber_id, jobber_job_number. Use this to verify whether jobber_id is truly NULL before running Backfill.

Re-fetches those 5 Supabase records, extracts job numbers via /#(\d+)\s*$/, then pulls page 1 from Jobber and shows whether the numbers overlap.