Child pages
  • [in-commerce] Product sorting by quantity results in SQL error [5.2.1]
Skip to end of metadata
Go to start of metadata

In each In-Portal module it's possible to select default sorting of module items. The In-Commerce module items are called "products" and they can be sorted on Front-End using several fields, including quantity in stock.

Due typo error the quantity related field is called "Qty" instead of "QtyInStock".

Solution

Rename "Qty" into "QtyInStock" in the "product_OrderProductsBy" and "product_OrderProductsThenBy" system setting value and possible dropdown options.

Related Tasks