I am in need of a Script, which will query a MySql DB, pull specific data, and then turn that data, into a well formed XML feed, which will be used to submit products to [url removed, login to view]
The following are the fields, in order, that will be used, and the 'field' from the SQL db:
category = sale (this is a predefined field)
id = 'id'
title = 'itemname'
url = '[url removed, login to view]'id'' (id from above)
city = 'city'
state = 'state'
zip = 'zip'
condition = 'new' (this is a predefined field)
create_time = 'startdate'
description = 'description' (Many contain HTML so will need to be completely stripped)
expire_time = 'enddate'
image_url = 'photo'
price = 'bidstart'
The XML feed should be well-formed. The best way to ensure this is to run your prospective feed through an xml validator or parser to check it.
Here is an example of an XML feed per their requirements:
[url removed, login to view] DOT xml
Please note that the itemname and the description, in many cases, contain misc chars and html - So those will need to be stripped clean for compliance with XML standards.
Have questions? Ask BEFORE placing your bid.