Hello @lorianqw
Many thanks,
Ok, I have divided the response to your submission into several problems, which will make it easier to understand. I hope ??
First problem:
This is how placeholder customer works in ShopMagic, i.e. after the first order it saves the customer data and does not update it afterward. Placing orders for the same user with new data will not update the customer data.
If you want to have the data that was actually entered in the form, you have to use placeholders from the order group, i.e. order.billing_email should be used instead of customer.email, but…. we don’t have an order.billing_phone placeholder. ?There is only customer.phone, which will actually be the same for each order.
I have notified our developers about this feature. I have added you to the list of people interested in it and will let you know when it happens.
Second problem:
Actually, there is an error in Google Sheet add-on. When the automation is opened, the previously entered fields are hidden. The client does not have to do choose ‘add field‘ button each time, as they are in these settings stored in the database. It does not affect the performance of the call, although it can be annoying.
We apologize for the inconvenience, the problem has been reported as an error, and our technicians are trying to resolve it as soon as possible. As soon as I receive further information on this subject, I will notify you immediately.
Third problem:
The customer number data from the order is not processed in any way, so you can enter it as you would for WooCommerce: with country format, with spaces etc. Perhaps Google Sheet treats a field that starts with e.g. +48123123123 as something to calculate.
Fourth problem:
You can reach for additional fields if they are stored as meta fields in the order. Just make sure under which key it is stored in the database. e.g. {{ order.meta | key: '_club' }}
More info about this mechanism you will find in this guide
If you have any further questions, let me know.
Best regards,
