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

Shopify Discussion
1

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.

2

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
Shopify Product Export796×324 14.1 KB

I hope that this helps!

1 Like
3

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

4

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!

1 Like
5

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!

1 Like
6

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!

7

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

2 Likes
8

Hello, I know this is old, but I found a complete solution for that.

You can go to your shop template editor, go to your Products page and add “Custom Liquid” block.

In “Liquid code” field enter this:

{% for product in products %}{% for variant in product.variants %}{{variant.sku}};https://{{shop.domain}}/products/{{product.handle}}?variant={{variant.id}}
{% endfor %}{% endfor %}

Don’t save your template to not let customers see this.

You will see on preview your products list in form:

SKU;URL

You can copy all lines in new text file. If you have multiple pages of products, go to each page, copy list and add to text file.

After everything is copied, save this file with .csv extension. Double-click on that file and let it open in Excel, Calc, or any other spreadsheet program you use. Voilla!