Contact us

Close this search box.

Six Tips for an Efficient WMS



Six Tips for an Efficient WMS

Not quite ready to upgrade your WMS but feel like your much older version could run more efficiently? Here are six tips to help you get a more efficient WMS.

The best part? You and/or your IT team can try these on your own:

  1. Conduct database counts for how large your tables are getting, including checking row counts of tables – running the “list table row counts” command in the Server Command Operations can do this for you. As a general rule, if you have over a million rows of data in any single table you may have a problem that could be affecting system performance. For these tables, you should check your archive/purge commands to make sure they are working or consider creating a new purge or archive command.
  2. Keep your work queue clean. Use Work Queue System Operations to clear out old work. Depending on the operations, this should be done anywhere from every few days to every few weeks.
  3. Make sure your archiving and purging are working and being done. Run all the scheduled agents that purge data, etc. in trace mode to verify they are indeed working. Open some applications such as Shipment Maintenance, Order Maintenance, etc. and visually look for old data that should not be there. Note: sometimes data gets orphaned and the standard archive/purge jobs won’t remove the orphaned data.
  4. Clean up pick and replenishment queues. These queues can build up and need to be cleaned out regularly, in many cases, every few days.
  5. Remember to purge old files out of the inbound and outbound integration directories because Windows won’t handle large numbers of files in a directory very well and system performance will suffer. A good strategy is to setup folders by YYYY or YYYY-MM to move off the processed files if you have a need to retain them for a long period of time.
  6. Check to be sure your system(s) have enough disk space and your database tables have enough free space (at least 10% free).

Related Articles

It’s time to elevate.

Discover how Open Sky Group
can help you reach new heights
of supply chain efficiency.

Jeremy Hudson

Vice President of Client Services

Jeremy’s focus is on the products and services clients need to stay competitive. Open Sky Group’s mission is to deliver technology-enabled solutions that allow our customers to achieve more while having the flexibility to adapt to change. Jeremy lives the core values and mission by bringing the best experience possible to our clients. He is an essential member of implementation teams, working alongside clients, and encouraging them to use innovation and best practices instead of customizations for success.

Jason Yantiss

Vice President of Client Services

Jason provides leadership to a variety of teams focused on implementation and integration. With 27+ years of experience holding operational and technical management roles in transportation, billing, and warehousing across a vast array of industry verticals, Jason is adept at driving multiple complex projects, understanding customer needs at all levels of the operation and providing viable solutions. Jason’s resume of 150+ implementation projects include Warehouse, Labor, Transportation, Yard Management and multiple AR/AP Freight Pay and Customer Billing systems. 

Eric McPherson

Vice President of Client Services

Mac works to oversee implementation and integration projects. A former Marine officer and military police officer, he brings over 27 years of supply chain experience, including 11 years at Blue Yonder in both delivery and service sales. Mac is a dedicated, team-oriented professional with a background in business management, professional services, customer service, and supply chain technology. His specialties include sales support, supply chain execution systems, project management, fulfillment operations, distribution operations, and GSA contracts.

Shannon Caflisch

Senior Vice President of Sales and Marketing

Shannon is responsible for the strategy and management of all sales, business development, and marketing programs. With over 25 years of sales experience and 15 years focused in the supply chain space, Shannon focuses on building strong relationships with clients and partners and strives to deliver the right software solutions to help conquer supply chain challenges. Shannon believes in learning by listening to understand clients’ goals, struggles, and what is important to their business to build lasting, successful relationships.

Alan Prillaman

Senior Vice President of Client Services

As Senior VP of Client Services, Alan oversees all consulting services and account management at Open Sky Group. Possessing over 30 years of combined industry and consulting experience, Alan leverages his unique background in IT, logistics, quality management systems, manufacturing and distribution operations, and facility and strategic account management to provide clients with creative resolutions to complex challenges. His core philosophy and passion are to deliver tangible value for and establish long-term trusted partnerships with our clients.

Mike Noble

Senior Vice President of Technology

As Senior Vice President of Technology, Mike leads Open Sky Group’s Managed Services, Software Services, Infrastructure Services, and Information Technology teams bringing 35+ years of experience in Supply Chain Execution and Information Technology. Mike and his teams ensure we maintain the highest levels of customer service in a secure and reliable environment, constantly reviewing and evaluating new technologies, their appropriateness and applicability so we can safely and securely transact our own business – and help our clients accomplish the same.

Chad Kramlich


Joining Open Sky Group in 2015, Chad, served as Chief Revenue Officer for three years prior to his appointment to CEO in 2022. With over 25 years of experience delivering results for high-growth software and consulting organizations, Chad is leveraging his background in building efficient and effective implementation teams, establishing high-impact services operations, achieving revenue growth, and deepening executive-level client relations to help propel Open Sky Group into a very successful future.

Skip to content