Testing Your Data Pull Integrations

Data Pull Testing Suggestions (From Your Business System to Power Pick)

Data Pull involves retrieving master data from your Core Business Application (ERP, WMS, etc) and synchronizing it with Power Pick. Once your integrations have been configured, it's important to conduct testing to ensure various scenarios have the intended results in each system.

This article provides a starting point for developing your Data Pull testing plan. While your specific Business System configuration will dictate the final test cases, these suggestions cover common scenarios for validating successful data exchange.

Materials / Item Data Synchronization

Test Case	Test Scenario	Power Pick Check
New Material Creation	A new, unique item is created in the Business System and designated to a Power Pick-managed location (e.g., a VLM).	Verify the new Material/Item record is created in Power Pick with the correct mapped details.
Existing Material Modification	A key attribute (e.g., Description, Material Property, Material Family) for an existing item is changed in the Business System.	Verify Power Pick updates the existing Material/Item record to reflect the modified details from the Business System.
Material Deletion	A material with zero quantity in all locations is deleted in the Business System.	Verify Power Pick removes the Material/Item record or sets its status to inactive, depending on system configuration.

Order Creation (Pick, Put, and Count)

Test Case	Test Scenario	Power Pick Check
Pick Order Creation	A new Pick Order is created in the Business System with a line item for an existing Power Pick material.	Verify Power Pick creates a corresponding Pick Order with the correct Material and Requested Quantity.
Pick Order Line Addition	A new Order Line item is added to an existing, unprocessed Pick Order in the Business System.	Verify the existing Pick Order is updated to include the new Material and Requested Quantity.
Pick Order Quantity Increase	The requested quantity of an existing Order Line is increased in the Business System on an unprocessed Pick Order.	Verify the Pick Order in Power Pick reflects the increased requested quantity on the corresponding line item.
Put Order Creation	A new Put Order is created in the Business System with a line item for an existing Power Pick material.	Verify Power Pick creates a corresponding Put Order with the correct Material and Quantity.
Count Order Creation	A new Count Order (Cycle Count request) is created in the Business System for a specific location or material.	Verify Power Pick creates a corresponding Count Order with the correct Material or Location to be counted.
Multiple Orders at Once (Stress Test)	A large batch of orders (Pick, Put, and/or Count) are sent from the Business System within a short timeframe.	Verify all orders are successfully created in Power Pick without data loss or duplicate records.

Verify Mappings

Incorrect mappings are the number one cause of integration failure.

Field Mapping Check: For a test transaction, verify that all critical fields (Material Name, Location Name, Order Number) are correctly mapped and transferring between the two systems via ItemPath.
Transformation Logic Check: If ItemPath is used to transform data (e.g., converting a Power Pick location code to a Business System location code), verify the logic executes as programmed.

Review Logs

Reviewing logs is the fastest way to confirm success and troubleshoot errors. After every test scenario, check the logs for both successful transactions (to establish a baseline) and intentionally failed transactions. Learn more about ItemPath Logs here.

ItemPath Logs: Check the logs to confirm the data was successfully pulled from the Business System and successfully sent to the Power Pick database. Look for a Success message indicating the Power Pick record was created or updated.
Power Pick Logs/Database: Verify within Power Pick's native logging or by viewing the Power Pick database that the new/updated record exists and is identical to the Business System source data.

See when a Data Pull integration has run and what was returned using the Integration Tasks.

Failed Records

Verify that the source data (Material/Order) meets the criteria and filters defined in the integration.
Review ItemPath logs for connection errors.
Correct the data in the Business System and wait for Data Pull to pick it up, or do a manual run.

Resources

To learn more about ItemPath and see it in action, please book a demo with our sales team. In the meantime, here are some of our popular articles and key topics.

Book a Sales Demo

Data Pull

Mappings and Confirmations for Data Pull

Data Pull creates and runs integrations that transfer data from external services (such as your enterprise resource planning system) to Power Pick. To successfully populate Power Pick with data, you ...

Data Pull

Manual Runs

Manual RunsYou can manually run an integration task using ItemPath, which can be helpful for creating records as needed. To do this, you will need the JSON data that would ...