Microsoft Outlook Calendar Integration

Web Connect provides a way to view Opportunities, Tasks and Sales Calls in a convenient calendar view. You can filter the view and even drag and drop events to other dates on the calendar making it simple to manage business-related events as schedules change.  You can also view that same calendar within Outlook or any other email/calendar/collaboration application that can consume iCal/ICS calendar feeds.

Having the ability to overlay your personal and business calendar events in one convenient view gives you a clear and concise display of any potential scheduling conflicts and allows you to plan upcoming events. To enable this feature, current Web Connect subscribers can go to the Calendar Settings inside Web Connect, consult the on-line Web Connect Help documentation or contact us for assistance.

Latest Web Connect Release : May 2017

Features and Enhancements for the May Release of Web Connect

Sales Process: Leads Tracking and Management
The new Leads Tracking and Management feature provides a way for sales staff to create a "potential" Prospect without possibly prematurely creating a P21 Prospect. Users can quickly add a Lead with attributes including Sales Rep, Assigned To, Next Call Date, Lead Source, Lead Type, Lead Status, Address, Contacts and Notes.  It is also possible to assign P21 Customer Classes to a Lead.  Once the Lead is qualified and deemed an actual Prospect, it can be converted into a P21 Prospect with one touch or click. Read more...

Customer “Impersonation” Accounts
Customer Impersonation makes it possible for a Sales Rep to launch Web Connect as if they were logged in as a certain Customer.  All of the information in Web Connect will be filtered for the customer – exactly like the Web Connect Customer Portal feature.  No need to worry about seeing another customer’s information.  A Sales Rep can even place an order for the customer while logged in as them.

CRM and BI

  • Web Connect Alerts
    • Administrators can now set Web Connect Alerts for user accounts without having to first impersonate the account
    • Added a user setting to enable/disable the ability to change alert settings
    • Opened up specific Alerts to the Inside Sales role
    • Added various menu options to the Manage Alerts main menu to make it easier for the user to see their options
  • Inventory and Item Details
    • Added Stockable and Sellable indicators to Item Details for the inventory by location listing
    • Added ability to auto-select a contract for a customer in Item Details if the customer is set to “Always Use Job Contract Pricing” in P21.
    • Added a per-user setting to show/hide the Quantity Details and PO info on Item details making it possible to turn these items on for Customer logins
    • Added the ability to Bookmark item detail information
    • Added a per user setting to show/hide quantity available. Most applicable to Customer logins but can be used for all roles.
  • Opportunities and Sales Calls:
    • Added ability to save a Quick-Call without selecting a contact based on the user’s settings
    • Added the Assigned To filter in the Sales Call log
    • Added Audit Trail to Opportunity Details
    • Added ability to bring in Product Group data from a Remote Order or P21 Order when creating an Opportunity
    • Added a button in Opportunity Details to create a new Sales Call
  • Orders
    • Added enhanced support for Service Orders to Order Details
    • Added a Route Filter to the Order Listing
    • Added an Order Summary popup on the Order Listing that breaks the order down by Product Group
    • Added a popup in the Contact Name on Order Details to show Contact details

Remote Ordering: VMI, Bar Code Order Entry, Quick Order Forms and Order File Import

  • Added an Item Search to the Quick-Order form. This can be used to filter items manually and can also be used to facilitate bar code scanning if the bar code contains the Item Id
  • Added ability to auto-select a contract for a customer in the Remote Order Form is the customer if set to “Always Use Job Contract Pricing” in P21.
  • Added the Customer PO field to the Manage Remote Orders page
  • Added a system setting to let the Order Date and Requested Date use the import date/time
  • Added the ability to turn the Remote Order Form on/off for each user role
  • Changed the Manage Contract Order Forms page to bring back a listing of contracts without first selecting a ship-to
  • Added the ability to select a Sales Location on the Remote Order Form and added a user setting to allow this function
  • Added a user setting for “Default Sales Location” for use with the Remote Order Form
  • Added a system setting to use the email address from the Sales Location for the “Back-Office Email Address”
  • Added Remote Order Line notes to the Remote Order Form
  • Added a filter to the Remote Order listing for Sales Managers
  • Added Extended Description to various Remote Order pages
  • Added ability to “auto-select” a contract for a customer in Item Details and the Remote Order Form if the customer is set to “Always Use Job Contract Pricing” in P21

