Inspiration
Reports are received on transactions made by small online merchants, but knowing the status of the sales, what products are being sold, payment fees, and how profitable a business is can be complicated and/or time-consuming.
We needed to address this issue with creating the intelligent assistant that would educate merchants on the business data without the need for in-depth financial or technical expertise.
From there, we went back to our research and development efforts to develop something new, AI-powered merchant analytics—Merchant Copilot AI—to convert transactions into business insights.
What it does
Using Merchant Copilot AI, small business owners can examine, analyze, and understand business performance with a working dashboard.
Key features include:
- Interactive Analytics Dashboard: A graphical visualization of gross sales, net revenue, estimated profit and refund rates. Product-Wise Analysis: individual product performance analysis is provided that includes product Revenue, Costs, Sales Quantity, Estimated Profit, and Profit margins. Overall Business Analysis: Provides visualisation of Business performance both daily, weekly, and monthly, with these visualisations made interactive. AI Business Assistant will enable merchants to ask a question like "Why did my sales decrease?" or "How much profit did I make this month?". Profit Calculator: Estimates profit based on product costs, PayPal fees and other expenses.
- CSV Report Upload: Enable merchants to upload transaction reports and Gain insight into business data.
- AI-Driven Analytics: Discovery of key trends, top products and opportunities.
- PayPal Sandbox Integration: Allows you to test payment related workflows in PayPal's developer environment.
How we built it
We have made Merchant Copilot AI by using a complete development approach.
Frontend:
- React.js with Vite
- Tailwind CSS Recharts for interactive data visualization.Recharts for data visualization for interaction. The icons are from Lucide, a free application.
Backend:
- Node.js
- Express.js
- REST APIs
- JWT authentication
Database:
- MongoDB for merchant data, business expenses, products, transactions.
Artificial Intelligence: The Groq API is used for the conversational AI assistant.
- The backend handles the relevant information from the merchants and feeds this information to the AI model to reach conclusions or insights of the business based on the context.
Payment Integration:
- Paypal Developer Sandbox to test with payments for integration related purposes.
The integrated application process the transaction data and analyzes it with product costs and expenses, then creates estimates on the profitability of the transactions and provides the results on graph and generates "explanations" based on Artificial Intelligence.
We encountered a number of difficulties:
- Getting transaction reports in various data formats and data structures. Association of transaction information to the product information.
- Estimating profits based on the cost of the product and payment fees and other costs.
- Using the Groq API and managing AI model configuration, and API exceptions. Creating real merchant data based AI responses instead of random numbers. Incorporate PayPal's Sandbox with the security of sensitive credentials.
- Making the presentation of complex info simple and comprehensible.
Our goals and achievements that we are proud of:
Creating an AI-powered merchant analytics dashboard was the key objective in developing the solution.The main goal in the development of the solution was to create an AI-powered merchant analytics dashboard, which fuses business analytics with conversational AI capabilities.
- Generating product specific and overall business visualisations. Creating an AI agent that enables merchants to use natural language to communicate with their business information.
- Summarizing information about a transaction, product costs, and expenses to determine “estimated profitability”. To develop a basic and user-friendly interface similar to PayPal to use for small business owners.
- Consolidating a number of business analysis capabilities in one platform.
What we learned
As a result of this project, we learned how to:
Build third-party payment integrations with PayPal Developer products.
- Review and analyze financial transactions. Create interactive dashboards and CHARTs based on data. Wrap and leverage large language models via the Groq API. Plan back-end services to deliver context for AI models.
- Process transaction and product data to compute business measures. Create a full stack application with React, Node.js, Express and MongoDB.
Another critical tip I received on AI in finance is that the insights it provides need to be based on reliable data if they are to be of value and reliable.
What are the worst instances of imposter syndrome?What are the nightmares of imposter syndrome?
We intend to enhance Merchant Copilot AI's capabilities with more features:
- Take PayPal transaction data with you: Allow merchants to easily access supported transaction data when securely integrating their PayPal Business accounts.
- Automated Business Monitoring: alert if the amount of sales or the percentage of refunds or drastic change in product performance. Arranged AI Suggestions: Make customized tips for product performance and business profitability.
- Support merchants accepting different currencies transactions. Sales Forecasting is the process of predicting or forecasting goals for future sales based on past transaction information.
- Generate downloadable business performance reports, Automated Report Generation. Further integration – with other ecommerce and payment platforms.
On a long-term basis, our vision is to provide simple, accessible and impactful advanced business analytics for all small merchants.
Merchant Copilot AI — More precise insights. Greater growth.
Built With
- ai
- css
- express.js
- groq
- javascript
- jwt
- mongodb
- node.js
- react
- recharts
- restapi
- sandbox
- tailwind
- vite