Case Study
Improving the Retail Experience with James Avery
Oracle E-business Suite and APEX
The Overview
Services: Oracle APEX Development
Solutions: E-commerce solutions, EBS Extension, Oracle EBS/Oracle APEX Integration
Industry: Retail
James Avery Artisan Jewelry is a family-owned company that offers high-quality, artfully crafted jewelry in sterling silver, gold, and gemstones. James Avery designs, manufactures, markets, and sells its products, which are available in multiple locations around the United States, and nationwide through its website, JamesAvery.com.
The Challenge
Attentive engagement with its customers is one of the foundations of James Avery’s success, and it is something they are very proud of. When the organization wanted to improve customer service engagement for their Buy Online, Pickup in store process, the jeweler sought a solution.
Buy Online, Pickup in store is growing fast, and improvements needed to be made to scale to demand. Retail associates required the ability to react to these types of orders and service customers quickly. Customers also needed quick and efficient handling of their transactions.
The integration between their Point Of Sale (POS) system and their back-end Oracle E-Business Suite (EBS) system required associates to wait for packing slips printed at the rear office machine. They could then confirm item availability and finally confirm the pickup in EBS.
There is no time for going back and forth between systems in busy seasons such as Christmas, graduations, Mother’s Day, etc. To keep customer contact and keep sales moving, retail associates would manually take down client information and then enter it at the end of the day. This methodology created the risk of inventory discrepancies.
As the busy seasons were fast approaching, the solution had to be built quickly, and the jeweler’s development team needed support for a smooth rollout to all stores.
The Solution
Insum created a user-friendly and visually attractive application that retail associates now use to react quickly to Buy Online, Pick up in store orders. This application allows immediate visibility of the orders, directly confirms the availability of ordered items at the store, and most importantly, allows the associate to keep the customer engaged during the entire checkout process.
The application also includes a responsive design, giving it the flexibility to be utilized from a desktop computer, an iPad, a POS, or a mobile POS.
Approach/Technology Used
The solution required seamless integration between the jeweler’s Oracle E-business Suite system and the existing POS system for user authentication. To ensure efficient data structure, collection, and management, Insum used Oracle APEX, Oracle’s web-based rapid application development platform. Working closely with the James Avery development team and certain James Avery power users, Insum developed and delivered a slick web-based application. It includes a list of open orders, inventory confirmation, customer notification, and documentation of in-store customer pickup. The combination of these functionalities has eliminated the need for repeated trips to the back office.
Oracle APEX also contains powerful built-in reporting tools and custom reporting views which significantly accelerated development and helped reduce costs.
Deployment of the application to all locations was simply a matter of sending them a URL by email.
The Results
The new application provides a quick turnaround time for Buy Online, Pickup in store orders. Retail associates spend much less time order handling since they are using only one system. They have also become more proactive in their order preparation as confirmation of on-hand inventory is updated in real-time, and the customer is quickly advised of their order’s availability.
In short, there has been an increase in the overall efficiency of the process and an improvement in the attentive customer engagement that James Avery continually strives for.
“Implementing the Buy Online, Pickup in store portal to retail was a huge win. It allowed associates to quickly confirm order availability, provide pickup confirmation through signature capture, and reduce associate efforts as they completed multiple tasks to manage inventory.”
-Andrew Davidson, Retail Operations Initiatives Manager, James Avery
The goal was to solve our associates’ pain points they had with the Buy Online, Pickup in store process. We did this by simplifying the transactions and keeping the associates out front with our customers instead of in the back office. Creating the Portal for them allowed them to service our customers better and ensured transactions were 100% complete.
–Mike King, Senior Oracle E-Business Suite Business Analyst, James Avery
Work with Us
We appreciate your interest in learning more about Insum.
We want to learn about how we can work with you.
Do you have any questions or need more info?
Fill out this form, and a member of our
team will connect with you. Let's talk!
Some of our other case studies
Enhancing Laboratory Solutions with Oracle APEX and OCI
Learn more about how Agilab, a leader in laboratory informatics, leveraged Oracle APEX and Oracle Cloud Infrastructure (OCI) to deliver a scalable SaaS platform. Learn how innovative development, secure cloud infrastructure, and tailored solutions transformed pharmaceutical R&D operations.
Transforming Shipping Operations with Oracle APEX at Nidec Leroy-Somer
Discover how a leading manufacturer improved its shipping operations by integrating Oracle APEX with Oracle E-Business Suite, reducing processing time and increasing efficiency with a modern, real-time shipping interface.
Modernizing ERP for Construction with Oracle APEX and OCI
Discover how CGSI modernized its ERP solution, iXbat, for construction and public works using Oracle APEX and OCI. Improved scalability, security, and efficiency with rapid development and real-time analytics.
AP Automation with Oracle APEX and Document Understanding
Trailcon Leasing, a top transportation company in Canada, struggled with inefficient and error-prone manual invoice processing. Insum implemented an Oracle AI-powered solution to automate invoice parsing, reducing processing time from 30 minutes to 5 minutes. This automation improved accuracy and operational efficiency, allowing Trailcon’s finance team to focus on strategic tasks.
Banking on a Customer Application
Discover how an international banking group improved operational efficiency, reduced customer duplication errors, and enhanced data security through a custom Oracle APEX application integrated with Oracle EBS.
Creating a Supplier Portal with Oracle APEX
Learn how Insum replaced an inefficient and cumbersome Excel spreadsheet and implemented an Oracle APEX-based Supplier Portal that revolutionized data handling, increasing efficiency and accuracy for a global electronics manufacturer.
