2.9.0 - Quicker Snapshots & Dynamic Fields Support

January 9, 2023

Improved Performance for Snapshots

Some of our users have experienced delays when loading snapshots data in reports or dashboards. We've made some changes to improve performance, so loading is quick and responsive. We've also added some checks to help users identify what kinds of snapshots might slow things down, and how to adjust them to prevent this.

For example, a snapshot that updates every minute, counting thousands of rows, takes some time. Often a user will set this frequency to get a quick update, but it can slow down the entire application. Now, you have the option to disable a snapshot that isn't in use. Also, snapshots that group data by a date field (e.g. pick transactions grouped per hour) show a warning that they might also slow down the application.

Snapshot grouping warning

Extensive Testing

We've introduced a new automated testing framework that checks for stability, changes, and data integrity. That means putting out releases with confidence that you're getting a stable product.

Dynamic Fields

For users with the Database Configurator module enabled in PowerPick, we've added the use of Dynamic Fields to the API and the Data Push app.* The names of these custom fields are set in PowerPick. They're available in Orders, Order Lines, and Transactions endpoints, which means they can be mapped in Data Push integrations. Dynamic fields can also be added to reports.

*This does require the Custom Fields app in ItemPath.

New Features

  • For compatibility with PowerPick 4.20, the "countEmptyLocations" field is now available in the API for creating count orders. Setting this value to "true" will include empty locations in the count. (By default, the value is "false".) An error will be returned if used with an older version of PowerPick.
  • Users can log in to ItemPath using either their email address or their username.
  • Password reset emails have a different message if no URL path has been set in ItemPath's general settings.
  • The POST /api/orders endpoint accepts many more location attributes, including "locations", "storageUnits", "zones", "areas", "carriers", and "shelves".
  • "directionType" is not a required field when creating a new order. PowerPick will automatically set empty directionType fields to 2 ("Pick").
  • Filtering orders by priority, status and direction type accepts number or text description.
  • Object IDs can be passed in PUT calls. ItemPath will ignore the value to prevent an error.
  • Data Push testing is disabled if there are no history records found.
  • API calls to create orders will now check that PowerPick Web Services is installed.
  • Web Services settings have a checkbox to allow or disable a proxy SSL connection.
  • License status warnings include the license expiry date.
  • Variance reports now can optionally ignore capitalization when comparing materials.


  • Cleanup of old snapshot data is now broken down into smaller, more frequent cleanup jobs to prevent database locking.
  • Some data was missing in the Explorer. This has been added in, as well as search functionality for the data.
  • When first creating a snapshot, the time selector was not always showing. This would prevent the snapshot from being created but has now been resolved.
  • Snapshots for material reports weren't able to group by location count, but this is now fixed.
  • An error causing importing report templates to fail has been fixed.
  • Filtering between two dates in the API logs now works correctly.
  • A successful connection test will update the status of the connection.
  • An occasional error when setting a connection test endpoint is fixed.
  • New user forms would sometimes hang if no license was entered, but this is fixed so licenses aren't required at this stage.

2.8.6 - Running on API

October 26, 2022

Most of ItemPath's functions run on API calls, so every improvement to the API means the UI will run more smoothly. That's why we've been adding better checks for allowed values, making calls more straightforward and returning more helpful error messages. The updated API reference has a comprehensive list of endpoint attributes and their descriptions, with string limits, possible values, and defaults.

2 8 6 api reference

In the same way, for Report-builders, we've created this list of all the values available for Reports, depending on the theme. The list includes descriptions of PowerPick terms and what integer values represent. As new fields get added and this list expands, so does what you can do with custom Reports, Dashboard views, and automated Workflows.

Automatic Updates

Speaking of automated, this is the beginning of automatic software updates for opted-in users. Regular upgrades means quicker access to new features and bugfixes, starting now. Read on for what's new and improved in version 2.8.6.

