ESP

Learn more about how to connect to and access the ESP product database from commonsku.

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 option 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 some products in brackets (e.g., ESP (289)) populating at the top of the search page but only see a limited number of products,  this just means that you will need to reconnect your ESP account. ESP requires our users to resubmit their credentials from time to time.

To fix it:

• Click in the top right-hand corner (your profile photo) on commonsku

• Click on Settings > My Settings

• Once you're there, please click on ESP and retype your ASI #, ESP WEB username and password

When you hit save, you should get a message that says "Saved Successfully" in the top right-hand corner.

If you get a message saying "ESP credentials cannot be authenticated" the password you entered is incorrect. Head here to reset your ESP password.

You can also test your ESP credentials by using them to log onto the ESP Web. Manually enter all of your login information, do not use the autofill form data. ESP's home page will identify whether or not the credentials are correct and will allow you to reset your password if needed. 

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 rating come from?

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

[Back to top]