Automated Product Import
The client is a furniture manufacturer based in California, USA, specializing in custom-made wooden furniture sourced from eco-friendly materials. Their product line includes over 1,000 variations, catering to both retail and wholesale clients.
**Project Goal**
Due to the extensive range of products, the client faces challenges with a large database, making manual updates to their website labor-intensive and time-consuming. To streamline this process, the client sought the creation of an automated data import service that enables quick data management with just a few clicks.
**Solution**
The service developed analyzes data from a CSV file, which can be uploaded through a designated import form. The AWG team established a data structure tailored to the product attributes, where each field captures specific information about a product's characteristics. As per the client’s specifications, the "Product Import" form features advanced settings for selective data updates. This allows the service to import any or a combination of the following options: all products, selected items, categories, pricing, producer details, images, brochures, and delivery information. Each product comes with various configurations, defined by multiple parameters such as 3D dimensions, wood type, color, etc. Each variation has distinct specifications and pricing, factoring in material costs and tax brackets. Once all the parameters are set and saved, a new product is automatically created.
**Result**
The client has gained a flexible and scalable data import system that reduces errors and minimizes the time and cost associated with data management. With the new service, managers can effortlessly update website content in just a few clicks. The introduction of online ordering through the website has also enhanced customer satisfaction, boosted conversion rates, and accelerated the sales process.