User Interface (UI)

  • Added a Filters option on most of the listing related pages including Order History and Customer Listing that opens a filters popup to optimize screen utilization
  • Made entire rows clickable on all listings
  • Added multi-select filter integration on many listings
  • Optimized the view of Order Details on mobile devices and made the various popup/more info buttons visible on smart phones
  • Changed the format of the Mobile Views Home page
  • Made several changes to the Themes
  • Optimized the responsive layout of a number of pages
  • Changed the Account User selector to display the name as First Name | Last Name to match the sorting
  • Made the 24 Month Invoice Chart clickable to view the details from the default Home page

Other Enhancements

  • Added the ability to validate password length against a central configuration setting when changing passwords.
  • Changed the Test SMTP page to allow users to specify settings for testing purposes
  • Added Audit Trail to Customer Details
  • Added a new user setting for users in the Sales Rep role to “Enable Sales Rep Selection”. This makes it possible for reps to view items not specifically assigned to them in P21
  • Added new Administrative menu options for Test SMTP Settings, Call Log Setup and Manage Announcements. Split User management into its own section.
  • Changed the handling of special characters in the Item Details Popup used in several areas in Web Connect
  • Changed the behavior of Inventory Class 1 in the Item Class Filters settings in the Edit User page

Sales Leads Tracking and Management

Prospects and Customers in P21

Prophet 21 includes two main categories of customer accounts - "Customers" and "Prospects". For the most part P21 Customers and Prospects are really the same thing with a different status flag in the database. Prospects do have some limitations in P21 - for instance a Prospect must be converted into a Customer before an Order can be created. However it is possible to create Quotes, Opportunities and Tasks for a P21 Prospect. Because of this most P21 shops use Prospects as the primary way to store information about "potential" Customers.

While in most cases using Prospect accounts for potential Customer accounts works well, there are some drawbacks to this approach. For instance many P21 shops end up importing thousands of of leads (potential prospects) as P21 Prospects from file listings from sources such as Dun and Bradstreet or other third-party lead list providers. This can bloat the P21 database and make it more difficult to manage "real" Prospects.  There is also no straight forward way to use Prospects in P21 as a pipeline for new customers. Other common sources of bloat and clutter in P21 can occur when P21 shops engage telemarketing services to generate leads and the leads aren't properly qualified as real Prospects or when a sales rep picks up business cards from a trade show and adds them to P21 as prospects before properly qualifying them as potential future customers.

Web Connect provides a way for a user to quickly record information about an organization or individual without having to create a P21 Prospect.

Introducing Web Connect Sales Leads Tracking and Management

Probably the best way to think of a Lead is as an "unqualified prospect" or "suspect" as some like to say. Imagine the following scenario:

A sales rep notices a new business opening. At this point the rep might only know the name of the business, the city and might have an idea of what type of business it is. The rep now records the lead in Web Connect with only this information and then sets the "Next Call Date" as a reminder to call on the business in the coming days. After later calling on the Lead, the sales rep enters additional information including the full address, phone number, website address and some notes. They can also add contacts to the Lead for the owner and also the business manager.

At this point if the sales rep has permission to create P21 Prospects in Web Connect, the rep could, with one-touch/click, convert the Lead to a P21 Prospect if there is potential for business. If the rep does not have permission to create P21 Prospects the rep could contact a Sales Manager or Admin to convert the Lead.

Another use for Web Connect Leads involves importing large listings of business leads from a source such as Dun and Bradstreet. Once the Leads are imported then they can be assigned to sales reps and also inside sales reps. This can work great if your organization would like to assign inside reps to make cold calls and qualify leads as prospects.

