XML datafeed importer for Price Comparison Web site.
Any previous experience with Affilate datafeeds and affiliate processes would be of great benefit.
See deliverables for further info on the project.
I require a backend XML import system that takes Affiliate Window datafeeds of merchant & products and imports them into a database (either mysql or MS sql server, not 100% sure which yet). Please see [www.**feedprocessor**.com], this does a lot of what I need in that you can add the merchants XML file and then map it to the relevant DB fields. But instead of spitting out 100's of HTML pages I would like the data to be written to the DB, and so none of the HTML template functionality will be needed. The DB will also save any settings/mappings I may have entered for each merchant.
The Product table also needs to contain only unique products, so if a 2 or more merchants have the same product it will only be stored once in the table. So when products are added to the DB there will be an element of fuzzy matching to see if that product already exists, exact matching will not be possible as not all merchants will use the exact same product name i.e.
Merchant A: Panasonic 42" PW7
Merchant B: Panasonic TH42PW7
This is the same product but described in different ways. So if the products exists do not add it again, otherwise add it.
Each product will also be part of a 4 tier architecture, this is the DB architecture and is not replicated in the feeds:
Sub-Category: MP3 Player
The feeds have a CategoryID but is only at Sub-Category level so if a feed has a CategoryID of 'MP3 Player' there must be some form of relation to the 'Audio' Category and so it will inherit the 'Electrical' department. I see this as being a series of link tables to form a relationship from products to department or vica versa. Once all the products have been added there will probably have to be some sort of manual proces that links each Sub-Category with a Category but should only need to be done once and updated if and when there is a new Sub-Category.
As with products the merchant will only be stored once and so once in the DB need not be added again.
I plan on this being a web based app and so a secure login page will be needed as well as editing functionality for products and merchants as well as the ability to manually match a merchant with a product (just in case the system cannot) and a method of matching the sub-categories to categories.
Please see XML feed supplied and an image of a rough ER diagram.
1) Complete and fully-functional working program(s) in DLL form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows, IE 6 upwards, ASP.NET, MS SQL Server or MySQL database.