This package is used for order management for online shops.

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.

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內沒有列出的項目表示滿了團啦～

Multiple reports of spreadsheets are also created for order management.