If the P21 shop uses telemarketing as a part of their overall lead generation strategy, they can even make the telemarketing firm a user in Web Connect and add the leads directly and even assign them (as directed by the P21 shop) for follow up by certain sales reps.

A Lead can have the following attributes

  • Lead Name
  • Address 1
  • Address 2
  • City
  • State
  • Postal Code
  • Central Phone
  • Website Address
  • P21 Company
  • Sales Rep
  • Assigned To
  • Next Call Date and Time
  • Deleted/Closed
  • Lead Source
  • Lead Type
  • Lead Status
  • P21 Customer Class 1 through 5
  • 1 or more Contacts
  • 1 or more Notes

Web Connect P21 Data Explorer

The Data Explorer in Web Connect allows you the ultimate in flexibility and complete control over creating custom views of your P21 data or any other data source you may have. For each data connector you create, you can immediately visualize the results in data grids (that behave much like Excel complete with column filters, exports and expand/collapse groups and rows and other features), a variety of charts and on Google Maps. You can control which of your users or user groups can access the data using the Data Explorer Admin tools. See below for a sampling of grids, charts and Google Maps possible with the Web Connect P21 Data Explorer.

Data Grids


Google Maps


Custom Charts



P21 Shines in the Sunset State during Connect 2016

We had a great time in Phoenix this week and quickly understood why one of Arizona's nicknames is, "The Sunset State". We witnessed several beautiful sunsets while we attended the P21 Worldwide User Group conference at the Arizona Grand Resort. The folks that run the user group did a great job and worked tirelessly to put on the most well-attended event since Connect began. We enjoyed spending time with current customers, fellow sponsors, P21 users and industry consultants and meeting many new people!

We also had time to enjoy a round of golf at the resort. It is a beautiful course with great views of the mountains and skyline off the 18th tee box.

We added information about our new Data Explorer to our booth this year and gave away t-shirts with the famous Arizona Kokopelli image on it. Here's Andy and Eyual pausing for a photo during booth setup day.

Speaking of t-shirts, we ran out of certain sizes and told folks if they send an email with their mailing address and t-shirt size to, we would gladly send them a free t-shirt.

If you weren't able to attend Connect this year and would like a free t-shirt, please email us as well and we'll be happy to send you one too!
Connect2016_KokopelliThanks and see you at Connect 2017 in Orlando!




See you at the P21 WWUG Connect Conference in Phoenix!

It's hard to believe the annual P21 User Group Conference is here again!  As of last month, the attendee count was above 500. This event continues to grow and improve every year!

2016 has already been a record-breaking year for us as well with many new P21 shops now using Web Connect.

True to our mission to "Do More with P21", Web Connect has added features that both complement and extend P21.
So far this year, Web Connect has many new features that enable users to do more in a variety of areas.

  • More ways to process and manage orders with Remote Ordering/VMI features
  • More features to support the sales process including Opportunity forecasting and pipeline management, sales activity tracking and call management
  • More views of P21 data with the new Data Explorer which allows P21 shops to build their own Excel-looking grids with many Excel-like features while still being on a mobile device.The Data Explorer also includes customizable charts and a cool set of Google Mapping tools that users can customize to map, analyze, route and explore their real-time P21 data on a mobile device.
  • More options for customers of P21 shops to interact, place orders and stay informed.
  • ...and More!

Browse this blog to see details about some of the enhancements we have delivered this year and visit our YouTube channel to see some of them in action.

If you will be at the conference this year, stop by our booth for a free t-shirt,  see a live demo or talk to us about doing a free trial with your live P21 data!

We're looking forward to seeing everyone in a couple of weeks!

Opportunity Forecast

In Web Connect, you can now see your opportunities (created in either Web Connect or P21--both stored in P21) in a Forecast view. A Sales Forecast is the estimation of the value of the Sales Pipeline: the expected revenue from all the deals (Opportunities) in the pipeline over a period of time. The forecast time frame is usually a month or a quarter. Several metrics can be used for sales forecasts but the most common calculations are total pipeline value and weighted pipeline value. Total pipeline value: the sum of all opportunities for a given time period (e.g. quarter). Weighted pipeline value: multiply the value of each Opportunity by its Success Probability % and add them up for a given time period (e.g. quarter).


