All things Shopify and commerce
Hello. I would like to export a document containing every product SKU in my store (both normal products and individual variants), and the URL for each - i.e. every product URL and every variant URL. Is this possible without using the API? Many thank for your help.
Solved! Go to the solution
This is an accepted solution.
Though this topic might seem a bit outdated, I just ran into the same issue recently. A really efficient method I discovered involves using the sitemap from [insert your website's domain]/sitemap.xml. Within this main sitemap, you'll come across three distinct sitemap URLs. Choose the one that suits your needs, like the products page sitemap. Right-click on this sitemap, select 'Save As', and download the sitemap.xml file. Next, open this file in Excel, and go ahead with the standard default settings provided by Excel. And there you have it — easy access to all the URLs you require!
When importing, just open the file in Excel using the standard options. Simply copy everything in column A, and you're all set!
Edit this does not include the variant. but useful for anyone trying get the urls.
Edit 2 clean up
Hi @Matthew_Harper1!
Karl from Shogun here. You can export your product information from the Products section of your Shopify account, which will give you a CSV export of your product information. It won't give you the full URL of the email, but it will give you the handle for the product. You can check out the screenshot below for more information on where to find this button.
Shopify Product Export
I hope that this helps!
Hi Karl
Thanks for your response. That function works well to get a list of page handles, and from that generate a list of product page URLs. But is there a way to find out the URL for specific variants? I.e. an URL that would take the user to the product page with the correct variant already selected?
Thanks
Matt
Hi @Matthew_Harper1!
Thanks for getting back to me!
Unfortunately, with the basic Shopify features, only the handle of the product is exported with the CSV export. There are some other applications that you could make use of in order to get more from the export of data from Shopify itself, you can check out the App Store for this.
Another thing to note, if you want to avoid addition apps, or coding, is that you can access variants of products by the variant ID - for example, https://shogun-karl.myshopify.com/products/example-tour?variant=12615505248329 will bring you to a variant of the "Example Tour" product. This is the same product page, just with the variant already selected for the visitor.
Hope this helps!
Hey Matthew,
We have an app for doing custom CSV exports called EZ Exporter that can take care of this for you.
The `variant_id` data is necessary to build the direct variant URL and our app can take care of this by adding a Custom Field like this:
https://www.myshop.com/products/{{ handle }}?variant={{ variants.id }}
We actually have a template that has this already included (the template is called "Published Products and Variants" in our app) so it's basically a one-click setup.
We have a 7-day free trial as well so if you just need to do this once you can just install our app, do the export, and uninstall.
Hope that helps!
Anyone seeing this in 2023: If you have a development store, this WON'T install. You could probably contact the developer of the app so that he can unlock it for you, but I'm launching a website tomorrow and I can't wait. So, I'll be looking elsewhere to solve that crazy stupid issue of not being able to export the full handles of the variants.
How BASIC is that?!? Shopify, you make yourself VERY HARD to love. VERY hard. but I DO love you... Damn it!
This is an accepted solution.
Though this topic might seem a bit outdated, I just ran into the same issue recently. A really efficient method I discovered involves using the sitemap from [insert your website's domain]/sitemap.xml. Within this main sitemap, you'll come across three distinct sitemap URLs. Choose the one that suits your needs, like the products page sitemap. Right-click on this sitemap, select 'Save As', and download the sitemap.xml file. Next, open this file in Excel, and go ahead with the standard default settings provided by Excel. And there you have it — easy access to all the URLs you require!
When importing, just open the file in Excel using the standard options. Simply copy everything in column A, and you're all set!
Edit this does not include the variant. but useful for anyone trying get the urls.
Edit 2 clean up
2m ago Learn the essential skills to navigate the Shopify admin with confidence. T...
By Shopify Feb 12, 2025Learn how to expand your operations internationally with Shopify Academy’s learning path...
By Shopify Feb 4, 2025Hey Community, happy February! Looking back to January, we kicked off the year with 8....
By JasonH Feb 3, 2025