Trying to Automate Google Sheets inventory from Ecwid store.

Hi ​@JacobB 

Review the available Zap app triggers/actions: 

• Ewcid
  • https://zapier.com/apps/ecwid/integrations#triggers-and-actions
  • https://zapier.com/apps/ecwid/integrations#help
• GSheets
  • https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
  • https://zapier.com/apps/google-sheets/integrations#help

NOTE: Some Zap actions handle line items.

Info about handling line items in Zaps: 

TIP: Try asking ChatGPT for guidance/help.

Thank you for this response! I read through each article and as they were helpful, I am still a little confused on how I could break down a package into individual items while also accounting for things like potential upgrades. I do not know if this is useful for this scenario, but I should also add that our business has a google sheet that breaks down the contents and quantities of each package. Is there a no code solution to this problem?

​@JacobB 

Some of the logic depends on how the data is returned from Ewcid.

Some of the logic depends on how you want to logic the data.

For us to have context, you would need to outlined specific examples of the expected inputs/outputs.

Screenshots of the DATA IN/OUT from the Zap steps help convey that info.

 I’ve been using the free plan and here’s what i have so far. The first step is a simple Ecwid new order trigger. Right now, I am trying to use the formatter step to read each item. However, I am having a hard time finding out how to get Zapier to read what is in the 2 person package as you can see below. Ultimately, I need each row to represent a single item tied to an order ID. Each row should includes columns for Order ID, Item Name, Quantity, and Dates. (I’m aware that I did not account for each of these columns in my last photo.) 

​@JacobB 

Post screenshots showing the DATA OUT from the Zap trigger step 1.

The Order line items should be returned as an array of items.

Some Zap app actions can handle line items.

Info about handling arrays in Zaps: 

Here’s my Step 1 DATA OUT. As you can see, it lists all of the components of each package in the description. However, I cannot find out how to split these and while also handling individual items. 

​@JacobB 

The screenshot only shows a subset of the DATA OUT from Zap step 1 so it’s unclear the true structure of the line items returned from Ewcid.

You are venturing into advanced territory for this type of logic.

Some line items will be for a single item whereas some line items will be for bundle items.

Some of the logic depends on how you want the data logged for individual items vs bundle items in the GSheet, which is still unclear to us. (Best to outline specific examples.)

Meaning you may have to iterate on the line items, then iterate on the items within a bundle.

You can try using AI by Zapier - Analyze and Return Data to help with the parsing of the bundle item data.

Help: https://zapier.com/apps/ai/integrations#help

If you can get the bundle item data structured as an array, then you can use this Zap action: GSheets - Create Multiple Rows

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

Thank you for all of your previous responses. I have been trying a new approach. Right now, I am trying to use javascript immediately after the trigger to put all of the items into a proper array, loop through the array and within that loop, filter all of the packages based on whether they have “package” in their name. I successfully put all items into an array. However I am on the loop action and I do not see the option to choose my array of items as input. I am attaching pictures of my code, output, and what I see when choosing variables to loop through.

​@JacobB 

Check the screenshots below to see how your Zap Codes step data points are available to select in the Looping step.

e.g. Items Item Name variable to map in the Looping step come from the output Code array of objects.

Help links for handling line items (aka arrays) in Zaps: 

TIP: When in doubt, test it out.

Help links for Looping: https://zapier.com/apps/looping/integrations#help