Catalog Query

Introduction

Fanplayr provides the ability to view and query the products in an imported catalog. This feature allows you to filter your catalog and download the results as a CSV file.

To access this feature, click the View products button from the catalog list.

Viewing products

The catalog query page loads with a default set of filters applied. You can adjust these filters at any time — see Filters below for details.

Results are ordered as specified in the filters, with the first product appearing at the top-left and the last at the bottom-right. Each product card shows the product image, name, and price.

Clicking the Download button initiates a CSV download of the listed products, ordered the same as in the grid. The CSV includes the following fields:

• ID
• Name
• Brand
• Stock Status
• Price
• Categories
• Product URL
• Image URL

INFO

The price value in the CSV is the displayPrice from the catalog, or originalPrice if displayPrice is not set.

Filters

Filters allow you to narrow a potentially large product catalog down to a manageable subset for review.

Click the Edit button near the filters to open the filter panel. Click Update to apply your changes and refresh the product list. The available filters are:

Filter	Description	Default
Name	Match by product name. Use commas to separate multiple values.	Empty
Brand	Match by product brand as defined in the catalog. Use commas to separate multiple values.	Empty
Category	Match by product category. Use commas to separate multiple values.	Empty
Product List	Restrict results to products in a specific product list. Options shown are active product lists defined in the portal.	None
Stock Status	Match by availability status.	In Stock, Preorder, Backorder
Sort By	How results should be ordered. See sort options below.	First Seen Date (Ascending)
Number of Products	Maximum number of products to return. Maximum is 300.	20
Days of History to Use	Number of days of history to consider when ranking products. Relevant even when a ranking algorithm is not selected, as it allows you to control recency.	—

Sort options

By ranking algorithm (options may vary depending on your account):

• Ranking by Views
• Ranking by Carts
• Ranking by Purchases
• Ranking by Revenue

Other:

• Price (Ascending)
• Price (Descending)
• First Seen Date (Ascending)
• First Seen Date (Descending)
• First in Stock Date (Ascending)
• First in Stock Date (Descending)