The search functionality is one of the most helpful tools in SureDone to help sort through data throughout the site from finding out what items are out of stock to pulling up all orders that occurred within the last month. Clicking on the magnify glass in the top right will populate the search bar:

After the search bar populates there are four different types of searches you can choose from:

· Products (default search unless you are on the pages for any of the other types)

· Orders

· Categories

· Pages

The Product and Order searches are most commonly used and are very useful if there are a lot of orders and products to sift through. It is common to enter keywords in the searches, but it is important to note that the headers used in your bulk uploads can be used as search constraints to further refine results. A list of the bulk file headers and explanations can be found here. In addition to those headers, any custom field headers can also be searched on.

Using headers as search terms will return more accurate results. For example, the below search only looks for items that have the word “leather” in their title and sku/guid value:

However, when  material:=leather is entered in the Product Search it will return all items that have leather input as their material and might return more results since the seller might not put the material in all their items’ titles:

A few things to note in the above search that can be applied to all search terms are:

· Lowercase search terms – Search terms are case sensitive so TITLE: won’t work but title: will.

· Colon after search term – For each search, a colon (: ) needs to be in between the search term and search query

· Operators after the colon – Although not required, adding an operator can refine results further. It must always come after the colon.

Search Operators

Search operators aren’t required in a search but are good practice to use to return the most accurate results. The following are search operators that can be used for all search options (examples all for Product Search):

· : like/contains

· :-  not like/doesn’t contain

§ Example:

§ Example:

· :=  equal to

· :-=  not equal to

· :>  more than

· :<  less than

· :>=  greater than or equal to

· :<=  less than or equal to

· ()  or

Multiple Search Terms

Using multiple search terms in your searches is as commonly used as single term searches in SureDone. The last example in the Search Operators section displays a simple example of this looking for items that either have blue or red filled in the Color field.

When searching on multiple constraints, using a space between your search terms indicates AND. If you want to search for items that have 3 or more in stock AND are $150 or under, the search will be stock:>=3 price:<=150 and look as so:

Usually searches for OR will return more results than AND searches. For example, if you input color:red color:blue in the product search, it will return items that have the term red AND blue in the same field:

However, by putting parenthesis around the search like (color:red color:blue) it will return results for items that either have the term red OR blue in the color field:

Comparing Fields in Search Queries

New functionality has been added to the SureDone Search that allows you to compare your fields using the search operators outlined above. The use of this functionality is primarily for Product Search but can be applied to the other searches as well (i.e. Orders, etc). For example, if you want to double check that none of your items' cost is equal to or higher than the price being sold, you can input cost:>=price in your Product Search as so and see if anything is returned to fix: 

These searches can also be input in the Export section, with specific headers exported out. Use of this functionality is most likely going to be differ from user to user depending on the workflow especially since you can use custom fields you create in these searches as well. 

Product Search

The Product Search is the most used searching type. No matter where you are in SureDone, when you enter a search for Products and click Enter, it will open the All Products page with the search query applied. Some common uses for the Product Search is to search for items out of stock (stock:=0), items that are live on eBay (ebayid:>0), etc.

Tips for Product Search

· Exporting data to see if your search requires a specific format. If you are unsure on what value to search on for something, search for an item and export. For example, if you want to search for all items that have a certain eBay shipping profile applied, you can pick an item that has it set and export it and see what value is in that header and copy it to your search. There are two ways to export products by either entering the query in the main search and export all the data tied to the items returned in the search by clicking Export. The other way is to go to Products>Export and enter your query as well as pick any specific headers you’d like to export. For more information on exporting data, please visit the following guide: Exporting Product Data from SureDone

· Save your frequently used search queries. To save a search, enter your search query in the Product Search and click enter. Once the results are returned there will be and button called Add this search:

 

Clicking this will populate a space for text so you can name your search and, of course, save it:

· Add columns in the All Product page. Most search terms can be added as columns in the All Products page by clicking the dropdown at the right:

 

If you are ever unsure that your search isn’t pulling the correct results, it is advised to add a new column for the header you are searching on to verify. These columns also have the option to be moved and sorted in any order preferred.