New Features

  • When creating Order Lines in the API, either a material ID or a material name can be used. There are also better checks for unique order line numbers and unique serial numbers.
  • When creating Orders in the API and setting the directionType or priority, either integers or strings can be used. Those values are listed here.
  • Material reports and API calls now include a Location Count (locationCount) value, which calculates the number of locations (bins) the material is found in. This can be helpful for making free space.
  • Reports show their creation date, which is helpful for sorting.
  • On-premise SQL server connections can now use more versions of TLS/SSL certificates.
  • Testing Web Services connections generates logs, which available on the logs page and in reports. There are also better log error messages when failing to connect.
  • Data Push testing shows clearer error messages, such as if the history ID is invalid.
  • New API endpoints for handling units have been added to the ItemPath Postman collection.


  • Several report columns weren't sorting because of missing tables. This fix also fixes "orderBy" queries that weren't working in the API. Also, some report columns weren't deleting properly, but that's also resolved.
  • Resolved a potential issue where snapshots failed to run because of other snapshots running for too long.
  • Reports with Allocated Quantity values can use those values with report filters.
  • The time to load the /api/reports GET call is reduced to about 5% of what it previously was.
  • There are better checks in place for snapshot triggers, making sure the update frequencies are valid to avoid errors.
  • Stacking bar charts in the dashboard can always set unique colours for each snapshot, so you can clearly see each one in the stacks.
  • In odd cases in dashboard widgets where a snapshot's data is a null or erroring value, a "-" will show to indicate this. Before, this might have caused the dashboard to crash.

2.8.5 - Snapshot Storage & Code Clean-Up

October 5, 2022

In addition to some much-needed improvements to the Dashboard's functionality and the snapshots that appear on them, we've been cleaning up our code on the back-end to make ItemPath easier to build and maintain. Part of this cleanup has been squashing sneaky bugs that found their way into ItemPath's UI.

New Features

  • In the ItemPath API, when creating or updating an order, the priority can be set either using an integer (1-4) or a text value ("low", "medium", "high", "hot"). Note: This is also true for setting order direction types (e.g. 2 or "pick").
  • Another improvement to API error messages is a message returned if the body of the request contains escaped characters.
  • When searching for a report column to add to a report filter or snapshot grouping, you can type to search for the column.
  • For users of the Epicor app, if importing orders from a CSV files, ItemPath checks that no orders get imported twice to avoid errors.
  • In Material reports, there's a new LocationCount column that we've created to check on number of locations a material is stored.
  • In LocationContentBreakdown reports, there's a new Pick Quantity and Put Quantity columns for serial/lot numbers.
  • TLS certificates are enabled for the Web Services connection in ItemPath.


  • Searching reports and workflows would sometimes not return the right results. Now you can easily filter these lists again.
  • Updating a report filter saves correctly instead of returning an empty value.
  • Snapshots calculating a sum of column values can now be shown properly in dashboard widgets.
  • A rare case of snapshot data getting stale and not updating has been fixed. Snapshot data storage is now smarter about its self-cleaning.
  • Some compatibilities with PPG 5 have been fixed, including some database columns being renamed (for example CountEmptyLocations).

2.8.4 - Scheduled Snapshots & New Material Codes

August 30, 2022

Changes to ItemPath updates

We've got some changes coming to the way we release updates to ItemPath, moving to a more automated release cycle. This will make it easier for users to keep up with the latest improvements and allow for better testing. You can expect to hear more details in the coming weeks about how this will affect your installation based on your licenses and service level agreement.

