Closed

Experienced Zapier developer connector with some custom java/python API

Hello,

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.

Zapier allows for custom javascript and python to be insterted within the "Zaps" that arebuilt in their system.

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.

Skills: API, Java, Javascript, Python, Shopify

See more: decrypt file java pgp api, experienced vb6 developer modify existing vb6 project, myspace custom java, java mail api thread uml, convert simple java python, speed java python php, java meerkat api doc, custom amazon store api, java maps api drupal, muenchen java python, fxcm java trading api, performance java trading api, developer or programmer near chester sql server c# ruby java python php

About the Employer:
( 10 reviews ) Castle Rock, United States

Project ID: #18153179

8 freelancers are bidding on average $160 for this job

DevStar925

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.

$155 USD in 3 days
(6 Reviews)
4.8
kkc1985612

Hi,I have made similar project like this using python before. You will be satisfied about my working result if I have chance of completing your project. I have ability to help you using skill you required and can be More

$155 USD in 3 days
(30 Reviews)
5.1
DarkKnight2206

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.

$140 USD in 2 days
(23 Reviews)
5.1
bisaneema

Zapier Expert I have checked your overall job applications which seems to be straightforward for me to set a new trigger between Airtable and Shopify through zapier. I have a lot of experience with Zapier and do More

$250 USD in 3 days
(3 Reviews)
4.2
gr8tech

Hello there I have worked with Zapier and have created numerous zaps, some of which had tricky issues like the one you have presented here. My understanding is that using Javascript on Zapier is for creating Apps, jus More

$111 USD in 2 days
(23 Reviews)
4.5
Craveo

Hi... How are you?. I saw your description carefully and i 'm very interesting your project. I have rich experience in your proejct types, so i can do your project perfectly. If u would like to give me your pro More

$112 USD in 3 days
(0 Reviews)
0.0
Nextfifth

We are a team with young and talented professional having 3+ years of experience. -----skilled---- Python Django flask Java android html css javascript We are here to provide a satisfaction solution to your business More

$155 USD in 10 days
(0 Reviews)
0.0
adityaneural

Hi there, I have been building Zaps on Zapier since they launched and absolutely love using it! (have you checked out Paths - which lets you do conditional workflows? it's awesome) They introduced Python 2.7 as More

$200 USD in 2 days
(1 Review)
0.0