Skip to main content

I am looking to create as many Zaps as needed to make sure this can happen!

Business Background: We are a YOUTH SPORTS PROGRAM with different age groups for each sport, in different locations and on different days. This zap will be duplicated across multiple sports and the different locations and age groups.

TRIGGER: When a specific SKUs are in the WooCommerce order 

ACTION: The information associated with that line item (the athlete’s name, age & jersey size) will be added to the correct spreadsheet workbook. 

ISSUE: I am having is that some parents will order 3 different children’s sport program in the same order example:

Child A: SKU = FFCV6to8011225 for Abby Hines, Age 6 & Size S

Child B: SKU = FFCV9to10011225 for Brock Hines, Age 9 & Size L

Child C: SKU = FFCV11to13011225 for Sophia Hines, Age 11 & Size M

Do I make ONE ZAP to do this or do I make individual zaps?

 

Hi @RisingStarsDL 

Here’s perhaps a better/different approach...use Airtable instead of GSheets.

Why?

Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)

Help for Airtable Views: https://support.airtable.com/docs/getting-started-with-airtable-views

Concept is to add all the data to the same Table in the Airtable Base, then create Views as needed with the desired Filter conditions.

 

Zap Steps

  1. Trigger: WooCommerce - Line Item in an Order
  2. Action: Airtable - Create Record

Reply