Find Jobs
Hire Freelancers

Experienced Zapier developer connector with some custom java/python API

$30-250 USD

Avslutat
Publicerad över fem år sedan

$30-250 USD

Betalning vid leverans
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.
Project ID: 18153179

Om projektet

7 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
7 frilansar lägger i genomsnitt anbud på $167 USD för detta uppdrag
Använd avatar
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 Om 3 dagar
5,0 (11 omdömen)
5,8
5,8
Använd avatar
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 realized it anytime. I expect to complete this project with you. Thank you.
$155 USD Om 3 dagar
4,4 (30 omdömen)
5,2
5,2
Använd avatar
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, just like Shopify/Airtable App integration. Other than that I would propose a workaround which introduces an intermediate App, which will take care of separating the SKU. I have simulated a scenario similar to yours and I look forward to your response. Moosa
$111 USD Om 2 dagar
4,8 (26 omdömen)
4,7
4,7
Använd avatar
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 Om 2 dagar
4,5 (23 omdömen)
5,1
5,1
Använd avatar
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 a 'step' within Zapier, which would be my preferred method of getting this data formatted and passed on to Airtable one SKU at a time, possibly in combination with paths - which should let us multi-thread, though I'm thinking we might have to setup an FTP cache or use Zapier's built in Digest function to get the job done - will figure out the best way once I get started. Bid- I have a lot of experience with multiple platforms, however, I'm new to freelancer, and am open to negotiate. Timeline - should definitely be able get this done within a couple of days, since I don't have much on my plate right now Milestones - indicative, feel free to suggest changes Let me know if you have any questions. Thanks, Adi 10+ years of experience with Salesforce, Python, Excel and *nix systems | Worked with 5 of the Fortune 500 companies in various positions | Now embracing the nomadic lifestyle | Financially Independent (Almost!)
$200 USD Om 2 dagar
5,0 (1 omdöme)
0,0
0,0

Om kunden

Flagga för UNITED STATES
Castle Rock, United States
4,9
12
Verifierad betalningsmetod
Medlem sedan apr. 4, 2010

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.