Is it possible to export all product URLs including variant URLs?

Solved

Is it possible to export all product URLs including variant URLs?

Matthew_Harper1
Excursionist
32 0 18

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.

Accepted Solution (1)
MョイA
Tourist
4 1 2

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

View solution in original post

Replies 6 (6)

Karl_J
Shopify Partner
67 8 43

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 ExportShopify Product Export

 

I hope that this helps! 

 

Karl Jones | Manager, Technical Support, Shogun
Get in touch: support@getshogun.com | Try Shogun Page Builder for Shopify for FREE!

If you found my answer helpful, please mark it as the solution!
Matthew_Harper1
Excursionist
32 0 18

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

Karl_J
Shopify Partner
67 8 43

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.

 

Finding variant IDs

 

Hope this helps!

 

Karl Jones | Manager, Technical Support, Shogun
Get in touch: support@getshogun.com | Try Shogun Page Builder for Shopify for FREE!

If you found my answer helpful, please mark it as the solution!

Jonathan-HA
Shopify Partner
336 26 107

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!

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
Neonjack2
Shopify Partner
2 0 0

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!

MョイA
Tourist
4 1 2

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