New Features

  • Material codes (a material's alternate lookup codes) can now be updated using the /materials API endpoint. Updating a material's codes deletes previous codes and replaces them. Click here to see how in the API reference.
  • Snapshots now have a setting to generate data at a specific time of day and day of week/month, depending on the frequency.
  • Snapshot caches reset when snapshot settings are updated, so the new settings are applied immediately instead of waiting for the next scheduled trigger.
  • Loading animations have been added in several places throughout ItemPath's interface to indicate that data is being retrieved.
  • An indicator across ItemPath's header indicates whether it is a production or development environment.


  • The API call to create a new material was requiring the "isBlocked" field. This field is now optional, because PowerPick will set this to "false" by default if nothing is specified. Also, errors around setting the "materialProperty" field have been fixed.
  • Dashboard widgets can no longer reposition themselves when loaded in a different size of window.
  • New user groups weren't saving properly due to a missing field.
  • An error occurring sometimes when updating user passwords has been fixed.

2.8.3 - Dashboard Upgrades & Data Push Resends

July 19, 2022

ItemPath 101: Taking The Course

Take your knowledge of ItemPath from basic to mastery with these new courses.

1. ItemPath Basics. Get started with the core features like reports, dashboards, and workflows with simple, step-by-step guide. Follow along with the examples on your own system to get familiar with how these essential functions work and how you can use them to your best advantage.

Itempath basics course

2. ItemPath API. Discover the full range of the API tool's capability, with examples of key calls to practice and adjust to fit your uses. Take your usage of the API to the next level with these tutorials and tips to avoid common pitfalls and errors.

Itempath api course

3. ItemPath Apps (in progress). Learn how to use the additional features unlocked by your ItemPath app integrations, such as Data Push, Cycle Counts, Lights, and more.

New Features

  • The dashboard has some improvements to make it more responsive. You can expect faster load times and clearer help text.
  • Data Push integrations show transactions that failed to send and allow you to retry them.
  • Widgets in the dashboard now display a message if an invalid chart type is chosen.
  • Snapshots can now be generated at a specific set time (every day/week/month/year).


  • Settings to connect the Lights (Philips Hue) app have been updated.
  • Exported files now convert the date to the user's time zone, or the global time zone if no time zone is set.
  • Fixed errors in pie and number charts.

2.8.0 - Sharing Dashboard Views

May 10, 2022

Keeping an Eye on KPIs

By popular request, sharing dashboard views is now possible in ItemPath. You can now create dashboards to share with your team! Users can switch between their private and public views.

Keep key data top of mind with multiple colours and graph styles. Customize multiple views with unique widgets and switch between them. Toggle the "shared" setting to make the view accessible across all users—or keep it to yourself.

Dashboard sharing

This example is keeping an eye on productivity and location space, but the possibilities are virtually endless. You can use any snapshot from your reports in dashboard widgets! Get started with some popular report templates.

New Features

  • Pop-up indicates when to refresh the browser because a new version of ItemPath is available.
  • API access and refresh tokens now return their expiry date in the response.
  • Endpoints for Kits and Kit Lines are added to the API.
  • Emails sent via ItemPath now say "Sent from [your company] through ItemPath" in the email footer.
  • Exported report files are sorted by most recent first. Reports can be exported to XLSX.
  • Time formatting in API logs show a more verbose time.


  • Updating user type to application is fixed.
  • Testing a connection sometimes appeared to fail even though the connection was successful. The API logs now have clearer response messages.
  • If user time zone isn't set, defaults to the global setting rather than missing.
  • Switching between snapshots is more responsive.
  • Added the ability to create multiple orders within milliseconds, even with few user licenses, by saving sessions.
  • Order processing confirmation shows the current serial number being processed.

2.7.8 - Better Error Messages & Report Building Tools

April 14, 2022

Here's what's been updated in ItemPath in recent versions up to 2.7.8.

What's the Problem Here?

Diagnosing errors from API responses just got a whole lot easer. Now when an API call fails, you'll get a detailed error message in the response. The status code and message will give immediate feedback about your request, with a diagnosis (need to modify the data or formatting, missing a required field, a connection has been lost, etc.).

New Tools for Report Builders

Reports now support column variables. This means that in report filters, you can compare the values of two report columns by using "column: Column Name". Check out the example pictured below where we filter out materials that (after being allocated to pick orders) have a net quantity less than the reorder point for that material.

Cycle 5 2

Also, report columns can now be renamed after they're created, in case you want to add descriptions or change column names that were created by default, without deleting columns and re-adding them. And for easier report creation, you can now duplicate a report to start working from a copy instead of starting from scratch. (Don't forget, you can also import our handy pre-made report templates.)

Cycle 5 3

New Features


  • New API endpoints are added, including create, update, and delete Material Codes
  • There is a new API type -> No Auth
  • Users can add a testing URL setting to an API connection

Data Push:

  • Headers can be added to Data Push at the connection level (as well as the integration level)


  • Storage rules and bin views are now available in the explorer

Settings & Logs:

  • Users can set their own time zone in the user panel
  • Headers are hidden from log messages for security

Bug fixes

  • New passwords set in the user panel are saving properly
  • The date comparator in the report filter is now working
  • Dashboard widgets pie charts are now showing correctly
  • In API logs, pagination is fixed, and sorting and filtering can be done per user
1 2 ... 6

Subscribe to Software Release Notes