How can I obtain all product SKUs from an extensive inventory?

How can I obtain all product SKUs from an extensive inventory?

sbdev
Shopify Partner
49 0 10

Hello, we have more than 3000 products and we want to get all SKUs of that products, how to get all SKUs of all that products, is there any API to get all SKUs of products.

Replies 2 (2)

simon-skrod
Shopify Partner
150 12 31

@sbdev, there are 2 ways you can get skus of the products, first one is by crawling through products, second one is by crawling through inventory entries. You can fetch up to 250 products in a single API call so only 12 API calls required (in case oyu have only 3k items) this means you can fetch all SKUS quite quickly.

There is no other API endpoint which will let you to fetch all the skus which exist on the store.

Simonas Skrodenis
Developer of Feeds Bridge - Catalog Management System
Email: simonas@feedsbridge.com

Olivia
Shopify Staff (Retired)
1725 148 321

Hi, @sbdev.

 

Thanks for sharing your question with our network.

 

I looked into this on your behalf, and I actually found a similar forum thread with an answer that might work for you.


The solution in the thread uses a creative workaround that you may find very helpful.

 

I also wonder if there's a use case where you might benefit from a simple Product Export to a CSV file. This way you can easily view all the product SKUs using a spreadsheet program.

 


Let me know if that helps!

Olivia | Social Care @ Shopify 
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit the Shopify Help Center or the Shopify Blog