Where can I find the data collected in the custom checkout form?

[mollie]

Question:
Where can I find the data collected in the custom checkout form for Wix Stores?
Product:
Wix Stores

What are you trying to achieve:
I need to pull this data into a spreadsheet where I track orders by fulfillment date. My flower farm fulfills orders on particular dates for each florist, so this is a question we ask at checkout. I pull this info into a spreadsheet where I am tracking harvests as they come in to understand what needs to be harvested by a particular date. I want to be able to access the data on this form so that I can know the date by which the flower harvest is needed.

What have you already tried:
I have searched and the only thing I came upon was a thread that doesn’t answer the question: Event checkout Form Collection/dataset - #2 by user4434 as well as looking at the information about wix custom checkout forms: Customizing the Checkout Form | Help Center | Wix.com

When I look at the CMS for orders, I do see a entry for “Custom Field” but it only contains one data point (“Contact Person”) and doesn’t seem to have all the other custom fields in my custom checkout form.

[noahlovell]

I haven’t had a chance to try this out end-to-end, but reading through the docs, it’s possible to get this information from the orders via API - Get Order | Velo

Alternative, it may be available when exporting order data - Exporting Orders | Help Center | Wix.com - although I don’t have a site to test this on

[mollie]

I already export the data using an automation, and I don’t see the form data in that data. This API looks like it’s accessing the CMS for the order, which also doesn’t seem to contain all the data from the form. The “Custom Field” data only had part of the form information. I’m seriously scratching my head on this one where I can access the data collected in this custom form.

[user5766]

Hello,

You can find the custom checkout form data in the customField JSON field of each order. To pull it into a spreadsheet:

Easiest: Use Wix Automations → Google Sheets to map custom fields.

More control: Use Velo to extract customField and save it to a custom collection.

Advanced: Use Stores API + Google Sheets Apps Script or Zapier.

Best Regard,
angela

[mollie]

@user5766

heckout form data in the customField

Thanks so much for this detailed information! I notice that when I try to set up a Google Sheet automation, I don’t see “Custom Field” as one of the fields I can map to a column in my spreadsheet. Am I doing this wrong? There are lots of other fields - shipping information, contact infomation, etc. but I don’t see those custom fields.

[mollie]

One more thing: I do see the “Custom Field” in the CMS for the orders object, but it only contains one of the fields in my custom form. My custom form has several fields. I’m attaching images to show this. The first image is from the CMS data for order # 11630. The next photo is from the order in my dashboard which shows all the information entered. Obviously, it’s getting stored somewhere because it’s displaying on the order page. Just want to be able to get this into a spreadsheet.