Find Jobs
Hire Freelancers

Experienced Zapier developer connector with some custom java/python API

$30-250 USD

Closed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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

About the project

7 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $167 USD for this job
User 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 in 3 days
5.0 (11 reviews)
5.8
5.8
User 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 in 3 days
4.4 (30 reviews)
5.2
5.2
User 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 in 2 days
4.8 (26 reviews)
4.7
4.7
User 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 in 2 days
4.5 (23 reviews)
5.1
5.1
User 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 in 2 days
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
Castle Rock, United States
4.9
12
Payment method verified
Member since Apr 4, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.