Advanced Tips for Product Search

The Product Search tool is a powerful tool for sifting through your inventory. Though you can perform a basic search by entering any value into the search bar, you can refine your search with a host of search modifiers.

Note that many other tools also use the same Product Search engine, including:

  • Customer Service - Order Search
  • Item Search when adding items onto customer orders
  • Order Returns Search
  • Shipment Wave - SKU Search
  • Feed Manager - Sample Data Search

Search by Specific Fields and Attributes

You can search by specific attributes and fields in RO. Look at the following product.

Search by Specific Fields and Attributes

You can find this product using the search modifier examples in the table below.

Search by
Search Modifier
Example Search
SKU
sku:
sku: 872356
MPN/Style No.
ident:
ident: b10151
Product Number
product:
product: 8
UPC
upc:
upc: 883290652780
Brand
brand:
brand: sebago
Product Name
name:
name: roebling
Status
status:
status: incomplete
Container
container:
container: 02-01-01

You can also search by any product attributes that you’ve built. Simply use the attribute’s clean name--its name in all lowercase letters with any spaces between words removed--as the search modifier. Look below for some examples. Notice that for quantity-based attributes such as Serving Size and Heel Height, you can use the Greater Than (>) and Less Than (<) operators or search within a set range.

Search by Search Modifier Example Search
Country of Origin
countryoforigin:
countryoforigin: china
Lens Color
lenscolor:
lenscolor: blue
Flavor
flavor:
flavor: mild
Serving Size
servingsize:
servingsize>
servingsize<
servingsize: [minimum TO maximum]
servingsize: 500
servingsize> 200
servingsize< 700
servingsize: [200 TO 700]
Gender
gender:
gender: female
Color
color:
color: red
Heel Height
heelheight:
heelheight>
heelheight<
heelheight: [minimum TO maximum]
heelheight: 1.5
heelheight> 1
heelheight< 3
heelheight: [1 TO 3]

Search by Missing Info

Not only can you search by different fields and attributes--you can also search by missing info in fields and attributes. Using the _missing_ search modifier, you can find items that are missing data in a particular attribute. This is most useful for cleaning up and maintaining your catalog. For example, if the Gender attribute is required to complete an item, you can find all items in your inventory that are incomplete because they are missing Gender and fix them to put them up for sale.

Note that you must use the attribute’s clean name--its name in all lowercase letters with any spaces between words removed--as the search term.

Search by Search Modifier Example Search
Missing Info
_missing_: attribute
_missing_: countryoforigin
_missing_: lenscolor
_missing_: flavor
_missing_: servingsize
_missing_: gender

You can also search for items with missing info for certain system-wide fields:

Field
Search String
Barcode
_missing_: barcode
UPC
_missing_: upc
VPC
_missing_: vpc

Search by Missing Media

Similarly, you can search for items based on whether the items have media or do not. Note that the string has_media: 0 returns items that do not have media; conversely, has_media: 1 returns items that do have media.

Search for
Search Modifier
Items without Media
has_media: 0
Items with Media
has_media: 1

Search by Quantity

You can search by the various quantity fields captured in RO.

  • Physical quantity describes the total amount of item units that you physically store inside your warehouse. This would not include any Dropship, JIT, or 3PL units.
  • External quantity describes the amount of item units that have been set aside for you via inventory advice. This reflects Dropship, JIT, and 3PL items.
  • Reserved quantity describes the amount of item units for which customers have placed orders. Reserved units are currently being processed for fulfillment. To view the reserved quantity, hover over the Quantity displayed for the SKU.
  • Available quantity describes the amount of physical item units currently available for purchase. This is calculated by adding the physical and external quantities together, then subtracting the reserved quantity.

Look to the table below for the appropriate search modifiers to use in each case.

Note: Currently, the search modifier for all external quantity is "dropship". This reflects Dropship, JIT, and 3PL items. We will be changing this in the future to provide a more intuitive user experience.

Search by Search Modifier Example Search
Physical Quantity
physical:
physical: 5
Reserved Quantity
reserved:
reserved: 2
Available Quantity
available:
available: 3
External Quantity
dropship:
dropship: 3

For all quantity fields, you can use the Greater Than (>) and Less Than (<) operators or search within a set range.

Search by Search Modifier Example Search
Greater Than
physical>
physical> 2
Less Than
physical<
physical< 7
Quantity Range
physical: [minimum TO maximum]
physical: [2 TO 7]

Search by Price

You can search by the various price fields captured in RO.

  • Price refers to the selling price of an item, the price that customers pay to purchase the item. The price is typically higher than the unit cost but no higher than the MSRP.
  • MSRP, or manufacturer suggested retail price, is the amount a manufacturer recommends that retailers sell an item for when it is first released on the market. This might be thought of as the full price. Often retailers will sell an item at full MSRP to begin with but lower its price either because of various promotions or because of lower demand for the item.
  • MAP, or minimum advertised price, is the lowest amount a manufacturer will allow an item to sell for. Sometimes, a manufacturer may want to limit how much retailers can discount certain items. They may do this to ensure all retailers can remain competitive. Or they may do this to maintain the integrity of the brand.

Look to the table below for the appropriate search modifiers to use in each case.

Search by Search Modifier Example Search
Price
price:
price: 50
MSRP
msrp_price:
msrp_price: 145
MAP
map_price:
map_price: 45

