Order Management Database Template
Order Processing System at Sportswear & Wearable Art Company
Mildly Wild uses our order processing software to route orders for custom designs on a variety
of clothing including hats, tee shirts, and sweat shirts. Developers at Blue Claw Database Design were
contacted to create a sales order processing database to replace an
aging spreadsheet order management system which was becoming unmanageable due to recent growth
in business.
The most challenging aspect of the order processing
database involved creating the ability to easily split apart customer order
components and quickly re-compositing them into supplier orders for the t-shirts
and component.
The specific deliverables for the order processing template where as follows:
-
Very user friendly, simple interface
-
Real time entry and management of customer orders
-
Generation of customer quote reports
-
Customer support quick response
-
Dynamic inclusion of graphics design on reports
-
Generate distributor orders from line items of customer
orders
-
Create packing slips for order shipments
-
Ability to expand product mix and handle increase in order
flow over time
All of these functions were created with an very user
friendly efficient interface in a tabbed layout. This interface is
the most efficient from a user's point of view.
Here is the Welcome screen of the order processing software
demonstrating a
polished look and feel:
The entire customer order is enterable and viewable on the Orders screen. This
includes multiple continuous dependent forms for maximum view ability of
data.
Additional order details:
Style
Item Cost
Design Code
Color
Screen Preparation Fee
Ink Match Fee
The orders processing database screen:
An important part of the order process is creation of distributor purchase
orders based on line items from each customer
order.
At the end of the day the user is able to pick and choose between different
order line items to generate a distributor order since only some distributors
offer specific items and rarely only specific sizes:
Below is a sample of a Customer Order Control report including alternate line shading of detail lines and dynamic inclusion of
artwork images.
Our customer order reports include several important features: Pivoting of order size records into column header; the
classic alternating line colors; and dynamic insertion of graphics associated with each order (note the bowling team logo at bottom
of report). The complex customer order reports can be programmed in a couple of hours by our software design team.
