Councils fail in shopping battle