Struggling to Bind JSON Data into My Shopify Store – Any Advice?

Products and Orders APIs
1

I’m stuck with something that feels simple, but I can’t figure out the right way to do it in Shopify.

I have some JSON data coming from an external source (for now, just sample JSON, but eventually it’ll be from a feed). I want to bind that data into my Shopify store to update products.

Right now, my workflow is super clunky:

  • I take the JSON and paste it into this online tool (https://jsontotable.org).

  • That converts JSON into a table so I can see the values clearly.

  • Then I manually copy those values into my Shopify admin one by one. If I want to scale my app, it isn’t easy to keep copying and pasting

It works, but it’s obviously not practical if the data keeps changing or if there are hundreds of products.

Here’s a sample example of the kind of JSON I’m working with:

{
“id”: 101,
“title”: “T-shirt”,
“price”: “19.99”,
“inventory”: 50
}

What I want is some way to:

  1. Take this JSON directly from a URL.

  2. Push it into Shopify automatically (update products, prices, inventory, etc).

I’ve been reading about the Admin API and Storefront API, but I’m not sure which one is best for this.

  • Should I build a small private app to pull this JSON and sync products?

  • Or is there some built-in method I’m missing?

Has anyone here done something similar? Any advice with some direction would be a great help, please. :folded_hands:

Thanks in advance!

2

Hey @Khaja_Hussain, what you are looking to do is definitely possible.

You’ll want to use our admin API. Specifically, the productSet mutation is designed for syncing product data like you have described. Here are some resources that can help:

1 Like
3

Hey @Khaja_Hussain, Are you still experiencing this issue, or can I mark this as solved?

4

Hi @Katya_Kilders

Thanks for your help. This is helpful. but this will take some time for me to integrate because lack of knowledge. I will learn more about it and see how it goes. Thanks for your time.