Retail

Odoo Database Synchronization Solution

Aspire Softserv

Case study

About the Project

The project involved developing a bespoke system to address the client's challenges. They relied on an Odoo system, mainly the Point of Sale (POS) module, for daily sales but faced limitations when traveling to areas with no internet access. The project objectives were as follows:


Offline Odoo POS: Enable the client to run the Odoo POS module offline on their machines during sales campaigns in internet-deprived locations.


Data Synchronization: Implement a seamless data synchronization process to transfer sales, accounting, customer information, POS session details, and inventory data between offline and online systems upon returning to locations with internet connectivity.


Custom Module: Develop a specialized module to facilitate this offline and online system synchronization, as no suitable off-the-shelf solution was available in the Odoo marketplace.


To achieve these objectives, Aspire's engineers used the Odoo XML RPC API for secure data communication, created a user-friendly interface for data exchange, and ensured compatibility with both Odoo10 and Odoo11 versions.


In summary, the project's core mission was to deliver a tailored solution that allowed the client to operate their Odoo POS system offline during sales campaigns and seamlessly synchronize data with their main Odoo server upon returning to areas with internet access. This custom module provided an effective and efficient way to overcome the challenges posed by offline operations in remote locations.


Customer

Our customer is a leading IT service company dedicated to delivering comprehensive solutions to businesses of all sizes. With a strong presence in the North American market and a global reach extending to 24 other countries, they specialize in providing a wide range of IT services.

TechStack

ASPIRE SOFTSERV

Benefits delivered

No need to maintain multiple ERP instances.

Uninterrupted selling even when internet is not available.

Sync multiple instances anytime from anywhere.

Data entry time reduces to 30% with synchronzation process.

Easier accounting as only single system to look at.

Aspire Softserv
slider-odoo-db-synchronisation-02.png
Aspire Softserv
Problems

Problem Statements

Our client had an Odoo system running on their premises. They use the Point of Sale module of Odoo for their daily sale. The problem with them was when they travel for campaigning and have sales, they can’t carry servers with them. Also, they need to travel to such areas where the internet is not available. For that purpose, they wanted to have a system that:

Allows to run Odoo POS on an offline machine.

Syncing of sales and accounting data when they return back.

Along with Sales they want to sync customer info, POS sessions and inventory with the main Odoo server.

They wanted to have a custom module that sync the offline and online systems and it was not readily available in the Odoo marketplace.

portfolio-innerpage-challenges-img.webp

Both the servers have different amounts of data with different unique identifiers and different inventory. Also, each offline server shouldn’t be aware of other offline servers.

Solutions

Aspire’s Solution

Aspire understood the requirement of customers and explored the different possible business scenarios. Our engineers explored and understood Odoo’s database thoroughly and found a way to implement it after some research.

Used Odoo XML RPC API to communicate between offline and online servers

01

Provided interface to push or pull data from offline server

02

Provided solution for Odoo10 & Odoo11 versions.

03

Share Project


Reach Out Image

REACH OUT

Ready to Build Something Great ?

Experience. Expertise. Know-How
80+

Tech Experts

13+

Years Of Developing

90%

Referral Business

Phone

mail-image
mail-image
mail-image