Normalizing supplier product data for Shopify using Zapier

Hi ​@rscof 

Yes, you can likely use Zapier Tables for your scenario, but will depend more about your specific workflow requirements. (trigger + action + step details)

Help links about Zapier Tables:

• https://help.zapier.com/hc/en-us/categories/13398036609933-Tables
• Zap App: Zapier Tables
  • Triggers/Actions: https://zapier.com/apps/zapier-tables/integrations#triggers-and-actions
  • Help: https://zapier.com/apps/zapier-tables/integrations#help

Hey Troy,

I appreciate the quick response. I think my workflow would have one work table table per supplier which would store the raw CSV data from suppliers. The workflows would transform each field from the work tables to normalize the data like, Change the size value from L to LRG, concatenate the SKU from oprion values, plus some default values for metafields in Shopify and this trigger an action to load a single master table from the work tables. Once the data is normalized in the master table, a single push button action would send filtered data from the master table to Shopify. Just not sure where to start, guess I’ll bone up on the tutorials...ideas?

Thanks, Rick

​@rscof 

You’ll need Zaps structured like this...

Zap 1.A: per Supplier

1. Trigger: GDrive - New File in Folder
2. Action: Filter
   1. Check files match conditions
      1. e.g. File Type = CSV
   2. https://zapier.com/apps/filter/integrations#help
3. Action: Formatter / Code
   1. Formatter: https://zapier.com/apps/formatter/integrations#help
   2. Code: https://zapier.com/apps/code/integrations#help
4. Action: Zapier Tables - Create Record

Zap 2: MAIN

1. Trigger: Zapier Tables - Updated Record / Trigger Zap Button Clicked
   1. e.g. fields updated such as a checkbox or a dropdown
   2. e.g. Button Clicked
2. Action: Delay After Queue
   1. https://zapier.com/apps/delay/integrations#help
3. Action: Shopify - Find/Create Product
4. Action: Shopify - Create Product Variant

NOTE: You may need additional steps in each Zap.