· Using Inspect Element to find our custom field header name. If you are ever unsure of what header is used for a custom field (or default field), you can go to the product editor and right click the field name you want to know the header for:

Product Search Examples

The following section will go into various searches that are useful in SureDone and that are specific to certain channels. To go to a more comprehensive list of search queries please click here. We will be working to update this spreadsheet periodically with more examples! Additionally, if there is ever a search that can’t be found in this guide and isn’t too obvious to figure out, feel free to open a ticket in support. Please note that the ampersand (&) cannot be searched. If you want to search for a field that includes an ampersand the best thing to do it omit it from your search query.

General Single Term Searches

title:helmet	items with the word “helmet” in the title
upc:=	items with no UPC
brand:=apple	items with the brand Apple
total_stock:=0	items with no stock2
total_stock:>10
status:=publish	items that are active, not drafted/disabled3
sku_type:=parent	items considered parents; used for variations
sku_type:=children	Items considered children; used for variations

General Multiple Term Searches

title:”remote control” stock:<10	Items with “remote control” in title and have stock less than 10
brand:nike stock:=0	Items that are Nike brand and out of stock
price:<50 ebayid:>0	Items that are less than $50 and active on eBay
brand:=nike (color:blue color:red)	items with Nike brand and are either have “blue” or “red” in color field
brand:=nike total_stock:>5	items with Nike brand and have more than 5 in stock

Channel SKU Search

ebaysku:-=	items with eBay SKU
amznsku:-=	items with Amazon SKU
magentosku:-=	items with Magento SKU
bigcommercesku:-=	items with BigCommerce SKU
etsysku:-=	items with Etsy SKU

If multiple instances are added for a channel, then simply add the number next to the channel name in the header. For example, the header for SKUs on a 2^nd eBay channel will be ebay2sku. This  is applicable for other channel fields as well (i.e. ebay2shippingprofileid would indicate the Shipping Profile chosen for the second eBay instance added).

eBay Searches

ebayid:>0	items with active listing on eBay
ebayid:=	items not listing eBay
ebayid:>0 (brand:= mpn:= upc:=)	items on eBay that have empty fields for Brand or MPN or UPC

Please note some eBay fields can’t be searched using the headers but there is sometimes ways to still get the results you want returned by using ebayoptions in your search. The following is a few examples of how to use ebayoptions in your search:

Amazon Searches

amznasin:=	items that currently have no ASIN
amznasin:-=	items that currently have an ASIN
amznsku:-=	items that currently are synced to Amazon
amznitemtype:= amznasin:=	items with no Amazon Sub-Category (browse node) nor an ASIN

Order Search

The order search is the second most used search option in SureDone. Although it’s used pretty often, there aren’t nearly as many use cases for the search as there is for the Product Search. One thing to note is that, unlike the product search, there is no option to save your search. However, there is the ability to export the orders returned for a search. Like the product search, the headers used to update orders in bulk can be used for searching as well. A full list of order search terms for orders can be found here and to see more examples on Order searches click here.

Tips for Order Search

· The b before a search query represents the billing info. Field such as bcity, bzip, bphone indicate they are information for billing fields.

· The s before a search query represents the shipping info. Fields such as scountry, scity, sstate they are information for shipping fields.

· Input SKU or GUID value in order search to see orders that came in for the item.  Please note there is no search term necessary for that.

· Special values for searching with shiptracking search term. Other than including the tracking number to search for an order the following values can also be searched on for this field: pending, ordered, shipped, dropshipped, incomplete, checkoutpending, notracking, refunded, canceled and pickup

Order Search Examples

 

order:amzn	orders from Amazon
order:ebay	orders from eBay
date:2016-01-27	orders placed on January 27th, 2016
date:>=2016-04-01T07:00:00 date:<=2016-05-01T07:00:00	orders placed between April 1st, 2016 at 7:00 AM UTC and May 1st, 2016 at 7:00 AM UTC
blastname:”smith”	orders with Smith as the billing last name
szip:10010	orders with shipping zip code of 10010
date:>2015-07-08	orders that occurred after July 8th, 2015
shiptracking:=incomplete	orders that have tracking status of INCOMPLETE
items:>1	orders that have more than one item
shippingcountry:=us	US orders