Marketing: CSV / XML export of products for price comparison sites

Submitted by jsudesign on Fri, 07/04/2008 - 17:46

Posts: 78
Joined: 01/17/2008

Hi there, I'm looking to export all of my products so I can upload them to a price comparison site such as shopping(dot)com

Their guidelines say:

Step 1
Decide on a format for all your feed files: .TXT(text), .XLS(Excel), .XML, or .CSV format.
General format guidelines:
Excel:

    * The product content must be in the first tab/sheet of the workbook
    * Do not include single quotes as field separators

XML:

    * The encoding method must be included in the XML declaration line. e.g: <?xml version="1.0" encoding="UTF-8"?>
    * Node Name cannot be the value
    * Do not include HTML tags within text of description
    * Include all data requirements for standard txt, csv, and xls files

CSV or TXT:

    * Always use the same file for all updates (e.g. MerchantnameSDC.csv).
    * Do not include single quotes as field separators for CSV files
    * Your delimiters must be consistent

Then there was a link to a sample feed: https://merchant.shopping.com/sc/docs/StandardFeed.csv
So my question now is how do I do this? In their format?

Any help at all with this would be great.

Thanks, - Justin

www.e-techcomputers.com