API Installation into Shopify

Hire a Pro
1

I need help building a Make.com scenario to automate product syncing from an API into my Shopify store.

Source: API (returns thousands of products in JSON).
Target: Shopify (I already have a private/development app set up with API access).

Requirements

Pull product data via HTTP request from API.

Parse JSON response and iterate through products.

For each product:

Check if it exists in Shopify by SKU (variant SKU → product ID).

If product exists: Update it only if fields (e.g., Title, Description, Media, Options, Tags) have changed.

If product does not exist: Create a new product in Shopify.

Error handling & logging:

Skip or flag products if more than one SKU match is found.

Create a log (Google Sheet or Data Store) showing action taken (Created, Updated, Skipped).

Performance considerations: The feed includes thousands of products, so the scenario must handle bulk efficiently and avoid unnecessary API calls/overwrites.

What I Already Have

Shopify app & credentials set up.

API documentation from supplier.

A basic scenario in Make that pulls data, parses JSON, and attempts to create/update, but I am running into issues with:

Mapping product options/values correctly for Shopify.

Safely matching by SKU without overwriting unrelated products.

Ensuring updates only change the right fields.

Goal

A robust, production-ready Make.com scenario that:

Runs on a schedule (e.g., daily).

Syncs from Supplier API → Shopify safely.

Prevents duplicates and accidental overwrites.

1 Like
3

My team and I have worked a lot with Shopify scenarios and tons of Google Sheet feeds (in bulk). Happy to help get this built and production ready.

We are Make Gold Partners.

Feel free to check my profile to book a call or email me.

Thanks,

Jeff

4

Hello @Kirsty_Eds , welcome to make.com community i will love to collaborate with you on this you can schedule a call Here and you can checkout my upwork profile Here

7

Hi @Jeffrey_Arnold, I’m an automation expert with 8+ years of experience, and I’ve built multiple large-scale product sync scenarios in Make.com for Shopify. I can help you set up a robust workflow that safely matches by SKU, updates only changed fields, and logs all actions without duplicates or overwrites.

You can check out my profile here:(https://www.upwork.com/freelancers/farhana401)
Or directly book a call here(https://calendly.com/automaxion-meet)

8

Kirsty, we can help. Let’s meet on Zoom to go over the details. Book a time of us here https://connex.digital/book/make

Talk soon!

9

Hi @Kirsty_Eds! I would love to help you with your Shopify scenario.

We are a small team of make.com experts and have developed plenty of complex integrations. This project should not be a challenge to us.

If you are interested we would love to help you, you can schedule a call in here: 30 Min Meeting | Felipe Saucedo | Cal.com or check our website www.aspirity.com

10

You’re close — the safe way is to make SKU the single source of truth and only push updates when something actually changed.

What I usually do in Make:

  • Lookup by SKU in Shopify → 0 = create, 1 = update, >1 = log & skip.

  • Hash the fields you care about (title, desc, tags, media, options) and compare with last run → if hash is the same, skip.

  • For updates, only send changed fields (GraphQL productUpdate / productVariantsBulkUpdate are cleaner than REST).

  • Log each SKU + action into Google Sheets or a Data Store.

  • Add throttling to respect Shopify’s API rate limits.

That gives you a safe daily sync → creates when needed, updates only diffs, skips when unchanged, and logs everything.

:backhand_index_pointing_right: I’ve built similar 10k+ product syncs with Make for client, happy to share example payloads and mapping if you want to see it: :date: Book a quick call

You can also check our past work here:
:globe_with_meridians: Portfolio
:open_file_folder: Case Studies
:star: Clutch Reviews

11

Hi,
I can help you build out this Make scenario for your Shopify product sync.

The SKU matching and variant mapping can be tricky to get right, especially when dealing with thousands of products. I know how to handle the performance considerations and prevent the duplicate/overwrite issues you mentioned.

Would be happy to work with you on getting this running smoothly on a daily schedule.

You can reach out to me on my email here

Colin

12

Hey @Kirsty_Eds,

If you’re looking for an professional with 2+ years of experience and certified expertise to help streamline Shopify product and options creation, I’d be happy to assist. I can ensure smooth integration and efficient workflow for your project.

Feel free to explore my services.
I’d also be glad to connect on LinkedIn and stay in touch.

I look forward to connect with you soon.

13

Hey @Kirsty_Eds,

Sent you a DM to talk more in detail but would love to help with your project. I run a small automation studio called Automation Jinn where we help founders like you automate their processes and increase efficiency.

Quick Question-
• Does the supplier API provide incremental updates (changed since last sync) or only a full product sync?

I can understand how it can become more technical and difficult to handle yourself. While doing API integrations, it’s important to delve deep into the documentation and handle pagination and throttling to avoid errors and make it more robust. I am Make advanced certified with a background in computer science so quite comfortable in integrating API and custom code. Would love to talk more about the project

Happy to also jump on a call if it’s easier. Feel free to book a slot through the website or just send a DM through my profile :slight_smile:

Cheers,
Sparsh
Founder
Automation Jinn

14

Hi Kirsty,

Thanks for outlining your requirements so clearly. I’ve worked extensively with Shopify API integrations and Make.com to automate large-scale product syncing, and I can help you finalize a production-ready workflow that solves the exact issues you’re facing.

Here’s how I’d approach it:

  • API Integration: Use Make’s HTTP module to pull product data in JSON format from your supplier API.

  • SKU Matching: Safely check if a product already exists in Shopify using the variant SKU → product ID mapping.

  • Update Logic: Only update fields (Title, Description, Media, Options, Tags, etc.) when changes are detected, preventing unnecessary overwrites.

  • New Product Creation: Automatically create products when no match is found.

  • Error Handling & Logging: Maintain a Google Sheet or Data Store log that tracks every action (Created, Updated, Skipped). Also include rules to skip/flag duplicates if multiple SKU matches are detected.

  • Performance Optimization: Handle bulk data by batching requests, throttling API calls to stay within Shopify’s rate limits, and ensuring efficient iteration through thousands of products.

  • Scheduling & Automation: Configure the scenario to run daily (or any set interval), making the sync hands-free.

I recently built a similar workflow for an e-commerce client who needed 20,000+ products synced daily from a supplier feed to Shopify, with diff-based updates and full audit logs. The result was a reliable system that required no manual oversight after setup.

Happy to review your current scenario and propose a clean, scalable architecture to get you live quickly.

Would you like me to prepare a draft flow diagram so you can visualize the process before we dive in?