clean up checkout_confirmation query