The Product List and Search
The Product List in Jasper, located from the Products section of the main PIM menu on the left hand side, is your main view into your product catalog. From here you can view your products, perform simple and advanced searches, and perform batch actions on a selection of products.
The Product List
The Product List shows your entire product catalog organized by ascending Jasper ID. The following fields of information are available:
Thumbnail
The image asset on the product set to the thumbnail
Product Information
The name of the product and the Jasper ID. Clicking on the name, takes you to the product details screen
SKU
Your unique product identifier
Brand
Displays a brand that is linked to the product (if any)
Visibility
Displays whether the product is made visible or not visible on the store front
View Button
Allows to view the product details
At the top of the page you will see your search window as well as the Create Product and Batch Action buttons. At the bottom of the window you can select the number of products to display per page between 10 and 100 and click through each page.
Product Search
As your product catalog grows within Jasper PIM you will need to regularly visit specific products or groups of products to perform updates and make edits. There are three methods of searching for products inside Jasper PIM.
1- Quick Search
The quick search in the top bar can be accessed from any page. If you know the exact product identifier, select it from the drop down and type or paste it into the field.
SKU - your internal identifier
PCSID - Jasper's automatically assigned ID number
WEBID - the published channel's identifier
UPC - Universal Product Code (if assigned)
| Info |
|---|
When using Google Chrome with Jasper PIM you can use a combination of CTRL + Click (Windows), or CMD + Click (Mac) on the search icon to open the results in a new background tab to keep your current place while quickly jumping to a new product. |
2- Product List - Simple Search
To perform a simple search query go to the product list from the left side menu. From the product list you have access to a simple search box. Here you can use short exact match phrases to find products or similar products. This will look at product names and descriptions to find a match.
NOTE: the search looks for the exact word or words in the order in which they were used, similar to wrapping the phrase in quotations on typical boolean search. (ex. 'Green Shirt' and 'Shirt - Green' will not show up under the same query).
3- Product List - Advanced Search
Jasper's advanced search allows you to narrow down your product catalog into easily digestible pieces. From the product list, access the advanced search feature by clicking advanced next to the search box.
Filters
The selectable drop down filters allows you to choose between the available search filters as follows:
| Expand | ||
|---|---|---|
| ||
Search by product name |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu |
| Expand | ||
|---|---|---|
| ||
Select from the list of available brands via drop down menu |
| Expand | ||
|---|---|---|
| ||
Search by product description |
| Expand | ||
|---|---|---|
| ||
Select from the list of available categories via drop down menu |
| Expand | ||
|---|---|---|
| ||
Search by category name |
| Expand | ||
|---|---|---|
| ||
search by product long description |
| Expand | ||
|---|---|---|
| ||
Select from the list of available Category IDs via drop down menu |
| Expand | ||
|---|---|---|
| ||
Search by product SKU |
| Expand | ||
|---|---|---|
| ||
Select from the list of available Categories via drop down menu |
| Expand | ||
|---|---|---|
| ||
Select from the list of available brand IDs via drop down menu |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu. Select Yes if the product has a value assigned to MSRP price |
| Expand | ||
|---|---|---|
| ||
Search by product price |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu. Select Yes if the product has a value assigned to Cost in the pricing tab |
| Expand | ||
|---|---|---|
| ||
search by product Inventory |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu. If Yes is selected display all the products that has a Yes value on the “Featured Product” field on the Details tab of Products |
| Expand | ||
|---|---|---|
| ||
Search by Product |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu. If Yes is selected display all the products that has a Yes value on the “Visible to Front End” field on the Details tab of Products |
| Expand | ||
|---|---|---|
| ||
Search by products Web ID |
| Expand | ||
|---|---|---|
| ||
Search by Products PIM ID |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu. If Yes is selected display all the products that has category assigned to them. |
| Expand | ||
|---|---|---|
| ||
Choose between the list of Channels |
| Expand | ||
|---|---|---|
| ||
Search by tag assigned to the products |
| Expand | ||
|---|---|---|
| ||
Choose between items set to "published" or "unpublished" |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu to select products with/without inventory |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu to select products with/without photo |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu to select products with/without price expiring soon |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu to select products with/without price |
| Expand | ||
|---|---|---|
| ||
Choose between Yes/No from the drop down menu to select products with/without sell price |
| Expand | ||
|---|---|---|
| ||
Search by the Workflow name |
| Expand | ||
|---|---|---|
| ||
Search by the weight value assigned to the products under the Shipping tab |
| Expand | ||
|---|---|---|
| ||
Search by specific Attributes. Choose from the drop down menu |
| Expand | ||
|---|---|---|
| ||
Search if a product has been enabled on 1 or more channels |
| Expand | ||
|---|---|---|
| ||
Search for sellable inventory amounts for a product |
| Expand | ||
|---|---|---|
| ||
Search for on hand inventory amounts for a product |
| Expand | ||
|---|---|---|
| ||
Search for a value on a products generic entity |
| Expand | ||
|---|---|---|
| ||
Search for a value on a product generic entity relation |
Criteria
The search criteria section allows more flexibility to narrow your product results. Using the + button to add multiple types of the same criteria perform AND based searches.
The text box allows you to search a string from a specific field. Default PIM fields and any custom created text attributes are available. NOTE: select box and multi-select attributes are case sensitive. The available qualifiers are:
Within
Not Within
Equal
Not Equal
Number range searches are available for default PIM fields and allow you to find products that lie between a range of values. This is most useful for pricing and PCSID ranges.
The number equals criteria uses mathematical relationship qualifiers to find items among default PIM fields. The available qualifiers are:
= - Equals
!= - Does not equal
> - Greater than
- Less than
>= - Greater than or equal to
= - Less than or equal to
| Info |
|---|
You are comparing all product values against the value you enter in the criteria box. (ex. 161 > PCSID will return all PCSIDs that are greater than 161. It helps to pick the field then your qualifier than your value so that you are choosing [PCSIDs] that are [greater than (>)] [161]. Do not think about it as an equation). |
Sorting
You can sort your search results by the following fields in ascending or descending order.
Display Photos
If you have a large product catalog you can speed up search results by unchecking the box marked Display Photos.
Add New Condition
You can add a new search filter to the existing search filter using the AND search command.
Saved Searches
If you are performing the same search many times you can save it as a project to keep the search filter for future use. To save a search:
Input your search string, filter, and criteria
Click the “Save Project” button next to the Filter button
Choose a name and Description for the project
Click “Save as new Project”
Retrieve a Saved Search
Saved searches are accessible via the Projects. Click on the Projects from the main PIM menu on the left hand side. From here you can view all the saved searches, Click on View button to see the list of products that match the search criteria or delete those you no longer need.