Enterprise software development
Project Gorilla
- Description of the business
TechLead’s client in this project is an e-commerce company from the US. The business has been doing business on Amazon for more than 5 years with many stores and has a large customer base with a number of employees up to> 50 personnel. After many years of operating on Amazon, the data is getting bigger and bigger, businesses are faced with how to manage order data, products, cost statistics and profits quickly and easily from Amazon. that offer appropriate business strategies and solutions.
- Description of the project
With this project, TechLead received a request to design a software that is an addon on Google Sheet to help collect data of customers and orders; statistics, analysis and reports on business results of businesses’ stores on Amazon. Initially the addon was built with the sole purpose of business use, but after the development process, realizing that the demand for software is increasing and the benefits of the software are too great, the client side customers have decided to develop to commercialize software aimed at businesses doing business on the Amazon e-commerce platform.
Service
Software Development
Client
America
Field
Ecommerce
Time
2019
CUSTOMER'S REQUEST
In this project, the customer wants the addon to help users collect customer data, and at the same time, synthesize and report the business status of the stalls… Some key functions from the customer’s request include :
- Data collection and statistics
Addon has the function of collecting customer data warehouse, order data, customer reviews … from Amazon to help create statistical tables and data reports.
- Proposing business strategy
Collect, analyze and compare information about competitors’ selling prices, product selling prices in different time periods, thereby proposing appropriate pricing strategies.
- Manage, statistics costs, revenue and profit
Addon helps to control, statistics and manage the costs and profits of the business.
Method
project approach
- With this project, besides analyzing requirements from customers to find a solution for the project, TechLead team must research to find a solution to collect information about customers, orders, products products in Amazon's data warehouse to combine that data into detailed statistics and reports.
- After 1 week of research and analysis, the TechLead team worked with the customer to build and define the functions available on the addon for implementation.
Difficulties during project implementation
- The biggest challenge in Gorilla's implementation was making sure the addon handled its massive data stores and returned the most accurate results to the user.
- Besides big data processing, the item of connecting and collecting data from Amazon is also one of the difficult points of the project because team members have to research and learn to get approval to collect data. data from Amazon.
Technology used
- PHP/Slimframework
- MySQL
- MongoDB
- Memcache
- Ajax/Javascript
- Google Sheet addons
- AWS
- Stripe
Benefits for businesses
- Manage detailed statistics about products and orders quickly
- Easily assess the potential level of the product to come up with a strategy to help business performance grow dramatically
- Track financial statements by month and quarter with just a few simple steps
- Inventory statistics of goods in stock, refunds, returns, comparisons make it easy to check.
Pictures of the project
Techlead