Exporting Item Records Using the Quick Export Tool

Follow these steps to export Item records using the Quick Export Tool:

  1. In the Utilities accordion menu, select Quick Import.
  2. Select the Database Export tab at the top of the page.
  3. If you have saved any searches, select one of them by clicking Saved Searches>Items>search_name. Otherwise, click New Search >Items>search_type. The following search types are available:
    • Items
    • Items by Site
    • Item Stats by Site
    • Items by Catalog
    • Items Images
    • Items Categories
    • Items Price Points
    • Items Vendor
    • Items Association
    • Items Catalog
  4. Add a data field or Attribute to the search criteria by doing the following:
    1. Select Field or Attribute from the first drop-down list. (Attribute is only available for search types where Attributes apply.)
    2. Select a specific field or Attribute from the second drop-down list. The specific fields or Attributes available depend on the search type.
    3. Click Add to add the selected field or Attribute to the search criteria. Or, click Add All to add all fields or Attributes to the search criteria.
    4. In the Condition section, select an operator from the drop-down list and enter a term in the text field. Available operators include (see the Conditional Search Functions Table for more information):
      • None
      • =
      • <>
      • LIKE
      • NOT LIKE
      • <
      • <=
      • >
      • >=
      • IS NULL
      • IS NOT NULL
      • IN
      • NOT IN
      • BETWEEN
    5. Check the Output box to include the selected field/ Attribute in the data export. If the box isn't checked, then the field/ Attribute is still used to search but isn't included in the data. By default, this box is checked.
    6. The output data fields appear and exported in the order they appear in this list. Use the red up and down arrow icons to move a field/ Attribute up or down in the list.
    7. Repeat the selection procedure to add more fields and/ or Attributes to the search/ output.
  5. Enter a value in the Max Rows Returned field to limit the search. The default value is 25.
  6. Optionally, enter a name for the search in the Search Name field. Then click Save to save the search, in which case it becomes available in the Saved Searches menu.
  7. Click Run Search to run the search.
  8. Click Export to Excel to export the data to a CSV (comma-separated values) file. The file is saved in the folder set as the default download folder in your browser.