How to create a data feed in xml for e-commerce website?

[rg123]

Hi All

My client has an e-commerce website built in Joomla + Virtuemart.

I want to start ppc advertising in getprice and myshopping (Australian websites). They want me to upload a data feed in xml format to advertise.

I tried searching in Joomla and VirtueMart but was unable to find how to create a xml data feed. I am not an expert in Joomla and I have tried reading forums but was not able to find anything relevant.

If anyone can suggest some answers to this problem it will help me a lot.

Regards
Reheen

[chandrika]

First you need to look at the format of the xml datafeed file that is required to upload to getprice and myshopping, on their site they probably have an example to download. Main points are what are the column headings (such as price, name, description, url) and whether it is tab delimited, comma delimited or other, (that is the space between each column)

It is easiest just to copy an example from the site it is for. Microsoft Excel spreadsheet program is useful for creating datafeeds, as it lays the information in an easy to see way, and you can then save as an xml file.

[Bagi Zoltán]

Hi,
If I werre you I would write a php file which do the export following the required layout. The script should connect to the database then put the active products into an associated array. Within a while or foreach loop you may easily place the product data into a comma separated files with the correct header declaration.
Thanks

[Travisnps]

do you have an example or something i could referance?

[NexusSoft]

It is very simply a matter of replacing the appropriate variables in your generated XML format file.
Below is an example of a basic RSS 2.0 format file. The same principle can be used for any XML format they would require.

<?xml version="1.0"?>
<rss version="2.0">
<channel>
<title>Example Channel</title>
<link>Website URL</link>
<description>My example channel</description>
<item>
<title>Item Title</title>
<link>Item 1 URL</link>
<description>Product 1 description</description>
</item>

<title>Item Title</title>
<link>Product 2 URL</link>
<description>Product 2 description</description>
</item>
</channel>
</rss>

[LD]

Thread closed.