- Business
-
Setup
- Installing & Updating
-
PowerPick Connections
- How do I set up the CEU Web Services Interface module in PowerPick for use with ItemPath?
- How do I set up the PowerPick SQL server to accept remote connections via IP?
- Connecting to PowerPick
- How do I fix a 504 error saying "The connection to an upstream server timed out"?
- Why am I getting an error from Web Services saying "User must be logged in to use order management!"?
- Why am I getting an error from my MSSQL connection?
- Why is my Web Services connection failing?
- How can I check if the Web Services endpoint is working?
- How do I restart PowerPick services?
- Why is ItemPath not able to connect and write to the SQL database?
- Users & Permissions
- Integration
- Features
Connecting to PowerPick
ItemPath connects to PowerPick in two ways: with the rule engine, and directly to the MSSQL server. Pictured below is the technical overview of these connections and ports.

In order to set up these connections, here is what you'll need:
For the PowerPick connection:
- PowerPick SQL Server username, password, database name, dedicated IP address, and port number (if changed from the default port 1433).
- For ItemPath hosted in the cloud, the dedicated IP address should be a public IP accessible outside of internal networks.
- Your PowerPick SQL Server will need to be able to accept remote connections via IP. For more details on how to set this up, visit the SQL server documentation: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15

For the Web Services connection:
- If you are planning to use ItemPath to create or process orders, you will need a dedicated IP and port number for your machine running the PowerPick rule engine.
- For ItemPath hosted in the cloud, the dedicated IP address should be a public IP accessible outside of internal networks.
Once you have these items, you can add those details in ItemPath's Settings, in the "Kardex" tab, under "PowerPick" and "Web Services." (You'll see a "Test Connection" button beside each, which you can click to check if the connection details were successful.)
