The goal was to create an application that provides a complete and easily accessible overview of all products offered on the e-shop. The platform we use is leased and did not offer all the functionalities we needed, specifically a comprehensive overview of all products that would allow bulk data management.
We proposed creating a FileMaker database that serves as a global overview of all products. It allows the use of filters and sorting of products according to selected criteria. The application monitors duplicates and ensures the correct categorization of products. Additionally, we are implementing a function for exporting products based on filtered data, which will make further processing easier—such as bulk importing of modified product data into the e-shop.
The application will also alert us about the ratio of our price compared to the supplier’s recommended price or the manufacturer’s price. Depending on the situation, the application will highlight prices that do not meet the criteria, enabling us to immediately identify and address pricing discrepancies. This way, we can spot potential errors at a glance and address them promptly.