Jeweller CRM is a comprehensive web application designed to help jewelers efficiently manage customer data and generate invoices across various businesses.
The client was using Microsoft Excel before we built the app. The requirement was to make the CRM very similar to Excel. Therefore, I had to ensure the app remained familiar to Excel users while also making it more useful and easy to use.
In the app, live prices of gold, silver, and other commodities are essential for calculating product prices at the time of sale. To facilitate this, we built an Express server in Node.js that fetches or scrapes data from various websites. The client provided the specific websites to be used for obtaining these prices. One of my team members expertly handled the task of scraping these websites to gather the current prices of gold, silver, and other relevant data, ensuring our app always reflects the most accurate and up-to-date information.
After obtaining access to the required data, we needed to store it in a database as per the client's preference, which was PostgreSQL. Once the database was set up, certain parts of the data, such as the prices of metals like silver and gold, along with price comparisons from different sources, needed to be updated constantly. To ensure the app always had the most current information, all prices were set to update every three minutes.
All customer data is also stored in the database. If a customer is new, a new data row is generated for that customer. If the customer is returning, their data is auto-filled based on their phone number. For auto-filling the address, we needed to use the Royal Mail API, which was not originally designed for React. This problem was solved by using Helmet tags and meeting the existing API requirements, as requested by the client.
I have actively contributed to various open-source projects and provided assistance to others in the community. Feel free to explore my contributions.