Sambaposv5 and ERPnext Integration

Questions
,
1

##We are using Sambaposv5 POS to capture restaurant sales records. On the other hand we are using ERPNEXT to manage the accounting bit of operations. ERP next has stock module, Am wondering if there is a possibility of automating the sales tickets/receipts from sambaposv5 to be auto created in ERPNEXT for the purpose of accounting entries and stock management. This should include the mode of payment used to settle/pay the ticket
Kindly assist

What is the error message (if any)?

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:
2

Hey @njorogewanjiru,

Welcome to the community :cake:

If Sambaposv5 has a rest api that you can use or a database you can connect to it should be possible, It would be even easier if it supported webhooks but it all depends on the features that it has available.

3

Hello @Jon
Thanks for your feedback. Sambapos connects to Microsoft SQL server database, ERPNEXT Runs on mariaDB. Here is a sample of Sambapos API inetgration

4

Hey @njorogewanjiru,

That looks like it might be possible then, I don’t have any examples so it may take you a bit of work to get there but I am sure you will be able to do it.

5

Hello @Jon .
Do you have any example of an integration and sync of data from a local db to an online db?
like from MS SQL(local) to mysql(online)

6

Hey @njorogewanjiru,

I have just checked the workflows that have been created and submitted by us and other community members and I have found this one: Two way sync Pipedrive and MySQL | n8n workflow template

This one will sync MySQL and PipeDrive, In theory the database location or type shouldn’t matter as long as you can connect to it and handle any data types that might be different between the 2 but this looks to be a good starting point.

7

Hi @Jon , I will try it out and give feedback. Thanks very much

8

@njorogewanjiru We have built a POS for restaurant which is directly integrated with ERPNext