Universal Air Conditioners

As an automotive supplier, UAC needs to interchange data from customers.

• Customers require flexibility to send orders, receive invoices, get pricing and availability, and transmit catalog data in many formats.
• UAC accepts orders via email or fax or through a basic website portal (without pricing, availability, payments, shipping, or tax information).
• UAC requires centralized software to allow customers to seamlessly interact with UAC to fulfill all of their needs without requiring manual intervention (self-service).
• The centralized software should retrieve information from backend ERP systems, send/receive information from customers, and process third-party information such as APIs (payments, rating, shipping).

To handle the needs of UAC staff and customers, UAC contracted the services of Aezion, Inc.

The experts at Aezion worked intently with the UAC team to develop a plan to automate all facets of interaction between UAC and their customers.

The following projects were all completed by Aezion to the complete satisfaction of UAC staff and customers.

A public web-based online ordering system that serves as a secure portal for UAC’s customers.

• The site provides current, up-to-the-minute catalog data (vehicle-to-product mapping, product-to-competitor/OEM mapping, specification information)
• The site provides live inventory and pricing via backend connections to the ERP system
• Many custom search tools to find just what the customer needs
• Data import capabilities to process large orders
• Data export capabilities for inventory and catalog data for customers to purchase or redistribute
• Estimate shipping for sales orders based on customer settings (prepaid, 3rd party shipping, COD, etc.)
• Estimate tax based on customer settings (tax-exempt, non-taxable state, nexus)
• Process credit card payments through a payment gateway (for orders and/or account payments)
• Provide report generation for invoices and sales orders
• Apply security to control customer access, tiered access with customer administrator and user roles
• Image management

A private web-based administrative site that allowed for administering many aspects of UAC’s public online ordering system

• Several tools to manage catalog data in bulk with import/export capabilities
• Tools to manage customer data (administrators, taxes, default shipping, default locations, tax settings, security settings)
• Ordering tool to allow UAC staff to upload customer sales orders in bulk
• Labeling software settings
• UPC management
• A vast array of reporting tools
• Newsletter management tools

A tool to generate catalog data documents in industry XML format from the catalog backend data system

• The Aezion data engineering team made sure that the UAC system can read massive datasets of millions of records
• Compress data per XML standards to remove redundant information

An API to allow UAC customers to connect directly to UAC from their backend systems to push orders and receive invoices automatically

• A tool that allows many orders to be uploaded to UAC directly, all at once
• For example, the client assists the customer and their developers with interacting with the API

An API to connect our shipping solutions to our ERP system

• Tool to retrieve and update orders, assign users, and update pricing
• Send orders to the backend ERP
• Automatic generation of purchase orders for drop-ship items
• Update shipping statuses
• Email reports to customers and distribution hubs

• As a result of the hard work and dedication of the Aezion and UAC partnership, UAC has grown significantly.
• The ease of use of all of the new software developed with Aezion allowed UAC’s customers to get everything they needed without having to wait for a staff member.
• Everyone is extremely happy with the work Aezion has done, and UAC will use them for every IT project in the future.