This article will review some of our robust search options to help you find exactly what you're looking for.
What we'll cover in this article:
Choosing the Best Section of UPS to Search
Different areas of the site offer different search options. Here are some basics:
- Market List: The most versatile place to search.Good for listing products or updating listings. You can also update product details and quantity, but not cost or storage location.
- Warehouse or Vendor Inventory List: Good for quantity, cost, storage location, and product information updates.
You can use the Find & Load tool to search Amazon and eBay for listings other sellers have launched. You can also use it to search your UPS account for products. You can even combine data found on Amazon or eBay with your products' details.
- This makes it a powerful shortcut for creating new products, but it's not a tool you would normally use to edit or delete products once you have them. For more info about Find & Load, see Creating and Editing a Product using the Find and Load Tool).
If you're using the user interface to add an existing product to a Warehouse or Market List, you have to search for the product on the level already contains that product, not the level you want to put it on. For example, if you created a product through the user interface, and added it to a Warehouse, but want to find it now to add it to a Market List, you need to search the Warehouse you added it to, not the Market List you want to add it to.
A note on deleting: Searching and deleting work hand-in-hand. If you plan to delete products, you’ll also want to check out our Deleting Products article. Just like searching, each section of UPS gives you different removal options. A Warehouse/Vendor List gives you the most control, but you might have a reason to delete data from another section instead.
Searching for Products
1) Navigate to the correct section of your UPS account:
- To search a Warehouse or Market List, go to the Products menu -> Inventory Manager and select the Warehouse or List.
- To search the Products Manager, to to the Products menu -> Products Manager.
2) Enter text in the SEARCH field, and use the drop-down menu to set which field it searches.
- As a note, you can usually search for the Parent SKU and for keywords from a listing error or Last Listing Result in a Market List. These options are not available in a Warehouse or Vendor Inventory List.
3) Clicking the More Search Options link allows you to further refine your search.
Here are a few of the more popular More Search Options:
- To use the Find in attribute filter, select any product attribute and enter the information you want to find in The value field.
- If the attribute you want doesn’t appear in the drop-down menu, make sure the Searchable option is enabled in your Manage Product Attributes pop-up window.
- Listing options:
- In a Warehouse/Vendor you can search by Marketplace, or use the by Filter by List to find whether products are in a Market List or not (In List or Not in list)
- In a Market List you can search by Auto Rule Name, Listing status, and Automation Status
- Date: in a Warehouse/Vendor List and Market List you can find products by: Quantity changed since
- Inventory: in a Warehouse/Vendor List and Market List you narrow your search by: Stock quantity
If you're searching for a range between two fields, don't leave one blank unless you've selected an "Or More/ Or Less" drop-down option.
- If you don't want to use a filter setting any more, remember to clear each of its settings — the Less Search Options button hides them but they keep limiting your searches.
4) Click the SEARCH button.
5) If you haven’t done so already, you can customize your view by clicking on the Columns Setup link on the left-hand side above the first column.
6) You can click Back or Next to see the previous or next page of search results. You can also change the View Per Page to see more products, or change the Sort By field. The search can be set to display in Ascending (ASC) or Descending (DESC) order.
7) To get your search results into a spreadsheet, you can click Export Products to download a text file. (You'll always get everything on your search, no need to check any of the rows' checkboxes.)
Two super useful and popular searches:
- Add a special custom attribute to the products you need to find, so you can filter your searches by that attribute; see Using Custom Product Attributes for details.
- To find products that may be ready to list on a marketplace: in a Market List, search by Listing Status = Offline and Stock quantity = 1 or more.
- You could also use the Quantity changed since filter with a recent date to find newly added products that need to be listed.
Some searches will show you fields you can't click on, because those fields properly belong to other levels of information in UPS. For example, you can see your Cost (acquisition cost) and the Storage Location in a Market List, but you can only update your Cost and Storage Location in a Warehouse. That is because Cost and Storage Location are inventory level information, tying those fields to a Warehouse. The Market List is designed to allow you to update marketplace level information.
- Creating a Product Through the User Interface
- Creating Products Using a Spreadsheet
- Using Custom Product Attributes
- Deleting Products