Integration with Restaurant POS (Future POS) system

Integration
15

I can do minimal on python

1 Like
16

We used FrappeCentral API, its a crude solution. We read the sql server with pyodbc and then upload via the API, items, UOMs, Groups, then Invoices. I’ll share soon, though I’d be happyto get some help

17

@adam26d oh man! that would be amazing! Regarding inventory sync; when you sync invoices, doesn’t ERPNext updates quantities by making material transfer? I guess

2 Likes
18

Good Question @eagoweb

ERPNext Indeed can do this but remember that in a restaurant your selling end products and the stock deduction should be done on the Raw Materials / Ingredients.

So to solve this we’ll need to make a BOM (Recipe) for each sales Item and then do Production-type Stock Entries or actual production then a Sales Invoice with Stock ticked, this should do all the proper posting that ERPNext needs

1 Like
19

Better to use product bundle as a BOM instead of Production BOM. This will not be applicable if you plan to have take away bom separate than dine in bom to take into consideration the packaging material stock.

Feel free to tag me if you have any more questions, we do restaurant pos but not on erp as we never got any serious restaurant client who can handle inventory control, as restaurant inventory control is the most hectic daily task only few big restaurants can handle in our region.

1 Like
20

There’s quite a long way to go but here’s a starting point. Some input would be greatly appreciated

22

Is using product bundle able to handle the waste/yield cause by processing the ingredient (meat trimming, etc)?

23

Hi Adam, I’m eager to learn about your samba-erpnext integration.
How do you handle the sync of the sales invoice? Is it real-time per transaction or bulk during eod only

When there is price discount given in samba because of various promotions, how do you record the discount program/value in erpnext? In erpnext sales invoice, is the discount given recorded per item line, or is it recorded as a lump sump (maybe in additional discount section or sales tax and charges section) thus only total $$ discount value is recorded, but the discount is not linked directly to each item line?

Many thanks in advance for your sharing

24

Hello @bobiskandar

The connector picks up the items sold and their unit selling prices, discounts or promo’s of any sort are not recognised. From this data it directly creates a paid sales invoice in ERPNext.

This is the only functionality that’s been developed for now.

The script runs independently of both ERPNext and SambaPOS, its a python script running with Windows Scheduler (SambaPOS is windows only). The interval is up to you, 5/10 minutes is recommended after the initial sync.

25

Thanks for the response
Appreciate it!

26

check GitHub - bailabs/tailpos: TailPOS an Offline First Open Source POS for ERPNext

27

There’s no indication of this working for restaurants. Why post it here?

29

Thank you @adam26d!

30

It’s free and it’s POS. Anyone can use it/contribute to it. So what’s the problem?

31

Have you used it in a real environment?

32

yes we did.

33

How can we access that script?

34

I tried to install but I didn’t know , can u explain to me how can I install samba pos and integrat it with erpnext v13 as well as on Ubuntu 18.04

35

I managed to pull and create invoices into erpnext but didn’t finish developing the app because the project was cancelled, that’s about how far this project went. Not very elegant IMO

Important Note

Modifying the SambaPOS database interferes with the SambaPOS metrik App, which is the mobile app that sambapos uses for reporting. I think they were using column numbers in their sql rather than names. But you might not need to use this app when you connect to ERPNext

2 Likes
36

hello, is this fully developed? If yes then can i use it with only restaurant based erp?