This document complements our documentation on: Custom Product Fields & Filters | Knowledge Base | SuperCat Solutions

Product sorting #

In addition to the ability to sort products by price or sales data, we allow you to chose custom product fields to sort by.

You can use this to sort by intro date, item number, year to date sales, or any number of other factors.

Configuring #

To set this behavior up, view the custom field administration view. Choose either Numeric Sort or String Sort and save.

You may configure up to 10 fields this way.

Understanding the sort behavior #

Numeric sort #

If you configure a custom field for numeric sort, the data in the field will be treated as numbers.

If the data for a given product is not a valid number, it will be sorted to the end regardless of whether the sort is ascending or descending.

String sort #

Strings will be sorted "ASCIIbetically." This is not quite the same as alphabetic search, but in most cases will work out the same.

Built-in sorts #

In addition to the sort fields you configure above, eCat provides some default sorts for those companies providing sales data.

• Territory Sales - sort the catalog by total amount sold, provided by the AmountInvoiced sales data column
• Territory Sales Qty - sort the catalog by total quantity sold, provided by the QuantityInvoiced sales data column
• Territory On Order - sort the catalog by the total amount on order, provided by the AmountOnOrder sales data column
• Territory On Order Qty - sort the catalog by the total quantity on order, provided by the QtyOnOrder sales data column
• Customer Sales - sort the catalog by total amount sold for the currently selected customer, provided by the AmountInvoiced sales data column. Requires a customer to be selected. (New with eCat 2023.5)
• Customer Sales Qty - sort the catalog by total amount sold for the currently selected customer, provided by the Quantity sales data column. Requires a customer to be selected. (New with eCat 2023.5)