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.
- 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.
- 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.
Clients such as this one also signed on for ongoing concierge services with Avatria, an affordable, flexible solution for website and technology management. With a fractional team of digital experts dedicated to your business, we provide ongoing support to manage your backlog, implement new features, author content, and ensure your website continues to evolve alongside your goals. It’s a cost-effective way to keep your digital presence running smoothly without the overhead of a fully staffed in-house team. Our concierge clients enjoy peace of mind knowing they have a reliable, experienced partner to handle day-to-day digital needs and long-term enhancements.