Generating reports, resolving ad hoc issue or processing transactions involved several manual cross system activities and the process was not scalable
Company's 3PL operation is managing a variety of e-commerce channels for several customers.
Customers using company as fulfillment, warehousing, RMA management , refurbish, scrap and remarking partner for their consigned products.
It was crucial to provide a 360 degree view of customer consigned assets throughout different stages of the operation.
The ecosystem consisted of 2 instances of NetSuite environment, multiple Shopify stores, eBay stores, Walmart and Target drop ship stores, and shipping carriers.
The solution to this challenge was, to create standardized business intelligence/ reporting environment for both internal and external use via designed apps.
An automated ETL data operation provides consistency and accuracy to the data pipelines.
Functionalities:
Inbound operations portal
Refurbish services portal
Inventory portal
Order Management portal
Shipment Portal
Item Master Management- MRB View
Single click access to information across multiple systems
Interactive screens
The solution had a high adoption rate
It eliminated hours of meetings and communication in addition to work that was required to gather and prepare the information for customers.
It had a great positive impact on customer experience
Using the interactive portal, customers had the ability to visually manage their projects, products and order status.