For all price fields, you can use the Greater Than (>) and Less Than (<) operators or search within a set range.

Search by Search Modifier Example Search
Greater Than
price>
price> 45
Less Than
price<
price< 145
Price Range
price: [minimum TO maximum]
price: [45 TO 145]

Search Using Enhanced Logic

You can use a variety of search operators to modify the search logic to fit your needs.

  • Either of multiple values. This is the default search logic when performing a search. If you enter more than one word into a search, RO will return results that contain any one of those words. However, you can also make the logic explicit by using the OR operator between values.
  • Multi-word phrases. If you surround a phrase in quotation marks (“phrase value”), RO will treat the phrase as one value and look for that exact sequence of words. For example, if you search for neon green (without quotes), you will get products in neon, green, or neon green. But if you search for “neon green” (with quotes), you can refine your results to just those products in neon green.
  • All values stated. Using the AND operator between values, RO will search for products that contain all values stated. The values don’t have to be together in a phrase. But the values must all be found in the product data. You can use this to enhance a basic search--for example, a search for blue AND nike will yield results for blue products from Nike. Or you can use this to search for keywords in any Text-type attributes you’ve built such as Product Description.
  • One value unless the product contains another value within. Using the NOT operator between values, you can exclude search results that you may not want. For example, if you wanted to search for products that are green but do not want any neon green products, you can enter green NOT neon into your search.
Search Logic
Search Operator Example Search
Either of multiple values
value1 OR value2
nike OR adidas
Multi-word phrase
"phrase value"
"neon green"
All values stated
value1 AND value2
red AND pumps
One value unless the product contains another value within
value1 NOT value2
green NOT neon

Perform Wildcard Searches

Wildcard searches allow you to search for a string of characters contained within a field or attribute. This search will return any results with the string without you having to specify an exact value. This can be particularly useful if, for example, your SKUs follow a specific format and you want to find a certain group of items with a specific string in the SKU.

There are two wildcard characters you can use for these searches: either an asterisk (*) character or a question mark (?) character. The asterisk represents any number of characters that may vary while the question mark represents a single variable character. You may place the wildcard character before, after, around, or within the string to perform different wildcard searches.

As a matter of example, let's say that your SKUs follow a certain format including shortcodes for brand, product, and color. One SKU might look like "BEY-01-BLK". Look to the table below for examples of different search terms and the search results that might be returned for each.

Sample Search Terms
Possible Search Results
BEY*
BEY-01-BLK
BEY-01-BLU
BEY-04-BLK
BEY-16-RED
*BLK
BEY-01-BLK
BEY-16-BLK
JAY-08-BLK
LMN-32-BLK
*01*
BEY-01-BLK
BEY-01-BLU
RIH-01-RED
PRC-01-PUR
BEY-0?-BLK
BEY-01-BLK
BEY-01-BLU
BEY-04-BLK
BEY-09-YEL
BEY-0?-B??
BEY-01-BLK
BEY-04-BRN
BEY-06-BUR
BEY-08-BLU

Perform Fuzzy Searches

Fuzzy searches allow you to search for results similar to the search string specified. Fuzzy searches can be useful for finding data that may have been misspelled when it was entered. They can also be useful for finding data that may have been input in slightly different forms (e.g. "multicolor" vs. "multi-color" vs. "multi colored").

You may add the tilde (~) character to the end of your search string to perform a fuzzy search.

Sample Search Terms
Possible Search Results
skechers~
skechers
sketchers
skehcers
scechers
multicolor~
multicolor
multi-color
multi color
multi colored

Combine Search Criteria

It’s very easy and very useful to combine search criteria. Say you’re planning a promotion for St. Patrick’s Day. You want to have a sale on green items over $50. Of course, you only want to sell items that you have available. This would require three different search criteria:

  1. color: green
  2. price>50
  3. available>1

You can combine them simply by typing them all into the search bar, separating each criteria with a space:

color: green price>50 available>1

If you want to include any criteria with enhanced logic operators (i.e. OR, AND, NOT), you must enclose that criteria in parentheses.

Going off the previous example, if you want to include turquoise in the promotion as well, your search criteria would be:

  1. color: green OR turquoise
  2. price>50
  3. available>1

And you would enter the following into your search:

(color: green OR turquoise) price>50 available>1
Have more questions? Submit a request

5 Comments

  • 0
    Avatar
    Nicholas Schneider

    Is there a way to search on External Vendor with Product Search?

  • 0
    Avatar
    Ally Norman-Daley

    Hi Nick! Not currently, but I'm happy to submit a feature request to add this to the product search tool. This information is visible in the reporting tool as well, under the "External Inventory" datasource.

  • 0
    Avatar
    Matt Wade

    Is there a way to search by date created?

  • 0
    Avatar
    Ally Norman-Daley

    Hi Matt! At this time, SKU or product creation date is not currently available in the Product Search. Product search tool improvements are on our long term roadmap, and I'm happy to log this as a use case for the upcoming functionality. Please let us know if we can assist further!

  • 0
    Avatar
    Matt Wade

    Hi Ally, we are trying to find a way to get "real-time" receiving metrics.  The reporting tool is delay by a few hours and I was hoping we could use the Product Search screen for this purpose.  Any thoughts on how we can get real-time information?  Thanks!

Please sign in to leave a comment.
Powered by Zendesk