VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: dylanphelan on August 14, 2013, 09:57:37 AM

Title: Create Product Feed - Open in Excel
Post by: dylanphelan on August 14, 2013, 09:57:37 AM
Hi

My client would like to be able to send clients a link to an Excel CSV / XLS file with up to date products.

I've seen a few plugins that can create an XML feed.

Is there any way that we can create a link to an up to date excel file (with a fairly user friendly layout).

Or - do you perhaps know of a way in excel to enter the feed URL, then he can send that to clients and it downloads the info?

thanks,
Dylan
Title: Re: Create Product Feed - Open in Excel
Post by: jenkinhill on August 14, 2013, 10:24:28 AM
Have a look at CSVI - http://www.csvimproved.com/ - a CSV file can be created using that to send to clients.
Title: Re: Create Product Feed - Open in Excel
Post by: dylanphelan on August 14, 2013, 12:17:05 PM
Hi

Thanks - yes i know and use CSVI already.

Problem is - we would like to be able to give clients a link so that they can download an up to date product list in CSV/XLS format.

CSVI working fine for exporting the info, but the client would have to do it manually each time someone requests a price list.

thanks.
Title: Re: Create Product Feed - Open in Excel
Post by: jenkinhill on August 14, 2013, 12:29:57 PM
I wonder if it could be done using CSVI with cron, eg run once a day or whatever, and storing the file on the server for access by clients? Need some programming, though. Above my payscale....
Title: Re: Create Product Feed - Open in Excel
Post by: dylanphelan on August 14, 2013, 12:38:54 PM
Sounds interesting, but i wouldnt have a clue how to do it...