Add the Featured Product Category in the Staff View Order Process
As an example, administrators can create a query and product category record that–together–display featured products in the Staff View order process.
Create a query record.
In the tab bar, click App Launcher, or in Salesforce Classic, click Nimble AMS, Staff View, Button, All Tabs.
Click SOQL Queries.
Click New.
In Label, enter Featured.
Click Sharing Mode and select System.
In SELECT, enter:
SQL
Id, Name, ListPrice__c, TrackInventory__c, InventoryOnHand__c, Status__c, (SELECT PriceClasses__c, DefaultPrice__c, EarlyPrice__c, LatePrice__c, Name FROM SpecialPrices__r)
In SObject, enter Product__c.
In WHERE, enter:
SQL
RecordType.Name = 'Merchandise' AND Id IN (SELECT Product__c FROM CategoryProductLink__c WHERE IsFeatured__c = true) AND Entity__c = :entityId
Click Save.
Create a product category record.
From Setup, enter Custom Metadata Types in the Quick Find box, then select Custom Metadata Types.
Click Manage Records next to the Product Category custom metadata type.
Click New.
In Label, enter Featured.
In Display Name, enter Featured.
In Query, enter Featured.
Optionally, in Display Order, enter a number to signify where within the list of categories this product category should be shown in the Staff View order process. The lower the number, the higher the name is shown on the page.
The number should be 0 - 999.
Consider spacing out your numbers to accommodate future additions to the category.