fix product scope and query for retrieving product brand
remove deprecated scoped call