
FCG Parfumerie sells in store and online. Their point of sale, WooCommerce shop, WhatsApp and spreadsheets were all working separately, so stock, orders and customer messages had to be kept in line by hand.
I designed and built the automation layer in Make.com that connects all of them: PHP Point of Sale, WooCommerce, WhatsApp Business API, Google Sheets, Microsoft Excel and Typeform, among others.

WhatsApp and delivery flow
WhatsApp and deliveries
Incoming WhatsApp messages are routed automatically based on what the customer needs.
Order and sale details are pulled from the point of sale, so customers get answers about their delivery without someone looking it up.
Delivery status gets updated in the POS, logged, and confirmed back to the customer by WhatsApp and in WooCommerce.
Customers who ask not to be contacted are flagged in the sheet and left out of future messages.

Stock and customer data flow
Stock and customer data
Products in stock at the point of sale are matched with WooCommerce and their stock and variations are updated in the store.
Excel reports are rebuilt automatically from POS data.
Order history per customer is pulled from the POS to update customer records.
Products are matched by item ID and brand to filter and segment clients by what they buy.
Result
The store, the point of sale and the customer channel work as one system. The team stopped copying data between tools and spends that time selling.
0 likes · 32 views · Aug 6, 2024
Make.com automations connecting FCG Parfumerie's point of sale, WooCommerce store, WhatsApp and spreadsheets: stock sync, delivery updates and customer follow-ups without manual work.