Key Integrations in Odoo ERP to aid Effective Management Of the Ebo Mart Website
About
The client is an eCommerce startup in the home-improvement terrain and deals in tiles, paints, and faucets. The Indian client follows a multi-seller marketplace approach to offer home improvement material to retailers, architects, and general consumers under one roof. The client approached us to manage their CRM, sales, helpdesk, inventory, purchase, accounting, PoS, employee, documents, and approval to help the client’s business function more efficiently.
Project Highlights
The client leveraged our Retail Ecommerce Solutions
to add several complex functionalities to their business and make it easy to manage their website. First, we created a system that validated users after several intricate checks. Then, our experts developed an invoice engine that helped in recording sales in Odoo ERP . We further built an option to track open invoices whose payment had to be collected from third-party logistics providers. Besides this, we created an analytics tracking system that helped the admin track the profit and loss statement of a particular product category from a specific location and sales channel.
The Challenges
- Creation of Vendor Approval ProcessThe client wanted to create an approval process wherein the ‘makers’ would update information about a vendor. This information would then go for approval to the ‘checkers’ only after which a vendor would be onboarded
- Posting a Sale in OdooSince all the products were imported from Magento to Odoo along with their vendors, deducting how much quantity of a particular product from where was a task.
- Maintaining Accounts for Payment on DeliveryRecording the invoice collections done by the third-party logistics on behalf of the company and making relevant accounting entries was a challenge.
- Access Profit and Loss Category-wiseKnowing a particular segment’s profit and loss statement say tiles were a big challenge from a specific geographical location.
Tech Stack
Odoo
PostgreSQL
Jira
Magento 2 Community
Odoo.sh
Github
OMS
Confluene
HDFC Bank-supported Payment Gateways
Result
Complex Approval System
Vendors were onboarded after complying with several requirements like GST number, Pan number, and so on. A user could create a purchase order for a vendor only when they got approved.Easier Analytics Viewing
An admin could easily view the Profit and Loss of a particular product category through a specific product channel to refine the future course of action.Precise Inventory Management
Direct API triggered to Odoo for invoice posting helped in inventory management. It meant that any mismatch found during invoice posting would display error logs.Accurate Maintenance of Accounts
Recording the amount received by the third party logistics as the amount to be received and making corresponding accounting entries helped keep the accounts clean.
