Trying to Automate Google Sheets inventory from Ecwid store.
Hello all,
I am trying to find a way to automatically update our Google Sheets order list when we receive an Ecwid order. Our business rents gear in both packages and individual items so I need to find a way to extract those individual items from our different packages and update our order list, logging information like quantity, rental dates, etc. However, we also need to account for updating orders when customers want to add, remove, or exchange an item.
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.)
Step 2 Formatter → Utilities → Line Item to Text Data In Step 2 Data OutStep 3 Google Sheets→ Create Spreadsheet Row Data In Step 3 Data Out
@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.
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.
CodeFirst item in the arraySecond item in the arrayNo option to loop through itemsh]
@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:
