Supabase tables not found

Run this SQL once in your Supabase SQL Editor, then click Done.

create table stock_counts (
  variant_key text primary key,
  qty numeric not null,
  counted_by text,
  counted_at timestamptz default now()
);
alter table stock_counts enable row level security;
create policy "allow all" on stock_counts
  for all using (true) with check (true);

create table inventory_items (
  variant_key text primary key,
  item_no text not null,
  code text not null,
  description text,
  uom text,
  location text,
  system_qty numeric default 0,
  updated_at timestamptz default now()
);
alter table inventory_items enable row level security;
create policy "allow all" on inventory_items
  for all using (true) with check (true);

create table app_state (
  key text primary key,
  value text
);
alter table app_state enable row level security;
create policy "allow all" on app_state
  for all using (true) with check (true);

Upload New Inventory Baseline

Upload this week's inventory export from Wiise (columns: Item No., Code, Description, Variant UOM, Warehouse Location, On Hand (Variant)).

This will replace the current baseline and reset all counted items back to Pending.

End Count & Lock?

This will stop everyone from entering new counts. You'll still be able to manually adjust values before exporting. You can reopen counting later if needed.

Edit Counted Quantity