• Customer / Name / 顾客 / 姓名 / 名字 → Customer name
• Your H/P / Buyer Phone / 您的号码 / 买家电话 → Buyer phone
• Receiver H/P / Phone / 收花人号码 / 电话 → Recipient phone
• Pick up/ delivery date / 自取/邮寄日 / Date / 日期 → DD/MM/YYYY or YYYY-MM-DD
• Pick up/ delivery time / 自取/邮寄时间 / Time / 时间 → Time slot
• Type / 类型 → Delivery / Pick Up / 邮寄 / 自取
• Address (for delivery) / 邮寄地址 / 地址 → Delivery address
• Message card / 卡片内容 / Remarks / 备注 → Notes / card message
• MYR / 金额 / Price / Total → Item price (RM prefix OK)
• Fee / 运费 → Delivery fee
• Payment / 付款 → Payment method
• PIC / 花艺师 → Person in charge
• CS / 客服 → Customer service
Tips:
• Missing fields are fine — florist can fill later by editing
• Multiple orders: separate with a line containing only ---
• Type "Delivery", "邮寄" for delivery; "Self-pick", "Pick Up", "自取" for pickup
Delete Order?
This will permanently delete the order from Firebase and the Google Sheet.
⚙️ Settings
Deploy your .gs file as a Web App, paste the URL here. Leave blank to skip Sheet sync and use Firebase only.