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.
You can find this product using the search modifier examples in the table below.
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 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.
You can also search for items with missing info for certain system-wide fields:
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 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.
For all quantity fields, you can use the Greater Than (>) and Less Than (<) operators or search within a set range.
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.
For all price fields, you can use the Greater Than (>) and Less Than (<) operators or search within a set range.
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.
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.
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.
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:
- color: green
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:
- color: green OR turquoise
And you would enter the following into your search:
(color: green OR turquoise) price>50 available>1