Download PDF
AFG Distribution's Growth in Multi-channel Ecommerce with Celigo
Technology Category
- Application Infrastructure & Middleware - Data Exchange & Integration
- Application Infrastructure & Middleware - Middleware, SDKs & Libraries
Applicable Functions
- Logistics & Transportation
- Warehouse & Inventory Management
Use Cases
- Inventory Management
- Last Mile Delivery
Services
- System Integration
The Challenge
AFG Distribution, a rapidly growing wholesaler, faced significant challenges in modernizing their ECommerce order fulfillment and inventory updating processes. In 2015, they decided to move to a new ERP system and switch from Magento to the Shopify marketplace platform. They also planned to set up integrations with other marketplaces, which required an integration solution. The company had previously been using a legacy ERP system and when they moved to NetSuite, they selected Celigo as the integration solution to connect to marketplaces like Amazon, Walmart, eBay, Shopify, and their own business site. Prior to the switch, the team was burdened with numerous manual processes for inventory updating and other Ecommerce processes. They were spending between four to eight hours a day fixing website errors and reconciling inventory, which negatively impacted their customer service.
About The Customer
AFG Distribution, formerly known as All Fun Gifts, Inc, was founded in 1999 and has grown rapidly in the past few years as an “Original One Stop Alternative” wholesaler. The company carries more than 8,000 products and is constantly sourcing and adding more unique items. In 2015, the company decided to modernize their ECommerce order fulfillment and inventory updating processes. This included moving to a new ERP system, switching from Magento to the Shopify marketplace platform, and setting up integrations with other marketplaces. They selected Celigo as the integration solution to connect to various marketplaces and their own business site.
The Solution
The integration solution provided by Celigo significantly reduced the manual work that AFG Distribution had been dealing with. The automation process was easy to handle, thanks to the many flow customization options that could be managed even by staff without a specialized tech background. With Celigo, AFG Distribution was able to solve the issue of spending too much time on manual tasks, a significant advantage when handling a large volume of orders. The team still checks the system for errors daily, but the number of issues sent out to be resolved has reduced significantly since Celigo was implemented. AFG notes that it now takes them just about 10 minutes daily to go through at least seven marketplace platforms.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Hardware Retailer Uses Data Warehouse to Track Inventory
Ace tracked which products retailers ordered, when they were ordered and shipped. However, the company could not track or forecast actual sales. Data used for reporting was up to a one-week old, owing to performance and data cleansing issues. Requirement to integrate wholesale and inventory data with POS data to help drive key business decisions, improve category management, lower inventory costs and optimize pricing. Reliance on custom coding to integrate POS data was excessively resource intensive and led to major performance constraints.
Case Study
Remake Enterprise-to-production System
The client was running a legacy material flow tracking system and wanted to replace the system with a more effective one as the system was increasingly expensive to maintain and support and also was not extendable. The client's IT landscape was filled with modern applications and it was difficult to interface the material flow tracking system with modern applications.
Case Study
Expertech - Capital Tool Inventory
Costly tools used to splice fiber optic cables are an important part of Expertech’s operational and capitalized expenses, but the company did not have an automated system in place to track their tools and optimize their usage. The existing data in its tracking system was inaccurate and required manual updating, making it essential for the company to implement an efficient process to track and follow up on its capital tool inventory.