Who is the Company
The Challenge
The company’s e-commerce platform was based upon SAP Commerce Cloud integrated with Talend. Talend is a low-code platform that provides data integration, management, and extract-transfer-load (ETL) support. All company product information was stored in MariaDB.
They were experiencing problems uploading data from their product information management system (PIM) into SAP Hybris. Data uploads were scheduled to occur every 12 hours. Because the execution time took between 15 to 17 hours, the old system was causing a delay in new product introductions. More recent products appeared to be unavailable when in fact, they were available. Further, customers needed clarification as older products still showed up with the old prices and attributes.
To summarize, the company was looking for the following:
- Timely access to new products: As the current system processing time often shot past the twice-daily product uploads, new product information was unavailable, resulting in missed sales opportunities.
- An accurate view of product data: Due to time delays, the website often displayed outdated or inaccurate product information. This increased customer dissatisfaction as they would not get what they expected.
The Solution
Business Impact
- No new products are missed: Because our solution significantly reduces upload time, the company misses no new products or product information updates. Uploads occur every 12 hours, and the overall upload time has been reduced to 3 or 4 hours, which means all updates are now available as needed.
- Timely access to data: The products are made available on the company’s website much faster and are visible in just 4 hours from the product and inventory information load. This change positively impacts dropship products from external vendors. With the new system, products show up online as soon as inventory is made available.
- Fast and accurate data: Consumers on the site will see accurate data much quicker now. An added benefit is that paid media campaigns and Google feeds now accurately refer to the newer links on the website.
