How do I find the product feed for my Shopify store

Ok, so I was searching online for “How to Find the Shopify Product Feed”.  I then tried “How to Find ALL Products for Product Feed Shopify”, then “How to Connect Share a Sale Product Feed to Shopify”. All of the results sent me to several forum posts that recommended I use apps like Flexify or Google Shopping or Facebook Product Feed apps.  However, I wanted to find out how to get the Shopify product feed without an app because I didn’t need a feed for any of these websites. I needed one for Share a Sale and did not want to pay for yet another Shopify App.

 

Note: The process below is for individuals who have technical knowledge and are use to using apis for coding. See Shopify API Docs Here

 

DISCLAIMER: The store that I was doing this for only had 1000 products. So, doing it manually didn’t take long. So, if you have a lot of products, it would be better to have a developer create a LOOP for you to obtain thousands of products OR to use an app from the Shopify App Store.

 

The Shopify  forums suggest this ( NOTE: (they don’t say this, but Shopify has a product limit for this url feed) only if you have 25 products in the store or only 25 products or less in the collection) If you attempt to use Postman and the api to pull the products, the limit is 50.

yourstorename.com/collections/all.atom

yourstorename.com/collections/collectionname.atom

Using any of the above urls will only show 25 products for Shopify.

So, what do we do to get a product feed from Shopify?

 

You can get a product feed app from the Shopify App Store or   click this link and find an app that suits your needs or do what I did and do it manually because I didn’t want to pay for another Shopify App for something I could do manually.  You will have to determine how often you need this data. If you need it more frequently than a few months, I would recommend using an app for this, otherwise, I just do it manually and takes about 30 minutes start to finish.

Want to take Shopify for a Spin? Click this link for a Free Trial or One that costs a buck. Who knows what promo is going on now but click my affiliate link and try it out so I can receive some of your hard earned money.

 

HOW TO CREATE A PRODUCT FEED FOR ALL PRODUCTS WITH SHOPIFY MANUALLY

You can hire After Dark Grafx to do this for you (recommended) OR do it yourself, you will need time, some technical know how, a lot of coffee and to create a private/custom app

Get the API access ( https://YOURSTORENAMEHERE.myshopify.com/admin/settings/apps/development )

 

Download Postman Here

Add the Authorization Information to Postman

Use this URL and replace the api_key, api_password, store_name and api_version: https:/{{api_key}}:{{api_password}}@{{store_name}}.myshopify.com/api/{{api-_version}}/Products.json – Postman will connect and grab the first 50 products, this is Shopify’s Products.json default limit

You can add this to the end of the url  ?limit=250  so your entire url would be https:/{{api_key}}:{{api_password}}@{{store_name}}.myshopify.com/api/{{api-_version}}/Products.json?limit=250

So it would look something like this https://a-bunch-of-numbers-and-letters-from-the-api(this is the store access token): then a colon then the store access api password@YOURNAMESTORE.myshopify.com/api/2023-04/products.json

So, the full url for a store named cool-store would be https://ert2……..:fghj……….@cool-store.myshopify.com/api/2023-04/Products.json

This will grab only the first 50 products from your store

So, we need to add the limit 250 (Shopify does not allow more than this)

So, our Postman GET request would be: https://ert2……..:fghj……….@cool-store.myshopify.com/api/2023-04/Products.json?limit=250

This will get the first 250 products from our store.

If you have more than 250 products, you will have to send the first request then scroll to the bottom of Postman and view the HEADERS for the request then scroll down to the LINK row and you will see something like this:  <https://cool-store.myshopify.com/admin/api/2023-04/products.json?limit=250&page_info=eyJffrtyka…..hc2gifQ>; rel=”next”

You will need to COPY this link and paste it into the URL bar for Postman GET so that you can GET the next 250 products. AND IMPORTANT: Remove the <  and >  in the url  (see the RED bolded <  and > in previous URL above. Note – url above does not work.

Final Url would look like this: https://cool-store.myshopify.com/admin/api/2023-04/products.json?limit=250&page_info=eyJffrtyka…..hc2gifQ; rel=”next”

So, as of this blog post the stable API is 2023-04

Once you GET the first request, it will place all of the contents into the BODY

You will copy the BODY of this content and then CONVERT this JSON response to a CSV (or whatever you need). There are multiple converters online. Choose the one that works the best for you. This is a good one for CSVs but has a lot of ads (not affiliated with) – so be careful to read between the ads as the STEPS are within all of the garbage but it works great. https://www.convertcsv.com/json-to-csv.htm 

Paste your JSON request into this URL then download the CSV.

You will now have the first 250 products.

After remitting the first request, Postman will kick back a response so that you can get the next 250 products from the header as described above in the HEADERS of the response. Then just proceed through the same steps above until you have all the CSVs you need. In my case it was 5.

 

See Shopify API Docs Here

 

Once I had my 5 CSVs I combined them in Excel (ie: MAC –> Numbers)  Please note that the URL to the products is not included in the responses.

Once I combined the CSVs into one CSV I then added another column called PRODUCT_LINK. In this I added a column called PRODUCT_START_LINK and place https://www.my-cool-domain.com/products/ in it then copied this to all of the rows for the thousand products I had

I then created a new column and copied the PRODUCT_HANDLE to this column and pasted down to all 1000 products.

So now I have the starting link and then the product handle.  In EXCEL or NUMBERS you can combine rows with Function but I just created the FINAL url for the products by COPYING the 2 columns together for all 1000 products. Pasted them into a TEXT editor like NOTEPAD or in my case SUBLIME TEXT for Mac and then REMOVED the SPACE after the first url. So, my initial paste looked like this:  https://mycoolstore.com/products/   /name-of-my-product-handle    after I removed the space after the /products/ and before the product handle, it created one URL for the product url.

I then pasted this NEW url into a new column for the PRODUCT_URL then saved the CSV file.

At this point, I have all of my products, the links to the images, skus, handles, and product links all in one document.  You can use this as the master doc now.

So, in order to MAP this data to Share a Sale or Google or Other Platform, you would download their example CSV for their feeds then MAP your data to their data by copying and pasting.

I will cover HOW TO MAP PRODUCT DATA or HOW TO CREATE A SHARE A SALE PRODUCT FEED FOR SHOPIFY In my next post.

Let me know if you have any questions or need any paid consulting help.

 

Want to take Shopify for a Spin? Click this link for a Free Trial or One that costs a buck. Who knows what promo is going on now but click my affiliate link and try it out so I can receive some of your hard earned money.

 

Thank you,

James Byrne, Information Architect (USMC VET)
Over 30 years of providing web solutions for businesses large and small.
After Dark Grafx Website Design, SEO Services in San Diego, App Development and Consulting – Since 1992