Kids n Pets: Online Wholesale Order Tracking

Client

Kids n Pets

Industry

Chemical manufacturing

Technologies

Access

Overview

Project highlights

No more faxesWholesale orders tracked in one database instead of faxes and Excel.
Orders and invoicesTrack orders and print invoices from the same system.
A clean working listShipped orders drop off the list automatically.
Configurable listsDrop-down values can be changed without new programming.

Before

The challenge

Paramount Chemical Specialties is the maker of Kids 'N' Pets, a non-toxic stain and odor remover, and many other dog and cat care products.

Paramount needed a more efficient way to track wholesale orders. Sending and receiving faxes manually and juggling orders in Excel had become too cumbersome as the business grew.

After

What we built

J Street designed and built a custom database to track orders and print invoices, replacing the manual, error-prone process with a streamlined ordering system.

The easy-to-use design lets users quickly search and sort to find the orders they want to work with, then drill down for details. Once an order ships, it automatically drops off the list, so historical records don't get in the way of the workflow.

Every drop-down list in the system is configurable using our standard Customize panel technique, so Paramount can change the values across the system without any further programming from us.

Beyond the ordering system, we've helped Paramount with technology upgrades, on-site support, and their move to Office 365 and SharePoint.

Inside the system

A closer look

Finding and working orders

Our easy-to-use design allows the user to quickly search and sort to find the orders they want to work with, and drill down for more details. Once an order is shipped, it is automatically dropped from the list, so that the historical records don't hinder the workflow.

Configurable drop-down lists

All drop-down lists in the system are fully configurable using our standard Customize panel technique. Our customers are often surprised when they find that they can configure the various dropdown values across their system, without needing any further programming from us. It takes a bit more effort to make everything configurable, but it's worth it. Our systems work perfectly for our customers for many years without needing programming updates.

“

Just wanted to say thank you for all your assistance in getting us set up with Office 365. I'm so glad we made the switch and we all really appreciate your assistance and hand holding through the set up. We are especially thankful that you made yourself readily available throughout the process as it seemed to make the conversion go very smoothly.

John Latta

Paramount Chemical Specialties, Inc.

The outcome

How it turned out

A streamlined ordering system replaced a manual, error-prone process.
Users find and work orders quickly, with history out of the way.
Drop-down values can be changed without programming updates.
An ongoing relationship that has included technology upgrades, on-site support, and a move to Office 365 and SharePoint.

See more of our work for chemical manufacturers.