Can we elegantly exit by handling this with a not supported message instead exiting with error

grandnode version 4.4

a) http://docs.grandnode.com/operations-with-categories

how to use $expand to get all products under categories?

b) http://127.0.0.1/odata/Product?$select=Price,Name

i get below error when i select only Price and Name. am i missing something?

result:

{
    "error": {
        "code": "",
        "message": "The query specified in the URI is not valid. The property 'Price' cannot be used in the $select query option.",
        "details": [],
        "innererror": {
            "message": "The property 'Price' cannot be used in the $select query option.",
            "type": "Microsoft.OData.ODataException",
            "stacktrace": "   at Microsoft.AspNet.OData.Query.Validators.SelectExpandQueryValidator.ValidateSelectItem(SelectItem selectItem, IEdmProperty pathProperty, IEdmStructuredType pathStructuredType, IEdmModel edmModel)\n   at Microsoft.AspNet.OData.Query.Validators.SelectExpandQueryValidator.ValidateRestrictions(Nullable`1 remainDepth, Int32 currentDepth, SelectExpandClause selectExpandClause, IEdmNavigationProperty navigationProperty, ODataValidationSettings validationSettings)\n   at Microsoft.AspNet.OData.Query.Validators.SelectExpandQueryValidator.Validate(SelectExpandQueryOption selectExpandQueryOption, ODataValidationSettings validationSettings)\n   at Microsoft.AspNet.OData.Query.SelectExpandQueryOption.Validate(ODataValidationSettings validationSettings)\n   at Microsoft.AspNet.OData.Query.Validators.ODataQueryValidator.Validate(ODataQueryOptions options, ODataValidationSettings validationSettings)\n   at Microsoft.AspNet.OData.EnableQueryAttribute.ValidateQuery(HttpRequest request, ODataQueryOptions queryOptions)\n   at Microsoft.AspNet.OData.EnableQueryAttribute.<>c__DisplayClass1_0.<OnActionExecuted>b__3(ODataQueryContext queryContext)\n   at Microsoft.AspNet.OData.EnableQueryAttribute.ExecuteQuery(Object responseValue, IQueryable singleResultCollection, IWebApiActionDescriptor actionDescriptor, Func`2 modelFunction, IWebApiRequestMessage request, Func`2 createQueryOptionFunction)\n   at Microsoft.AspNet.OData.EnableQueryAttribute.OnActionExecuted(Object responseValue, IQueryable singleResultCollection, IWebApiActionDescriptor actionDescriptor, IWebApiRequestMessage request, Func`2 modelFunction, Func`2 createQueryOptionFunction, Action`1 createResponseAction, Action`3 createErrorAction)"
        }
    }

}


Regards,
Kalyan

could you please confirm if below line is removing all the products from cache?
_cacheManager.RemoveByPattern(PRODUCTS_PATTERN_KEY);

I noticed this line in both InsertProduct and DeleteProduct methods of ProductService.

Why should adding single product to Db cause all the Products from cache to be removed?
Why should deleting a single product from Db cause all the Products from cache to be removed?

Thanks

Thank you. it works when i create / edit a product using a vendor account.

Hi -

on vendor details page. there is an option to select the store for the vendor. however, when i visit other stores unallocated to this vendor, i am still able to see this vendor's products.

is it possible to restrict vendor's products to a single store using this setting?

am i missing something?

Regards,
Kalyan

even though Individual price is lower. the Tier price is the one being shown in case the individual customer is in the same customer group.

eg. customer group Retail's, Tier price is 1000.  Individual price of cust1 (part of retail group) is 950.

when cust1 login to front end, the price being displayed is 1000.

Also, could you please advise what would be the base price for discount calculation when promotion on a particular product are active. would it be tier price or individual price?

Patrik - What is the priority of pricing classes when individual prices are active?

i mean when tier prices, discounts and Individual prices are effective which one takes priority and in which order.

i tested tier prices with individual prices, when a customer group pricing is active, Individual prices for that customer is overridden.

is this expected behavior? I used the 4.3 for this test.