Zocalo now works with commercetools! Read more about the integration that expands commercetools' capabilities and accelerates deployment on a leading commerce platform. Learn More
Industry
Non-profit Organization
Location
Albany, NY
Tags
Strategy
Order Integration
Digital Commerce
Adobe Commerce
AWS
Key Impact
Avatria developed a process to convert orders created in SPS Commerce into Adobe Commerce, saving their customer service team hundreds of hours each week.
2,500+
Orders Automated
THE CHALLENGE
Simplify a manual order conversion process between disparate eCommerce systems.
A subset of orders within the NYSID ecosystem originate within an eCommerce system called SPS Commerce. NYSID’s order fulfillment process requires all orders to be present within Adobe Commerce, resulting in a manual process of converting these SPS Commerce orders into Adobe Commerce through the admin panel.
The manual process was a daily task for the NYSID customer service team, taking hours of multiple team members each day to perform this task, while also introducing the possibility of order conversion errors due to the nature of manual order creation.
PROJECT DETAILS
To meet NYSID’s needs, Avatria worked with NYSID to understand the following:
- Capabilities of order exports / API availability within SPS Commerce
- Appropriate field / attribute conversion from an SPS Commerce order to an Adobe Commerce order
- Find the best way to automate the order conversion process for the NYSID team.
- Minimize additional costs for NYSID.
Given the SPS Commerce contract limited order visibility to their admin dashboard & a bulk order CSV export, with an inability to expand that contract for API access, the project was to work in these confines to build a workflow with as much automation as possible.
Our Role
Avatria took full ownership of this initiative, delivering technical and strategic expertise:
- Facilitated Knowledge Transfer Meetings: Met with the NYSID & SPS Commerce staff for understanding the underlying order fields across the various eCommerce platforms.
- AWS S3 & AWS Lambda Development: Created a process for NYSID to drop a daily order export file to be converted into a series of Adobe Commerce order objects.
- Testing and Validation: Facilitated tests of this AWS flow through the Adobe Commerce staging environment, as well as robust error handling & logging.
- Process Documentation: Provided the NYSID team a detailed document for steps for facilitating this flow & comprehensive details about the AWS configuration.
RESULTS
A significantly easier & faster process to convert orders between systems
Before our solution was in place, a team of customer service representatives were spending up to 4 hours a day entering orders manually between systems. Our solution minimized the effort to less than 15 minutes per day for a single customer service rep for NYSID. With detailed documentation and robust logging & error handling scenarios, Avatria enabled NYSID staff to fix any data errors and re-run any failed orders with ease.
This diagram shows the full process from receiving a file from SPS Commerce and converting it to the format Adobe Commerce requires for a given order.
Have questions or want to chat?
