Hi @ebefort-DDP 

Good question.

Can you help us have more context by posting screenshots with how your Zap steps are configured?

@ebefort-DDP 

Another option is to use an Airtable Automation with the Run Script step to delete records that match your conditions.

Hi, Troy! Thank you for replying to me!

I have not looked into Airtable Automations yet, so I’m not sure what script (or where) I would find one--if you have any advice on that, it would be great!

Here is what I have now:
 

Of course, I want only the line items with SKUs to be made in Airtable, but because the order itself has SKUs that exist with those customizations, it sends it all over to airtable.

@ebefort-DDP

Airtable provides example code to use in the Airtable Automation Run Script action.

// Delete a record in the Data table
let table = base.getTable("Data"); // Change this to the name or ID of your Table.
let query = await table.selectRecordsAsync({fields:  ]});

let recordId = query.recordss0].id;

await table.deleteRecordAsync(recordId);

console.log("Deleted a record!");

@ebefort-DDP 

Otherwise, you’d have to use the Looping app to iterate over each Line Item in the Shopify Order.

Within the Loop you can add a Filter step.

Hi, Troy,

Thank you so much!!!

Regarding the looping, how would I go about implementing that? For example, I think I have this portion kind of figured out:

Then I tried to add that to the record creation:

But I was confused about which options to pick here:

Or would I even need the line item support for Airtable and only have the “Create Record” option?
I tried to make this work once, but it only added a single record; then I didn’t see where to add a filter in the loop itself, so I think I’m not fully understanding. Sorry to be such a pain! Thank you so much for helping me out!!!

@ebefort-DDP 

NOTES:

• The Looping approach will run the Looping step and following steps within the Loop for each iteration (aka line item)
• The Looping approach will use more Zap Tasks than using an Airtable Automation to delete records
• The Airtable Create Record(s) option only supports a max of 10 line items

The Filter would be added as a Step between the Looping step and the Airtable step.

Make sure to fully review the help article for using the Looping app: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

You are amazing!! That’s incredibly helpful!!

One last thing regarding the Airtable automation: I had it set up like the first time with the line items and I have the script in--which part of the script tells it to delete empty SKU records? It deleted some records, but I’m not sure which ones.

Do I need to locate it with “fields” and put “SKU” somewhere?

Is this it?

Thank you so much, Troy!!!!

@ebefort-DDP 

You can try these options:

1. Try using a different Airtable Automation trigger (e.g. record matches conditions, record enters view where you configure Filter conditions)
2. Add Conditional Logic to check the conditions

I will give that a shot then as well, thank you! You have been so amazing to someone so green like me!!