Consumer confidence has crashed to a three-year low over fears the war in the Middle East will prove to be highly costly for households.