Intoduction

This package is used for order management for online shops.

Collect Order Information

This example uses Google Form to accept order. Form responses are then exported to Google Sheets¹. Data is hence extracted using Google Sheets API and transformed.

Notification and Whatsapp link

Order confirmation notifications based on provided template with emojis are created for each user. Links to Whatsapp which include pre-filed message are created.². Below is an example of template and the notification.

👉🏽FOODPIGPI 貝果訂單確認單🥯
Hello🙋🏻‍♀️多謝你支持😆🤍🤍
你訂了

{% for shop, categories in items_by_shop.items() %}
{{ shop }}
{% for category, items in categories.items() %}
{{ category }}
{% for item, quantity in items.items() %}
{{ item }} x {{ quantity }}
{% endfor %}
{% endfor %}
{% endfor %}

🏃🏽交收時間係🏃🏽
{% for delivery in delivery_options.values() %}
{{ delivery }}
{% endfor %}

👉🏻TOTAL : {{ price }}
👉🏻⭐⭐確認訂單後 麻煩必須回傳信息確認⭐⭐
👉🏻此為最後確認單⚠️
如msg內沒有列出的項目表示滿了團啦～

Other features

Multiple reports of spreadsheets are also created for order management.

Footnotes

1. View & manage form responses ↩

2. How to link to WhatsApp from a different app ↩