I use Zapier to connect the APIs of AirTable ([login to view URL]) and Shopify. I have successfully configured zapier to allow me to add a new product/inventory item to my inventory database in Airtable, and then Zapier automatically pulls that data and creates and publishes a new product in my Shopify store. This connector works great.
I need a new connector; When I get an order in shopify, I need this to trigger an Update Record event in Airtable where zapier takes the Order Number from Shopify and adds teh order number to a cell in Airtable for the product that was sold. Currently Zapier supports this connector and I can get it to work, but only if the customer order has 1 line item and 1 sku. Zapier supports multiple line items for Shopify, but not multiple line item updates for Airtable.
For example, if my customer buys product SKU 11293641-3334 and places an order in Shopify, shopify creates order #1001. The API sends that order number and SKU to Zapier and Zapier will search Airtable for that SKU and update the sale in Airtable successfully and place 1001 in the cell and column associated with that SKU. Please see attached example that illustrates the end result in Airtable, [login to view URL]
Theproblem is, if a customer buys more than 1 Item (more than 1 SKU), theshopify sends out the SKU for all of the line items purchased in a comma separated format. This then gets passed on to Airtable and Airtable does not find a record as it searches SKU for the entire string instead of each individual SKU. This is because Airtable does not support line items in Zapier. For example. If a customer places an order and buys buys SKU 29034150-3334 and 28789873-3334 and 11293640-3334, Shopify sends the string "29034150-334,28789873-3334,11293640-3334". Zapier then searches Airtable for the SKU 29034150-334,28789873-3334,11293640-3334 which does not find any results, therefor it does not add the order number 1002 to anything and fails.
What we need to happen, is that when Shopify sends the order number 1002 with the string 29034150-334,28789873-3334,11293640-3334, Zapier breaks out each SKU from the String, goes in and finds the SKU in artable, and adds the order number to each SKU in the database, as illustrated in attachment Order-3-Item.png.
I need someone who has experience working in Zapier to help me achieve my desired result. I understand this is not a very hard project and should be pretty quick for an experienced developer. Please bid accordingly. I will put money into escrow prior to starting the project and will promptly release payment once I have verified that this works as desired using sample sales data.
Please let me know if you have any questions prior to bidding.
8 freelancers are bidding on average $160 for this job
How are you? I read your description. I am C++/C#/Java/Python programming Expert. I can finish your project quickly with best quality. I want to discuss more on chat. Thank you for your time.
Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.