How we made a loyalty program for 300 U Palycha stores on open source iDempiere ERP / CRM

What is iDempiere?

iDempiere ERP / CRM is free and open source software. Has the functionality of Tier II ERP, CRM, SCM, POS, Promotion, Campaign management and, in principle, much more.





It is important to understand that this is not just a business application - it is a Java platform / constructor for low-code development of various database-oriented business applications with a web interface. At a time when many are trying to build a business application from scratch, it is good to remember that there are similar frameworks based on the principles of OOP, with millions of lines of tested code, an "active data dictionary" that allows you to manage entities, validation rules, windows, tables, formats and other application settings, without resorting to coding at all or using small, several lines, code injections.





It is part of the "... piere" family widely known abroad - Compiere , Adempiere , Open Bravo , Metafresh . It differs from some of them in the complete absence of a pay wall, from others in a modular (plug-in) architecture (you can change the functionality of the system on the fly by updating one or another OSGi plug-in ).





Every year on Halloween, the project community releases an updated version. Version 8.2 was released in the fall of 2020.





"The learning curve of the iDempiere ERP / CRM team was passed earlier, on previous projects. We have a project behind us at an industrial enterprise: 500 active users per day, a database of about 500 GB, 100-400 million requests to the database per day."





, -, (), (), , , , .





iDempiere PostgresSQL >=9.6 Oracle 11G/12C. HAProxy Hazelcast. write to Master & report from hot replicas, - ("" - - -) . . , .





"" , word of mouth , , open source sharing.





"300 450 . ., . , , - ."





?

300 , - POS- , , (), omnichannel. .





.





?

c Forrester, , . 60-70% . , - . 50% "" . , :





  • :





    • - , . , , , .





    • customer experience : , , , .. , , , . .





  • :









    • , - instant gratification.





, , , , .





" - BI . open source - Metabase. "





?

, , .





, . , , , , - . - , .





-

, . , , .. , , . offer engine .





, , , , , , ( ). , , .





. , !

, , " " . , 1 . , . , , , --! " ?". , Darth Vader Zaya, , . - , , , . , ""!





, . , : , , / . , ( privacy, ).





multichannel

- , offer engine





  • ( , -, , ..)





  • - ( , , )





  • ( .. "" )





( , , , - ..), , . .





,

, , . , , , . 900'000 .





, , . , , . , .





FIFO

, . , . , " " .





!

- BI . open source - Metabase. .





,

  1. 300 450 . ., . , , - .





  2. , , , POS , ( ; / ..) 99.9% 1 . POS, , , , , .





  3. - . .





  4. .





  5. 6-9 .





" iDempiere ERP/CRM retail & promotion ..."





,

  1. , -. , , .





  2. , , - API.





  3. iDempiere ERP/CRM , . : 500 , 500 , 100-400 . .





  4. iDempiere ERP/CRM retail & promotion :





    1. (, , , ) ;





    2. ( , , , .) ;





    3. ;





    4. ;





  5. iDempiere , :





    1. - GL (General ledger - ) /;





    2. ( - , 1:1 );





    3. Report Cube  Fact_Acct_Summary, ( , );





    4. HAProxy;





    5. REST web services  JSON ;





    6. Schedulers - . iDempiere, RPA , , , , . , . , β€œβ€ FIFO, , ( , , - , β€œβ€ ).





    7. Workflow engine - 2 -, , , , ( - ).





    8. β€˜Write to master database, report from hot replicas’  , , , ;





    9. , .





    10. , , , , , .. , Java , ( ), .





?

  1. 800'000 .





  2. 99.9% 300 POS, .





  3. , REST API, .





  4. , , , , , , - - ERP/CRM .





  5. POS- - , . , / / - ( , ..).





  6. Depending on the buyer's behavior scenario (only add points or add-write off), one sale accounts for up to 3 data exchange transactions. They take on average 50, 200 and 200 milliseconds, respectively.





  7. Bonuses accrued on a purchase that has just taken place are available for debiting during the next purchase no later than 1 minute.








All Articles