Export a list of products with detail including direct porduct link

[jeffchiz]

My affiliate partner wants me to provide them a feed of product detail via excel, but it also needs to have the direct product link to the website.  The Shopify export doesn't give me the product link.  Since I have 500 products, I don't want to be manually copying and pasting the product links.  How do I get all this info?

[Ablestar_Daniel · Accepted solution]

Hi @jeffchiz,

There's two ways I can think of to do this, one's more manual but free and the other would involve our third-party Shopify app.

Adding the URL yourself

The DIY approach would be to download the product exports from the Shopify admin and add the URL column yourself, with the use of formulas it shouldn't take too long. For all products, the URL is "https://yourstoredomain/products/product-handle", where "product-handle" is the handle that appears in the first column of your product export. 

In Google Sheets you can use a formula like =concat("https://mystore.com/products/", A2) to create the URL for all products:

Automated exports with a third-party app

If you want a more automated solution I suggest trying our Ablestar Bulk Product Editor. You can use the app to create an export with just the columns you want (including the product's URL). When the app generates the export, you can configure it to upload to a unique URL that you can share with your affiliate partner.

To give you an idea of what this would look like, here's where you would configure the export:

Once you create the spreadsheet you can have a public URL for it. When the spreadsheet gets regenerated data will update but the URL will stay the same for your affiliate:

Please let me know if you have any follow up questions to either method, happy to help.

Best,

Daniel