ALTER TABLE bazzar_pos.products
ADD COLUMN IF NOT EXISTS is_sellable BOOLEAN NOT NULL DEFAULT TRUE;

ALTER TABLE bazzar_pos.products
ADD COLUMN IF NOT EXISTS is_internal BOOLEAN NOT NULL DEFAULT FALSE;

UPDATE bazzar_pos.products
SET
    is_sellable = FALSE,
    is_internal = TRUE,
    updated_at = NOW()
WHERE UPPER(COALESCE(item_code, '')) LIKE 'AUTO-%';
