We're software that helps growing brands & retailers grow and scale. Sync, sell and ship your products and inventory on online marketplaces and storefronts faster, easier and more accurately.

Learn more now

How to Search SureDone for Products and Orders


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

§ Example:

title:leather

items that have leather anywhere in the title


· :-  not like/doesn’t contain

§ Example:

material:-leather

items that don’t have leather anywhere in the material field (will omit results like “faux leather” or “vegan leather”)


· :^ like/contains "starts with"

§ Example:

title:^lea

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"

§ Example:

material:blue$

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

§ Example:

material:=leather

items have material of leather exactly (will omit results like “faux leather” or “vegan leather”)


· :-=  not equal to

§ Example:

material:-=leather

Items that do not have leather as a value (will include results like “faux leather” or “vegan leather”)


· :>  more than

§ Example:

stock:>50

items that are over 50 in stock


· :<  less than

§ Example:

price:<150

items that under $150


· :>=  greater than or equal to

§ Example:

stock:>=50

items that have 50 or more in stock


· :<=  less than or equal to

§ Example:

price:<=150

items that are $150 or less


· ()  or

§ Example:

(color:red color:blue)

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. 


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:




  

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


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 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).

 

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:




ebayoptions:listing":"Chinese

items listed as auction in eBay

ebayoptions:Chinese

items listed as auction in eBay

ebayoptions:listing":"FixedPriceItem

items listed as fixed price item in eBay

ebayoptions:FixedPriceItem

items listed as fixed price item in eBay    

ebayoptions:enabled":true


Items listed with Best Offer enabled or Best Offer set to True

ebayoptions:shippingprofileid":"

items listed with specific profile ID (insert profile ID after last quotation marks)                                            





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