ALTER TABLE public.product_units 
  ADD COLUMN IF NOT EXISTS retail_price numeric NOT NULL DEFAULT 0,
  ADD COLUMN IF NOT EXISTS wholesale_price numeric NOT NULL DEFAULT 0;

UPDATE public.product_units SET retail_price = price WHERE retail_price = 0 AND price > 0;