Best Sellers

The Best Sellers extension adds a sorting option that lets you showcase best-selling items in your web store. Best Sellers can be used in several ways:

Sort your product list page by best-selling items
Set up specific merchandising zones to showcase best-selling items

Important:

Commerce extensions are only available if they are provisioned and set up in your account. For more information, see Commerce Extensions.

Best Sellers adds additional fields to your item records that are considered when calculating best-selling item sorting. You can choose to exclude specific items or override the best seller calculation to highlight specific items in the product list, custom landing pages, and merchandising zones. You can use either sales quantity or sales amount to determine whether an item is a best seller for a given period.

Installation

The Best Sellers extension does not require activation for a specific website or domain. However you need to install the SC Best Sellers SuiteApp. For more information, see Installing Theme and Extension SuiteApps.

To install the SC Best Sellers SuiteApp:

In NetSuite, go to Customization > SuiteBundler > Search & Install Bundles.
In the Keywords field, enter the Bundle ID or ‘best sellers’ and click Search.
Verify that the SC Best Sellers SuiteApp is returned in the search and select it.
Review the SuiteApp details and then click Install.

Best Seller Fields in the Item Record

When you install the Best Sellers extension, the following fields are added to your Item record, in the SuiteExtensions tab, Best Sellers subtab:

Exclude Item
Override Calculation
Last 7 Days – Sales Quantity
Last 30 Days – Sales Quantity
Last 90 Days – Sales Quantity
Last 365 Days – Sales Quantity
Last 7 Days – Sales Amount
Last 30 Days – Sales Amount
Last 90 Days – Sales Amount
Last 365 Days – Sales Amount

Best Seller Calculation

When the Best Sellers extension is installed, all items are automatically included in the calculation by default. When the best seller calculation script is run, the item’s accumulated sales quantity and amount for a given period are entered in the best seller fields in the Item record. These values are used to create a list of items with the highest sales amount or highest sales quantity. The script is run when the Best Sellers extension is installed for the first time to take into account all existing transactions. It is then run daily at the end of the day to consider the current day’s transactions.

Exclude Items From Best Seller Sorting

You may decide that you do not want an item to appear as a best seller in your web store if it is a low-margin item, for example. You can choose to exclude it from the automatic calculation by selecting the Exclude Item box. When you select this option, all sales amount and sales quantity fields are set to 0 for this item and you cannot change the values. The item is no longer included in the calculation.

If you want to re-include an item in the best seller calculation, clear the Exclude Item box. The sales amount and sales quantity for the given periods are re-calculated when the best-seller calculation script is run again.

Override Best Seller Sorting

You may decide that you want an item to appear as a best seller in your web store, even though it has a lower sales turnover. You can manually change the best seller calculation by selecting the Override Calculation box. When you select this option, you can enter values in the sales amount and the sales quantity fields for the various periods. To force an item to be listed as the best seller, you must enter the highest sales quantity or sales amount value for that period. You can determine this value by executing a saved search with the appropriate criteria.

You can choose to override the best seller calculation for all periods or for a specific period. The fields that you do not change retain the values from the last calculation.

To remove the override, clear the Override Calculation box. The sales amount and sales quantity for the given periods are re-calculated when the best seller calculation script is run again.