ESP

On this page:

How to connect to ESP

Search the ESP database in commonsku

Search filters

FAQ

How to Connect ESP

Each user must have their own ESP Web license to access the ESP database from commonsku.

To connect your profile to the ESP database:

1. Click your Profile icon (top right corner of commonsku) > Settings
2. Under the My Settings tab, click ESP
3. Enter your ASI number, username, and password
4. Select your default market (USA or CAN)
5. Click Save
6. Click Done

[Back to top]

Search ESP in commonsku

commonsku's ESP integration allows you to pull products directly from the entire ESP database and add them to your commonsku forms and shops. Products will display in order of ESP's sponsored suppliers, your preferred suppliers, then products from remaining suppliers.

To search for a product from a client form (presentation, estimate, sales order, or invoice):

1. Click + Add > Product
2. Select the ESP database
3. Type a keyword or SKU number into the "Search term" field
4. Select a supplier from the "Supplier" drop-down, filter based on net pricing, or click the "Sort" drop-down to sort the results (optional)
5. Click Search
6. Filter the products (optional)
7. Select the product(s) you'd like to add to your form; the product's background will turn blue once it's added to the form

To search for a product from a shop:

1. In the Products tab, click + Add > Product
2. Select the ESP database
3. Type a keyword or SKU number into the "Search term" field, select a supplier from the "Supplier" drop-down, filter based on net pricing, or click the "Sort" drop-down to sort the results (filtering based on cost and sorting is optional)
4. Click Search
5. Filter the products (optional)
6. Select the product(s) you'd like to add to your form; the product's background will turn blue once it's added to the shop

[Back to top]

Search Filters

ESP's integration offers a variety of search and sort filters.

Click the Arrow button to select all filters, including:

• Search term
• Supplier
• Net cost
• Market (US or CAN)
• Sort
• Preferred
• Prod. Time (days)
• Min. Quantity
• Supplier State/Province
• Has Rush Service
• Full-Color Process
• Canadian Friendly
• New
• Made in USA
• Canadian Priced
• Category
• Color
• Material
• Price
• Size
• Rating
• Line name

Beyond simple keyword searches, you can perform more advanced searches by using the parameters outlined below:

EXAMPLE	FINDS PRODUCTS
ceramic mug	containing both "ceramic" and "mug" - this is the default search
"ceramic mug"	containing the exact phrase "ceramic mug"
cup OR mug	containing either "cup" or "mug" (or both)
mug -ceramic	containing "mug" but not "ceramic"
asi:33020	which are products of a supplier whose ASI # is 33020
shape: heart	which are available in the shape of a heart
theme:golf	that relate to the theme "golf"
green mug theme:golf material:ceramic	containing "green" and "mug," related to the theme "golf" and made of the material "ceramic"

Sort

Click the Sort drop-down to sort your search results by:

• Product cost: Low to High
• Product cost: High to Low
• Supplier Rating
• New Product
• Canadian Priced
• Canadian Suppliers
• Price: Low to High
• Price: High to Low
• Confirmed Product

• Preferred Rank

Preferred Suppliers

Create a "Preferred Suppliers" in ESP Web list use it as a filter in your commonsku products searches.

You'll need to:

1. Create a Preferred Suppliers list
2. Assign users
3. Add suppliers to the list
4. Apply ranking and pricing (optional)

Then, you can search your Preferred Suppliers within commonsku.

To create a Preferred Suppliers list:

1. Log into ESP Web > click your user icon in the top right-hand corner > click Preferred Supplier & Notes Admin
2. Click Create a Preferred Supplier List
3. Give the list a name
4. Click Create List

To assign users:

1. Click the 0 Users link at the top of your ESP lists
2. Use the "Search for Users in list" box to search for your team members
3. Click the + Add button beside the user you'd like to add to your list
4. Select the checkbox beside "Automatically assign this list to newly license ESP Web users" to automatically add all new ESP users to the list (optional)

To add suppliers to your list:

1. Click into the "Add Supplier" field
2. Enter the supplier's ASI number, name, or linename
3. Click the search icon
4. Click + Add next to the supplier 

Supplier Ranking and Pricing

You can assign the suppliers in your preferred supplier list a rank ranging between 1-5. 

To assign a rank to a supplier in your list:

1. In the Preferred Suppliers list, click the Rank & Price button next to the relevant supplier
2. On the left side of the pop-up, select a rank between 1-5
3. On the right side of the pop-up, enter your pricing details
4. Click Save

 

Search your ESP Preferred Suppliers within commonsku

To search your ESP Preferred Suppliers from a client form:

1. Click + Add > Product
2. Click the ESP database
3. Type a keyword or SKU number into the "Search term" field, select a supplier from the "Supplier" drop-down, filter based on net pricing, or click the "Sort" drop-down to sort the results (filtering based on cost and sorting is optional)
4. Click the Arrow to expand your search filters
5. Click the Preferred drop-down
6. Select All or a specific rank
7. Click Search
8. Select the product(s) you'd like to add to your form; the product's background will turn blue once it's added to the form

The product results will show a label indicating their rank.

To search your ESP Preferred Suppliers from a shop:

1. In the Products tab, click + Add > Product
2. Select the ESP database
3. Type a keyword or SKU number into the "Search term" field, select a supplier from the "Supplier" drop-down, filter based on net pricing, or click the "Sort" drop-down to sort the results (filtering based on cost and sorting is optional)
4. Click the Arrow to expand your search filters
5. Click the Preferred drop-down
6. Select All or a specific rank
7. Click Search
8. Select the product(s) you'd like to add to your form; the product's background will turn blue once it's added to the shop

[Back to top]

FAQ

• Why do I only see a limited amount of product results?

• Why do I see an error message when I try to enter my credentials?

• Where do the supplier's rating come from?

Why do I only see a limited amount of product results?

If you see a product source count at the top of the search page (for example, ESP (289)) but only a small number of products are actually displayed, your ESP connection may need to be reauthenticated.

ESP requires users to periodically reconnect their account by resubmitting their login credentials. When the connection expires, commonsku may be unable to retrieve the full set of product results from ESP.

How to Reconnect Your ESP Account

1. In commonsku, click your profile photo in the top-right corner.
2. Select Settings > My Settings.
3. Open the ESP section.
4. Re-enter your:
   • ASI Number
   • ESP Web Username
   • ESP Web Password
5. Click Save.

If the connection is successful, you'll see a “Saved Successfully” message in the top-right corner of the page.

If you receive the message “ESP credentials cannot be authenticated”, ESP was unable to verify the username or password entered.

To resolve this:

1. Reset your ESP password through ESP.
2. Return to Settings > My Settings > ESP in commonsku.
3. Enter your updated credentials and save again.

 

Why do I see an error message when I try to enter my credentials?

Error messages indicate that the saved credentials do not match ESP's records or that you're attempting to use the same login information as another commonsku user. Teams cannot share ESP Web logins on their commonsku profiles; each user must have their own login.

Where do the supplier's ratings come from?

The supplier ratings are pulled directly from ESP Web and based on the average rating from all ESP users.

[Back to top]