CASE STUDY

Order management system for dealers and distributors

Industry

Retail

Work Done

Web Application Development,

Challenge

The client sells off-the-shelf cabinets with or without assembly and modification options. Dealers were placing offline orders manually. There wasn’t any online system where they could choose the products, select assembly or modification options, make payments, and track their order shipment that ensured a proper supply chain.

The client wanted to achieve the following objectives to have a smooth order management system for dealers and distributors:

Build an online eCommerce platform for Dealers
Online Dealer Registration
Approval or Rejection of Online Dealer Registration by Admin
Dealers should be able to Log in to the Dealer Portal to view product details, select assembly or modification options, add Shipping addresses, and make payments to place orders
Add on Assembly & Modification charges at the product level
Split Flat & Assembly/Modification orders within an order
Shipping Charges calculation based on Dealer’s shipping address
Sales Tax calculation based on Dealer’s Shipping Address
Payment method integration for Credit Card, eCheck, Dealer Credit Terms
To and from data integration with Oracle NetSuite
Email Notifications on Registration Approval/Rejection, Activation/Deactivation of a Dealer account, Order Placement, etc.

The solution

We suggested the client to develop the web-based eCommerce application using WordPress (WooCommerce).
We identified critical concerns in the existing supply chain and user journey and created a new user journey for the Dealers.
We moved the Dealer Registration from the client website to the Dealer Portal.
We researched various Tax applications and selected AvaTax for integration with Dealer Portal for Tax Calculation.
We integrated Authorize.net for receiving Credit Card and eCheck payments.
Given a provision for Dealers with Terms Credit to place orders by skipping the online payment.
We integrated Shipping Charges calculation using UPS
We facilitated warehouse operations by splitting a single order into Flat and Assembly or Modification orders.
Enabled auto calculation of order delivery date based on Flat or Assembly/Modification orders.
Admin panel for checking Dealer, Product, and Order details within WooCommerce.
Auto-sync of Dealer data and Products data from NetSuite.
Auto-sync of Order data to NetSuite.

Technologies used

Results

The client saved 50% of the effort with the proposed order management system by receiving the order over the phone or via email.
Dealers have more clarity in Product Details, Assembly/Modification options, Shipping charges, Taxes, and Final Amounts with multiple payment options before placing an order.
With the help of split order details, the client was able to process and fulfill the order in half the time compared to the past.
Dealers can place orders 3 times faster with an intuitive design than with manual orders.
The client and Dealers could track the orders more efficiently and have an improved supply chain.
WooCommerce and NetSuite integration helped the client manage the dealers and their orders efficiently.