Hi folks im trying to find a solution for my eCom site. I have created a customer Collections that is getting updated with customer info and address info when a new order is done. Works fine. I need to do some magic with the products in the order. My problem is that the data i receive from the order is not in JSON or JS. can someone find a smart solution for me??
This is a return from zapper. Webhook new order. Getting info from the order that I’m storing in a new collection. The response is from the hoock that returns the order from the api. In the return from WF you have fields but also complex items, alladdresses and more the return of complex data is returned like this
EDIT
Since the return is in form view all “” are gone and I can’t use it
Using a webhook to get a new order. When it’s a new order I need to get some information that I can send to external systems. I need the products from each order to update external system.
At the same time I’m storing customer name, order number, customer email in a collection in WF
EDIT
My customer dB
I also store the item structure in WF
EDIT 2
There is no GetOrder in the Zapier interface. There is one in integromat but it’s not working
The GetOrder system, what fulfillment is that form?
Amazon? eBay?
The connection should go to them not back in WF
However, fi you want to track orders, I would recommend using Google Sheets instead. For one thing you are limited on the CMS items within Webflow where as in Google Sheets you are not.
When I say GetOrder I’m referring to get an order from WF.
As I said before, need to get the product info for a new order.
Will I have all product data in a structured way in GS that a can send to any external system automatically?
EDIT
As you might know I do like to find special solutions that’s why I have decided to store some info I WF collections. Then I can build my own stats in WF
I do know with forms you can create a structured data set in GS.
You can also use Airtable as it might pull the data for you better then GS as it is just a table like Excel where Airtable can be formatted around your data you need.
I have tested both with GS and Airtable. The data comming from WF can’t be used. Any suggestion? The WF data ia without “” abd don’t know how to solve this