Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi everyone,

I’m a beginner working for a small clothing business, and I’m trying to use Zapier to send order data from my Wix store into a Google Spreadsheet. My goal is to have all the order details, like product options and custom fields, appear in the sheet automatically.

I’ve been trying, but I can’t get Zapier to send the order data I need, and I’m completely lost on how to make it work. For example: I have an order for an item here: 

The item.


I need it to do the following: List the string of numbers and letters at the end “DM139” into the “MODEL” Column in my spreadsheet.

 

The columns.

I’d then need to have the Color, size, and any other included fields listed out in the row of the order. I’m struggling to achieve functionality for any of this.

Any advice or examples for a beginner would be greatly appreciated!

Hi ​@Tylercwork 

Help us have more info by posting screenshots showing:

  • how your Zap steps are outlined
  • how your Zap steps are configured in EDIT mode with the field mappings visible

 

Since ecommerce orders can have 1+ items per order, you can use the Looping app to iterate thru each line item data: https://zapier.com/apps/looping/integrations#help

 

If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory

Hey ​@Tylercwork,

You can use the ecommerce trigger in Wix to get the details whenever a new order is placed. See more about Wix integration here-https://zapier.com/apps/wix/integrations. You can filter this Particular trigger for Order Placed. 

 


Once you have the necessary details to map from the trigger, you can use Create Multiple Spreadsheet rows action to map that data. Here is a helpful article for mapping data in Zapier- https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

 


This is a sample flow but the exact workflow and complexity depends on your needs. You may have to use other Zapier actions like Filter, Formatter, Looping etc depending on the data. Hope it helps!

 

PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Terms & ConditionsAccessibility statement