I know a potential customer who has 9 sites. These sites do wholesale commerce, warehousing, some even do retail.
They already have a really old desktop-based application that has its limitations.
The current setup for these sites are:
They have to operate offline so that sales won't stop/slow down at the peak seasons
These databases sync with each other every 30 minutes
To avoid collisions of invoice sequences, every site uses a custom prefix for their invoice and they have their own sequences (E.g.: Site1 has S1/2020/0001 and Site 2 has S2/2020/0001)
My question is:
How do you handle multiple sites? They have to know somehow that they made a sale at site 7.
Is it possible to have multiple invoice sequence numbers that are used based on who creates the invoice?
I know the technical aspects of database syncing but id collisions will happen, multiple invoices will have the same sequence nr., etc.. Is on-premise community Odoo capable of syncing multiple sites?