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)
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 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
items that have leather anywhere in the title
· :- not like/doesn’t contain
items that don’t have leather anywhere in the material field (will omit results like “faux leather” or “vegan leather”)
· :^ like/contains "starts with"
items that have a title that starts with "lea"
may be combined with not like operator to exclude titles that starts with the search
· :...$ like/contains "ends with"
items have a color that ends with "blue" (will omit results like “blue sky” or “blue ocean”)
may be combined with not like operator to exclude colors that end with the search
· := equal to
items have material of leather exactly (will omit results like “faux leather” or “vegan leather”)
· :-= not equal to
Items that do not have leather as a value (will include results like “faux leather” or “vegan leather”)
· :> more than
items that are over 50 in stock
· :< less than
items that under $150
· :>= greater than or equal to
items that have 50 or more in stock
· :<= less than or equal to
items that are $150 or less
· () or
items that have red OR blue contained in the Color field
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.
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:
Clicking the Inspect option will open a section on the right of the browser with a bunch a text and will highlight the area you right clicked on. It will list the header for the field. In this example it is usshoesizewomens:
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
items with the word “helmet” in the title
items with no UPC
items with the brand Apple
items with no stock2
items that are active, not drafted/disabled3
items considered parents; used for variations
Items considered children; used for variations
General Multiple Term Searches
Items with “remote control” in title and have stock less than 10
Items that are Nike brand and out of stock
Items that are less than $50 and active on eBay
items with Nike brand and are either have “blue” or “red” in color field
items with Nike brand and have more than 5 in stock
Channel SKU Search
items with eBay SKU
items with Amazon SKU
items with Magento SKU
items with BigCommerce SKU
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 2nd 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).
items with active listing on eBay
items not listing eBay
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:
items listed as auction in eBay
items listed as auction in eBay
items listed as fixed price item in eBay
items listed as fixed price item in eBay
Items listed with Best Offer enabled or Best Offer set to True
items listed with specific profile ID (insert profile ID after last quotation marks)
items that currently have no ASIN
items that currently have an ASIN
items that currently are synced to Amazon
items with no Amazon Sub-Category (browse node) nor an ASIN
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
orders from Amazon
orders from eBay
orders placed on January 27th, 2016
orders placed between April 1st, 2016 at 7:00 AM UTC and May 1st, 2016 at 7:00 AM UTC
orders with Smith as the billing last name
orders with shipping zip code of 10010
orders that occurred after July 8th, 2015
orders that have tracking status of INCOMPLETE
orders that have more than one item
shippingcountry:=us US orders