I am trying to get the ID of the products and variant to create a mini excel spreadsheet. Is there anyway to grab these products IDs from the bulk editor? How do I do it?

Hey @Dean_Kara , thanks for your clarifications. I try to do the same here to export my variants together with the ID + SKU. As per https://mokebo.myshopify.com/admin/variants/count.json we have over 600 Variants to export which would be 3 API calls, however if im inserting " https://mokebo.myshopif…

OMG, you have the most simplest solution! You rock!

▶ Show More Hi Guys, i didn´t get any response to my question above. We have more then 250 variants we want to JSON export but the URL in the way the documentation tells it is just not working. thats what i´m trying: https://XXXX.myshopify.com/admin/variants.json?fields=id,sku,product-id,title&page=…

The page parameter is not supported in the API version you are using. If you follow the link in the error you will see: Cursor-based pagination is supported only in version 2019-07 of the API and above. It replaces page-based pagination for the endpoints listed below. The link contains informat…

Worked great!! Thank you for sharing!! New to Shopify and needed this data for bringing stuff in from our old site. You rock!

These were all helpful but not quite what I needed, which was everything from the typical export BUT with product IDs. What worked for me was combining the data Grabbing the admin/variants.json, downloading, converting to csv (just google json to csv there is a free converter) Typical full pro…

I would suggest using the Shopify ID Export program in combination with xsv: shopify_id_export -t access-token your-shop.myshopify.com This will output a file named your-shop.csv. You can take this file and the product export from the Shopify Admin and combine them via the xsv program: xsv join …

Xamy’s solution using the built-in reports worked very well

Thanks a lot! I think this is the most efficient way if you are not comfortable with json or any coding like I am. I have 530 ids in my store and edit the product ID with google sheet takes less than 10 seconds.

How to get product ID and variant ID with bulk editor

Shopify Discussion

quikcamo February 22, 2024, 4:09am 29

You are a hero! Thank you!

Topic		Replies	Views
How to get Products details with Ids and variant ids Merchandising	3	1026	December 17, 2025
How can I include id_product in my CSV export? Shopify Discussion	2	105	December 17, 2025
Getting product id and variant id in bulk Shopify Apps shopify-apps	1	73	December 24, 2023
Variant idの取得について技術的なQ＆A	6	128	December 8, 2020
How to get the product data by product variants data Store Design customizations , collection-page , cart-page , troubleshooting	0	23	January 11, 2023

How to get product ID and variant ID with bulk editor

Related topics