Subscription Management Software

Subscription Order Management Systems

Subscription management software system turned out to be a challenging project.  Customers may subscribe for multiple arrangements and deliveries which typically occur each Monday.  However, our system was designed to manage most any periodicity of delivery for the order fulfillment requirements.
 
Some additional features of the subscription order management software include:

• Generation of a complete delivery schedule or partial delivery schedule for subscriptions.

• Management of customer's off-days where they might be away and want their subscription deliveries held.

• Management of company holidays where subscriptions will not be delivered.

• Subscription orders status reports.

Our subscription order software database is built with the user's ease of use in mind.  Below is the order management interface illustrating a software design method which eliminates the need for popup or nested menus.

All aspects of the subscriptions, customers, orders and reports are maintain with this form.

Customer subscription orders are managed on the form shown below.  One customer may have multiple orders with differing delivery schedule.  On the right is the Delivery Schedule for this order.

It is easy for the user to change the order schedule at any point in time by simply deleting the not-yet-delivered schedule dates ad changing the interval or the start date - the system will recalculate the new order delivery schedule.

Below is the customers management form.  This customer form shows all of the detailed attributes about the customer along with all of the customer's orders.  Note in the delivery schedule area the non-delivery dates.

The database is set to automatically pick the next nearest scheduled delivery date.  The system also provide global delivery schedule exclusion dates for national holidays.

An unlimited number of reports can be added to the database simply by appending a new report description record to the reports table.  Below is the interface used to run a report.  Double clicking on a listed report will either run the report directly or call a parameters form.

All of our databases are list driven where ever possible. This feature provide unlimited flexibility for future growth.  Below is the list maintenance form: