Hi,
I am using AC 7.0.3
We create a weekly email featuring product specials and can obtain all relevant product information (product price, name, image etc.) via the dataport download however we cannot easily obtain the product URL to link directly from the product in the email to the website.
Please can someone advise how to 'extract' the product URL without actually clicking into each product and copy/pasting the URL into the spreadsheet?
Many thanks.
Tony
How to 'extract' the product URL for email marketing purpose
Re: How to 'extract' the product URL for email marketing purpose
Here is a code sample that describes how to read CSV. viewtopic.php?f=61&t=9828 You can read your custom exported CSV using this technique by building some small utility that reads Product URL and then adjust its actual product URL by making it absolute. All you will need is to remove ~/ with actual store URL in product URL.
.comRe: How to 'extract' the product URL for email marketing purpose
Hi Mazhar,
I think I have figured out an alternate method. Can you please confirm that this will work without any unforseen issues?
Step 1) you take a CSV download of your products from the dataport.
Step 2) add a column with your store url and an additional string so the data looks like this: http://www.mystoreurl.com/Product.aspx?ProductId=
Step 3) in a new column, run a 'concatenate' function in excel to add the product ID to the end of the string in 2) above.
Step 4) the product url http://www.mystoreurl.com/Product.aspx? ... ctidnumber] is the 'absolute' url for the specific product and can be used in email marketing. An added benefit of using this URL is that you can change the product name without breaking the link to the product from your email.
Another issue (that will hopefully be resolved soon) is that the dataport cannot download from specific dates or multiple vendors/warehouses or even just 'featured products' so we currently need to set products featuring in the email to 'featured products' and then filter the entire catalogue csv download by 'featured products' to extract the relevant products.
Is there an easier way you can think of to download featured products and/or recently uploaded products by date and/or multiple vendors/warehouses (without having a custom CSV file written)?
Thanks and regards.
Anthony
I think I have figured out an alternate method. Can you please confirm that this will work without any unforseen issues?
Step 1) you take a CSV download of your products from the dataport.
Step 2) add a column with your store url and an additional string so the data looks like this: http://www.mystoreurl.com/Product.aspx?ProductId=
Step 3) in a new column, run a 'concatenate' function in excel to add the product ID to the end of the string in 2) above.
Step 4) the product url http://www.mystoreurl.com/Product.aspx? ... ctidnumber] is the 'absolute' url for the specific product and can be used in email marketing. An added benefit of using this URL is that you can change the product name without breaking the link to the product from your email.
Another issue (that will hopefully be resolved soon) is that the dataport cannot download from specific dates or multiple vendors/warehouses or even just 'featured products' so we currently need to set products featuring in the email to 'featured products' and then filter the entire catalogue csv download by 'featured products' to extract the relevant products.
Is there an easier way you can think of to download featured products and/or recently uploaded products by date and/or multiple vendors/warehouses (without having a custom CSV file written)?
Thanks and regards.
Anthony