The Solution
Our client discovered 73 Systems via a longtime 73 Systems partner, and now uses 73 Systems Integration Cloud for data transformation and B2B integration. It currently takes just 30 minutes to draft a spreadsheet and mass-update pricing, saving a considerable amount of employee time and effort.
Our client also uses Web Services to push purchase order (PO) information to an external website that allows the company to manage and manipulate the data, which it couldn’t do before. Pushing this information to the website enables Our client vendors and PO manager in China to see a real-time view of client data without requiring VPN or ERP access, which kept its security on point.
Overall, our client found that 73 Systems Integration Cloud:
- Automated manual, time-consuming internal processes
- Increased employee efficiency, saving time and money
- Increased visibility to its data with Web Services, which also improved business productivity
With internal pricing and other translation processes now a well-oiled machine, Our client can better pursue its mission to present products of quality and value to its customers.
Business Need
Our client imports and distributes disposable foodservice products, and is comprised of three branches serving different market needs. Our client is mainly plastic cutlery and other related items for the food industry, including its Veg-ware line of compostable products made from plants. Our client delivers customer cups, containers, and other items common at fairs and public events. Paper and Supply is the regional distributor of foodservice disposables, including paper towels, napkins, bathroom tissue, and paper and plastic bags.
Our Client customer portfolio includes large office supply companies, foodservice distributors, and popular fast-casual restaurants, among others. With demand for its services increasing across all three divisions, Our Client sought to automate many of its internal processes and save countless hours.
Freeing up employees from tedious data entry tasks would allow them more time to analyze data and make better decisions for the business.
IT Challenge
Specifically, Our Client was looking for a software solution to manipulate data and automate some of the cumbersome manual processes, which include updating pricing in the system. Our Client internal workflows call for constant spreadsheet-to-database updates and inserts and require XML to JSON conversion for Web Services. Using a database trigger to JSON allows real-time data transmission to an external website, which keeps website data current and enables up-to-date price lists for its vendors and partners.
Previously, users would manually update pricing for items and vendor items, and the processes would take an entire day, if not longer. Enterprise solutions manager for our client knew there had to be a better way to provide real-time pricing information critical to its business.
“I don’t need a hard disk in my computer if I can get to the server faster… carrying around these non-connected computers is byzantine by comparison.” – Steve Jobs, late chairman of Apple (1997)