Exporting error for the Product csv

I have a query related to exporting product data in Shopify. Column headers of " Product Id and Product URL " are not present. Does anyone have suggestions for the Product id and URL when exporting the data?

@Shopify_77

What I have found was that the “Handle” column is usually the URL.

What do you want to do with the product ID? For Shopify import export files, Shopify uses the “handle” to identify the item you want to modify. So when you import a file, if the handle on that row matches an existing items handle, Shopify will modify/replace that items info based on that row.

I want to export the bulk of Shopify product Id’s.

Any suggestion on a free app for 5000 Product Id’s exported?

Can I ask you what you plan on doing with the IDs? There may be another way to accomplish what you’re trying to do without using the product IDs.

can you share what your end goal is?

Hi,
when I’m importing a file in an excel sheet for Product data than they not having the Product IDs in the sheet but I needed Product Ids. Have any idea how to do it? because I’m not finding any solution yet.
Thanks

Yes. the way shopify works with improting data, is they use the “Handle” field as the ID.

See https://help.shopify.com/en/manual/products/import-export/using-csv#get-a-sample-csv-file

"

Required columns in the product CSV file

  • When you update products using a CSV file, the only required columns are Handle and Title.

"