Custom Warehouse Management System for ACE Pyro

AcePyroNew
Project Overview

ACE Pyro required more than a traditional inventory management system. Its operations span multiple warehouses, order fulfillment, customer management, e-commerce, regulatory compliance, reporting, and data synchronization across locations. Managing these functions through disconnected applications would have created inventory inaccuracies, duplicated effort, and operational inefficiencies.

Keyideas developed a custom fireworks inventory and operations platform that unifies warehouse management, customer-facing commerce, compliance tracking, and business operations within a single ecosystem. The solution provides real-time visibility into inventory across multiple locations, including stock that is on hand, reserved, on order, in transit, held, or allocated for fulfillment.

The platform was designed to support several critical operational requirements:

  • Barcode-driven inventory management for stock imports, label generation, warehouse transfers, case breakdowns, picking, and physical inventory counts.
  • Offline warehouse operations with automatic synchronization when connectivity is restored.
  • Customer and order management covering payments, discounts, invoices, packing lists, delivery details, fulfillment workflows, and account history.
  • ATF compliance management, including license tracking, acquisitions, dispositions, DSMT reporting, and regulatory documentation.
  • Multi-location synchronization to ensure inventory and operational data remain consistent across warehouses and branches.

In addition to internal operations, the platform powers ACE Pyro’s digital commerce experience. Customers can browse products, search and filter inventory, view pricing and videos, place orders for pickup, shipping, or delivery, and access invoices, order history, and downloadable firing-software data. The system also supports both ACE Pyro and Fire Art brands while maintaining a shared operational database.

The result is a purpose-built platform that connects inventory, orders, customers, compliance records, reporting, and e-commerce operations into a single system—providing the accuracy, traceability, and operational control required for a highly regulated fireworks business.


Our Solution

Keyideas designed and developed a custom ASP.NET MVC platform that integrates warehouse operations, inventory management, e-commerce, compliance reporting, and automated business processes into a unified environment. Rather than operating separate systems for inventory, online ordering, and regulatory compliance, ACE Pyro benefits from a centralized platform where data flows seamlessly across departments and locations.

Warehouse & Inventory Management

At the core of the solution is Pyro Inventory, a desktop application used by warehouse and office teams to manage inventory, orders, customers, compliance records, and operational workflows.

Key capabilities include:

  • Real-time inventory visibility across multiple warehouses and stock statuses.Barcode-based inventory receiving, transfers, labeling, product lookup, case breakdown, and stock counting.
  • Warehouse pull management and fulfillment workflows.
  • Customer, employee, and ATF license management.
  • Order processing, payments, discounts, invoices, packing lists, and disposition tracking.
  • Offline operation with automatic synchronization upon reconnection.

Reporting & Compliance

The platform provides comprehensive operational, inventory, sales, and regulatory reporting, including:

  • DSMT reporting.
  • Acquisition and disposition tracking.
  • Inventory valuation and product-aging reports.
  • Sales, transfer, warehouse pull, and open-balance reporting.
  • ATF license management integrated throughout customer, order, and checkout workflows.

By embedding compliance directly into operational processes, ACE Pyro can maintain regulatory documentation alongside the transactions that require it.

E-Commerce & Customer Portal

The Pyro Web storefront extends operational data directly to customers through a fully integrated online commerce platform serving both ACE Pyro and Fire Art brands.

Customers can:

  • Browse, search, and filter products.
  • View pricing, product details, and videos.
  • Place orders for pickup, delivery, or shipping.
  • Manage profiles and account information.
  • Access order history, invoices, and ATF disposition documents.
  • Download firing-software data, including Finale 3D-related files.

The checkout experience supports multiple payment methods, including credit cards, PayPal, checks, cash, and wire transfers, while capturing required ATF licensing information for regulated purchases.

Automation & Multi-Location Synchronization

A suite of background services keeps inventory, websites, and operational systems aligned across locations.

Automation features include:

  • Centralized synchronization between master and branch databases.
  • Automatic website inventory updates.
  • Customer auto-hold rules based on stock availability.
  • Multi-location inventory and transaction synchronization.
  • Automatic software updates and synchronization conflict-resolution tools.

Business Impact

The completed solution delivers a connected software ecosystem that combines inventory management, warehouse operations, e-commerce, compliance tracking, reporting, and business automation. By eliminating disconnected processes and maintaining a single source of operational data, ACE Pyro gains greater inventory accuracy, improved visibility, stronger compliance controls, and a scalable foundation for continued growth.

Need a Custom Inventory, E-commerce or Operations Platform?

Have a question or need support? Our team is here to help and will get back to you within one business day.

No spam. No upselling. Just a focused discussion. We'll respond within 24 hours.