Find Jobs
Hire Freelancers

Experienced Zapier developer connector with some custom java/python API

$30-250 USD

Lezárt
Kiadva ekkor: több mint 5 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
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.
Projektazonosító: 18153179

A projektről

7 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
7 szabadúszó adott átlagosan $167 USD összegű árajánlatot erre a munkára
Felhasználó avatár
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 3 napon belül
5,0 (11 értékelés)
5,8
5,8
Felhasználó avatár
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 3 napon belül
4,4 (30 értékelés)
5,2
5,2
Felhasználó avatár
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 2 napon belül
4,8 (26 értékelés)
4,7
4,7
Felhasználó avatár
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 2 napon belül
4,5 (23 értékelés)
5,1
5,1
Felhasználó avatár
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 2 napon belül
5,0 (1 értékelés)
0,0
0,0

Az ügyfélről

UNITED STATES zászlója
Castle Rock, United States
4,9
12
Fizetési mód hitelesítve
Tagság kezdete: ápr. 4, 2010

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.