Store Trade-In Tracker

Run this SQL once in the database SQL editor to schedule a daily scrape at 03:30 UTC. It hits the same endpoint the “Run now” button uses.

create extension if not exists pg_cron;
create extension if not exists pg_net;

select cron.schedule(
  'istore-tradein-daily',
  '30 3 * * *',
  $$
  select net.http_post(
    url     := 'https://project--e1540896-7663-4601-a98b-ee2c9d225e02.lovable.app/api/public/scrape-tradein',
    headers := jsonb_build_object(
      'Content-Type', 'application/json',
      'apikey', 'sb_publishable_keq1AsFX8Cq6lhCRaIUjlw_FJXpSkdO'
    ),
    body    := '{}'::jsonb
  );
  $$
);