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

Here is my zap along with the configuration. I have a few things I’d like to achieve. As I mentioned in my first post, I am looking to have the string of letters and numbers at the end of the product name to be placed into the “MODEL” column for the order in spreadsheets. Though I can manage if it has to implement the entire name of the product. Example: Port Authority® Silk Touch™ Performance 1/4-Zip | K584 instead of just K584.

One of the issues I am facing is that I am unable to have Zapier pull the color, size, and other optional customs, like Logo design or the price of the order.

I would prefer to do this without spending hundreds of dollars on professional help, but I will do so if it comes down to it. Making this work would save this business hundreds of hours of manual data entry.

Hey ​@Tylercwork  👋 just came across this and wanted to check how you’re getting on. Were you able to find a way to extract the model number?

If not, assuming the model number always comes after the | pipe character, you could try using a Formatter (Text > Split Text) action.

For the Input field you’d select the field that contains product name. In the Separator field you’d put “| ” and set the Segment Index to be Last. It should look something like this:

That should get you the last part of the name:

Then in your Google Sheets action you’d select the output from the Formatter action in the MODEL field.

You mentioned that you’re unable to pull the other information for the product being ordered. I suspect this might be because the selected test record in the Wix trigger doesn’t have real order data. If that’s the case and it’s unable to load a new test record with real order data, you could try using a live Zap run for the test record. That might then give you access to the custom fields with that missing info. You can learn more about how to do that here: Select from previous Zap run

Hope that helps. If you run into any issues on that, or if you found a different way to solve this please do let me know - want to make sure you’re all set! 🙂