Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
2 Відповіді
3632 Переглядів

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:

  1. They have to operate offline so that sales won't stop/slow down at the peak seasons

  2. These databases sync with each other every 30 minutes

  3. 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?

Аватар
Відмінити
Автор Найкраща відповідь

Thank you for your answer Ray!

You mentioned that another layer for conflict resolution will be necessary. Is there an actual hands-on example or tutorial that you could point to? 

Also, do you have any suggestions for handling multiple sites? As I mentioned, we have to know which invoice was created at which site. What entity should be handled in Odoo to make this distinction? A warehouse or Company would be a poor choice IMO.

Аватар
Відмінити
Найкраща відповідь

The only parts of Odoo that work offline are Point of Sale (via the browser) and Timesheets (via the mobile Apps on iOS and Android).

Odoo has worked on setting up multiple on premise systems that can synch with each other (and as long as every user has access to the server, they don't need continuous access to the internet) but this is not trivial and we recommend purchasing a backup mobile based internet connection - like almost every ATM in the world has - because this is far cheaper and allows people to bypass all of the replication issues.

Some very skilled Customers and Partners have also setup systems like this but they leverage AT LEAST PostgreSQL replication and, often, another layer to manage situations where multiple updates need to be resolved (the customer visits one site to purchase but then another site handles an update to a phone number).

You can re-write the sequencing logic to incorporate additional factors such as the user who created the invoice.

You can get pricing on phone based internet backup connections from the following company who also happens to be an Odoo Customer - https://www.ventusgns.com/ 

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
1
серп. 20
5380
4
трав. 24
12829
1
квіт. 24
3444
0
лист. 23
2085
1
вер. 23
2241