Opportunity Pipeline

A sales pipeline describes an approach to selling, typically based on an underlying sales process. It describes the individual steps salespeople take from initial contact with a potential customer, or prospect, to qualifying that prospect into a lead, and further validating that lead into a sales opportunity followed through the different stages until closed. All sales opportunities arranged along each of the sales steps that make up your sales process is what the sales pipeline represents. The Web Connect Opportunity Pipeline management tool lets you view and filter your pipeline and also touch/click and drag opportunity "cards" from one Stage to another and instantly see the impact on the overall value of the pipeline.


Calendar Feature

The Calendar in Web Connect is a great way to see tasks, opportunities and more, at a glance in one convenient view. Clicking or touching on items in the calendar pops up the item summary and from there another click/touch drills into a complete detail view. The data lives natively in P21 but is accessed with Web Connect's mobile-friendly interface.

Whether you or your sales reps are simply trying to keep track of import business opportunities, events and tasks or the team is looking for a way to keep management and others up-to-date, the Calendar is a great way to unite team members and keep everyone in sync.


Web Connect Latest Features

June 2016 Release


  • Enhanced the Opportunity Details screen to show the Type, Status Stage and Step description when a user selects an option from the associated dropdown lists.
  • Created a new “Opportunity Forecast” screen that charts opportunities based on either the Anticipated Close Date or Next Step Date.
  • Created a new “Opportunity Pipeline” screen that places each opportunity into groups based on the Stage Sequence.  Opportunities can easily be moved to new stages from this screen.
  • Enhanced the Opportunity Listing to display the next task due date, who the next task is assigned to and what type of task is next.
  • Added a version of the Opportunity Forecast chart to the CRM Overview screen.
  • Added an optional configuration setting that will treat older opportunities as “Dormant”.


  • Added the ability to drag and drop Opportunities, Sales Calls and Tasks on the calendar.
  • Made it possible to start a new Opportunity, Task or Sales Call from the calendar.
  • Added a variety of filters to the calendar.

Added Last Hard-Touch Date to:

  • Customer Listing/Lookup
  • Contact Listing/Lookup
  • Customer Details Screen
  • Contact Details Screen

Mobile Views:

  • Added “Create New Task” in Mobile Views
  • Added “Create New Sales Call” in Mobile Views

Sales Analysis View:

  • Added line and column totals
  • Added Ship To as a “View By” option
  • Added Ship To as a “Filter” option
  • Added Product Group Range as a “Filter” option
  • Added Month Range as a “Time Frame” option

Sales Call Log:

  • Made both Scheduled and Completed Date visible on the Call Log grid.
  • Added the ability to filter the Call Log by Product Group

Item Inquiry:

  • Added code to remember the last Stock/Nonstock selection of the user
  • Added code to remember the last Company selection of the user
  • Added a per-user permission for Customers to be able to access the Item Inquiry Screen
  • Added Item ID as a distinct search box.  This makes it possible to either search for an item specifically, use the wildcard search or combine the searches.

Remote Order Form:

  • Added a field for the Quantity Available for each line-item.  This information will update each time the form is loaded so that users can get real-time inventory availability when working with orders over a period of time. This is a per-user setting.

Improved “Time Pickers”:

  • Reworked the date/time selectors for screens such as New Task, Task Details, Sales Call, etc. so that the time selector would be more phone-friendly.

Sales Rep Contact Visibility Options:

  • Added a per-user setting for sales reps that will either restrict the contact search to contacts related to the rep by ship-to or allow the rep to search all contacts in P21.

Customer Item Inquiry:

  • Added the ability to enable then Inventory Search/Item Inquiry system for customer logins.

Remote Order Item Search:

  • Added Extended Description to the results and search when looking for an item in the various remote order screens.

Invoice History:

  • Added Down Payment Applied as a column to the Invoice History screen.


  • Added Australian date format compatibility
  • Added deployment update options for self-update and auto-update