Inventory & Stock Take Search Query

In this article

YoPrint supports advanced queries for our inventory management. In this article, we will cover ways you can narrow down your selection.

Simple Querying

Before you try our advanced query, try just typing in your query as you would normally. Most of the time, the result would be an exact match.

In this example, we've typed in "Gildan 5000," and the result shows all Gildan 5000 t-shirts we have in our inventory.

Using AND Operator

Let's say we are only interested in Gildan 5000 White t-shirts. We can specify the query like so.

"Gildan" AND "5000" AND "White"

The query above translates to find me all products with the words Gildan, 5000, and White.

Pro Tip

Using the quotes around the words will perform an exact match. If you omit the quotes, we will perform a fuzzy match which may produces inaccurate results. Also avoid searching for multiple words within the same query like "Gildan 5000". 

All our searches are case insensitive.

Using OR Operator

Now, let's look for either White or Azalea t-shirts in our inventory.

"WHITE" OR "AZALEA"

The query above translates to find me all products with the words "White" or "Azalea." 

Compound Queries

Building on the example above, we are looking for Gildan 5000, but we are interested in either White or Azalea t-shirts.

"Gildan" AND "5000" AND ("WHITE" OR "AZALEA")

The query above translates as find all products with the words "Gildan" and "5000". From the products found, find all products that have the words either "white" or "azalea."

Search by a Field

If you would like to be precise with your query, you can search for products by the fields. For example, let's find Gildan 5000 by its id "5000".

product.style_name:"5000"

You can also use AND / OR operators to narrow down your query as well. 

Let's say I am interested in Gildan 5000 and 42000L t-shirts in the system; here is how the query would look.

product.style_name:("5000" OR "42000L")

Pro Tip

The parenthesis is required to ensure accurate search results.

Search by Multiple Fields

Building onto the query so far, let's search for all Gildan 5000 size XL t-shirts.

product.style_name:"5000" AND product.size_label:"2XL"

You can also use AND / OR operators to narrow down your query as well. 

Let's look for all size XL for Gildan 5000 or 42000L.

product.style_name:("5000" OR "42000L") AND product.size_label:"2XL"

Search Stock Availability

You can also search for stock availability. Let's find all the products you need to reorder.

stock_need_reorder:[1 TO *]

The syntax translates to find me all products with a reorder quantity set to a minimum of 1.

Pro Tip

The syntax to search for a range is [MIN TO MAX], and you can use the wildcard (*) symbol to make the range open-ended. For example,

To find a minimum, use [MIN TO *]

To find a maximum, use [* TO MAX]

All Supported Fields

Field Type Description
product.type

Fixed Options

  • db_catalog
  • db_simple
  • db_variant
Search by product type. 
  • db_catalog is for products from our catalog like SanMar
  • db_simple is custom product without color or size variant
  • db_variant for custom products with sizes or colors
product.style_name Text Product id from vendor catalog. For example, Gildan 5000 product code from SanMar is 5000 but from AlphaBroder it's G500
product.brand Text Product Brand. Example, Gildan
product.title Text The product title. For example, Gildan 5000 is "Heavy Cotton™ 100% Cotton T-Shirt"
product.color_label Text Product Color. Example "Azalea"
product.size_label Text Product Size. Example "2XL"
product.subtype Fixed Options
  • SanMar
  • SSActivewear
  • tsf
  • conde
  • AlphaBroder
  • augusta
  • delta_apparel
Search by catalog. 
stock_available
Number Available stock count. The value is derived by subtracting Stock Committed from Stock on Hand.
stock_need_reorder
Number Amount you need to reorder. It takes into account incoming stock to ensure you are not double ordering.
stock_on_hand
Number Stock on hand count
stock_committed
Number Total items needed to fulfill all active order
stock_incoming
Number Stock we have an outstanding PO for but have not received
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us